Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Question Unanswered: VB converting from 97 to 2000

    I'm new to the ACCESS VB world so if I sound clueless... I am. I'm in the process of converting our Access 97 databases to Access 2000. It look as though I'm having trouble with the VB code attached to the forms. First... am I correct in assuming I have to recompile this code? When I do I get "Method or Data Member not found". I know the fields are in the database. ".[Completion Date] =" is highlited when I try to compile and the error appears. Below is the sub routine its stopping on.

    Sub CloseRequest(RequestNumber)
    Dim MISDB As Database
    Dim RequestT As Recordset
    Set MISDB = DBEngine.Workspaces(0).Databases(0)
    Set RequestT = MISDB.OpenRecordset("Request Table")
    RequestT.Index = "PrimaryKey"
    RequestT.Seek "=", RequestNumber
    If Not RequestT.NoMatch Then
    RequestT.Edit
    RequestT.[Completion Date] = Forms![List Contacts Form]![Completion Date]
    RequestT.[Status] = "Complete"
    RequestT.Update
    Else
    MsgBox "DB Error"
    End If
    RequestT.Close

    End Sub

    Any suggestions?

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    please check your references: 97 used DAO, 2000 uses ADO by default and does not automatically include a reference to the DAO library.

    if you want to set a reference automatically,
    http://www.dbforums.com/t981987.html
    might help.

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    The syntax isn't quite right. If you are referencing fields in the recordset you should use the ! and not a period. So change :

    RequestT.[Completion Date] = Forms![List Contacts Form]![Completion Date]
    RequestT.[Status] = "Complete"


    To

    RequestT![Completion Date] = Forms![List Contacts Form]![Completion Date]
    RequestT![Status] = "Complete"

  4. #4
    Join Date
    Feb 2004
    Posts
    4

    Convert Access 97 to 2000

    Hi Izy,

    I saw your reply to pmslic and went the solution you pointed them at
    I don't know if that one will help me

    I have a problem - converting 97 to 2000. Applicaton is split
    I Compiled and converted then had a number of different problems

    Looked at REFERENCES in new(2000) version of application found discrepencies -

    MISSING ActiveBar Control
    MISSING br549 OLE Control module

    Both appear in 97 version (ticked and without the preceding word 'MISSING')

    I think many of my problems are sue to not finding these reference libraries but how/where do I go to find them

    Thanks for any help one can supply

    Cheers Peter
    PS Would conversion be easier if I firsr unsplit (imported data tablesto application) and then converted
    Does it just require importing with relationships to replace the links or is there more

  5. #5
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    MISSING ActiveBar Control
    MISSING br549 OLE Control module
    ...is always going to give you errors.

    sorry that i dont know what these libraries are or what their a2k equivalents might be. i no longer have any a97 installations to check, but i don't recall seeing these libraries/controls in a standard a97 install back then.

    maybe someone still using a97 can help you.

    splitting / not-splitting wont change anything if your code is looking for something MISSING.

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •