Recent content by Methodikal

Lol. I figured it out. I was like a dumb dumb I had a circular reference that was confusing the system. I fixed it. Thanks!

The Debug is giving me something funny. When I hover over: If Len("" & Me.!SupervisorSearchCbo3) It shows: Me.!SupervisorSearchCbo3 = "50640" When I hover over: Me.Filter = strSQL It shows: strSQL = "[ReportsTo] = '50640'" So wondering if there may be something causing this. Error when...

Greetings, New Problemo. I have a combobox that pulls in the Supervisor name and filters the results in the form by the Supervisor Position ID. However, when I click on some options it takes me to a different Supervisor (Supervisor Position ID). Then when I try to switch to another Supervisor...

Hi guys, I finally got this figured out. Like a big dumb dumb I had the EmployeeID2 field pointed to a freaking short text field versus the number field. It works now and I will keep testing around to find ways to optimize. Thank you all for your knowledge and education. I appreciate it very much.

Thanks so much. I will try this in the morning. I'm a newbie and just trying to learn by doing.

OK. For some reason I can get the combobox to show the Employee Name only but for some reason it will only accept the Employee ID into the field. So if I change the Column Width back to 1";0" Then it will save the EmployeeID but when I have the dropdown set to Column Width to 0";1" It won't...

The only time it sometimes works is when I change the: Me.EmployeeID2.Requery To Me.EmployeeID.Requery However, then it gives me: Compile error: Method or data member not found Which I know is because it can't find the EmployeeID2 combobox.

Hi, I have a Form with a Filter by Supervisor (named AltWorkScheduleF The Nested Subform is for an Alternative Work Scheduler (named AltWorkScheduleSF). They use a lot of information from multiple tables and queries. I have everything working except... When I click on the emplyee combobox in...

Again thank you for what you have done. I am trying to learn. I have been reading the books you sent me. It is a lot to consume. I have also been working with the files you created to try to understand what you did. I may have to see if I can pay you out of my pocket if you have some time to...

I've been trying to understand what you did on these. You're awesome. As for the checkboxes being not normalized I have no idea how else to do it. I'm thinking of having to come up with a code for each possible combination of days teleworking.

BTW, what do you mean by normalized?

Thank you so much. I'm going to look at these asap. I studied the first file you made and have so many questions. I tried to recreate it but I'm missing some thing. So appreciate everything you are doing for me. But honestly I need some sleep atm. I didn't sleep all night. Will check back in the...

Here is the DB I am trying to create. I wanted to put the combo box on top of the Employee Name. Then filter by Supervisor Name and Filter by IsTeleworker. I am going to try to learn as much as I can from Arnelgp's example. But this is the actual way I am trying to make it look and feel. I need...

OMG! @arnelgp are you serious? How did you know this so well? I have been taking courses and trying for a long time and you do it like nothing. Is there a book or something on Access and VBA that I need? I am trying to learn this stuff seriously.

I can always post an example with some test data.