Three little questions

J

Jack Sheet

Hi all, Access 97

Three little queries:

Query 1

What is the procedure, please, for ensuring that specified windows within an
Access database are maximised on being opened? Clearly there are several
possible situations. The first one that comes to mind is the window that
contains the database itself (with the Tables, Queries, Forms, Reports,
Macros and Modules tabs). But then each individual Form, Report etc will
presumably have its own definable default setting on opening.

Query 2

What is the procedure, please, for ensuring that the "View" format is set to
"Details" as opposed to "Large Icons", "Small Icons", or "List", for any
particular window?

Query 3

Is it possible, and if so how, to set up a shortcut on the desktop that
automatically runs a specified report within a specified Access database? I
can set up a shortcut that simply opens the database, no problem with that.

Thanks
 
G

Graham R Seach

Jack,

1. Add the following line to each form's Load event:
DoCmd.Maximize

2. I presume you're now talking about Windows Explorer. Open Explorer, and
select [Details] from the [View] menu. Then select [Folder Options] from the
[Tools] menu. Select the [View] tab, and click [Apply to All Folders].

3. To do this, you need to create a macro in Access, that opens the specific
report you want to see (using OpenReport). Name this macro, say,
"RunMyReport". Then locate and right-click the database that contains the
report, and select [Create Shortcut] from the context menu. Right-click the
new shortcut and select [Properties] from the context menu. The [Target]
property will display the path to the database you just selected. To the
extreme left-hand-side of this path, prepend the path and filename of the
Microsoft Access executable (usually "c:\Program Files\Microsoft
Office\Office11\msaccess.exe") - including the quotation marks. The exact
path may be different on your computer. Make sure there is a space between
the two paths. Lastly, append "/x RunMyReport" to the extreme
right-hand-side of the Target property - but this time excluding the
quotation marks. The whole [Target] property should look something like
this:

"c:\Program Files\Microsoft Office\Office11\msaccess.exe"
"c:\Temp\MyDatabase.mdb" /x RunMyReport

The above example may have been split onto two lines by your newsreader. It
should all be on one line.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
F

fredg

Hi all, Access 97

Three little queries:

Query 1

What is the procedure, please, for ensuring that specified windows within an
Access database are maximised on being opened? Clearly there are several
possible situations. The first one that comes to mind is the window that
contains the database itself (with the Tables, Queries, Forms, Reports,
Macros and Modules tabs). But then each individual Form, Report etc will
presumably have its own definable default setting on opening.

Code the Open event of the Form or Report you want maximized:
DoCmd.Maximize

All will stay maximized unless you have code somewhere that restores
the database object, i.e. DoCmd.Restore

Query 2

What is the procedure, please, for ensuring that the "View" format is set to
"Details" as opposed to "Large Icons", "Small Icons", or "List", for any
particular window?

This is a Windows question. Re-post to a Windows newsgroup.
Query 3

Is it possible, and if so how, to set up a shortcut on the desktop that
automatically runs a specified report within a specified Access database? I
can set up a shortcut that simply opens the database, no problem with that.

Thanks

Right-click on the name of the report (on the Main Database folder)
and select shortcut. A Shortcut icon will be placed on th desktop.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top