Solved

Can I open a table to edit using a button in Access 2013?

Posted on 2016-09-28
8
31 Views
Last Modified: 2016-10-17
I would like to open a table to edit (when necessary) using a button. The button will reside on a form that I created for a Main Menu. The name of the table is "ListofDetectives -tbl". I tried this ( docmd.opentable "ListofDetectives -tbl", acviewnormal).

Is this the correct syntax? If so, where would I place it? I do understand that buttons are really for forms, records, reports. I am curious if this can be done.
Thanks
Earl
0
Comment
Question by:Earl Wolf
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 41819802
you must apply the VBA code in YourButton_Click event procedure as the following:

Private Sub YourButton_Click()
      DoCmd.OpenTable "ListofDetectives -tbl", acViewNormal, acViewNormal, acEdit
End Sub
1
 

Author Comment

by:Earl Wolf
ID: 41819845
Thanks for the syntax. Should this be placed in the event on click setting in the buttons properties?
0
 
LVL 57
ID: 41819847
Earl,

 Just as a side comment and a cautionary note: this is normally not something you'd do.   Tables should not be worked with directly, but via forms.

 When a table is opened directly, there is no control you can apply over what happens.  

 With Forms and controls, you have properties and methods you can use to ensure data integrity, format, etc.

Jim.
1
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 41819856
Anyway
@ Should this be placed in the event on click setting in the buttons properties?
Yes
1
 

Author Comment

by:Earl Wolf
ID: 41819884
Thanks Ferruccio, I appreciate it.

Jim,
I totally agree with you. My client would like to see this done. I've tried talking him out of it, but he's persistent about it. I asked why, his reply was, this is how it was done in their old DB. I told him he could get any data he wants via queries.

This is the reason I am asking.
Earl
Back
Submit

FEATURED POST
0
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points (awarded by participants)
ID: 41819950
If your client wants a form that "looks" like a table, create a form in DataSheet view. He'll never know the difference and you will have the necessary events to control what happens.

Some things are just so wrong that you should refuse to do them.  Of course if you stand up for your principles, you have to be prepared if the client won't budge.  Remind him that he is paying for your expertise.  You don't presume to tell him how to run his business, he shouldn't be telling you yours.
1
 

Author Comment

by:Earl Wolf
ID: 41820031
Pat,
Thanks for your feedback. Excellent idea to create the form in DataSheet view. I will insist this is the better approach.
Earl
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 41846331
The poster selected this comment as his best option.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question