Search results

Thanks again Chris....I am thinking I will put it at the very end of my module as a "clean up" that way I will not need to worry about if the email made it to the send folder before it is trying to loop through and send it to a personal folder. Thanks again.

Thank you Chris, I take it this code would go in the outlook side, or could I nest it in my loop within my access message? I will need to look into this more.

Good Day all, I have a not while rs.eof loop that goes through a recordeset and sends emails. I was wondering if anyone has had experience with somehow saving those emails to the associates personal folder. If it is not possible to save it to an outlook "personal" folder then can you point me...

ah ha! Perfect! Thank you !

Hey Guys, I am trying to write code which transfers a table into an excel file and then saves it on my departments share drive with a name and date. A file save name example would be: TesT_File 12-6-2010.xls I am not sure how to do this. I have tried Dim dt as string dt = date...

Worked great! Thank you!

Good afternoon all, I am working on a form where there is a starts on text box (me.starts_On_PPY) and an ends on text box (Me.ends_on_PPY) both fields are in short date format like the underlying table that this information gets appended to. I am trying to build an IF statement to make sure...

Any ideas where I can get the Macro that prevents shift key bypass?

Interesting. Thanks for the additional info.

Worked like a charm! Thanks Bob!

Guys, I am having trouble with a date function. Currently I am using: If Day(Date) + 7 < 8 then code code code else code code code As I write this post on the 25th of November, the number coming back is equal to 32. How do I tell it to remain in "month ranges" What I...

Hey Dcrake, I got one step farther but the criteria2 in the sql code is coming up as blank. for some reason the mntharray(9) (for october) is inserting into the sql code. Don't give up on me!!:cool:

Can't seem to get this one to work. I deleted the array from the general declaration. Then added the array to the load event of my form that I am working off of. Here is the code in my onload event: Private Sub Form_Load() Dim MnthArray(11) MnthArray(0) = "'Monthly' Or...

OKay, I have posted the code below in the "general", "declarations" section of the vba module that the rest of my code is on for this form. Dim MnthArray(11) MnthArray(0) = "'Monthly' Or 'Jan-April-July-Oct' OR 'Jan-Annual'" MnthArray(1) = "'Monthly' Or 'Feb-May-Aug-Nov' Or 'Feb-Annual'"...

Thank you DCrake. I will try this and post back with the outcome!

DCrake, Thanks a ton for your response. I have read about Arrays but never had a full understanding or "need" for them. Could you please expand more on the sentence below? "place it either into the forms declarations section or in a standard module" I am not familiar with the declaration...

Good Morning All, I have a tricky one here, at least it is tricking me. It is a rather simple concept but cannot get this to work 100%. I will try to make this as short as possible. In my VBA code below. I first check what day it is. If it is any day other than Friday then the query pulls...

Hey GHudson, What does the DBEngine(0)(0) portion of your code do? I tried inserting your full line: DBEngine(0)(0).QueryTimeout = 0

Thank You Bob- I will look into this. Looks a little complicated but I think I got it!

Thanks Bob, My intention is to build this piece of the code within the query itself, once I bring this into the VBA "SQL String" I am going to be adding some other pieces. I am not sure how to put them all togather in vba. I was hoping I could get the "day level" done in the query and then...