Search results for query: *

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.

sort it descending by date? put a count of records and suppress anything greater than 1?

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

Roni check out this thread thread149-160340

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

thanks for the reply but that didnt help. any other idas? thank you!

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!

How can I select multiple items in my combo box? I am trying to pass it as a parameter to my crystal report. thanks!

Its xp, sorry a bit clueless here but what is a spooler service and how do i stop it? thank you 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.

thanks for the reply, but i got it removed with a paperclip, it was stuck in there somehow ;)

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

Try this, it works fine for me. NumberVar TotalSec := {@Seconds}; NumberVar Hours := Truncate (Remainder ( TotalSec,86400) / 3600); NumberVar Minutes := Truncate (Remainder ( TotalSec,3600) / 60); NumberVar Seconds := Remainder ( TotalSec , 60); Totext ( Hours, '00', 0,'') + ':'+...

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