Search results

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

In this Sub-routine 'trim(left$(robbins, 4)' results in the string "robb" Hi thanks for the reply, 'robbins' is actually the current element value in a string array variable. I thought i'd simpllify showing the problem by not including the loop through the array and the declaration of the...

I have a recordest that does not return any records. I know that it should return exactly one record. When i create the equivalent query in MS Access 2002 design view i get one record returned. The details: VBA code: Dim conA As Connection Dim strConA As String Dim rstSql2 as recordest...

Reply I haven't learnt any VB yet. Any clues on how to do that? The most complicated funtions i have in my database are the date() and now() functions which i have used in the criteria row of a simple two table query.

Reply Mike, i am new to Access, but this idea may be useful. Create a new 'calcualted' field in your query. With the following code: If(IsNull(Option1) Or IsNull(Option2) Or IsNull(Option4), "",Concatenate(Option1,Option2,Option4)) Then in the criteria row for this field type: Not...

Hello, i have created a CD production scheduling database in Access 2000. Unfortunatley, my work place is only running Access 97 on the network. After converting the database to 97 i cannot open the database without getting errors on the network. The error message is a long the lines of 'the...