Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2011
    Posts
    2

    Angry Unanswered: very urgent access report problem!!!

    I have an old access2000 application running on pc with windows xp, this application connects to an SQL db on windows server 2003.
    in the last months we heve noticed a really strange problem, happening not very often but very serious:
    from a form we select some data and we fill a temporary table, then we launch a report that reads from the form some data and other data from a query on the temporary table.
    Sometimes the query seems not working because the report printout has correct data read from the form but the data from the query are those of the last preceding successful query.
    Checking the temporary table the data are correct.
    I'm desperate because this problem mix data of different documents
    Please help me

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    I'm afraid that you do not provide enough precise information to get some help.

    See:http://www.dbforums.com/microsoft-ac...ml#post4534485
    Have a nice day!

  3. #3
    Join Date
    Sep 2011
    Posts
    2
    I'm sorry SINNDHO, following your faq link, i try to be more clear.
    The application creates shipping documents for textile goods.
    herewith enclosed find an example of report and form.
    In the report you see red circled data read directly from the form are always correct. The green circled data are obtained from the simple following query and sometimes give the problem.
    Query: "SELECT Bollatex.* FROM Bollatex INNER JOIN Pezza ON Bollatex.CODPEZ = Pezza.CODPEZ WHERE (((Pezza.NUMBOL)=[forms]![BOLLA_S]![NUMBOL]) AND ((Year([Pezza].[DATBOL]))=[forms]![BOLLA_S]![YEARBOLL]));".
    I repeat the apllication is runnig from 8 years, we noticed the problem last months, the only change was the substitution ( end 2010) of the pc with a new model but same operating system (XP) same access 2000 version with SP3.
    I thank you in advance for your attention at my problem
    Attached Files Attached Files

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    No need to apologize: just help us to help you

    I'll have a look at what you sent and let you know what I found. It's possible that I'll come back later asking for more information, though.
    Have a nice day!

Tags for this 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
  •