Recent content by msrichards

After some successful use of Openargs with reports I did find one drawback: apparently Docmd.OutputTo does not have an Openargs argument. So, if you want to use the same report for both printing and exporting, the report will ignore the Openargs value when it is used with OutputTo, which means...

Well I'll be. You learn something new everyday! I have used every version of Access through 2003 and never picked up on that. Thank you, pbaldy! For srs09 that means all you need to do is docmd.OpenReport "Report1",OpenArgs:=strMySQLCmd My apologies for the wrong info.

There is no method for reports similar to the OpenArgs that you have for forms. I have never figured out why Microsoft has never created an OpenArgs for reports. So, you have to use something like this to pass anything to a report. However, this is an efficient use of resources, so I would not...

Create a textbox control on your form and set its visible property to not visible. You probably have a 'View' button. On the code behind the click of the button that opens the report, set the sql command string you have built to the text box value. Then open the report which will use the value...

Well HiTechCoach your instincts were right. The default printer was a LaserJet 1020 - had all the right printer drivers works fine, etc. I changed the default printer to a Multifunction HP printer they happened to have and now Access works great. Re-installed the LaserJet 1020, downloaded and...

Wrote this module many years ago... here you go (English and Spanish) Public Function ConvertCurrencyToText(ByVal curAmount, _ Optional fNumericCents As Boolean = True, _ Optional fDollarText As Boolean = True, _...

That is an excellent suggestion. I have packaged up a test mde and will get the client to try it out tomorrow. If it works, you are right: it must be something in my program and not a system issue. Thank you. I have not found any hotfixes for this problem.

You might try setting the control source of the field to =NZ([FieldX],"")

I verified that the printer was installed properly, so it is something else...

Yes, there is. I suppose, though, that I did not verify that it actually prints. I will check the driver and test that tomorrow. Thanks. Will post results.

Have an MS Access ADP project running on hundreds of machines under MS Access 2003 Runtime. On a particular client's machine it worked fine up until last week. After installing MS updates last week, NO reports show. All work in the Report_Open event is done, then the report closes itself before...