Recent content by Hikari95

Thank you all for your advice, by looking at all of your answers I've managed to piece together a working solution, code found below :) Private Sub txtSearch_Change() Dim db As DAO.Database Dim rsSearch As DAO.Recordset Set db = CurrentDb() 'Setting up db, selecting all records that are...

I have tried it with the OnChange event also, unfortunately with the same results. I also do have Option Explicit at the top of my code, but no error is thrown up.

I am trying to program a dynamic search box, wherein on the KeyPress event of a textbox, some SQL selects records from a table that are similar to whats in the textbox, however when I type something into the text box, it refreshes by nothing is displayed. When debugging, the textbox value is...

Works like a charm! Thank you very much!

I am trying to program an appointment booking system, and I am using DCount to check appointments that already exist to avoid clashes, but I am getting a Run Time error: 13 Type Mismatch. I am not sure why, because as far as I knew, Date and Time formats were delimited with "#". Have I got the...