Simple report problem


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Simple report problem

Hybrid View

  1. #1
    Gary Thompson Guest

    Simple report problem


    Using VB, I run a query in Access, and then show a VB Report using the query
    results.
    (The query makes a new table each time it is run.) Inside access, the data
    is correct.
    The VB report is correct THE FIRST TIME I RUN IT. If I ask for the report
    on a differtent PO#,
    I get the original PO data, not the new one. This has got to be something
    realyy simple, I
    just don't see it.

    Code:
    Private Sub mnuPrintPO_Click()
    Dim ac As Access.Application
    Set ac = New Access.Application

    DoEvents
    ac.OpenCurrentDatabase ("c:\abstract\abstract.mdb")
    ac.DoCmd.OpenQuery "qryMakeSinglePO"
    DoEvents

    drSinglePO.Refresh
    drSinglePO.Show
    ac.CloseCurrentDatabase
    DoEvents
    Set ac = Nothing
    End Sub
    Share on Google+

  2. #2
    Phil Weber Guest

    Re: Simple report problem

    > Using VB, I run a query in Access, and then show a VB
    > report using the query results...The VB report is correct
    > the first time I run it. If I ask for the report on a different
    > PO#, I get the original PO data, not the new one.


    Gary: If you don't get an answer here, you might try reposting your question
    to our vb.vba newsgroup. Thanks!
    ---
    Phil Weber
    DevX.com, Inc.


    Share on Google+

Similar Threads

  1. MS Access Report Problem.
    By Imran Jalali in forum VB Classic
    Replies: 1
    Last Post: 07-13-2005, 06:23 AM
  2. Replies: 0
    Last Post: 07-05-2005, 11:07 PM
  3. Simple Sorting Problem, Please Help!
    By cookieman in forum Java
    Replies: 2
    Last Post: 02-26-2005, 10:33 AM
  4. Replies: 3
    Last Post: 02-10-2001, 08:24 AM
  5. Simple SQL Parameter problem
    By Eric in forum Database
    Replies: 1
    Last Post: 11-10-2000, 02:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center