Search results

Right before I send the e-mail, i double click on the attachment to view it from OutLook, it is messed up when I view it from there. it is okay until it is an attachment in outlook.

Yes it works fine on my Vista machine. I don't know why it's doing that on Windows 7 ???

It can be done via the Sales Order Form by a button which opens the MS Outlook and attaches the file as .pdf. Or you can open the report from the form and view it and then right click and send to recipient as .pdf either way, when the report is opened it looks perfectly normal until you view...

Hi all! I am having an issue with sending reports via email. It has worked fine up until today... When the recipient receives the the .PDF report attached to the email, when they open it up it only shows the top left quarter of the report zoomed in. Does anybody have any idea why this is...

Hi All! I have a 75 page word document with about 4 different section breaks. Before I print, the TOC displays everything fine. The last couple pages of the document are an Appendix (new section), so the page numbering is A-I, A-II, A-III, etc... Even after I have updated the page...

and [Company] is the FK to the main customer table

The company names for both the Combo Box and the Company in the form have the same row source: its the master customer query for the database.

Hi All, I have a little problem; I have a form that shows many records. I created a combo box at the top of the form to filter records by company. The filter code looks like Me.Filter = "[Company] Like" & "'" & "*" & Me.Combo60 & "*" & "'" The filter seems to work, but sometimes the...

Hi all, I have a report that each time it's run will have a different number of records, I created a text box in the detail section of the report and then put the control source to "=1" and then changed the running sum to over all. That totals everything up perfectly, but I want the TOTAL # of...

I think I've figured most of it out except for one small thing: Some of the Checkboxes for Repairs are Null, and some are FALSE, is there any way to have it so if "CheckRepair = False" that every record with a NULL or FALSE checkbox will be returned? Private Sub QA_Report_Click() On...

No there is no limit in the query. but it seems that the code for [Repairs] is only returning records where [Repairs] = True. Doesn't there need to be an If statement to say something like: if [this checkbox in the form header] = true then return records where [Repair] = true Else...

I think I know what might be the problem, It's only returning records where that Part has been repaired. Whereas I want to be able to use the CheckBox in the form header to decide whether I want to view the parts repaired, or view the parts that haven't been repaired. The code is only telling...

When the box is UNCHECKED: [Part]="910-BT100AVS" AND [Cus Order Date] <=#07 14 2010# AND [Repair]= True When the box is CHECKED: [Part]="910-BT100AVS" AND [Cus Order Date] <=#07 14 2010# AND [Repair]= True

There are very few records that are repaired, so when I left the date fields blank, and just selected a part number, it would show only those parts that have been repaired, no matter what the checkbox was.

Yes, the Cus Order Date is a date field.

wait... I just played around a bit more, its ONLY bringing up records on the report where [Repair] is true, the checkbox doesn't seem to make a difference.

Well, I don't get any error messages anymore, but when the report opens its completely blank with no records to show, even though the criteria states it should be showing certain records.

You had the debug.print. strWhere I changed it to debug.print.stWhere and did the same process. this time it came up with this in the Immediate Window: [Part]="910-BT100A" AND [Cus Order Date] Between #Jun 01, 2010# And #Jul 08, 2010#[Repair]= True

Private Sub QA_Report_Click() On Error GoTo Err_QA_Report_Click Dim stDocName As String Dim stWhere As String Dim stDates As String Dim blnRepair As Boolean If Not IsNull(Me.Combo44) Then stWhere = "[Part]=" & Chr(34) & Me.Combo44 &...

Okay so when I press the button, get the error message, click OK and then go back to VB editor, in the Immediate Window it says : "[Repair]= True" (the quotations are not in the code)