Compile Error: Method or data member not found

RayL · May 4th, 2009, 03:07 PM

I am opening a recordset using the following code

Set dbs=openDatabase"G:\Database\GPManager\GPManagerDa ta.mdb")
Set rstA = dbs.OpenRecordset("tblLineItem", dbOpenDynaset)
rstA.Index = "InvoiceNumber"
rstA.Seek "=", Val(strSearch)
rstA.MoveFirst
vRate = rstA.LineRate

When I run the code, I get a Compile Error. Method or Data member not found. I know the spelling is correct and there is data in the table. What am I missing?

Thanks ... Ray

gbianchi · May 4th, 2009, 05:14 PM

There is a missing ( in open database.. is that the error??

RayL · May 4th, 2009, 07:12 PM

Sorry, I left it out when I posted the message. My bad.

gbianchi · May 4th, 2009, 09:24 PM

if this rstA.LineRate is a field name, shouldn't be writed as rstA!LineRate ???

RayL · May 5th, 2009, 09:36 AM

Thanks, that was the answer. In the past, I have always the dot instead of the bang and it always worked. I would like to know what the difference was, this time.

Ray

gbianchi · May 5th, 2009, 11:24 AM

I really don't know. You should always use ! when you referenced a field...

Maybe you was using rs.item(nameoffield)??? (And I'm not even sure that's the correct property to get a field)

RayL · May 5th, 2009, 05:05 PM

Sorry, you are very correct. I'm not sure what I was thinking this morning. It must have been a senior moment.

After I made my changes, I took a look at previously written code and found that I always used the bang and not the dot. I think I've working on this project too long. Anyway, many thanks, I'll sleep well tonight.

Ray

gbianchi · May 5th, 2009, 05:50 PM

Glad I help you out. Thanks buttons are on the bottom right ;)