Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cwindoma

    Creating a parameter in a macro

    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
  2. cwindoma

    Sending attachments in an email.

    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.
  3. cwindoma

    Sending attachments in an email.

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

    Sending attachments in an email.

    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...
  5. cwindoma

    Sending attachments in an email.

    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
  6. cwindoma

    Sending attachments in an email.

    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...
  7. cwindoma

    Access 2007 - Concatenating Leading Zeros, and Storing an 11-Digit Num

    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...
  8. cwindoma

    Access 2007 - Concatenating Leading Zeros, and Storing an 11-Digit Num

    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...
  9. cwindoma

    Access 2007 - Concatenating Leading Zeros, and Storing an 11-Digit Num

    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") &...
  10. cwindoma

    Access 2007 - Concatenating Leading Zeros, and Storing an 11-Digit Num

    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...

Part and Inventory Search

Back
Top