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!

Search results for query: *

  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...
  16. Sanasta

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

    Thank you AceMan and Zion7, RegNo is the number of registration of concrete truck. And RegNo is an index, but not unique. Unique is my primary key, the number of trip KomNo. I did exactly what you quote above. When the truck depars I get its number from a combo box. But all situations are...
  17. Sanasta

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

    Thanks Dan, Kindly please apologize me for not responding but unfortunately now I am with temperature and pneumonia. Now I have try to do someting but not understand all. What I understand is that your code is a SQL view of a Select query. What I understand is that I add my table RouteAvtovozi...
  18. Sanasta

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

    Hi Dan, Thanks you try to help. Field KomNo contains unique sequence numbers: 1, 2, 3, 8, 11, ...., 1211, 1215, ... 1227 from totally 687 records - with gaps. These numbers we get from company's order book and are convenient for primary key as tey are unique. For example KomNo KomDate...
  19. Sanasta

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

    Thank you PHV, Trying your advice I have avoid Debugger, but text boxes in each records became equal to max value of this concrete Reg No, not for particular record as I want. I thought a lot over my problem and came to a conclusion that I have not explained it quite well, so kindly please to be...
  20. Sanasta

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

    Thank you PHS, I have create text box control on ny form named Km_Start. Than in After Update Event Procedure of RegNo Conntrol wrote Private Sub RegNo_AfterUpdate() Dim varKmEnd As Variant varKmEnd = DMax("kmEnd", "qryKursAvtovozy", _ "RegNo =" & Me.RegNo) If...

Part and Inventory Search

Back
Top