Recent content by klnlsu

What is the fastest and most efficient method to access and update a record in a SQL table using VBA?

That worked great! Thanks!

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...

Changing the query to a create table query and using the table instead of the query worked great for me. I would suggest you try that.

That fixed it!

I did but I still get the same error.

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...

Opening my recordset this way, will I be able to make changes to the record and write them back?

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?

Changing the query to a make table query and using the table for my recordset worked fine, so this issue is resolved. :o Thanks to pr2-eugin for your help!

I'm taking a new path. I changed the query to a create table query and I am using the table as my recordset. Still debugging, but I didn't receive any compiler errors. :)

Denileigh, In response to your question, no I haven't resolved my issue yet. My problem is I am using a query that requires input by the user and my VBA code doesn't like the way I am trying to use it as a recordset. That is why I am getting the "not enough parameters" error. Instead of using...

I have not received a response to my SQL code, so I am guessing this is more complicated than I at first thought. Should I use a "QueryDef" approach? Or "strSQL"? I haven't been able to get the syntax right for either because I am trying to pass 3 parameters input by the user. Am I going...

There are a series of three queries that are run in this order: SELECT dbo_IMINVTRX_SQL.item_no, dbo_IMINVTRX_SQL.Loc, dbo_IMINVTRX_SQL.trx_dt, dbo_IMINVTRX_SQL.doc_type, dbo_IMITMIDX_SQL.activity_cd, dbo_IMINVTRX_SQL.quantity, dbo_IMITMIDX_SQL.prod_cat, dbo_IMITMIDX_SQL.mat_cost_type...

Yes, the query has parameters, so I'm not sure what to do here because I have to allow the user to select the data. By running the query from within my VBA code using the docmd.openquery, will that solve my problem? I don't know if I understand the strSQL statement enough to use it.