Recent content by sherlocked

Hi experts, I'm working on a function to generate an outlook calendar invite from a form in my database. The person generating the email will need to be able to enter a specific contact card name and the invite should go to everyone on the card. I have worked up the below but it hits an error...

AMAZING!! SUCCESS!! I fiddled more. This works!!!! Thank you, thank you thank you a million times thank you for your patience and for sticking with it! Wish I could hug you! Do While dteEvent <= EndDate .AddNew !MeetingType =...

Good to know it's not just that I'm incapable of understanding! I am feeling rather challenged. Here's what I've done using your helper function. However, I am getting a "type mismatch" error at the line in red below. I think it's because the last input is set as VARIANT but I'm trying to...

I appreciate this, and the time you took to write it. I have Googled until I'm blue in the face. I am a novice at writing code and therefore most of the threads I've reviewed, while full of information, either don't address my needs directly or only address the THEORY behind how to do this...

I hate to be a noodge....any feedback?

Made this change. Now am getting an "invalid procedure call or argument" error here: If DatePart("mm", CounterBack) = DatePart("mm", Me.cboStart) Then

haha yeah, that's just my sneaky way of keeping the form neat & trim :)

Much obliged :)

This is....kinda like reading Greek. I apologize for being such a noob, but I am one. I am taking a shot in the dark here! The below code is what I came up with based on my comprehension (what little there is) of the ideas being suggested. I get a Run Time Error 6: Overflow when trying it :)...

This works FABULOUSLY for Daily, Weekly & Bi-Weekly appointments. You are a godsend. What I am up against now is Monthly appointments. For obvious reasons this same process doesn't quite work as each month has either 30 or 31 days, so saying the first Monday of each month works fine until a...

Appreciate this, thanks. I am just getting back in the office after a few days travel. I'll poke at it and see what shakes out. :)

Sure, sorry to be a pain in the a**. I truly appreciate your help. Attached for your review. Thanks :)

Fiddled more. Got it to actually create some records with the below. However it appears to have spontaneously, for no reason I can determine, started creating records every THREE weeks instead after March 4th. I am so confused, lol! Here's my code for bi-weekly meetings now below - and here...

Sure do! This time it created about 1.4 million records with the exact same date of 7/15/19. I just don't know where I'm going wrong here!

Thanks. here's a snippet of how I used it - however the code now hangs up forever and I must CNTRL+BREAK in order to stop it. Case "Bi-Weekly" strSql = "SELECT tblWeeks.DayofWeek, tblWeeks.SchedDate FROM tblWeeks " _ & "WHERE tblWeeks.DayofWeek = '" & Form_frmDataEntry.txtDayofWeek & "' "...