Search results for query: *

SQL Server 6.5, Access 97. When OrderTypeID = 6, I want to not allow that record to be updated. I am thinking of doing this in a trigger. Is that the proper or best place to do this?

Didn't remember that A <> B was one operation. Glad that I sparked a some thought. Thanks for the info. I also did a little benchmarking and came up with similar results. I don't commonly trust benchmarks on single opertions. I even received negitive times while benching this. And the...

Yeah MichealRed you did go to far. Wasn't specific, x = 0 was just used to show syntax. Petermeachem, I agree with b = a > 4. Use that style also. Also have a history in Assembler, so have that same &quot;don't waste a byte idea&quot; My question was basically is (Not =) slower than (<>)...

Is there a performance difference? Why do I never see the Not in examples or documentation? Just curious?

Found it. Minimum({?DateRange}) and Maximum({?DateRange})

How do I display a date range parameter on my report in the report header.

Is there a way to add a icon in the viewer's tool bar to change the printer that report prints to? I know how to do it using a vb control, but would rather not do that.

Is there a way to add a icon in the viewer's tool bar to change the printer that report prints to? I know how to do it using a vb control, but would rather not do that.

The software is VB 6.0 and CR 8.0 developed. CR and VB are not installed on the clients. We have many other reports running with no problems on the client sytems. All working reports don't have a chart. All non-working report contain charts.

I have several pie charts reports. On the 2 development machines, no problem. On client systems a GPF is triggered. I am assuming there is a missing or incorrect dll. I have been unable to locate any documentation to that affect. Please Advise.

Use dir to check to see if it exists. sPathName = &quot;c:\MyStuff\*.ps&quot; Do While sFileName = &quot;&quot; sFileName = Dir(sPathName) DoEvents Loop Give this a try. It is quick and dirty and some would say bad form.

I am using CR 8 and VB 6. I have set up a pie chart in a report. I want to use the same report for 10 different pie charts. I want to change the &quot;on change of&quot; for the chart. I made it a formula. It has no problem with this. After changing the formula using VB the viewer shows no...