3 questions

[golan]

hello, i have 3 questions:
1. how i switch the database to application .
2. i have some forms and i want one of then to run when the application is
load.
3.i have add query and delete query and i dont want the msg box " u want to
add/delete....." to open.
thanks

 

[Tom Wickerath]

Hi Golan,

1. how i switch the database to application.

Not really sure what you mean, although providing a "switchboard-like" form
that opens at startup might be a good first step, along with hiding the
database window (or Navigation Pane in A2007).

2. i have some forms and i want one of then to run when the application is
load.

Use a macro named AutoExec that includes an action to open your form, or
specify your form under Tools | Startup (Access 2003 and lower--you'll need
to look up the equivalent if you are using A2007).

3.i have add query and delete query and i dont want the msg box " u want to
add/delete....." to open.

You can set warnings off in code, or use the .execute method of DoCmd
object. See examples # 3-5 in this Word document:

http://www.accessmvp.com/TWickerath/downloads/ActionQueryExamplesWithSetWarnings.doc


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[pietlinden]

hello, i have 3 questions:
1. how i switch the database to application .
2. i have some forms and i want one of then to run when the application is
load.
3.i have add query and delete query and i dont want the msg box " u want to
add/delete....." to open.
thanks

1. not possible.
2. set the startup form in Tools/Startup/Display form ... dropdown
3.
DoCmd.SetWarnings False
DoCmd.OpenQuery "qappendRecords"
DoCmd.OpenQuery "qdeleteRecords"
Docmd.SetWarnings True

 

[golan]

thanks, but in thanks mistake some menu are gone how i get it back.
when i rum the program i dont tools and more
golani

 

[John W. Vinson]

thanks, but in thanks mistake some menu are gone how i get it back.
when i rum the program i dont tools and more
golani

Hold down the SHIFT key while opening the database to bypass the Startup
processing. Correct the errors, restore the menus, and close and reopen the
database.