Switchboard

[Lalitha]

For an existing database I designed a SQL query with parameter query. I also
designed a form-startform with two unbound text boxes(text1 and text2) for
start date and end date and these were used in parameter query. Before adding
this query Switchboard will open first when I open the database, but now when
I open the DB the list of objects are opened and I need to enter the start
date and end date to open the switchboard form. Other forms open
automatically. When I open the database I want the SB to be opened, It is
already set as default page. I will appreciate the help very much.

 

[Larry Linson]

For an existing database I designed a SQL query with parameter query. I
also
designed a form-startform with two unbound text boxes(text1 and text2) for
start date and end date and these were used in parameter query. Before
adding
this query Switchboard will open first when I open the database, but now
when
I open the DB the list of objects are opened and I need to enter the start
date and end date to open the switchboard form. Other forms open
automatically. When I open the database I want the SB to be opened, It is
already set as default page. I will appreciate the help very much.

Just designing and implementing a Form will not cause that Form to be opened
at Startup. So, you must have changed the Tools | Startup options in the
database window. Change them back to what they were before, and update your
Switchboard to include a capability to open the Form from which you open the
Query.

Larry Linson
Microsoft Access MVP

 

[Lalitha]

Larry, I did not explain the problem clearly let me try again. The database
was designed by another person with tables, forms, queries and a switchboard
which opens when I open the database. All those queries have parameter
queries linked to switchboard. When I tried the same method for my query SB
is blank in form view. But design view was available. Suggestion was made to
design a unbound form with two textboxes to define parameer query to enter
start date and end date to my query.
when i did that only the switchboard form(already designed by previous
person) requires me to enter start date and end date in the
dialogbox(designed by me). I need the swtch board to be opened without
upsetting the previous setup, my query to run smoothly, and report of my
query also to be run from a button on switch board. This little part ihave
done successfully. Hope I am clear. I may be missing a small think. I am new
to database design.

Thank you for your help and appreciate very much.

 

[Larry Linson]

You designed and implemented an unbound form with two textboxes -- that I
understand. But what I said was this: designing and implementing that form
will not cause the switchboard to automatically open that form.

What did you do to the switchboard to make it open the form?

Is this a switchboard created and modified by the Switchboard Manager, or is
it just unbound Form(s) with Command Buttons and Text Boxes? (If it is
handled via the Switchboard Manager, then someone else will have to
assist -- I don't use the Switchboard Manager because it seems to me to be a
complex solution to a simple problem and I don't use it.)

Is this query truly a _parameter_ query? That is, does the Query itself
refer to the Controls on your Form, or do you use VBA code to create a WHERE
clause that you use in a DoCmd.OpenReport or other command?

Do you want to expose the Query results directly to the user in Datasheet
View (not generally a good idea)? Or is it enough that you use the values
from the Text Boxes to limit the data shown on the Report?

Larry Linson
Microsoft Access MVP

 

[Lalitha]

Thank you so much for your effort Larry. I found my mistake. I have selected
the new query as the record sourse in the switchboard form by mistake. I have
fixed every thing. Anyway by making a small mistake I have learned a lot.

Thanks again,
Lalitha.