By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Query on a Switchboard ?

P: n/a
Does Access allow a query to be listed on the switchboard?
Does Access allow a table to be opened in datasheet view from the
switchboard?

I have an application where users enter new data, print reports, (based on a
parameter query), and edit previously entered data in form view.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
It is not a good idea to give users direct access to queries or tables in
datasheet view in an application -- there are too many things that can
accidentally be done wrong. I suggest you consider creating forms for
displaying and handling the data and using the queries as the forms' record
source. But, if you are determined to use datasheet view, you can use either
a macro or the VBA DoCmd.OpenQuery or DoCmd.OpenTable.

Larry Linson
Microsoft Access MVP
"ogilby1" <og*****@insightbb.com> wrote in message
news:wxsdb.450086$cF.144726@rwcrnsc53...
Does Access allow a query to be listed on the switchboard?
Does Access allow a table to be opened in datasheet view from the
switchboard?

I have an application where users enter new data, print reports, (based on a parameter query), and edit previously entered data in form view.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.