Search results

Hi I have no idea why my list.listcount always returns 18. Anyone runs into this problem ? A2010 Thanks

My code worked flawlessly in 2007 version. My laptop comes with 2010 trial version and it doesn't work anymore. When I click "Email" button it opens Outlook and pastes all the email addresses but there is no pdf attachments. What went wrong ?

I have a subform that 3 Master/Child links such as Client, PaidDate and CheckNumber. After the main form is updated, the cursor will focus on a field in the subform and this subform will show the unpaid invoices belong to the current Client if the 3 mentioned criterias are not met. It worked...

My SQL statement was working fine except when the value of criteria has the aspostrophe in it. How do you handle this problem ? Thanks

The EMAIL field in my Client table is set to be Hyperlink. I want to be able to edit this EMAIL in my Client form but there is no way I can partial select the email address because the whole text box is clicable. I can I make it clickable only on the email itself, not everywhere in that text...

I have two list boxes and would want to have this happens If I select an item in list1, none is selected in list2 and vice versa. Right now I can do this with For...Next looping. Is there any other way ? It might take longer as my list gets bigger.

I can't think straight anymore. Here is the story I can print multiple reports with one click using force page break. Can I do the same with emailing them ? I now can email one report at a time only. What are the steps I need to do ?

Right now I click a button, which run a query of what addresses needed to be print. Then I have to open mail merge manually and print them from there. Is there a code allows me to print them right way (by pass merging manually)?

Hello all I want to refine my code. I'm printing multiple reports while looping through my list. I have to open and close report for each selected item in the listbox. Is there a way to by pass this ? Thanks Private Sub cmdPrintAll_Click() 'for each client in the client's list, print the...