Search results

I want to display the message "Processing Record ? of ???..." on the screen while my vba code is running without interruption. Since the msgbox requires the user to click a button to continue, what is the simplest way to display this message on the screen without interrupting the program or...

I am trying to call a subroutine from a VBA routine to append a record to an existing table. Below is the code for opening my recordsets for reading followed by the code creating my table to append to: Public Sub UpdateLotsizes() Dim curDatabase As DAO.Database Dim ProdPlanDB As...

From what I have read, I understand you can't use the seek command on a recordset from a linked table from another database. Is that true? If so, what is the alternative to find a specific record in the table using an indexed field?

I'm trying to use a query in a recordset and I'm getting errors. The query was created in Access using a SQL table. The query and table are in my current database. I get runtime error 3061 (expected 3 parameters) at line in red. Public Sub UpdateLotsizes() Dim curDatabase As Object...

Hi Everyone! I am from Texas and I'm new to the forum. I have experience in Access and experience in programming, but I am new to VBA programming in Access and I'm having trouble with some of the syntax details. I appreciate y'all's patience with some of the dumb questions I may ask.