G
Guest
I think I need a list box.....maybe I need something totally different. This
is what I want to do:
Each night we get a .txt file. Each morning I load the .txt file(s) into a
table, using Get External/Import. Then via a form, the users can go a print
their reports. I would like to have a form that will list (listbox?) the
files (in a specific folder). Then the user the user could click on the file
they want to load, which would then load using the spec I set up. Then they
could go to their form and get their reports, with no intervention from me.
Is this even possible? Could there be a better/easier way to do something
like this? Please keep in my I do not know vba code. Any advice would be
greatly appreciated. Thanks
is what I want to do:
Each night we get a .txt file. Each morning I load the .txt file(s) into a
table, using Get External/Import. Then via a form, the users can go a print
their reports. I would like to have a form that will list (listbox?) the
files (in a specific folder). Then the user the user could click on the file
they want to load, which would then load using the spec I set up. Then they
could go to their form and get their reports, with no intervention from me.
Is this even possible? Could there be a better/easier way to do something
like this? Please keep in my I do not know vba code. Any advice would be
greatly appreciated. Thanks