Search results

Sorry I am trying to take the appointment date from my existing form and put put it in another table. I can do it with a macro but after awhile this is going to become very slow and I thought in VBA it would be quicker to process. Dim dbData As DAO.Database Set dbData = CurrentDb()...

I am trying to insert data from a form to antother table in VBA and would like to do this without using a macro. I have got the following code but it doesn't work. Can anyone help me???? Dim appointmentdate As String Dim db As DAO.Database Dim rst As DAO.Recordset Dim strsql As String Set...

Hi I am trying to put a simple search facility on my database without using a combo box/filter. I have got this far below, but this will only find 1 record and then won't search any futher. Can anyone help me please?? Thanks Louise Private Sub Command156_Click() Dim strnhsRef As...