Search results

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-

I'm getting a couple errors using it. I've attached them. Any chance moke or youself can have another looksee to the code opening on the subform after entering, USERID -> Date? Heya moke, To explain more in details what this is, it's a db used by 3 people. Myself and 2 others. It will be...

I wouldn't have thought this would cause an problem, but it seems when I load the Appointment form using a NavigationControl / Subform I get this error. Main form name is : frmMainNavigation Appointment form with cbo : frmAppointmentBooking Is it because it's not an ActiveForm but a...

Thanks, I'll give that a shot when I'm at my access machine next. What you described isn't what I meant though. I meant to say that if I have to go to a meeting or lunch, I would deselect 3:00 and 3:30 pm and it wouldn't show for people trying to book an appointment with me. The cbo would...

Some days we have a meeting during those hours and I'd like to disable the check mark. That way they don't show up in the drop down. Just need to figure out where to put it in your macro to check for it.

Running in to a few snags with my continued testing and no edits. Not exactly sure what's triggering it. Most of the time it works. I have attached some snips. --------------- -=Edit=- Believe I found the culprit on that one. There was a stray "2:00:00 PM;2:30:00 PM" in the row source of...