Search results for query: *

Hi all... Does anyone know how to create a parameter in a macro (Access 2007)? I'm using the SetValue action with an argument of... Item [Intro_Call_Date] Expression =[Please enter the date of the call.] So, I need it to prompt a user to enter the date of the call. Any ideas? -Cindy

Thank you Triacona...but that's not what I'm trying to do. I have a document stored in a table as an 'attachment'. I need to pull that document into an email automatically.

Not quite, I have the document stored in a table, just need to pull it into the email. Cindy

Hello all, I'm trying to pull an attachment that is stored in a field in a table into an email. I've tried the SendObject action in a macro, but it only allows for Objects (tables, querys, forms, etc.), not the 'values' stored in a data field. So since it wanted an object, I tried pointing...

Hello Skip... The documents are pretty big, 3-10 pages. So it's beyond what I can represent in an email. Need to include the document since the email recipients need to approve that specific document. Cindy

Hello all, I'm trying to pull an attachment that is stored in a field in a table into an email. I've tried the SendObject action in a macro, but it only allows for Objects (tables, querys, forms, etc.), not the 'values' stored in a data field. So since it wanted an object, I tried pointing...

Thank you both so much for your help!! fneily... I followed your troubleshooting suggestion, and as it turns out after I started fresh with a brand new database, it worked like a charm...even though the expression and library references appeard to be the same between the databases. Anyway...

JBinQLD.... That's actually pretty close to what I'm trying to do...for example, ultimately, I need to get Field2 to increment by 10, and Field3 to increment by 1....concatenate just those two fields, then calculate a MOD10 to get the value of Field4. Didn't think I could pull that off with a...

Thank you...on the Double, I tried that before and it didn't work...does now...can't explain why, but thanks. On the formatting though...I am still getting a compile error when I try to run it. This is the way it's written: Expr1: Format([Field1],"00") & Format([Field2],"00000") &...

Hello Access Gurus, I have seen posts regarding this topic, and so far it's not working for me. Hoping someone out there can help me. Here's the roadblock(s) I'm running into... Ultimate Goal: I need to take an 11 digit numeric code, calculate a MOD10 check digit on it, and store it in the...