Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2005
    Thanked 0 Times in 0 Posts

    Warning message (Access 2000)

    I have a query based on productid, with fields In,Out and Balance.

    How can i get a message in the form, when something is wrong, i.e.

    Dim R as Report
    Set R = Reports!Audit

    If R![balance] <> R!In - R!Out

    From my form I am opening a report, where
    the discrepncies are marked with red.
    But i want to get a warning in the form,that something is wrong and will tell me to open the report.
    The report is based on the query,but the form is not based on that query.The query is:
    SELECT [qryBlInputSum].[Productid] AS ProductID, [qryBlInputSum].[grade] AS grade, [qryBlInputSum].[size], [qryBlInputSum].[SumOfSumOfQuantity] AS [In], [qryBlOutputSum].[SumOfQuantity] AS Out, [SumOfSumOfQuantity]-[SumOfQuantity] AS balance, [products].[items2] AS [OnStock]
    FROM qryBlOutputSum RIGHT JOIN (qryBlInputSum INNER JOIN products ON [qryBlInputSum].[Productid]=[products].[Productid]) ON [qryBlOutputSum].[Productid]=[qryBlInputSum].[Productid];

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Warning message (Access 2000)

    How do you define that something is "wrong"?
    When do you display the warning? When the form is opened, or when a record is updated, or ...?

    Please try to be specific.

Posting Permissions

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