Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Sanasta

  1. Sanasta

    Retrieve value based on multiple criteria

    It gives me message: The expression you entered has an invalid date value". I have tried to change it but without success.
  2. Sanasta

    Retrieve value based on multiple criteria

    Thank you Harleyq Tomorrow I shall try it. Hope it works. Sanasta
  3. Sanasta

    Retrieve value based on multiple criteria

    It don't accept it. And I don't understand why because I'm not qualified enough
  4. Sanasta

    Retrieve value based on multiple criteria

    [Avtovoz1], [Avtovoz] and [Event_Date] Avtovoz is Truck on my nativ language Event_Date is the date when a damage has been found
  5. Sanasta

    Retrieve value based on multiple criteria

    I have 2 tables as have specified before. I would like to write a letter to Insurer (report) based on a query (I have a form based on this query as well). When I select the truck and write the Event_date, Policy No automatically to be returned (now I write this number /over 16 characters/...
  6. Sanasta

    Retrieve value based on multiple criteria

    Sorry I have not been clear. Table: Letter_to_Insurer Key No Number Date Date/Time Insurer Text Title Text Name Text Event Date Date/Time Policy No Text OurRef Text Sum Number Truck1 Text Table: Policy_OP Key ID_OP AutoNumber Policy Text Insurance policy Truck Text From Date/Time...
  7. Sanasta

    Retrieve value based on multiple criteria

    I have 2 tables: "Letter_to_Insurer" and "Policy_OP" and query based on the "Letter_to_Insurer". I need to have one field in this query, which to find the policy number of concrete truck in the concrete time interval. I tried DLookup (in query and in the form...
  8. Sanasta

    How to export MS Access report as .pdf file

    Thanks Remou! Have a nice day1
  9. Sanasta

    How to export MS Access report as .pdf file

    Dear Remou, Thanks for your reply! If you don't mind please give me the name of this useful pdf cretor. With the very best regards
  10. Sanasta

    How to export MS Access report as .pdf file

    I am working with MS Access 2003 and would like to export my report as Acrobat .pdf file. I have tried different ways but without any success. I think whether with MS Access 2007 this is possible or not.
  11. Sanasta

    Date in the current record not to be less than date in previous record

    Hi, I have form based on table. There is a field Inv_Date which value must be greater than or equal to the previous record value (not less). How to prevent entering (or in case of copy-paste) earlier date for the next invoice? May be this is easy but I can't do it. Shall appreciate any help...
  12. Sanasta

    Database Window disapear

    Hello all, I have manage my problem. Kindly please exuse me for false alarm! Sanasta
  13. Sanasta

    Database Window disapear

    My Database window disappear and do not appear even when I push button Database Window on the toolbar? I don't know what's happen. Please help with advice! Sanasta
  14. Sanasta

    Start data to be equal to End data of previous record?

    DDiamond, I simply have no words to explain my gratitude to you for help. It works perfect. I understand your idea right the first time you suggest it. But I was no able to realise it because I am not so clever as you. Now I have to apply it in real program situation when go to work but I think...
  15. Sanasta

    Start data to be equal to End data of previous record?

    Hi DDiamond, Following your advice I have try step by step your code. First in SQL view I have written: [Code] SELECT Trips.KomNo, Trips.KomDate, Trips.RegNo, a.KomNo, b.KomNo, a.KmEnd AS CurrentMileage, b.KmEnd AS PreviousMileage FROM Trips INNER JOIN (Trips AS a INNER JOIN Trips AS b ON...
See more

Part and Inventory Search

Back
Top