Add filter in the shortcut

[accessman2]

Hi,

In the my database program, I write the code to create the shortcut, and then send the shortcut (attached) through the Outlook to the people.

I know how to create the shortcut. But, I want to add the form and filter in the shortcut.

"C:\Program Files\Microsoft Office\Office10\Msaccess.exe" "C:\db1.mdb" /WRKGRP "C:\Secured1.mdw" /form "app" /filter "[Date] /filteron True

Once the user click the shortcut in the outlook, then the database will goto the specific form and specific record.

Can I do it in the shortcut?

Please let me know, thanks a lot.

 

[KenHigg]

I'm thinking you can do this with command line option '/cmd'. Google 'access command line options' and see what you get...

 

[accessman2]

Could you give me an example for /cmd?

I searched in google, there is NO example for working /cmd.

Do you have one for me? Thanks.

 

[accessman2]

Thanks. I got it

 

[KenHigg]

Thanks. I got it

Can you share your solution with us?

 

[ghudson]

Can you share your solution with us?

Your kidding right?!?! Be thankful AccessBoy actually posted a thank you to your help.

If only AccessBoy would use the Access help files and he would have found everything he needed [and more].

How to use command-line switches in Microsoft Access

Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions