Search results

I admit, I was trying to be cheap and hold the appt times in my source table. Creating new tables is a last resort for me in most instances, so it can take some work to get me there. Lol

I was thinking about something similar to what you've described. Using a completely different table to manage the appointments so I'm not limited to the structure of the table I'm pulling my data from. I will definitely start digging around on the "tally table". Thank you!

Thank you for this Arnelgp...Here's what I have that I failed to mention in my original post. If you see any reason to modify what I'm using, I'm 100% all ears. Option Compare Database Option Explicit Dim MySelTop As Long Dim MySelHeight As Long Dim MySelForm As Form Dim fMouseDown As...

Hi Pat! Thank you for your reply... So the list of records is based on a query however, the scheduling of appointments happens quarterly, in one shot for that quarter. To give a little more detail: The "appts" are time slots for personnel to arrive for an annual exam. The query pulls personnel...

Thank you for being so thorough! I am working on your instruction now...I'll check back in.

I failed to mention I do have those mouse events in place, although you're still half right. I had it implemented for my ApptDate, but I failed to put it in the ApptTime mouse events. This is likely causing an issue that I couldn't see yet. Thank you Arnelgp!

Hello! Looking for help so I can stop banging my head into the wall... My newest headache: I'm using a subform to mass schedule appointments at 10 minute intervals. The loop function I have works for applying dates to records the user selects in the subform (continuous), so I used the same loop...

Thank you so much Pat! This has given me a whole new perspective to work with. Sorry for the slow reply.

Considering I use public codes in my modules that check users security level, I'm disappointed that I didn't think to go the route you're suggesting for the forms themselves. The user security level isn't the same for all of my forms, but there are groups of forms that could use the same code...

My apologies...To clarify per your previous response: All of my form fields are unlocked by default. OnCurrent, my code loops through the form fields and locks all of them, then unlocks one specific field by name, then based on higher level user security level, unlocks the fields that have the...

This was absolutely perfect for my application! I only used the "'lock" portion of the Private Sub. In the Public Sub, I used Case"" for the fields to remain unlocked so I didn't have to apply tags to all of my controls (there's a lot). Lastly I commented out the command button portion for later...

Your solution worked great for me! I know that it doesn't matter if the auto number is sequential, but if/when we use our "Clear Form" button it still burns a number and we just don't want that. This was the easiest solution for our troubles.

Here it is 2022, and you saved my day. Thanks!

I changed it to 'acCmdWindowHide = False' in that line and it resolved :rolleyes: As I said... Learning as I go.

Here's the error: If I click the exit command, the ribbon and navpane unhide. For anyone else, it exits the application. I replaced with 'acCmdWindowUnhide' and get this error on execution, though it still performs the desired function. *starts pulling out hair*

My code is below. I have tried to use 'Option Explicit' in this code and it basically kills the switchboard. Not sure why. I do have it on my other objects though. Some items are the same as your code (albeit in different places), but a lot is set up differently. Would I need to mirror your code...

I'm no expert, but I've been learning as I go for 3+ years (with still lots to learn). The current switchboard code I have was outsourced. I am able to modify one or two spots, but the rest I'm essentially afraid to mess with.

Thanks again Pat! After review, your set up is indeed what I am looking for, just more complex than I'd like Hahaha. It will take me some time to implement it (translating is slow work) but I'm sure I'll get it. Permission to come to you with any questions?

Pat, thanks again! After review, this is indeed what I am looking for, just more complex than I'd like Hahaha. It will take me some time to implement it (translating is slow work) but I'm sure I'll get it. Permission to come to you with any questions?

Thanks for your reply Pat! Not sure why, but it wouldn't let me reply to your post. I have other databases that run off of a "one form for everyone" type of method, but I really struggled with the coding when I had to make some forms read only for only some users. I'm looking at the link you...