Move forms and queries to desk top

[Sanjo]

How do I access the Forms and Query Screens from my desk top without having to go inside of Access 2010? In other words, how do I simply access those screens, enter/view my data and close them without having to display the main pages of Access 2010?

thanks in advance for your help

 

[rodmc]

you can set a shortcut to the forms on your desktop, however, this will still show the Access window, but it will take you direct to the form

If you want to only show the forms, then you'll need to use some VBA, there's a module that does that particular function, do a search on "hide access window"

 

[Beetle]

...without having to display the main pages of Access 2010?

Not sure what you mean by the "main pages of Access 2010". Access objects (forms, queries. etc.) are not usable outside of the application, but there are options you can set so that some of the built in objects (tool bars, navigation pane, etc.) do not display when you open the application. You can also set a start form that opens by default each time you open the application. Go to the File tab, then Options/Current Database to set these.

 

[rodmc]

think he means the main Access window itself

 

[Sanjo]

correct, the Main Access window itself that lets you create tables, forms, queries, etc. I just want the users to see the ENTRY and QUERY forms without having to be confused or faced with the main window which they would not know anything about. If the Desktop screen had icons(whatever) that simply opens the entry (input) screens and inquiry screens that is all they need. The entry screens would update the tables and the inquiry screens would access the tables to display the requested data. The user wouldn't really know that ACCESS 2010 was doing all the work behind the scene.

 

[rodmc]

Must be your lucky day Sanjo, think this is what you are looking for

http://www.access-programmers.co.uk/forums/showthread.php?t=218554&highlight=global+user+ID

 

[Sanjo]

hey, RODMC, hope you are right. thanks for the info. I will give it a try.

 

[Sanjo]

RODMC

I have entered the code into a module and also put the code in my form's ON Load field.

The note also said to change the value to suite as above. At that point I got lost. Where do I change the value and is it literally to "suite"?

thanks again for your help

 

[rodmc]

Hi Sanjo

After having a quick scan at the module John Woody posted, I think what he means Change the value in the call to suit your needs, for example at the top of the module, you have these 4 lines of code

Global Const SW_HIDE = 0
Global Const SW_SHOWNORMAL = 1
Global Const SW_SHOWMINIMIZED = 2
Global Const SW_SHOWMAXIMIZED = 3

So when you call the function from the "On Load" you can select what you would like displayed ie, to show it as normal the call would be

Call fSetAccessWindow(1)

for minimised

Call fSetAccessWindow(2)

etc etc

you get that? Let us know how you got on!

 

[Sanjo]

Thanks RODMC. i did what you suggested, but since I am new at ACCESS 2010 I am messing up elsewhere, I'm afraid. After I did as you suggested, I closed the form, then reopened, but got the following message:
"Microsoft can not find the object called 'call fSetAccessWindow(1)'" Obviously, I screwed up, but will keep trying to find the mistake.

Thanks
Sanjo

 

[rodmc]

Sorry Sanjo, my bad

call the code using

=fSetAccessWindow(0)

in the On Load event

Using

call fSetAccessWindow(0)

would be if your calling it from inside a module

that should work no problem!