Search results

Okay. Can you give me a clue as to what it should be???

Hi I am wondering if someone could offer some advice. I have a data entry form within my database. I would like to have the option for the form to be printed. I have designed the report for this and within the form I have attached the following code to the print preview button: Private...

Oh boy, I'm in trouble if no one has any ideas on how to solve this one!!!!:eek:

Managed to fix it by changing Private Sub StartDate_Change() to Private Sub StartDate_AfterUpdate() Thanks to everyone for their help!!!!!:D

I had the # in previously, however, this is giving me a runtime error, as explained in previous posts above.

Asistance from a fellow Red Dwarf fan - awesome!!!! When I do this it doesn't catch the duplicates.

I may have spoken too soon, as it comes up with the duplicate entry message every time I try to enter an employee's leave dates, and I know that they are not in the table. Private Sub StartDate_Change() If DCount("*", "Tbl_Calendar", "EmployeeID = Forms!frmLeaveApplication!EmployeeID And...

YAY!!!! It works, thank you very much!!!:D

Hi, I am hoping that someone can offer some words of wisdom. I have designed and coded a calendar for my database. Now I am needing to display information from a query in the calendar text boxes (ie, I would like the calendar to display which employee is off on annual leave when). I have the...

From what you are explaining I think that you need to link your Comboboxes to your table, ie they should not be unbound.

No, its in the dd/mm/yyyy format.

Still returns the same runtime error????

I am reluctant to do this as I have queries and other forms linked to it. The runtime error I am receiving is: Runtime Error '3075' Syntax error in date in query expression 'EmployeeID=1And StartDate =#' :confused::confused::confused:

I have the following code attached to an annual leave form, to prevent duplicate entries. However, the problem I am having is that it returns a run-time error when i try to test it by putting in a duplicate record. Anyone have any ideas as to what I may have done wrong? Private Sub...