Search results

Pat, is it possible for you to change my code and show it to me because I still can't figure it out. Thanks a lot.

Still not working. Now, when I close the form with the X in the upper-right corner I don't get any messages and the form simply closes. What am I doing wrong here? This is my code so far. Option Compare Database Dim gPendingError Private Sub Form_BeforeUpdate(Cancel As Integer)...

Thank you guys for your quick replies. I'm going to check all these things out. I hope it will work this time.

Thank you very much Jack for the quick reply. Unfortunately I still couldn't solve the puzzle. I'm going to explain my problem a bit better first. You should try it out yourself perhaps to understand my problem. So here it is. Let's say I've got a form with only one field called...

I have the following problem. I have a form with several fields including a date field called "Date". Now this field is unique so duplicate values are not allowed. So when I have added a new record but filled in a date that already exists and I close the form with the cross in the upper-right...

Thanks David, I think this is what I was looking for.

I'm gonna give an example. How many hours and minutes are there between for example 01/01/2002, 08:00 and 05/01/2002, 14:00. Can you calculate this in an expression? If so, what is it. Can someone help me out here? Thanks.

I have a form based on one table. On the form I have 4 fields ("DateIn", "HourIn", "DateOut", "HourOut"). Now, I want to make a new textfield (not bound) on the form which has to show me how many hours are between DateIn HourIn and DateOut HourOut. Can someone help me please as quickly as...

Once again, thank you for helping me out, Adrianna. I'm afraid I'm still using Access '97 but I'm planning to upgrade to Access 2000. Or I can try it out at my work but then it won't be before next weekend. Anyway, I'll let you know what I think of it as soon as possible. Bye

I think the list of artists is too big to do this through an option group. Therefor a listbox would be better. I really want to do it with VBA-code (For Each... In ... Next). Thank you.

I know this question has been asked several times. I've searched the forum but I still can't solve the problem by myself. My VBA knowledge is not what it should be. So therefor I've included a simple database to this message. Can someone please solve my problem in this database and return me...

Thanks Jim for your reply. I tried it out but in both cases I get the message false (with "Date" left empty and with "Date" filled in). The problem actually is that when users fill in the subform and forget to fill in the date in the parent form they cannot find their data back when they have...

I have a form with a subform. The form is based on a table with 2 fields: "ID" and "Date". The property "Required" of the field "Date" is YES. So normally when I leave this field empty in my form I should get a message but I didn't have one. Now I've tried something. I've put a third field...

I have two tables "Employees" and "Tasks". Now, I want to have a form on which I want to fill in the task of all the employees every day. Every employee has a different task. Every employee has one task for the hole day. When I open this form I want to see the employees already filled in so...

I've put the following function in my query to sum several hours (type date/time) grouped by another field called "Employee" Function: Int(CSng(Sum([Time]) * 24)) & ":" & Format(Interval, "nn:ss") Now, I've made a report of this query and I want to put the entire sum of the above results on...

Thank you very much RV.

In a query with the field "Code" which can contain A, O, P or U I want to count all the codes with an A in it. That's not the problem, but the problem is when there are no records found with "Code" = A then the query returns an empty cell instead of 0 (zero). Can this be solved? Thanks again...

Thank you very much Rich, my problem is solved.

Thank you very much for you reply, Alexandre, but I still can't solve my problem. I'm going to specify my problem a bit more. So, I've made a form with a subform, the subform is in datasheet view. The form and the subform are linked through an ID-number. On the subform I have a field (Combo...

I made a form with a subform. On the subform, which is in datasheet view, I have a field called "Code". There are 4 codes (A,O,P,U). On the form I want to put a field that counts all the codes "A" that appear on the subform and not from the whole table underneath. How can I do this? I...