Search results for query: *

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

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

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

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

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/...

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

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

Thanks Remou! Have a nice day1

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

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.

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

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

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

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

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

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

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

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

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

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