Recent content by k3ll1n

Sorry, I did mean they should not be able to select it. I also changed the me.cbodate to Me.txtAppointmentDate It's acting as though nothing was done to it. I'm not familiar with break points. I am familiar with this cbo not displaying should anything be wrong lol.

Appreciate the help Cronk I've changed it to Forms! and I'm no longer getting an error. Though it doesn't seem to be doing much. I still have all the times that weren't booked today listed. As it's 9pm now, I should be able to select 2:00, 2:15, etc.

Attached. FillApptCombo was already in the after update.

The only cbos I have on the form are the Availability and UserID. No date cbo. Attempting what you suggested on the txtbox did not work unfortunately.

Hey all, I'm still trying to learn but my needs are surpassing my studies at the moment. I'm hoping someone can take a look at the code below and let me know where to make the adjustment so that; the time (i.e: 2:00 PM) is not listed in the cboAvailability dropdown if it is currently 2:01...

I took the input mask off prior to entering the new format formula. Haven't run into any issues. Thanks again.

Switching it to "dd\/mm\/yyyy" seems to have done the trick. I had been shown this prior and thought I knew where to enter it. Your post helped me situate it. Thank you.

It's the combobox that won't load it's dropdown after having periods in the date textbox.

Thanks for the quick reply arnelgp. After changing it to what you suggested, I am still getting the same error. I will attach the image. I typed in the date of 2016.06.15 and selected via the date picker. Both returned the error. I also tried to change your format to yyyy/dd/mm with no...

Hey all, Wondering if anyone can provide a work around for this issue I'm having. The DB I've created is for our department at work and once complete, I will place it on a shared drive and provide shortcuts to it. The issue I'm having is that one of my Appointment Date field is required...

Evening all, I've noticed an issue with my DB when I brought what I created at home, to the office. It seems that because my home PC and office PC had different regional short date format settings in the control panel, Access wasn't playing nicely. My office PC was formatted as...

I didn't think it had periods in it originally, but when I found my older backed up work they were there also. And it does work off and on... I don't believe it was ever changed. Seems to be working now though. I'm not understanding why it's happening randomly. I don't know much about how...

The errors are coming back now and again. It must have something to do with the code below. After I enter a USER, Date and try to open the Availability dropdown, I get the error; "Syntax error in date in query expression. 'AppointmentDate = #2016.06.08' Which is the date I'm attempting to...

edit. Unclear what is happening. I'm still getting that error message now. I haven't changed anything since yesterday except deleted all the records for testing. Please have a look at the next post.

-resolved-