Question Access 2007 Switchboard More then 8

[xirokx]

gotcha!!! followed it and works a treat...

I just created more forms, so button 8 would open up another switchboard page consisting of 8 more buttons...

Thanks for your help and especially for creating a new page on your site for me

Finally can I ask, is there a way I link one of these buttons on my switchboard to a query? Or can I only link to forms and reports?

Would linking to a query merely mean changing the view of a report?

Thanks for your time and certainly for your patience...

 

[AccessJunkie]

Excellent, I'm glad you've been able to achieve your goal of showing more than eight items on a Switchboard page.

To answer your next question, yes it is possible to open a query from the Switchboard form, however, this will require more work because in this case you will have to manually change all the embedded macros on the form to handle an additional Command.

I first have to ask though, are you sure you want to do this? In general, it's usually wise to only show users forms and reports. Presenting a query to a user could be problematic because they could inadvertently add/edit/delete something you didn't want changed. Could you achieve what you want by just showing the users a different form or report?

If you still want to do this, let me know and I'll walk you through it. I have instructions on how to do this using versions pre-2007 on the link below, but those instructions don't apply to 2007.

http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html#query

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[gemma-the-husky]

gotcha!!! followed it and works a treat...

I just created more forms, so button 8 would open up another switchboard page consisting of 8 more buttons...

Thanks for your help and especially for creating a new page on your site for me

Finally can I ask, is there a way I link one of these buttons on my switchboard to a query? Or can I only link to forms and reports?

Would linking to a query merely mean changing the view of a report?

Thanks for your time and certainly for your patience...

eh?

is accessjunkie/jeff REALLY saying create more menu forms

you only need a single switchboard form, which uses menu items described in the table "switchboard items"

jeff has already explained that all you need to do is add more master buttons to the form, and in the code behind it change the value for the constant

Const conNumButtons = 8

to a bigger value (ie equal to the number of button you now have)

Is this what you are doing?


the standard action available in the code (ie action responses for a button click) are these 8

Const conCmdGotoSwitchboard = 1
Const conCmdOpenFormAdd = 2
Const conCmdOpenFormBrowse = 3
Const conCmdOpenReport = 4
Const conCmdCustomizeSwitchboard = 5
Const conCmdExitApplication = 6
Const conCmdRunMacro = 7
Const conCmdRunCode = 8

none of these options are "open query" which is why jeff is saying you need to add it yourself if you want to do this. It is not too hard to do, but as jeff says, it is most unusual to want to open anything other than a FORM or REPORT

 

[xirokx]

What I would like to do is for my report to show me a list of peoples documents that have expired or are due to expire in one week using the date as a determining factor...

Currently my report is setup to highlight any dates that fall within this category.

However it shows me all records, so I setup a query which shows me ONLY the documents that have expired or are due to expire...

How could I acheive this by running a report??

All ideas would be appreciated

Thanks

 

[Rabbie]

Just build a report using the query which only has the expired/about to expire documents

 

[xirokx]

thats what I thought...

But how do I do that?

Do I need to use VBA code? Any chance of a step by step guide?

Am slightly confused..

please clarify

thanks

 

[xirokx]

I first have to ask though, are you sure you want to do this?

Access Junkie, yes please can you write the instructions on how to open a query from switchboard manager...

Thanks

 

[gemma-the-husky]

you need to look at the handlebuttonclick event code,

you will see a case statement showing the processes for each action code 1 thru 8 (actually action constants but its the same thing)

Add another action constant for code 9

look at the code for value 3 (open form), and copy it, as a basis for constant 9
the actual code you need will be something like

docmd.openquery rst!argument instead of
docmd.openform rst!argument

then edit your switchboard items table to add the menu details.


------------
Now this may be double dutch to you

So with respect
a) it is hard to see the benefit of opening a query directly. (as already pointed out) You really should be opening a form/report BASED on the query

b) if you don't understand how to modify the switchboard code/switchboard items table, then the above comment applies especially - if MS thought people would want to/need to/should open queries directly, they would have built in the functionality to the switchboard manager.

 

[xirokx]

hi there,

Im a bit stuck...

I understand what you are saying about there is no point in opening a query from switchboard manager but I do not know how to create a report or form that will enable me to view the data in the same format as a query allows?

If you could clarify this for me step by step I would be so grateful...

Also, I want to assign more then 1 vehicle to a driver, so that when they change their vehicle I can keep historical records...Same for their address details...How can I acheive this....I would really appreciate your help...

Finally I managed to work out how to get more then 8 buttons on switchboard, would you hurt me if I said it was really easy and I was complicating such a simple procedure I now have 10 buttons on my switchboard thanks to you guys and will never forget how to acheive this...

I just need to resolve the above 2 issues before I can provide the database to my friends to use...I will of course split the database and lock it so they cannot amend any code or forms...

I cannot believe this is my first database and I am having much fun seeing the results most important of all thank you all for your patience and support...