Recent content by SikhSioux

I get the #name? error in all cases

Thanks for helping out, I've tried what you said but again the email address does not display. I've tried specifiying the field as combo box field as well as text field but the problem remains, by the way, I'm using Access 97

I forgot to mention what I've tried so far: I created a totals query which shows the deptEmailAddress where the DeptId is equal to the value of the DeptId in the frmCustEnquiry form and the dateEmailAddressIntroduced field has its maximum value. I then successfully tested this query. I then...

I forgot to mention what I've tried so far: I created a totals query which shows the deptEmailAddress where the DeptId is equal to the value of the DeptId in the frmCustEnquiry form and the dateEmailAddressIntroduced field has its maximum value. I then successfully tested this query. I then...

I wonder if someone can help me: I have a customer enquiry form (frmCustEnquiry) within which is a combo box field, the combo box stores the customers department ID (DeptId). The email address for the department sometimes changes, the changes are stored in a table (tblDeptEmailAddress) which...

I wonder if someone can help me, I have a customer enquiry form (frmCustEnquiry) within which is a combo box field, the combo box stores the customers department ID (DeptId). The email address for the department sometimes changes, the changes are stored in a table (tblDeptEmailAddress) which...

I'm looking to create a form called 'frmMilkShakeIngredients' which allows you to add info about particular milkshakes and their ingredients. One of the fields (called 'cmbFruit') is a combo box filed which allows you to add a fruit. You can choose a fruit from a list (the source of the list is...

Thanks for helping guys, Gemma following your advice I included the 'acdialog' constant in the 'Openform' command. I then tested the code and I found this successfully prevented the 2237 error message showing up, the code for the 'NotInList' event now reads: Private Sub fruitId_NotInList...

Say I have a form 'breakfast' that contains a combo box control which allows you to choose a fruit from a list of fruits. The list of fruits is obtained from a table called 'fruits'. Is there a way that I can add a new fruit to the list so I can choose it from the list? I have tried the...

Thanks Paul, I'll give it a try Bob

Paul, I made a mistake when I typed in the code on this forum. The original code has the changes you mention i.e dateDeactivated is replaced by dateIncluded. Any idea what could be causing this? Bob

Hi I have re-posted this thread as I made a mistake in the earlier on, hope someone can help with this tricky on: I have a form module attached to a 'search' form used to search (filter) for records on another 'main' form that shows all the records. One of the fields I can filter for is a...

Thanks for the reply, do you know how I can make them the same? Should I change all the date values in the table to DD/MM/YYYY HH:MM:SS format? Is there some way I can add 00:00:00 to the date fields in the code so that a particular date value in the table say 23/05/2007 becomes 23/05/2007...

Hi, hope someone can help with this one. I have a form module attached to a 'search' form used to search (filter) for records on another 'main' form that shows all the records. One of the fields I can filter for is a date/time field. When I type a date to be filtered for in the 'search' form...

Hi, hope someone can help with this one. I have a form module attached to a 'search' form used to search (filter) for records on another 'main' form that shows all the records. One of the fields I can filter for is a date/time field. When I type a date to be filtered for in the 'search' form...