Tab Control and Record Operations

Posted on 2001-06-17
Medium Priority
Last Modified: 2008-03-06
Using MS Access 2000

i created a form and then place a tab in it. the tab doesn't have buttons for record operations (add, delete, etc.) and record navigation (find next, find precious, etc).

i want my tab to have this capability bec i'm going to place fields (text boxes, combo boxes) in them so that the user can modify the contents of my table.

i tried inlcuding command buttons using the wizard. i'm able to create, say, a save button in the tab -- just that it doesn't actually save anything when clicked.

any advice?
Question by:kiphughes
  • 2
LVL 12

Expert Comment

ID: 6200379
hi Kiphughes,

if u have created the button using the wizard.
select the button, and open the properties window.
Scroll down until u see 'onClick'.  
Put the mouse pointer in it and click. On the right u will see a button with arrow, choose it and it should show 'Eventprocedure'. Select this. Save the form and try your actions again.


ps: might be that the actual naming i used is a little off, since i only have a dutch version.

Author Comment

ID: 6200396
the wizard automatically does that for you. try stepping throught the wizard and u'll see what i mean. the code it generates is this:

Private Sub Save_Click()
On Error GoTo Err_Save_Click

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

    Exit Sub

    MsgBox Err.Description
    Resume Exit_Save_Click
End Sub

i don't know what it means. but whatever it is, it doesn't save me stuff.
LVL 12

Accepted Solution

Paurths earned 80 total points
ID: 6200472
hi kiphughes,

i know the wizard does that for u. But sometimes with tab-elements the code is no longer connected to the button.
U have to make sure that the click-event of the button is shown in the properties window of the button.

try to add a line to the code, to see if it runs the code:

Private Sub Save_Click()

   DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
msgbox "Ok, passed"

end sub



Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

627 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