Search results

  1. S

    Automatically populate a field using a field on another form

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

    Automatically populate a field using a field on another form

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

    Problems Using a Search Form

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

    How do I update a list (whose source is another table) on a form

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

    Applyfilter method gives unexpected results when filtering for date values

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

    Unexpected reults when filtering for a date value

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

    Unexpected message with Applyfilter method using VBA

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

    Recordset not returning a record when it should

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

    Problems using with earlier version

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

    Using a Database created in a later version.

    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...
Back
Top Bottom