Auto Execute of forms

[BenjaminLim]

I will like to create a shortcut on desktop that could call a particular form in ACCESS application (ACCESS 97) through DOS command :<br><br>Something like the following:<br><br><b><font color=blue> H:\COMMON\SUPPLOG\Supplog.mdb /x OpenReq&nbsp;&nbsp;/Ini h:\common\supplog\supplog.ini /user ksk </b></font><br><br>I am not able to do this after I convert the application from Access 2.0 to Access 97.&nbsp;&nbsp;I am not able to make use of Autoexec macro as I will need to call different forms at times (i.e. I need to create 2 or more shortcuts on desktop)<br><br>Pls advice what should be done.<br><br>Regds

 

[DougP]

Put the shorcut in the Start up folder.<br>I guess you want the app to launch when the machine boots right?<br>Here's how:<br>Right click the &quot;Start&quot; button on your desktop. then click &quot;Open&quot; then Double click the &quot;Programs&quot; folder then double click &quot;Startup&quot;. Create a new Icon there.<br><br>here is one I have right now.<br><br>&quot;C:\Microsoft Office97\Office\MSACCESS.EXE&quot; C:\TIMESAVR\FILES\db1.mdb /X OpenOrder<br><br>There are 7 parts to it:<br>1. Drive and full path to Access<br>2. a blank space<br>3. Drive and full path to the .MDB or .MDE (if you have one).<br>4. a blank space<br>5. /X <br>6. another blank space<br>7. then the name of the macro, without any spaces in its name.<br><br>OK, now in Access create a macro that opens your form.<br>That's the name that goes into the above. In may case it's &quot;OpenOrder&quot;. Note: The macro name cannot have any spaces in it.<br><br>We've used this for years since Windows '95 and I'm on Win 2000 Pro right now.<br>The machine boots and then we are setting on the form which the macro called. Works great!!!!<br><br>DOS is dead, leave a dead dog alone.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.