Recent content by MasterLu

Wow! Thanks Zion7 for the quick response. I will try that out and let you know how it works for me. Thanks! -Lu

Hi I have a question regarding how to apply the same sub procedure such as the following example to multiple controls on the same form. I want to apply this procedure to Copy2, Copy3, Copy4... Copy10. Is there a way to pass the Copy# as a variable? So for each Copy#, before updating I want it...

Hi 4946 Thanks so much for the extremely detailed and thorough explaination! I have tried several examples given throughout several other threads with no success. Your example is working perfectly for me! Thanks again for the explicit instructions - it's exactly what some of us novices need to...

Hi Schaap Would you mind posting the link to where you found the Mapilab free redemption stuff? I'm running into the same problem here... Thanks!

you can also start the macro by adding the action "SetWarnings" to "No" (this will turn all yes/no prompts off) and then end your macro with the action "SetWarnings" to "Yes" to turn them back on.

Hi - actually, it does work and gives me the results I need... but it is extremely slow which is why I thought it wasn't working at first. Any tips on how to speed it up? I really appreciate it!!!

Hi - It seems like it should be simple... but I can't figure this out! The code I have been working on, but may be entirely on wrong track: SELECT DISTINCT ORDER_NUMBER, TESTING_DATE, Category, Passing_Score FROM qry_Database WHERE (((TESTING_DATE)=#5/8/2004 8:30:0#) AND ((Category)="Big")) AND...

Hi Skip Thanks for your response! I just tried it without the quotes and it still gives me the same error 'subscript out of range' as i'm stepping though just as it gets to that part... any other suggestions? i appreciate it!!! lu

i've been working on this code to copy a worksheet from one workbook to another workbook. first i have to open each workbook and then copy the name of "whatever worksheet" to the other workbook. 3 workbooks are involved: workbook with the code in it with the spreadsheet to loop through, workbook...

Hi I have a report that is basically like a Member Profile Report print-out. The left side has all the column headings (or "questions") followed by their "answers" on the right side. Name: Jane Address: 1234 Comments: blah blah blah blah blah blah blah blah...

Hi toolking Did you try exporting the query that the report is based on to an excel file? just a suggestion. It will export the entire contents of memo fields over 255 characters. Lu

Hi All ~ I'm still looking for the answer to this issue too - How to avoid having to click yes to send the automated emails. So is the only way to digitally sign our macros? Any advice is appreciated!

vbajedi Thanks for the script. it works!!! you're the best!!! at first i was getting this error msg: Object variable or With block variable not set (Error 91) that would pop up after the "Set Itm = App.CreateItem(0)" line but it works now after i moved the "Set App =...

To VBAJedi I haven't had a chance to try it out yet, but i wanted to say thanks for your help first!!! I'll let u know how it goes...

Hi - i'm very new at this and i'm trying to do something similar. I have an excel file of all my contacts and their email addresses and i'd like to send a standard email to each person but attach unique files to each person's email. i thought there could be a way to add a column with a link to...