New user and a bit stuck...

[Guest]

I have created a database in Access and I have a have a couple of problems I
have not been able to solve.

1. I have created the securities on my database by using the workgroup
admin. This causes me to have to change the workgroup in Access in order to
use my databse, of course effects the securities other databases that have
been created by other users. Can you tell me how to use a shortcut icon to
start my database without changing the default workgroup?

2. I have a form that I created from a query in order to display data (it is
used only for display, no input). I used a command button to apply the
filter by form command. I would like to add a apply filter command button on
the form so I would not have to use a toolbar to access this function. I am
a new Access user, so I am not sure if this is possible or if this is even
the best way to get the desires results.

Your help would be much appreciated..Thanks in advance.

 

[Guest]

Hi G. Gray,

In order...

1. Use the following shortcut:

"c:\program files\microsoft office\office11\msaccess.exe"
"c:\DB\database.mdb" /wrkgrp "c:\DB\workgroup.mdw"

This assumes that your database is located in c:\DB and is called
database.mdb, and your workgroup called workgroup.mdw. Of course, substitute
the correct path/filenames.

2. Yes, you can apply filters using a command button. Instead of filter by
form, set the forms filter like this:

me.filter = "[FIELD] = " & me.lngFIELD
me.filteron = true

Of course, substituting FIELD and lngFIELD for the names of the appropriate
database field and control on your form.

Hope this helps.

Damian.