Can I Access A Query From A Switchboard?

Apr 14, 2007

I am trying to access a query from a switchboard. I see that the Switchboard Manager shows you only reports and forms - no queries. How can I run a query from a switchboard?

Robert

View Replies


ADVERTISEMENT

Access Switchboard Command To Run Query

Oct 31, 2004

Hi!
I'm working on an Access file. I know how to create a swtitchboad and have it appear when the file opens. The switchboad will have three commands. The commands will be:

1. Open a form called "FORM1" in add mode.

2. Run a query named "Query1" so that it will run a query that is the only query in the file. The query only lists ten items of information entered in the ONE most recently completed entry in ONE table.

3. Close the switchboard and then close the file.

I know how to do the first and third commands. Does anybody out there know how to write the code, or the macro, or whatever it's called that will do the second one?
Thanks,

pfdjr

View 1 Replies View Related

Switchboard Access

Apr 12, 2007

I'm sure there probably an easy explaination for this, how do you make the main switchboard a desktop icon instead of going into the database so that all they have access to is the switchboardand the forms etc.

View 3 Replies View Related

Access 07 Switchboard HELP!!

Feb 27, 2008

Pretty much ive became stuck in access 07. i have made all my forms and i have made my switchboard but when i when i looked for the "startup" option as existed in 2000 i couldnt find it.

Basically i am setting up a database as part of my alevel coursework and unfortuanatly i am the first person to reach the stage of wanting to run the switchboard on startup. I would greatly appreciate it if any one could shed any light on how to run a switchboard automatically on startup. i know it is probably something reli simlple that i have just over looked so any help at all would be just great :D

cheers, Paul

View 2 Replies View Related

Switchboard Not Available In Access Database

Aug 29, 2005

As a newcomer to Access programming I have just shot myself in the foot!
I unticked all the start-up boxes and the switchboard no longer appears. My database works fine (thanks to several articles in your amazing forums) but I don't know how to access the switchboard as I need to add a delete record button to a form.

Silly but true, I seem to remember that the switchboard can be unhidden by pressing a few keys?

I would be grateful if someone could spare a few seconds to advise.

Ralphie :o

View 3 Replies View Related

Access Switchboard Problems!

Feb 18, 2007

Im creating a acccess database system as part of my A-level ICT project. Im having problems with the switchboard, which i designed using the Switchboard Manager. it comes up with the following error message:

Run-time error ‘2465’:

Pass-It Driving School can’t find the field ‘Option8’ referred to in you espression.

Then when clicked on 'Debug' it displays the VB code as follows:

Private Sub FillOptions()
' Fill in the options for this switchboard page.

' The number of buttons on the form.
Const conNumButtons = 8

Dim con As Object
Dim rs As Object
Dim stSql As String
Dim intOption As Integer

' Set the focus to the first button on the form,
' and then hide all of the buttons on the form
' but the first. You can't hide the field with the focus.
Me![Option1].SetFocus
For intOption = 2 To conNumButtons
Me("Option" & intOption).Visible = False
Me("OptionLabel" & intOption).Visible = False
Next intOption

' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set con = Application.CurrentProject.Connection
stSql = "SELECT * FROM [Switchboard Items]"
stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID]
stSql = stSql & " ORDER BY [ItemNumber];"
Set rs = CreateObject("ADODB.Recordset")
rs.Open stSql, con, 1 ' 1 = adOpenKeyset

' If there are no options for this Switchboard Page,
' display a message. Otherwise, fill the page with the items.
If (rs.EOF) Then
Me![OptionLabel1].Caption = "There are no items for this switchboard page"
Else
While (Not (rs.EOF))
Me("Option" & rs![ItemNumber]).Visible = True
Me("OptionLabel" & rs![ItemNumber]).Visible = True
Me("OptionLabel" & rs![ItemNumber]).Caption = rs![ItemText]
rs.MoveNext
Wend
End If

' Close the recordset and the database.
rs.Close
Set rs = Nothing
Set con = Nothing

End Sub

Private Function HandleButtonClick(intBtn As Integer)
' This function is called when a button is clicked.
' intBtn indicates which button was clicked.

' Constants for the commands that can be executed.
Const conCmdGotoSwitchboard = 1
Const conCmdOpenFormAdd = 2
Const conCmdOpenFormBrowse = 3
Const conCmdOpenReport = 4
Const conCmdCustomizeSwitchboard = 5
Const conCmdExitApplication = 6
Const conCmdRunMacro = 7
Const conCmdRunCode = 8
Const conCmdOpenPage = 9

' An error that is special cased.
Const conErrDoCmdCancelled = 2501

Dim con As Object
Dim rs As Object
Dim stSql As String

On Error GoTo HandleButtonClick_Err

' Find the item in the Switchboard Items table
' that corresponds to the button that was clicked.
Set con = Application.CurrentProject.Connection
Set rs = CreateObject("ADODB.Recordset")
stSql = "SELECT * FROM [Switchboard Items] "
stSql = stSql & "WHERE [SwitchboardID]=" & Me![SwitchboardID] & " AND [ItemNumber]=" & intBtn
rs.Open stSql, con, 1 ' 1 = adOpenKeyset

