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 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 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...
I have a delete query that runs off a button on a form. If the user types in the value of a record that can not be deleted due to referential integrity rules, I want a message of my own to come up that says they can't do it. I tried debug.print and got dataerr=8058 and then in the Form's OnError...
I have an Access 97 database and about 30 Crsytal Reports built off this database. I was wondering if in the Access database, I can include a custom menu that when the user chooses a certain item it will run one of the compiled Crystal Reports? I see that there are additional tools in Form...
I am getting an error message box when I delete or replace the information in a certain field on my form that is coming up blank. I know it isn't one of mine because I guve mine specific header lines that this one lacks. Is there any way to get rid of it and what is it anyway???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.