Results 1 to 2 of 2

Thread: [RESOLVED] need code explanation

  1. #1

    Thread Starter
    Member
    Join Date
    Sep 2014
    Posts
    45

    Resolved [RESOLVED] need code explanation

    Please explain each line
    Code:
    Set Axs = CreateObject("Access.Application")
    Axs.OpenCurrentDatabase ("C:\Users\Talha- khan\Desktop\SIMS\Database1.mdb")
    Axs.DoCmd.OpenReport "customer_receipt_report"
    Axs.Quit
    Last edited by FunkyDexter; Dec 22nd, 2014 at 06:31 AM.

  2. #2
    VB-aholic & Lovin' It LaVolpe's Avatar
    Join Date
    Oct 2007
    Location
    Beside Waldo
    Posts
    19,476

    Re: need code explanation

    Axs is just a variable of type variant. Lines...
    #1. start new Access app & store reference in Axs
    #2. have Access open database at the path/file specified
    #3. run a stored report within that database
    #4. close Access
    Insomnia is just a byproduct of, "It can't be done"

    Classics Enthusiast? Here's my 1969 Mustang Mach I Fastback. Her sister '67 Coupe has been adopted

    Newbie? Novice? Bored? Spend a few minutes browsing the FAQ section of the forum.
    Read the HitchHiker's Guide to Getting Help on the Forums.
    Here is the list of TAGs you can use to format your posts
    Here are VB6 Help Files online


    {Alpha Image Control} {Memory Leak FAQ} {Unicode Open/Save Dialog} {Resource Image Viewer/Extractor}
    {VB and DPI Tutorial} {Manifest Creator} {UserControl Button Template} {stdPicture Render Usage}

Posting Permissions

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



Click Here to Expand Forum to Full Width