Queries on a Switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Fredq,
While searching for how to add a query to a switch board, I came across your
advice to some else (dated 3/1/2005 re:queries/switchboards), since was
search for the same info, I tried it.
I made the module and named the function as you did "OpenAQuery"
then replaced "TheQueryName" w/the actual existing query name
"NamesAlphaOrder" so my module looks like this:
The text
Public Sub OpenAQuery()
DoCmd.OpenQuery "NamesAlphaOrder" (without parenthesis)
End Sub
Click to expand...
Then, I saved the file under objects+modules+(name=)Queries1
As per your instructions I opened switchboard manager, made the
additions to the main switchboard using edit mode.
Select the Edit mode and Click on New and Write
"Run a query" in the Text box (without the quotes).
 
DLHoston said:
Fredq,
While searching for how to add a query to a switch board, I came across
your
advice to some else (dated 3/1/2005 re:queries/switchboards), since was
search for the same info, I tried it.
I made the module and named the function as you did "OpenAQuery"
then replaced "TheQueryName" w/the actual existing query name
"NamesAlphaOrder" so my module looks like this:
The text
Then, I saved the file under objects+modules+(name=)Queries1
As per your instructions I opened switchboard manager, made the
additions to the main switchboard using edit mode.
Select the Edit mode and Click on New and Write
"Run a query" in the Text box (without the quotes).
Click to expand...
Hi DLH,

I always create my own "Switchboard"
form, so have no experience here, but...

I think the problem is here:

OpenAQuery *is* the function

so if I were putting something in a
Function name box, I would put
OpenAQuery, not NamesAlphaOrder....

good luck,

gary
 
Back
Top