Search results for query: *

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!

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

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

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

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

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 to repair it self without me doing it...

I am trying to redo an old report. I have 2 tables. People and Refer (Actually more but to simplify i'll just use the 2 main ones). Refer table may have one or more referrals for each customer. Each referral has a status. Lets say A (accepted), R (rejected) and I (incomplete). I need to select...

is it possible to do a select statement in vb and then pass it on to crystal? right now i have many reports all with different select statements, i was wondering if i could just make my selections in vb and pass it on to crystal and just reuse the same one report. Like maybe make a query in vb...

My program is on a server. I use Access as my db. Sometimes when you leave it in the background and dont use it for a while and then do something it hangs there Not Responding. After half a min or so it works fine. Its almost like the connection to the db gets timed out or something and it takes...

When I open my access database in vb, how do I set the options Default Record Locking = Edited Record and Number of Update Retries = 0 ? DBConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database.mdb;Persist Security Info=False" thanks

When I open my access database, how do I set the options Default Record Locking = Edited Record and Number of Update Retries = 0 ? thanks

How would I go about getting the next week start and end date? I have a grid with mon-friday/hours, and want to load into a combo box week start date and end date. (12/9/2002 - 12/13/2002) and then switch between grid views on the combo box week selection. So is there an easy way to do this...

When I have the FlexGrid Selection set by Row or Col when you click it gets Highlighted, but when the selection is set to free when you click it doesnt get highlighted, its selected with a black line around the col but not highlighted. How can I get it to highlight when the col is clicked? thanks

I am trying to do a popup menu and highlight the row that was selected on right click. I got it selected but how do I highlight it? heres the code...thanks Private Sub grdRoster_MouseUp(Button As Integer, Shift As Integer, x As Single, y As Single) If Button = 2 Then...

I am trying to set the background of Col 7 to red in every Row where value of Col 7 is 0 or less. I load the grid from a table and the number of rows is always different. How would I do this? thanks!

Does the order of your select statement make the report load faster? In example, lets say I am trying to select where ID = 5 and Name = CD. I have 10,000 recs with ID of 5 and out of those 100 have a name of CD. would (Name = CD and ID = 5) load faster than (ID = 5 and Name = CD), or it...