Search results

NigelShaw, HA HA, Do not worry you was next on my list:) As stated in my reply to georgedwilkinson i am very grateful for the help and advice all of you have given to me her at AWF. I am currently looking at the design of the form and also how i am storing it as i feel like you said the way i am...

Wazz, I am very grateful for your help and advice, i think sometimes it pays to step back and go back to basics. As i am sure you have seen i am very new to Access and always trying and willing to learn. Once again thanks.

boblarson, Thank you for the information on the Black exclamation mark in the red triangle, i was not aware of this function.

Georgedwilkinson, I owe you an apology it was uncalled for and unprofessional to speak to you like that. I took out my frustration and comments my ungrateful boss made about my Database, which lead to my original posting of the question. Like all boss's they seem to lack the understanding of...

And how does this concern you?? Stated another way... Do you think it might be that i got the title wrong (Hence why the titles are different). But the real question here is that you looked at both and did not take the time to help. So 10/10 to you!!!

DLookup/DCount (PLEASE HELP ME!!!!!) Hi, My problem is that i have a form which is used to book dates against a employee. I have a SubForm placed on the form that shows all dates currently booked against that employee, which automatically populates when the EmployeeID is entered into the Form...

WAZZ, Thanks also for your help but neither of the suggestions worked, just out of interest did you try then in the sample i attached? The reason i ask is just wondering if it was something i have not done correctly or not.

NS, Your Codes looks just what i need but it does not work as it still allows the user to book dates already booked against an employee.

Hi sorry to bother you again the EmployeeID in the tblEmployee cannot be a autonumber as its a clock number.

Hi thanks but this only checks that the EmpID is not already in the table i need it to also check that the BookingDateID is also not booked by that EmpID. So to stop the same date being booked against the same employee.

DLookUp???? (Someone please help!!!!!!!) Hi, My problem is that i have a form which is used to book dates against a employee. I have a SubForm placed on the form that shows all dates currently booked against that employee, which automatically populates when the EmployeeID is entered into the...

HI, Thanks but that does not do anything.

Hello, I have looked and looked at all the delete statements on the forum but i am not getting anywhere fast. I have a table called "tblMaster" With the following fields that i want to search by IDNo DateRequired DateBooked In short i want to search the table and delete all duplicates where...

Thanks for your help, i have placed the else code in and it works fine

Hi all the Information including the DefectID is stored on the same table, your code seems to be what i need. Just one more question, where would i store the code, am i right to assume it is "After Update" for the "DefectID" Field?

Hi, Sorry i dont understand what you mean, as i said i am new to Access. When someone tries to input a already known DefectID a system generated message box pop's up and will not not allow you to save the record.

Hello all, I am new to Access but with that i side i want to learn. I have created a Database that collates defects. The Primary key is called "DefectID" which takes its number from a defect form that is never repeated. Unfortunately ever so often a person will try and input the same defect...

Yes i can see the problem now, your right it was down to the format. Thanks it works fine now

Hi i have a Textbox called DateTimeGiven which CONCATENATION the Date and TIME: =[DateDefectGivenToEngineer] & " " & [TimeDefectGivenToEngineer] and another one that does the same: DateTimeReported: =[DateReportedToRepairServices] & " " & [TimeReportedToRepairServices]. I am trying to find the...

Thanks for your help today, you have saved me some sleepless nights