Search results

Bob, I am not sure I fully understand. Do you have any examples I can look at?

Good Afternoon, I am trying to find some code that when I run a "make table" query it knows to save the table as "weekly Trail Audit " with todays date. I am thinking it would look something like this. "Weekly Trail Audit" & Format(now, 'mm/dd/yyyy') Not sure where I would put this or...

Good Morning- I have a sub-form which has about 15 fields one field is called Cancel_Date. What I need to happen is if the Cancel_field is not null then the Account_number field turns red. I have tried conditional formatting but it colors the whole column red not just the individual fields...

Genious! Pbaldy

Hello, I have a database which sends emails out to Financial Advisors regarding their clients' accounts. I have the code set up and the email is working properly but I do not know how to insert the "Account_Number" field into the subject line of the email. I will be sending 15-25 emails at...

Mike, I have been searching the forum all morning trying to find some code that would help me insert the account number in the subject of the email. Do you have any links or ideas on how to do this? I am thinking maybe a SQLinsert function. THanks, Tall Man

Thank you for your help SOS.

I am not sure how to do that. I had a programmer write the main VBA code. Thanks though.

Just out of curiosity how would they make that change? Is it in settings? Thanks SOS.

Hello, I have a database that sends out mass emails. The emails contain an excel attachment that list an account number. The problem I am having is that when the receiver sends back the email with directions the attachment is lost and I do not know what account number they are referencing...

Hello, I am having the same issue as Damire69. However I have no idea what "OO put pull" is. Could you help me by elaberating on your fix? Thank you for your help. Tall Man

Hey Paul, Do you have any good articels or links to help me with a hyper link in html text. You had posted some code but I am unable to get it to work.

Great!! Thank you PBaldy. That was very easy. Do you know a way to have a piece of the text be a hyperlink?

Hey Guys, I think I have an easy one for you. In my VBA code I have a body to an email which is too long so it does not let me type anymore characters. Does anyone know how to kick it down to the next line??? I think is is something like this. .htmlbody = "first...

I have email text that I need to create a hyperlink for an email address. Is this something I can do? Basically the text states....... Please contact the "Email_Address" below. I need the "Email_Address" to be the hyperlink. Thank you for your help.

Thank you GUUS2005. One last question. Where would I insert that command? At the end of all of the code?

Hello, Has anyone ever had any issues with forms "freezing" on them? For instance, when I scroll to the right the data is column "E" will "stick" and remain in column F,G and H. I had to create a refresh button do get rid of all of all the junk that accumulates as I scroll to the right...

Uncle Gizmo, The code is very large and extensive, this is the only piece I am having trouble with. Do you need to see the rest of the code to possibly solve the error? Honestly I am not sure how to post the code.

Hello, Bob had suggested that I use the Chr(34) format instead of the quotes but I could not get that to work. maybe I have been looking at this code too long but could someone tell me if they see a mistake with this? I am still getting the "Run-Time Error 3346" While Not rs.EOF...

I am getting an error "run-time error 3346"