LouisPrefersExcel
New member
- Local time
- Today, 02:02
- Joined
- Jun 29, 2021
- Messages
- 6
Hey guys,
I currently have a simple query with a parameter to allow the user to type in an item code and pull all of the information required, I then have a macro to export this data to Excel. What I would like to do is be able to enter multiple item codes at once so that I can export the information for all of them in 1 go. I may want to pull the data for just 1 item then the next time I run the query/macro I may wish to pull the data for 4 lines of data.
The best solution I have to this currently is to type all of the item codes in a separate table within the database and to link this to the query instead of typing the codes in, this is not ideal though as this database may have several users that will need to clear the old data in the table and type in new data, and that's only if they know/remember to clear the old item codes and type in the new ones.
Appreciate any help or tips.
Thank you.
I currently have a simple query with a parameter to allow the user to type in an item code and pull all of the information required, I then have a macro to export this data to Excel. What I would like to do is be able to enter multiple item codes at once so that I can export the information for all of them in 1 go. I may want to pull the data for just 1 item then the next time I run the query/macro I may wish to pull the data for 4 lines of data.
The best solution I have to this currently is to type all of the item codes in a separate table within the database and to link this to the query instead of typing the codes in, this is not ideal though as this database may have several users that will need to clear the old data in the table and type in new data, and that's only if they know/remember to clear the old item codes and type in the new ones.
Appreciate any help or tips.
Thank you.