Search results for query: *

Hello, I'm using Excel 2003. I've created a personal.xls file to run every time Excel is opened. In personal.xls I have a macro that I want to run whenever someone hits the Print button in any workbook. I'm trying to change the printer that Excel will print to (but not the default printer of...

Hello, I'm using Excel 2003. I've created a personal.xls file to run every time Excel is opened. In personal.xls I have a macro that I want to run whenever someone hits the Print button in any workbook. I'm trying to change the printer that Excel will print to (but not the default printer of...

thanks guys. will try it and see what happens. I also have not done a system restore..

I have XP Pro and had the welchia and blaster worms. they were removed but now I can't get the Registry to stay open. If it type regedit in Run, it flashes really quickly and closes. Anyone know how to fix this? I can't find any fixes on this for XP so far.. any help would be great. thanks!

I cannot for the life of me figure this out. I'm using the Microsoft Calendar Control 9.0. I'm trying to set just the cell of the current day selected to a different color from the backcolor. The BackColor affects the background color of the entire calendar. I know there is a way since...

Does anyone know if when I send an update command to an Access database, does Access send any information back to VB to confirm that it has updated the table?

Thanks for the tip. I found out that the db wasn't updating fast enough so when the grid refreshed it only extrated the old data. I put a pause time in there and it seems to be working ok. I'll try your idea and see if it works better. Thanks again!

Hi. I'm having trouble getting a flexgrid to refresh. I'm using a datacontrol to get the data from an Access DB. I've tried doing data1.Refresh or MSFlexGrid1.Refresh and that doesn't work. I've also tried requerying and then refreshing but that doesn't work either. I'm probably doing...

Thank you both, chelseatech and dgillz, for your help. The formulas worked great. dgillz, in case you're still curious, when I tried to sum my distinct count this was the error that kept coming up "the summary/running total field could not be created" Have a wonderful day... Peggy

This is what I have as Output right now. Order_no Od_no Qtr_no Description 3 1 1 Pepperoni Sausage 1 7 1 1 Pepperoni...

My Count is actually a Distinct Count. I want to sum that Distinct Count. But when I try to create a new formula to sum that Distinct Count, I get an error. I must be doing something wrong. Any suggestions instructor?

Just out of curiosity, is it possible to make a formula to sum what's in a Group Footer. What I mean is if I have only 1 field in a group footer that is a count of other fields.. can I do something like sum({GroupFooter2}), using "GroupFooter2" as the field, to get a sum of that count?

The "last field" you're asking about is the name of your parameter field. If you do Insert->Parameter Field, you should be able to see the name it.

Hm.. you know what, I didn't link my parameter to a field. But it seems like only the values I choose in the Select Expert (example {orders.order_no} in 3.00 to 11.00) are the ones that actually affect the result of my report. When I'm prompted to enter values, say 3 to 100, only values from 3...

I'm just starting to learn Crystal Reports and am having trouble using the Parameter Field option. I just created a simple report with some number IDs and a few names. I want to be able to choose a range of numbers to report on. My Access database contains primary IDs from 1 to 10. If I...