' If no item matches, report the error and exit the function.
If (rs.EOF) Then
MsgBox "There was an error reading the Switchboard Items table."
rs.Close
Set rs = Nothing
Set con = Nothing
Exit Function
End If

Select Case rs![Command]

' Go to another switchboard.
Case conCmdGotoSwitchboard
Me.Filter = "[ItemNumber] = 0 AND [SwitchboardID]=" & rs![Argument]

' Open a form in Add mode.
Case conCmdOpenFormAdd
DoCmd.OpenForm rs![Argument], , , , acAdd

' Open a form.
Case conCmdOpenFormBrowse
DoCmd.OpenForm rs![Argument]

' Open a report.
Case conCmdOpenReport
DoCmd.OpenReport rs![Argument], acPreview

' Customize the Switchboard.
Case conCmdCustomizeSwitchboard
' Handle the case where the Switchboard Manager
' is not installed (e.g. Minimal Install).
On Error Resume Next
Application.Run "ACWZMAIN.sbm_Entry"
If (Err <> 0) Then MsgBox "Command not available."
On Error GoTo 0
' Update the form.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.Caption = Nz(Me![ItemText], "")
FillOptions

' Exit the application.
Case conCmdExitApplication
CloseCurrentDatabase

' Run a macro.
Case conCmdRunMacro
DoCmd.RunMacro rs![Argument]

' Run code.
Case conCmdRunCode
Application.Run rs![Argument]

' Open a Data Access Page
Case conCmdOpenPage
DoCmd.OpenDataAccessPage rs![Argument]

' Any other command is unrecognized.
Case Else
MsgBox "Unknown option."

End Select

' Close the recordset and the database.
rs.Close

HandleButtonClick_Exit:
On Error Resume Next
Set rs = Nothing
Set con = Nothing
Exit Function

HandleButtonClick_Err:
' If the action was cancelled by the user for
' some reason, don't display an error message.
' Instead, resume on the next line.
If (Err = conErrDoCmdCancelled) Then
Resume Next
Else
MsgBox "There was an error executing the command.", vbCritical
Resume HandleButtonClick_Exit
End If

End Function

[SIZE=3]Could someone kindly help me with this problem as im not a very experienced user with VB. Any Help would be appreciated. u can email me on [B]atiqskool at yahoo.co.uk

View 1 Replies View Related

