Recent content by rhancox

Variables local to a procedure are always allocated when the procedure is run. While they should also be deallocated at the end of the procedure, have you tried: SET dirP = Nothing at the end of your procedure? This should insure the memory is deallocated.

No responses since my last post? I hope I didn't offend anyone with my elementary explaination. But I could use an answer. I've done a lot of research, and I don't see a solution, short of performing some fancy mathematical magic. There doesn't appear to be a simple AND or OR function to use...

Ok, I've got a field in a record, called Flags. It contains flags that I use in a VB program to set or reset check boxes on a form. In VB code, I can use this code: For x = 0 to (chkBoxes.Count - 1) If Flags AND 2^x THEN chkBoxes(x).Value = 1 End If Next x So now in my CR formula...

I'm not sure I understand your solution. I've got a flags value, say 7. I want to see of bit 1, value of 2, is set. With immediate data, the statement looks like this 7 AND 2. If bit 1 is set, the answer is 2. I want to write a formula in CR that says, IF Flags AND 2 = 2 THEN ..whatever..

Does anyone have any suggestions on how to perform bit-wise functions, since AND/OR will only return a boolean answer. Obviously, I want to check for the existence of a bit within a value. Doing the following, "Flags AND 512" only returns True/False (depending on the contents of...

I've been going round and round with CR tech support, via email, and still haven't got a solution. I have re-packaged my application to make sure all the CR files are installed in their right places. Still doesn't work. I am waiting for a reply to my request to elevate this problem and have the...

I have this problem in a similar fashion. The sendmail dialog box never comes up. You get to select the export type (in my case PDF) and the destination (MAPI), but then the send mail box never displays. I've checked the CR KB article C2011229 and I've got all their suggestions in place and it...

I have tried that and it does exactly that. It prints at the bottom of the page at the size I've set it to be. What I want the report footer to do is expand to take up the remainder of the last page. I can't figure out how to do that.

How can I make the report footer print from the last detail section to the bottom of the page? I want the section to be of variable length depending on how much data is in the report. I'm trying to create a "do not write in this space" area on a signin sheet to prevent people from...