Create my own type of menu system from scratch in access

[dgaletar]

Hello. I have been working on this for a while, and I have finally gotten to a point where I THINK that I finally know what to ask.



I think that what I am trying to do is to create my own menu system instead of using the "Switchboard" option in Access.

You see, I have a form named "View Reports". In its operational view it looks like this:


…and, in its ‘design view’ view, looks like this:

(basically, a title/header, an “unbound” object and 2 buttons)

The “Form” itself uses a query as its control source. The query looks like this:

(pretty basic)

And here is where I am stuck. What I am trying to make happen is this:

· If you select the first option, “View Filter Types”, and then click on the “Open Report” button, it will open a similar form that lists the filter types (ie. “Oil Filters”, “Air Filters”, Fuel Filters”, etc.).

· If you select the second option, “View Batteries Used”, and then click on the “Open Report” button, it will open the actual report “Batteries Used”.
· If you select the third option, “View Belt Types”, and then click on the “Open Report” button, it will open a similar form that lists the belt types (ie. “Fan Belt”, “PTO Belt”, Deck Belt”, etc.).
· If you select the second option, “View Tire Sizes Used”, and then click on the “Open Report” button, it will open the actual report “Tire Sizes Used”.
· If you select the second option, “View Spark Plugs Used”, and then click on the “Open Report” button, it will open the actual report “Spark Plugs Used”.

In short, what I am trying to do is to create a form where its contents can be executed to either open a form or a report... respectively. So if you select the "View Filter Types" line, it will open a form. While, on the other hand, if you select the "View Batteries Used" line, it will open a report.

Any ideas???

Thx!

DG

[ItsMe]

It sounds like you want to use the Docmd.OpenReport Method
http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

Just get the properties correct in your listbox so its .Value property returns the Report Name

[dgaletar]

Hey ItsMe, that would be fine except for the part about opening a form. Remember, in the list, some of them need to open a report, and others need to open a form.

[ItsMe]

There is a docmd.openform too.

[dgaletar]

Right. But how do I make it so that one button performs both functions? In other words, if you look back up at my initial issue, if you select the first option, “View Filter Types”, and then click on the “Open Report” button, it will open a similar form that lists the filter types (ie. “Oil Filters”, “Air Filters”, Fuel Filters”, etc.). Furthermore, if you then select "Oil Filters" from that list, it will open the "Oil Filters" report.

But, at the same time, if you select the second option, “View Batteries Used”, and then click on the “Open Report” button, it will open the actual report “Batteries Used”.

So while one selection opens another form, the other selection opens a report, and so on.

And there lies my dilemma.

[ItsMe]

Well, in your table that stores the report and form names you could include a column of Boolean type to indicate the type of object. Then, you VBA could do verification and use the appropriate command.

[dgaletar]

...include a column of Boolean type to indicate the type of object

I like where you are going with this!!! Tell me more about BOOLEAN. It sounds bad-ass!

Then, you VBA could do verification...

Please... show me!!! This is awesome!!!

[ItsMe]

You can create a yes no field in your table. When a record's Yes/No field is ticked, it returns Yes, True, and -1

You can do validation using an If Then statement.

If me.MyYesNoField.value = True then

docmd.openreport
else
docmd.openform
end if

[dgaletar]

I'm on it. I'll let you know Monday how it goes. Thx!