how to remove compile error "method not found" in ACCESS2000?

[ArmstrongHe]

Dear Sir,
When I compile the following code in VBA of ACCESS2000, I saw compile error like "method not found or invalid number" due to the line "RS.edit". How to overcome the problem?

Dim RS As Recordset
Set RS = myDb.OpenRecordset("PL-report&quot
RS.MoveFirst
Do Until RS.EOF
RS.Edit '***compile error

thanks!
Armstrong

 

[MakeItSo]

Hi Armstrong.

1) Check your references: Your recordset-syntax is only valid for DAO reference.
Check, if you have DAO in your references.

2) If you do have DAO reference and the error remains, try by specifying the recordset/database:
Dim RS as DAO.Recordset
(Dim myDB as DAO.database)

Cheers,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[ArmstrongHe]

Hi, Andreas,
You are very nice! thanks very much! I have read the homepage, I can read some German, it's your personal homepage?
Thanks!
Armstrong

 

[MakeItSo]

Hi Armstrong.

Yeah, it's my personal hp. I have to work on the design a bit, takes much too long to load all the different gifs in there.. ;-)
BTW: It's completely bilingual.

Concerning your problem: Did it work, have you solved it?

 

[ArmstrongHe]

Hi, Andreas,
Yeah, at least compile is passed well without error.
Are you working in Germany?
Best Wishes!
Armstrong

 

[MakeItSo]

Working in Germany, living in Germany...
I confess: I am German.
Long live the all-connecting, all-uniting (?) Internet!

 

[ArmstrongHe]

I am working in China, for an American company. I am Chinese, very nice to know you by tektips. thanks again!