Recent content by ChemistZ

Is there some reason why the group summary formulas would not work when the report goes to multiple pages?

Jeez - all the blasted thing wanted was for me to check if it was null FIRST not second. THANKS for the good advice!!

Man, I thought for sure that would be it but it still doesn't show zeros. WTF!!

I have a formula that looks at a database field to see if it is equal to a certain value - if it is then it is supposed to multiply two other fields and it does this correctly and then at the end of the formula I say ELSE 0 but no zeros appear. Any ideas why? I tried checking the database field...

I am trying to validate a report that has global variables by the dozens. They are all being used to total certain things using by groups. However, one isn't working and I can't figure out why. Can anyone help me with this?

I have Symantec's Ghost 7.5. I have a PC that is linked through Reflection NFS to a HP-Unix server. Can I "ghost" the image to that server?

Thanks Bob - I just e-mailed you from ChemistZ@aol.com

I have a DLookup that just won't work. Is anyone game for me to e-mail you the zipped Access database and have a go at fixing it?

I have a database that I am trying to crack into. Someone created it here at work and then left. Now no one can get into it. If I hold shift when I open it, I see the tables, forms, etc.. behind the scenes but I still can't get past the fact that first a message pops up saying I am opening it...

I need to know if what I want to do is even plausible. I want to create a form where a user can enter their main business functions to a list or combo box. I won't know in advance how many they will enter so I need for the list to just keep adding them as they go. Next, I need when they finally...

I have used the data environment to create a connection and command. Where is the right place for the adlockoptimistic?

I have a VB app connecting to a SQL Server 7.0 database. On a form that consists of one table's data, I added a button with the AddNew method attached. When I click it I get the above error message. The words following it are "Object or provider is not capable of performing requested...

I am trying to print a slide with a picture on it that is supposed to take up the entire surface of the slide. It appears to do so in slide view but when I print the slide, I have a very small white border around the picture. Is it possible to get rid of this? How?

I have a text box on a form that is tied to a date field from a table. I have an input mask set on the field for Short Date. When I type something like 01/33/01, I get the proper message that says the date is invalid. However, if I type something like 56/01/02 it takes the entry and changes it...

I have managed to trap error number 8057 which is supposedly a key violation error message. My new error message shows up but so does the key violation message. I have set Response=acdatacontinue which according to Help turns off the default message and I have tried setting Response= -1 which...