Hello charitable,
I have a repetitive task that requires the user to go to a command prompt, navigate to a folder (usually deep in the system), and perform a syntax scan on a file (with an in-house program), and this occurs thousands of times a year across a few users. In order to simplify this task, I have gone into the registry and created a key that allows the user to navigate to the file through the gui, right-click on the file, and then...
WillChapman
Last Activity: Jun 16 '10, 08:17 PM
Joined: Mar 9 '10
Location:
-
Thanks, NeoPa. I didn't see that part about passing in the variable. -
ADezii, That sounds like a great idea!
I think that will work, and I think it's what I've been waiting for. You really put some good ideas together with the environmental variable concept. I am absolutely blown away! Many thanks!Leave a comment:
-
Ok. I understand what you are doing with the import text command with the macro, and there is a way to run it at startup from a command prompt. The only thing I am looking for is how to pass the name of the file into the macro, such as this manner:
c:\>"C:\Program Files\Microsoft Office\Office\m saccess.exe" "C:\Program Files\Microsoft Office\Office\s amples\northwin d.mdb" /X AddProducts
The above...Leave a comment:
-
The text files are generated by another program, and they are constantly being created. I would like to be able to add the records from the text file without having to manually open MS Access.Leave a comment:
-
Adding records to MS Access table from command line
Hi,
I have text files that are created with comma-delimited records inside them. I am trying to figure out how I can construct a command-line method of importing the records to a MSA table. The end result will be that I can right-click on the .txt file, there will be an option on the context menu that says something like "Add records to 'Modules' table", and that will bring up a command window that will execute the import command....
No activity results to display
Leave a comment: