Re: Access startup commands to convert file??
From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 02/24/04
- Previous message: Raymond Pistey Jr: "Access startup commands to convert file??"
- In reply to: Raymond Pistey Jr: "Access startup commands to convert file??"
- Next in thread: Nate: "Access startup commands to convert file??"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Feb 2022 19:40:45 -0600
There is a command line option to run a macro at startup or you could just
create a macro called autoexec and it will run automatically when you open
the database. The problem is, both of these options would require you to
create a macro in the file which you won't be able to do if you aren't
allowed to make changes to the file. It may be easier to create another mdb
file that you do have control over. In this new mdb file, link to the table
in the other file. You could then create your macro in the file that you own
and export the linked table.
-- Wayne Morgan Microsoft Access MVP "Raymond Pistey Jr" <rpisteyj@optonline.net> wrote in message news:OUNqd%23m%23DHA.3232@TK2MSFTNGP10.phx.gbl... > Does anyone know a command I can run from start, run that will open an > acess database (mine has 22 tables) minimized and open say table #2, then > run a macro that selects all that data in table #2 and saves it as a comma > or tab delimited text file. I have an access 2000 file created by a custom > program that creates this access file and it's structure can't be altered > but I can open it and export the table manually but would like to provide a > 1 button solution to my endusers, once it's in that text file I can do what > I need to with it. > > Thanks > Ray Pistey > >
- Previous message: Raymond Pistey Jr: "Access startup commands to convert file??"
- In reply to: Raymond Pistey Jr: "Access startup commands to convert file??"
- Next in thread: Nate: "Access startup commands to convert file??"
- Messages sorted by: [ date ] [ thread ]