Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kovas
  • Order by date
  1. kovas

    Group Selection Formula Help

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

    greatest date

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

    Group Selection Formula Help

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

    Summarize Formula by Group (see example)

    Roni check out this thread thread149-160340
  5. kovas

    Grouping by Date Quarters.

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

    CD Rom Problem...

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

    CD Rom Problem...

    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!
  8. kovas

    Multiple Selection In Combo Box?

    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!
  9. kovas

    Multiple Selection In Combo Box?

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

    Cancel all jobs in queue on Printer?

    Its xp, sorry a bit clueless here but what is a spooler service and how do i stop it? thank you for the help!
  11. kovas

    Cancel all jobs in queue on Printer?

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

    CD Rom problem

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

    CD Rom problem

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

    Monitor Help

    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!
  15. kovas

    Monitor Help

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

    Crystal and Visual Basic HELP!

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

    Formating Int and Mod Functions

    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,'') + ':'+...
  18. kovas

    Getting data from two tables

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

    Crystal and Visual Basic HELP!

    '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")...
  20. kovas

    Db getting corrupted

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

Part and Inventory Search

Back
Top