RE: Please Help!? new User

Tech-Archive recommends: Fix windows errors by optimizing your registry

OK thanx Klatuu I'll save that for tommorrow!
--
Regards

Ashley Smart


"Klatuu" wrote:

> This is different. It has to do with how the recordset is defined. I think
> you need to identify it as a dynaset recordset type:
> Set myset = mydb.OpenRecordset("Objects to Copy", dbOpenDynaset)
>
> "A. Smart" wrote:
>
> > Right you are just re-checked DAO Object Libray. Excellent Thanx
> > I do have another Compile error now!
> >
> > If rs.NoMatch Then
> >
> > Method or Data Member not found (.NoMatch)
> > Can u help?
> > --
> > Regards
> >
> > Ashley Smart
> >
> >
> > "Klatuu" wrote:
> >
> > > You have a missing or undefined reference. In the VBA Editor,
> > > Tools->References
> > > If you see one that says "Missing", you need to reestablish the reference.
> > > If none are missing, then you need to add it. Because this happens trying to
> > > dim a database object, it is probably the dao library you are missing.
> > >
> > > "A. Smart" wrote:
> > >
> > > > I have succesfully used microsofts code to password protect a form, but when
> > > > applied to my own database I get a compile error for the type Database!!
> > > > Coding Line is:
> > > >
> > > > Dim db As DataBase
> > > >
> > > > From (http:/support.microsoft.com/default.aspx?scid=kb;en-us;179371)
> > > >
> > > > Error is:
> > > >
> > > > Compile Error:
> > > > User-defined type not defined
> > > >
> > > > Surely the database type isn't user defined. PLEASE Help!
> > > > --
> > > > Regards
> > > >
> > > > Ashley Smart
.

Relevant Pages

  • RE: Help needed with Price Change
    ... "Klatuu" wrote: ... Back to the orginal problem of opening the recordset. ... Dim Conn As ADODB.Connection ... Set rst = New ADODB.Recordset ...
    (microsoft.public.access.formscoding)
  • RE: Passing a record to a function
    ... "Klatuu" wrote: ... visibility to the recordset, so it doesn't have to be passed. ... Dave Hargis, Microsoft Access MVP ... ADODB.recordset that I am trying to figure out how to pass from Sub to ...
    (microsoft.public.access.modulesdaovba)
  • RE: Help with Record Not On File
    ... "Klatuu" wrote: ... Set rst = nothing releases the reference to the recordset. ... Now the user can see both the tag number and the animal's name. ...
    (microsoft.public.access.forms)
  • Re: Need Form and TextBox Help
    ... Klatuu wrote: ... You open a recordset based on a table or query, ... HR needs to know on any given store how many times they sent a resume ...
    (microsoft.public.access.forms)
  • Re: Newbie question on Datatable
    ... Best regards, and once again, thank you for your time ... new Access recordset that is derived from an Access Query. ... As a VB6 coder you probably own or know of "Programming Microsoft ... Dataset is a container around multiple datatables and / or data adapters ...
    (microsoft.public.dotnet.languages.vb)