Search results

Here is the code. Dim strDate As String Dim strSQL As String strDate = Format(Me.txtAppointDate, strcJetDate) strSQL = "SELECT * FROM tblAppointments WHERE tblAppointments.AppointDate > " & strDate sSQL = "SELECT DoctorsID, AppointDate, AppointTime" sSQL = sSQL & "...

Unfortunately No. I get the same Runtime Error '3075': Syntax Error in Date query expression DoctorsID=1 AND AppointDate=#08.08.2020'., when I try to assign appointment time. Sorry, for taking up your time I might have made somewhere mistakes.

Dim strDate As String Dim strSQL As String strDate = Format(Me.txtAppointDate, strcJetDate) strSQL = "SELECT * FROM tblAppointments WHERE tblAppointments.AppointDate > " & strDate Debug.Print strSQL SELECT * FROM tblAppointments WHERE tblAppointments.AppointDate > #08/08/2020#

AppointDate is a field in the table Appointments and is meant to hold appointment dates. The reason why I wanted to format is that because my regional setting Europe-Germany is, I get runtime error in date format. "run-Time Error '3075': Syntax Error in Date query expression DoctorsID=1 AND...

Sorry with my basic manual skills I can't get any further.

Now I decided to use this Video: as June 7 proposed. In this Process I used the same table, Form and query names as it is. Option Compare Database Private Sub cboTime_Enter() Dim i As Date, n As Integer, oRS As DAO.Recordset, sSQL As String Dim dLowerbreak As Date, dUpperBreak As Date...

I will try with it if you send me. Thank you.

Thank you for the hint.

I totally understand what you mean. I am on the process of learning MS Access. What I have done till now is setting the above Tables, Forms for new Clients, new Records to sessions and Lists for all sessions. What I want (and make research) is now to add to this database the possibility of...

Thank you. I watched this video. However, I am not sure if the form/table schedule can check whether the employee is free for the appointment that can be held in the future.

yes I have a single status filed.

I want to create a small database for consulting purposes. I have created the tables for that: Client Employee Appointments (Session) - the appointment has the following status options (noticed, session OK, canceled, missed The question is now with the form or the table for scheduling an...