Oct 12 2023 08:03 AM
Is it possible to import an excel sheet into a form in Access. I have a form that we use for bill of ladings and it is saved each time as a unique BOL. I would like to import this sheet and build a database around it.
Oct 12 2023 10:31 AM
Oct 12 2023 01:14 PM
To supplement what XPS35 pointed out, here is a quick overview of the essential components of a relational database application, such as those created with Access.
Your screenshot illustrates only the 2nd of these elements, an interface in which data is retrieved from underlying tables and displayed in a formatted presentation for the viewer.
You can build a report for the interface which displays data in a manner similar to that in your screenshot. However, the storage of the data is done only in tables. And the process of adding new records, updating existing records and reading them into the report is done via an interface designed to prepare the report for display.
Investing time in understanding how relational database applications work will pay off when it's time to use the application for tasks like this one.
Oct 12 2023 01:15 PM
Okay I was hoping there was an easier way to do this. I will create a form with 2 sub forms
Don
Oct 12 2023 01:21 PM
Oct 12 2023 01:23 PM
Oct 12 2023 02:28 PM
Oct 12 2023 03:36 PM