Recent content by Bain

http://www.utteraccess.com/forums/showthreaded.php?Cat=&Number=546025&page=2&view=collapsed&sb=5&o=&vc=1 I got the kinks worked out. Both problems seemed to be caused by the MonthName issue. I created a wrapper function like the one described in the link, and everything works fine!

[RESOLVED] A2K app doesnt work on all A2k Machines I have written a number of small Access 2000 apps recently. I have run into a problem with other Access 2000 machines not being able to fully run these apps. Example 1: I have a report which uses the MonthName() function. It runs fine on my...

use the count(*) function example: SELECT Count(*) as NumRecords From..........

I put 2 textboxes on the report, one for start date, and the other for end date. The other ones are sub reports pulling the dates from the main report. And if I run this on as a sub report, it works fine. but doesnt seem to work as a stand alone report.

I would rather not use form pop-up, and I know this method works, I have like 9 other reports that work this way.

I have a report that is based off of a cross tab query. The cross tab query is based off a query which takes the date parameters from the report. The spelling of the controls are correct. But when I run the report I get 2 errors where the date is supposed to be displayed. Base Query SQL...

1. for the "SUM", do a Count of your count.... make sense? that is what I did, seems to work fine. 2. have a different RowHeading field that holds the Month number, and sortbased on that, and make sure that it is set to "not shown" hope that helps

can it be done? I have a report with about 9 sub reports, the final one need to be setup as Landscape..... is there any way for me to do this and leave the other protrait? Or I will I just have to print this sub report separately?

No worries man, thanks again for the help.

I dont mean to be a jerk. Any how the form idea is not a bad idea, however I dont think the users will get that they need to click on a form button to print a report. Thanks for the idea, i will take it in to consideration.

Hopefully this makes sense. I have a report that consists of nothing but sub reports (attached to parameterized queries) that all take the same parameters. I would like to have the user enter in the in the data parameters once at the beginning. Right now I have no record source set up for the...