Recent content by MikeG

Well, I tried with both intWeekNumber and iWeekNo in the GetMondayOfWeek statement but neither one worked. I get a ByRef type mismatches with both options. Public Function GetMondayOfWeek(iWeekNo As Integer) As Date Dim tmpDate As Date tmpDate = DateAdd("ww", iWeekNo...

OK, I've stared at the date function I believe I need but I'm drawing a blank on how to call it via form load event. I'm a total VBA novice and can't say that I've coded any processing like this. I've done some reading on functions and events but I'm having a mental block on putting it together...

Thanks RG! That should help IMMENSELY.

Sorry, that should've read "entries are NOT messed up!"

I recently was handed a database to manage with a field (date type) titled WeekOf. Users were instructed to enter Monday's date regardless of when they made the entry. To cut down on wrong dates, I'd like to change it to always default to the current week's Monday date so that entries are...

Pat, big THANKS! I was to the point where nothing I read was making sense. mg

Greetings all! We have a mentor-mentee database that's been setup with a many-to-many design. We're storing essentially the same data in each table except for the field names. We thought we were good to go but one additional request was made to determine a count of employees participating in the...

You wouldn't, by chance, have played with a combination of both your FixCombo db and your ManytoMany db? I helping a co-worker with a Mentor-Mentee db. We've struggled with that one since neither of us has much Many-to-Many experience. The cascading combos on the subform would REALLY be nice...

Yes, I tried it with an AfterUpdate event on the field but that forces another prompt because of the parameter query so it can't go there... I think it needs to be on some sort of "current" event so I'm looking at the resources available on that. I just wish I knew more on those underlying...

Good day all! I have a field on my form based upon a parameter query to assist the data entry person. Because of the number of entries possible, I thought it might be a good idea to narrow the possible selections based upon a possible name string e.g. I used LIKE "*" & [Enter some portion of...

Thanks, Lagbolt. Unfortunately, that didn't work. I'm still trying! I'll add that this is the coding I'm using for the calendar selection. Private Sub Date2_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Set cboVariablebox = Date2 ocxCalendar.Visible =...

To ensure that each date field (3) on my form is not entered earlier than the previous one shown, I attempted to setup a before update event based upon what I've found in searching on date verification or date validation in the forum. Note - I defined BadDate in the OptionExplicit... Private...

I have a couple of fields on my form (Resolution Type, Date Closed) that I want to display only if the Status field has Closed as its selection for each record. I initially set the Visible parameter of both the type and closed fields to False and I reset them to visible by checking for...

Forget my earlier post. I matched the field names in my master table to the combo box names and set the record sources to link as such. They are no longer unbound (of course) but it still appears to work so I'm going to "assume" that method was correct. Mike

This is my first attempt with cascading combo boxes (2) and with the help of the forum I've made it work BUT, I feel like an idiot because I'm drawing a complete blank on how to link them back to a "main" data table. The example I used as a reference was to create them as unbound boxes while...