To Ken Snell

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

Ken:

Ken:

Sorry, for not following in the previous tread of October
22. I figured that since this page is on a current date,
it would be easier to keep up. If you wish to reply to the
first tread for all to benefit, by all means, be my guest.
I am new to this news group thing, about a couple of
months or so. I work most issues out via researching help
files and the like prior to coming here.

Here is the code:

If Len(Me.cboDayShift.Value & "") <> 0 And Len
(Me.cboNigthShift.Value) <> 0 Then _
Me.Recordset.AddNew
End If

The error generated targets the "Me.Recordset.AddNew" part
of the code in both instances with the "Method Or Data
Member Not Found" error.

Hoping that this may help in the debugging.


Thanks,...
 
PMFJI....

If you are using A2K or 2003, do you have a reference to
Microsoft DAO 3.6 Object Library checked?
Your code ran fine when I tried it in a form I whipped up.

Also, did you mean cboNigthShift or cboNightShift?
^^ ^^
Steve
 
Steve:

Thanks for your assistance. However, I'm still having
problems getting this to run correctly.

I'm using Access 97. Ooops, yes I did mean cboNightShift.
I'm still getting the error ("Method Or Data Member Not
Found") mentioned earlier even after setting the reference
to DAO 3.6. The reference in Access 97 is DAO 3.51, I
think, correct? Or does it matter in this case? It seems
that something else is missing, I can smell it, but, not
cigars,yet!

HELP!
 
Russ,

In A97, there is no method (recordset.AddNew) available to
add a new record. when you type in the code window, after
you type Me. a dropdown appears. Moving down to the "R's",
there is a RecordSetClone, but not a RecordSet. That is
what the error message is telling you.

Ken Snell is still replying to your thread from Oct 22 at
7:26am.

I don't have my Access97 Developers Handbook, but I think
you could use :

DoCmd.GoToRecord,,acNew

but I'm not sure how to add the new data to the fields.

I'll keep looking.....


Steve
 
Back
Top