Results 1 to 13 of 13

Thread: RobDog888

Threaded View

  1. Aug 4th, 2004, 11:44 AM #1
    RichMojo
    RichMojo is offline

    Thread Starter
    New Member
    Join Date
    Aug 2004
    Location
    Saudi Arabia for now!
    Posts
    12

    RobDog888

    Rob,

    Ok, I am having problems. New VB programmer wantabe! I have a Access Database (PMEL.mdb). I have a report (TestQuestions) that I want to print from that database.

    Ok, I have gotten to this point. Here is my code:

    Dim objACCESS As Object
    On Error Resume Next
    Set objACCESS = CreateObject("Access.Application")
    objACCESS.OpenCurrentDatabase filepath:="C:\PMEL.mdb"
    objACCESS.Visible = True

    DoCmd.OpenReport "TestQuestions", acViewPreview
    DoCmd.Maximize

    Now Access opens, but the Database does not! It will open the Report if I already have Access open. What the hell am I doing wrong? Thanks!

    RichMojo in the Sand Box!
    Last edited by RichMojo; Aug 4th, 2004 at 03:37 PM.
    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