How Can I Show Switchboard Only (i.e Access Doesn't Appear To Be Open)

Jul 19, 2005

Hi,
Does anyone know if I can just show the switchboard only so that it looks like a program, or if I can use an existing MDB to create an .exe??

View 2 Replies View Related

Linking From Switchboard To Switchboard On Two Or More Databases

Nov 21, 2006

I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.

I have the original database with the name of "Cell MFG Screen" that contains a switchboard. I am now creating a db to keep track of manufacturing waste (which will also be on the same server when completed). That switchboard is called "Cell Waste Weight". Again, I want to keep these db's separated from one another as well being able to add future dbs. Now, what my plan is to make up a one db that consists of only a switchboard that will be used as the main switchboard to be able to navigate to other dbs that are located on the server.

Does anyone know how this is done?

Thank you in advance for your help,

~Kilch

View 10 Replies View Related

User Security Access 2013 For Switchboard Items

Aug 3, 2015

I have user security level setup with username and password.I have set forms and tables etc to security levels.what i am having trouble with is setting user security levels to command buttons on the switchboard.Example if you sign in Mary Jones and you click on the command button (open Tom Smith switchboard) button on the main switchboard and your not tom smith you get a message access denied.

Code:
Private Sub Form_Open(Cancel As Integer)
If Forms!frmLogin!cboUser.Column(4) <> 2 Then
MsgBox "you cant open this form"

[code]...

it is a switchboard page. and putting CoCmd.OpenSwitchboardPage that does not work either..when you look at the event on click of the command button a macro opens up but I dont see how you can edit it.

View 5 Replies View Related

Switchboard Query

May 3, 2005

Hi guys,

I've got a form that shows the result of a query in datasheet mode.

However if I use a switchboard to open the form (and hence run the query) the results aren't in datasheet mode but in column mode.

How do I get the this query to display in datsheet view?

Thanks

View 2 Replies View Related

Add A Query To A Switchboard

Nov 8, 2007

hi i have a query that is connected with a form. Now i want to add that form to the switchboard, but i have to add the qry as the form doesnt work without the qry. so i was wondering if anyone knew how to add a qry to a switchboard??

View 2 Replies View Related

Running A Query From A Switchboard

Jan 21, 2008

I have an SQL query which simply deletes any blank records from a table. I want to put it on a switchboard menu, but cannot see an option to do that. How do I do this? Perhaps create a little form and put a button on it to run the query?

Robert

View 1 Replies View Related

Switchboard Front Page - Users Able To Access Forms For Data Input

Dec 8, 2011

I have created a switchboard 'front page' through which I hope for users to access the forms for inputting data.

Within this front page I have an 'enter' button - successfully created - everything.

However, I am unclear as to how you activate this, or any other button. I have linked it to the appropriate form and stated the action I want it to undertake, but nothing is happening.

What further instructions do I need to provide ...and where?!

View 5 Replies View Related

Re-opening 'switchboard' After Closing Crosstab Query?

Jan 12, 2006

I have a 'switchboard' form called Menu (not created by access wizard). One of the buttons down the navigation tree opens a crosstab query for the user to examine a data summary; but the 'Menu' form is still visible right in front of the query. Now, I could close the Menu form easily enough when the run query code is triggered, but that would leave the user loose in the database window when they eventually close the crosstab query window.

All that I have read on database navigation says that this is bad thing.

I can't place the crosstab query into a form or report because the column headings/fields don't appear when I try. (The field headings of the cross tab query are likely to change based on the underlying select query parameters so I can't hard-code the field names).

So, any thoughts on how to reactivate my Menu once the user closes the crosstab query or else puts the focus on the database window? (I achieve this using vba code in the on_close events of other forms and reports but I don't see an equivalent option for queries!)

Please note that I'm a vba newbie!

Thanks,
Craig

View 5 Replies View Related

Count On Query And Displaying Result On A Switchboard

Jul 31, 2006

Hi Folks

More questions from the newbie :eek:

I have a very simple table with a field that will have only the values open or closed

I created a query based on this table and used the count function (to count open or closed cases) and in the next querie field I used the group by open.

This gives me a count of all open cases

I can do the same for closed cases.

I want this count to be displayed on a Switchboard form but i cant get my nehad round how to get it there.

Can anyone help me out ?

Many thanks

Jimmy

View 6 Replies View Related

Switchboard

Apr 14, 2006

Hi All, looking for some help.

I am looking for a way to link a help file to a button on the switchboard. I have several pages that all work well and open up the required forms and reports but I would like to add a help file to a button. Any idea would be appreciated thanks Williebear.

View 3 Replies View Related

Switchboard

Aug 10, 2005

hi everyone,

I am new to MS Access. I've created a database and now i want to add a switchboard to launch whenever i open the database file. i created the switchboard form and table following the access help. but i can only view the switchboard when i manually open the switchboard form. can anyone tell me how to make the swithboard launch automatically? i'm using access 2003

thanks

View 1 Replies View Related

Switchboard

Nov 14, 2005

I have a main switchboard, with a few Open Form command buttons on it, but what i would like to have is another button to bring the user to another switchboard screen giving the option to open a few Reports (obviosly the button on teh main switch board would read "Report Section), can this done, and also how would i go about putting Back or forward buttons withing the second (report Section) screen so the user can nav. to back to the main screen?

Thanks

View 2 Replies View Related

Switchboard Help

Dec 12, 2005

All,

I have created a new switchboard but don't know where it is. When I create it using the Switchboard Manager and then click close, it doesn't appear under any of the options. I have also set is as default but it fails to appear on startup.

Silly question I know. Any ideas?

Many Thanks

version: MS Acess 2003

View 8 Replies View Related

Switchboard

Jan 10, 2006

Was wondering how one might go about creating a swithboard similar to the Northwind one found in the sample database. Thanks

View 1 Replies View Related

Help With Switchboard

Jan 31, 2006

Brief Summary,

I have limited experience in Access but have a bit more understanding of databases and tables. I am helping a friend create and access database to track the time his employees spend on different job sites. i am using a template from Microsoft called "Time and Billing" I am going to be manipulating the structure a bit but other than that the template should work fine.

My main struggle is I need to have a screen that the employees access that takes them straight to add / edit a time sheet. i want the rest of the data, reports, views to be password protected. Ideally the switchboard would load up to a page that had a button from employees to click on where they would be taken to the form and a button the owner could click on, enter a password, and be taken into the back-end where the main switch board and the rest of the data resides.

If anyone can help me out that would be great. Oh yeah, The Access database in is Access 2000 being used on a machine running XP Pro.

Thanks in advance for your help.

Gary

View 1 Replies View Related

Switchboard....

Feb 22, 2006

Ok, so I will sound like the dumbest person but essentially what is a switch board?

I have searched this place I have searched google but no luck, all I get is that its a menu to navigate, so basically a form with buttons that open frm's qry's etc... I have made a main menu with a basic form so whats so special about a switchboard.

Cheers

View 2 Replies View Related

Switchboard

Mar 13, 2006

I have two queries. I have a delete query and an append query. Is there anyway that I have these two queries run on a switchboard.

View 4 Replies View Related

Switchboard!

Mar 15, 2006

Help - I made a switchboard and it went wrong, so deleted all of the sub switchboards and the switchboard icon in the forms window.

I have now made a new one, but I can't get it to appear in the forms window.

Any ideas?
Shellie xx

View 2 Replies View Related

Switchboard

Feb 26, 2008

Hi

Can anyone tell me what the advantage (or difference) is in using a switchboard rather than just creating your own form and using command buttons etc?

Thanks

View 3 Replies View Related

Switchboard

Apr 9, 2008

When I make a switchboard is there any way you can go to a table? or can you just go to a form or query? and when you make a switchboard and you have a button going to the form how can you go from the form back to the switchboard?

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved