Command Button for Tables?

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

Guest

I know how to write a command button in a form to open a query. Is there a
way to open a table.
 
I know how to write a command button in a form to open a query. Is there a
way to open a table.
Click to expand...

Yes there is, but why would you want anyone to look at a table.
Tables are for data storage, not display.

DoCmd.OpenTable "TableName", , acReadOnly


will open the named table as read only.
See VBA help for the other arguments available.
 
Thank you both for your comments, it worked. Fred I wanted to have someone
able to add items into a drop down field. I usually would not have people in
the tables. Thanks for your words of caution.
 
You might want to heed the horror stories of dropdowns in tables and use a
dropdown in the data entry form instead.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Command Buttons On The Fly 1
Access Automatically Send a notification email once a record is added 0
Command Button not working 1
Open specific form from cmd button 3
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
command buttons access 2007 2
Date parameter 1
Command Button 1

Back
Top