Results 1 to 7 of 7

Thread: printing an access table in vb6

  1. #1

    Thread Starter
    Addicted Member GenocideOwl's Avatar
    Join Date
    Jul 2006
    Location
    Ohio
    Posts
    144

    printing an access table in vb6

    how would I print an access table(I am using ADO) in VB6?

  2. #2
    Addicted Member BestS's Avatar
    Join Date
    Mar 2005
    Posts
    222

    Re: printing an access table in vb6

    With DataReport for example.
    Using Visual Basic 6.0, access 2000, Visual Studio 2005

    Rate the post that you approve

  3. #3

    Thread Starter
    Addicted Member GenocideOwl's Avatar
    Join Date
    Jul 2006
    Location
    Ohio
    Posts
    144

    Re: printing an access table in vb6

    DataReport?
    I am still new to a lot of stuff in VB6, could you forward me to a link or explain what that means?

  4. #4
    Addicted Member BestS's Avatar
    Join Date
    Mar 2005
    Posts
    222

    Re: printing an access table in vb6

    On the project explorer right click -> Add -> DataReport.
    It works with recordsets
    I'll give you an example.
    Using Visual Basic 6.0, access 2000, Visual Studio 2005

    Rate the post that you approve

  5. #5
    Addicted Member BestS's Avatar
    Join Date
    Mar 2005
    Posts
    222

    Re: printing an access table in vb6

    Here is a good link with example. Good luck

    http://msdn.microsoft.com/library/de...datareport.asp
    Using Visual Basic 6.0, access 2000, Visual Studio 2005

    Rate the post that you approve

  6. #6

    Thread Starter
    Addicted Member GenocideOwl's Avatar
    Join Date
    Jul 2006
    Location
    Ohio
    Posts
    144

    Re: printing an access table in vb6

    quick question
    is there an ADO command to just tell access to print the current open table?

  7. #7
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: printing an access table in vb6

    No... ADO is just a link between your program and a database, which allows you to transfer data (and meta-data) from one to the other.

    Also, as far as ADO is concerned, there is no "current open table" - only a selection of recordsets which are open (which may possibly be based on whole tables).

    If you want to print the data, you need to either use some kind of reporting tool (Data Report/Crystal Report), or print it yourself with code using the Printer object.

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