Error

[Paulo Ferreira]

Hello,

I'm trying to use your code but, on "rst.edit" it gives me the error "method
or data member not found".
Any idea?
I'm using Access2003.
Thanks.

Paulo Ferreira

 

[strive4peace]

Hi Paulo,

try this:

when you Dimension your recordset variable, specify the DAO library

ie:

Dim rst as dao.recordset


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Paulo Ferreira]

Now, it stops on line "If rst![InUse] = "Yes" Then" with "runtiemerror
3021".
More help please.
Thanks.

Paulo Ferreira

 

[strive4peace]

Hi Paulo,

you're welcome

Yes/No fields aren't text, they are stored as numbers

If InUse is a Yes/No field, you need to do this:

If rst![InUse] = True then
OR
If rst![InUse] = -1 then

True is a constant that represents -1

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Now, it stops on line "If rst![InUse] = "Yes" Then" with "runtiemerror
3021".
More help please.
Thanks.

Paulo Ferreira

Hi Paulo,

try this:

when you Dimension your recordset variable, specify the DAO library

ie:

Dim rst as dao.recordset


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*