Search results

  1. L

    Referencing forms with a space in the name in VBA

    I have a form called "Main Form" and I need to reference it in my VBA code by name, how do I do that. If I leave the space I get an error. Thanks, Legion
  2. L

    Type Mismatch Error

    Can anyone tell me where the type mismatch error is coming from? Private Sub Form_Load() Dim rs As Recordset Set dbs = CurrentDb Set rs = dbs.OpenRecordset("SELECT [Survey Number] FROM [Main Table]") rs.MoveLast Forms!Form_Main!RecordNumber.Value = rs(0) rs.Close Set...
  3. L

    Giving a field a value from the database

    I was wondering if it's possible in Access to set up a form load event that sets a value in a text box to the last value entered in a table. This way when the user closes the Database, the next time they open it, it will have the last value entered, in the box. So lets say the user enters 20...
  4. L

    Creating Dynamic Forms

    I was wondering if it is possible in Access using VBA to create forms dynamically. I have a survey for a course, which is made up of a number of topics, however, the topics change order ie. topic 1 might be taught on day 2 the first time, but the next time the course is taught, topic 1 might be...
Back
Top Bottom