Search results

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 & "' "...

I appreciate your willingness to dig around. The part of your snippet that I'm not quite sure of is For x = 1 to 3 Where does this go? How is it used in relationship to the rest of what I have?

I dig it. One option I did explore is adding a "recurrence" field on my user form so they could say how many times to repeat the event. so, if they want a bi-weekly event that happens only for the next two months, let's say, they'd enter "4" here. Can you possibly expand on how your code...

Hi, tblWeeks just has three columns: DayofWeek, SchedDate and Holiday. I use this because I do not want the database to create appointments indefinitely; only for the current calendar year. Also, on reports, the users want holidays highlighted so that they can be re-scheduled or skipped...

I noticed that as well, almost immediately after posting :P I have modified a bit. The SQL is different for daily appointments than it is for recurring, but that is the only difference. However, now that I am defining the variable "Recur" in each instance (weekly, bi-weekly or monthly...

Appreciate your valuable feedback! Based on your guidance I've amended my code as appears below. An odd thing though - even when I select "Bi-Weekly" from the dropdown, the code is creating a record for every week. Not sure why - does anything leap out at you? Function FindDates() Dim rsIn...