Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-09-28
8
Medium Priority
?
46 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 23

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 58
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 23

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 39

Accepted Solution

by:
PatHartman earned 2000 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 39

Expert Comment

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

670 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