Results 1 to 7 of 7

Thread: Printing in access

  1. Jul 16th, 2003, 10:20 AM #1
    FiRe5tOrM
    FiRe5tOrM is offline

    Thread Starter
    Member
    Join Date
    Jun 2003
    Posts
    37

    Printing in access

    in my project i have created a vb front end for querying and minipulating a ms access database.
    i can print in it use the preview options etc that can be used in vb but 4 the i have to have the database open on my tastkbar.
    i dont however want the user to ever have the database open on the taskbar 4 them to be able to change or view anything in it withought using my vb program


    DoCmd.OpenReport ReportName:="finalTable", View:=acViewPreview

    is a command im using for example

    hope that mkes sence
    thx in advance

    FiRe5tOrM
    Reply With Quote Reply With Quote
  2. Jul 16th, 2003, 12:05 PM #2
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    the only other option, since you don't want to have the database opened, would be to create the reports in either the VB datareport or a 3rd party report software (Crystal Reports)...then just fill in the areas of the report with the data from the database.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  3. Jul 16th, 2003, 12:57 PM #3
    FiRe5tOrM
    FiRe5tOrM is offline

    Thread Starter
    Member
    Join Date
    Jun 2003
    Posts
    37
    its ok to have the database opened as long as they cant see it open if u know what i mean and that helps?

    all my reports are already done in access and i can view them just only by operning up access first
    Last edited by FiRe5tOrM; Jul 16th, 2003 at 01:10 PM.
    Reply With Quote Reply With Quote
  4. Jul 16th, 2003, 01:52 PM #4
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    unfortunately, in order to view the access reports you have to create an instance of access and open it...so to do it your way access will have to open and show as far as I know.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  6. Jul 16th, 2003, 02:37 PM #5
    FiRe5tOrM
    FiRe5tOrM is offline

    Thread Starter
    Member
    Join Date
    Jun 2003
    Posts
    37
    ah ok thx is there a way i can open it, bring up just the rteport then close the database then?
    Reply With Quote Reply With Quote
  7. Jul 16th, 2003, 10:31 PM #6
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    In order to view the report, you have to open access...The database is physically opened on the user machine, and can be viewed in the taskbar.

    About the only option would be to open access, view/print the report and then immediately close access. Otherwise, you would need to recreate the reports in some other software.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  8. Jul 17th, 2003, 03:43 AM #7
    FiRe5tOrM
    FiRe5tOrM is offline

    Thread Starter
    Member
    Join Date
    Jun 2003
    Posts
    37
    ah ok i think i got it now
    thx for all your help
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width