Dummy DoCmd.OpenQuery question

[Kader]

Hi Listers,

I'm very new to MS Access and VB. I inherited Access application and try to find where the queries reside and other objects.
I find the following code on the event commands:
....
Dim stDocName As String
stDocName = "Account Financial Snapshot"
DoCmd.Maximize
DoCmd.OpenQuery stDocName, acNormal, acEdit
....

My newbie question: Is "stDocName" the name of the query? If it is, how can I access to the query?

When I open the application I have only the option of Form design from which I can access to the properties and there is no queries!

Thanks for your input.

PS. It's MS Access 97.


Kader

 

[WayneRyan]

Kader,

Welcome!

stDocName is just an Access string variable.

It is assigned the value "Account Financial Snapshot"

The DoCmd.OpenQuery will open that query.

You will find the query on the Query tab of your database window;

Tables, Queries, Forms, Reports, Macros and Modules are the tabs.

Wayne

 

[Kader]

Hi WayneRyan,

Thanks a lot for your prompt reply. My problem I don't know how I access Tables, Queries, Forms, Reports, Macros and Modules! When I open the mdb file I can see only the form view or form design the properties menus no other options or tabs.

Have a nice week end,


Kader

 

[pbaldy]

Hit F11, which should open the database window containing all those objects (I assume that worked in 97).

 

[Kader]

Hi pbaldy,
F11, that's what I missed! Thanks you. Now I can what WayneRyan was taking about.

Many thanks for you guys.


Kader

 

[pbaldy]

Wayne was glad to help, I was glad to throw in an assist during his lunch hour.

Welcome to the site by the way.