Search results

  1. V

    Insert Record: Past dates only.

    I have form which uses VBA to manually insert a record into a database when a command buttons is clicked. The table I am inserting the record into is an enrolments table. Each enrolment must include a student ID, a course code and course start date for the course. The course code and start...
  2. V

    Small problem with the following code.

    The way you are doing this is not ideal as you are causing data repetition Why concatenate all the parts on order? Where is the string going to be used? - Is it just for display purposes on a form or report? If this is the case then you shouldn't be duplicating this data in another table and...
  3. V

    Small problem with the following code.

    I think I understand your problem. You want to use the data in a table and concatenate all the parts on order into one string for each engine. I don't think using two tables is the best way of doing it. I assume what you are trying to do is display all parts on order for one engine in the same...
  4. V

    Small problem with the following code.

    This is why you get an error: 'rsFind record pointer pointing to a record set containing 1 record 'rsFind record pointer on first record If Rcount = 1 Then ' always true for first loop iteration EngineID = rsFind.Fields("EngineID") NewPartName = rsFind.Fields("PartName") rsFind.MoveNext...
  5. V

    Small problem with the following code.

    To find out which line the errror is occuring on comment out the following line: On Error GoTo Err_Handler then run your code. It should bring up a box with a debug button on it. If you press that button you will see the line which is causing the error highlighted. It looks like you are trying...
  6. V

    Small problem with the following code.

    Which line is causing the error?
  7. V

    Sub sub forms

    Thanks for the reply. That solution worked perfectly. Does it matter whether or not you use IsNull() or the SQL - Is Not Null? I would have thought that using the SQL syntax over VBA was better becuase it will make it more portable :confused:
  8. V

    Sub sub forms

    Hi, My first post :D I am developing a form in Access which enables a student to be searched or added to the database. The form I created contians two sub forms - one of the queries which the form is based on takes three criteria from other form fields which are as follows: [StudentId] =...
Back
Top Bottom