Solved

How to trigger the next record button on an access form via vba?

Posted on 2016-10-13
10
35 Views
Last Modified: 2016-10-21
I’m trying to call the below macro from another module and it does work, but it’s a hit or miss.  Is there a better way to do it?

Public Sub btnNextRecord_Click()
    DoEvents
    DoCmd.GoToRecord , , acNext
End Sub

Open in new window


Just in case it matters, here is how I’m calling it.
Call Forms("frmMyTicketAudits").btnNextRecord_Click

Open in new window

0
Comment
Question by:kbay808
  • 5
  • 5
10 Comments
 
LVL 34

Expert Comment

by:PatHartman
ID: 41842307
If you want to make common code, put it into a standard module.  Forms are classes and they are not available unless the form is open.
0
 

Author Comment

by:kbay808
ID: 41842369
I will always have the form open and I'm calling it from a standard module.
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 41842382
It only makes sense to call it from a form.  in a standard module, you don't have a bound recordset which is what this code affects.
0
 

Author Comment

by:kbay808
ID: 41842392
The reason why I'm calling it from a standard module is because I am calling it from Excel.
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 41842418
Can you tell us what you are trying to do with this code and why you are running it in Excel.  If you are attempting to process a recordset, this is the wrong approach.  You would simply open a recordset using ADO and process that in EXCEL without automating Access.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:kbay808
ID: 41843640
I have an excel file that compiles and processes that data.  I have code that updates all of the fields in an access form from excel that works great.  The only thing that I can’t do consistently is click the next record.  My goal is to be able have the user not have to go back and forth between excel and access.  The access form will always be open during this process.
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 41843673
Let's start with - form's don't store data.  Tables store data.  That means that your Excel app, if you are using it to update data (and I'm having trouble with that also but that's a different issue), should be updating a table NOT trying to poke data into an open form.  

If you want to use Excel to update data in an Access table, do it by opening a recordset in Excel and updating that way or by running an update query.  Do not do this by manipulating forms.   If you are doing this because you have code in the form's BeforeUpdate event that needs to run, why not just do the data entry in Access and eliminate Excel from the process?  You can export the data back to Excel when you are done.
0
 

Author Comment

by:kbay808
ID: 41843694
You way make more sense.  I will work on doing it that way.
0
 

Author Closing Comment

by:kbay808
ID: 41853997
Thanks for your help
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 41854038
Glad to help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

910 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now