Search results

OK, I tweaked the RehabTestQuery query and now I have the following, but am still getting the Too Few Parameters error message on the line that opens the rstRehab (the long line--it's actually one one line in my module): Option Explicit Public Sub OverlayNo() Dim myDb As DAO.Database Set myDb...

OK, I have made most of the changes you recommended as far as my sub name, public, explicit, etc. I had declared a string variable of RehabQuery to run to create the recordset, then I have these two lines right under the Debug.Print statements: DoCmd.RunSQL rehabQuery Set...

Unfortunately, that didn't work, but I appreciate the help.

I've uploaded a database attached here called PMBooks1. It coughs and spits at the line: Set rstRehab = myDb.OpenRecordset(rehabQuery) I get an error message to the effect that VBA "expected parameters," but evidently was disappointed. I know that the SQL is valid because I tested it in...

Sorry for the double post, I thought it wasn't working. In case anyone else is wondering, I had to go get the Show All Actions from the Options to put on my ribbon. I searched the help, plus a huge book I bought, but it wasn't readily found in either place. I would think all the macro...

Never mind, I got it.

Never mind, I found it.

Forgive my denseness (density?:confused:) but I don't see a Show All Actions option on the ribbon. I enabled the macros, but don't see this. Thanks.

I've done macros before in 2003 where I run queries and do SetWarnings to Off. But I can't seem to find this action in 2007. Does it go by another name now? Thanks.

The first SQL statement work, the one for the sections because the statement Debug.Print rstSections!anssecid works fine. The program coughs when I get to opening the second recordset. I will try setting things up. Thanks for the help. So you can nest recordsets then?

I tried to run the code below, but got an error saying that I was not providing a required parameter, on the line marked in red--it runs fine up to that point. I'm trying to nest looping through one recordset within another (sections with projects on them, an expansion of the simple recordset...

That worked, thanks guys! I'm doing a happy dance that I've run a recordset successfully. I've gotten spoiled to the SCAN . . . ENDSCAN from Visual FoxPro where it assumes the record movement. VFP also lets you see your cursor when debugging. Not being able to see what's going on every step...

Since my previous attempt (posted in a previous thread with no response) didn't work, I decided to punt and simplify things a bit. So I wrote a routine that merely opens a recordset of section numbers, loops through them, and prints the section number in the debug window. The program runs...

Below is the code I wrote after looking at a book. I know, I know, but it's all I have since no Access gurus live nearby. What I'm trying to do is to loop through a recordset of unique pavement sections, then get the overlay/rehab table (rehab_proj_join), of course many projects to one...

The data is a one-to-many relationship, one pavement section to many overlay projects (though some pavements are new construction only with no overlays). So I would need one recordset for the pavement section table, then I'd loop through that, have another recordset for pulling out the overlays...

Thanks for the insight. So I would make a recordset, loop through it, then how would I update the original table? VFP would let me hold memory variables then I could do UPDATE SQL or INSERT to update the original table. Would I need two recordsets--one for the distinct...

I'm trying to convert some Visual FoxPro applications to Access/VBA, and I find that I'm spoiled to some of the old xbase code. For example, VFP has a recno() function. I realize that Access does not have this for practical reasons, but unfortunately, I still need it. My data sitch is this...

Hello--I'd like to request your help. I've created a form where I use combo boxes to narrow down user choices. The combo boxes have an SQL statement for a RowSource, and this works well. However, I can't get the the record pointer off the first record and filter them down to the criteria...