Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    330
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Import a form via code (Acc 97 sr2 on 95b)

    On our 6 machine network, 5 run win95b and 1runs NT4. The NT machine has a slightly different printer driver and so the print and margin settings alter slightly on this machine and have to be manually corrected every time the database front end is updated.

    What I want to do is set up a database on the NT that has only the 3 forms in it that need to be changed.

    I want to put a button on the front end that will run a macro or function that will delete the 3 from the db and then copy the 3 from the reserve db into the db.

    I know how to delete the 3 forms: docmd deleteobject

    but how do I import using code, the 3 forms that I want?
    "Heading for the deep end"

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import a form via code (Acc 97 sr2 on 95b)

    Use :
    DoCmd.TransferDatabase acImport,"Microsoft Access","C:My DocumentsMyDatabase.mdb",acForm,"FormNameToImport" ,"DestinationName"
    Francois

Posting Permissions

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