Can it be done

[Colmol]

Newby, right NEWBY, so take it easy on me.

I am looking to see if a database can be made that allows multiple entries (rows of records) to be entered into a table in a single upload (form?).
For example,
I have a list of assets (main table), this list has inspections performed that may include all or part of the list dependant upon a frequency (1 week, 2 week etc) these inspections are recorded in a related table (inspection table) with a number of yes / no fields.
I would like to find a way to data entry only the required assets with the yes / no fields for each frequency as a single operation.
Is this possible???

 

[Uncle Gizmo]

Well it might be but I'd have to know more about what you are doing first, and any solution will involve a change in your current database structure, which to be honest is not good! Read this post for more information and a tool to help you effect the change.

You might still be able to do what you want without changing your database structure but as you can read in the article directed to, you will have to create your own code as you may not be able to find it anywhere.

 

[Colmol]

Thanks for your prompt reply. No problem about dB structure as all this is pre planning anyway. I have from another department a heap of mainenace activity lists they use for this work and was pondering the "how do". Will take a look at your attached post. Thanks again.

 

[Colmol]

Hi Uncle Gizmo
I have been blundering on and making some progress with my dbase.
Somehow, I would like to populate a table called "results" by running a query on a seperate table "list equipment". Query is based on a unique list number contained in "list Equipment". The query returns data that I wish to modify.
I'm not sure if this should be done through a sub form or another way. I have fiddled with an append query, however I need to edit the data before it goes into the "results" table.
If you have a few suggestions, I would appreciate it. :banghead:
Regards
Collin

 

[GinaWhipp]

Hmm, perhaps you could show it in a Subform, make your changes and then have a *Submit* button which you then use your APPEND query to send to your Results table.