thanks lbass, i already had something similar as to what you suggested.
But when you use this method. How can you get an accurate count of how many records you are displaying? I tried using Summary/Count but it counts the suppressed records.
I have duplicate names in my report so to get rid of them, i grouped by Name, and then put a formula that looks like that in the details
if not isnull({people.ssn}) then
1
else
0
then in the group footer i sum up the formula and in group selection formula i put this
Count ({@SSN}...
I have a few reports that need to be grouped by four quarters, Jan - March, April - June, July - Sept, Oct - Dec.
The way it works now is that there is a Formula called Quarter. That looks like this.
if {term.termdate} in Date (1999,01,01) to Date (1999,03,31) then
"1999/01/01 -...
My CD Rom opens and closes whenever it feels like it. It just started happening this week. It just randomly opens and closes. I am totally clueless as to why this happens. Does anyone know what it could be?
thank you!
using listbox is exactly what i am trying to avoid, i could have sworn i saw a way to select multiple items in a combo box before.
thanks for the help!
I have a network printer and it has 5 documents in print queue but it tells me Access Denied when I try to Cancel them. The computer the documents were sent to print from is no longer here I dont think. I unpluged the printer but it still had those documents in queue. Any ideas?
Thank you.
I was intalling some software, put in the cd, it was installing just fine until for some reason the cd rom ejected without the cd. I got the error saying "Error reading from Cd" I aborted the installation and rebooted the pc. The cd was left inside. I tried to access the cd but it kept...
Yes, so does anyone have any idea how to change the resolution for the normal boot?
perhaps go into dos mode and edit some settings files?
there has got to be a way :)
Thanks!
My monitor broke and until i get a new one i am trying to use an old 15 inch one. But the screen is all back when I log into windows. I think it might be because the resolution settings are wrong. I can log in just fine in Safe Mode and the Display settings show 640 by 800 something? And cant be...
I think you need to create two parameters in your report, StartDate and EndDate. Then pass strControl to StartDate and strControl2 to EndDate.
rptTotalStats.ParameterFields.GetItemByName("StartDate").AddCurrentValue strControl
in your selection formula replace strControl with the...
I have 3 tables, Application, Term and Term2. The Term tables are basicly copies of each other.
The Report is filled with junk from Application but some fields like Termination Date come from either Term or Term2.
If the application doesnt have a record in Term how would I make the report check...
'The Application object is used to open an external RPT file as a Report object.
Public CrxApplication As New CRAXDRT.Application
Public CrxReport As CRAXDRT.Report
Set CrxReport = CrxApplication.OpenReport("Report.rpt")...
Sometimes when ppl just power off their pc without shutting down properly my access db gets corrupted, I usually just repair it and its fine after that. But until i repair it the app gives an error saying DB not recognized. Is there someway I can automate it in the error handler to repair it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.