open access to a specific form and record

[Alockhart]

Hi there I have developed a database where I can send an email from it with a hyperlink the database.
Now I would like in that hyperlink to the database have it so that it will open a specific for and goto a record.

Does or has anybody ever done this before??

If so your help would be greatly appreciated.

Thanks
Andrew

 

[maxhugen]

You can start Access with switches such as:

/cmd

See "Startup command-line options" in Help.

The command function can retrieve this value, and using your code (which you can start when the application opens), determine which form and record to open.

eg: /cmd "myForm IDxxxx". Use code to parse this to open "myForm" and use the criteria "IDxxxx" as the filter.

HTH

Max Hugen

http://www.AlphaFinancial.com.au

Sydney Australia

 

[Alockhart]

Thanks for the help but I cannot get that to work.

I have set up a hyperlink as well as short cuts but it will not read in the command line value.

Is there something else that I have missed??

Andrew

 

[PHV]

Have you an autoexec macro lauching a function parsing the return value of Command() ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Alockhart]

No I don't but it is ok I figured it out. It is nothing to do with getting the value. It is how it is being pasted in the hyperlink or short cut.

I have to specify the location of MSACCESS.EXE as well as the location of the DB. You can not just have the location of the DB with the /cmd.

Now I have a problem because we are using ACCESS 97 and will be converting to ACCESS XP in the next couple of weeks so I will have to change the location of the MSACCESS.EXE
when that happens.