Recent content by DentTec

Here is my code Private Sub cmdEmailAll_Click() 'output all reports at once Dim i As Long Dim olApp As Object Dim olMail As Object Const olMailItem = 0 On Error Resume Next Set olApp = GetObject(, "Outlook.Application") If Err.Number = 429 Then Err.Clear 'Outlook is not...

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 ?

Gina: I have 2007, what is SP ?

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

Thanks Jeanette, it works great.

GalaxiomAtHome: I just correct my code, I posted a wrong SQL earlier. I'll take a look at your suggestion tomorrow. Thanks

Thanks for the link Jeanette, I'll check it out soon. Sorry I posted a wrong one. Here is the correct one Dim sql As String sql = "SELECT blah blah, [Outstanding Invoices].Client" sql = sql & " FROM [Outstanding Invoices]" sql = sql & " GROUP BY blah" sql = sql & " HAVING...

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

You create QUERY based on a table, not a form. From there you can create report. Can you be more specific of what you are trying to do ?

Then add a command button to your form, choose Report Operations, Print Report, then choose your report.

Just hit Ctrl+P

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

Beautiful!!!!! Thank you so much DCrake

DCrake: no, they are not