Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ChemistZ

    Page two of report - group formula not working correctly

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

    Formula result won't show a zero

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

    Formula result won't show a zero

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

    Formula result won't show a zero

    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...
  5. ChemistZ

    Totals using global variables - need help

    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?
  6. ChemistZ

    Can an image be "Ghosted" to a HP-Unix server?

    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?
  7. ChemistZ

    Need Help with a Dlookup

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

    Need Help with a Dlookup

    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?
  9. ChemistZ

    How do I make an Access database read-only?

    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...
  10. ChemistZ

    Combo box help

    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...
  11. ChemistZ

    VB Run-time error 3251 - Can someone advise?

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

    VB Run-time error 3251 - Can someone advise?

    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...
  13. ChemistZ

    PowerPoint - Pictures on Slides

    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?
  14. ChemistZ

    Date Field Problems - Help

    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...
  15. ChemistZ

    Key Violation Error - Turning off default message

    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...
  16. ChemistZ

    Key Violation Errors - Can you trap them?

    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...
  17. ChemistZ

    Calling a Crystal Report from an Access 97 Form

    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...
  18. ChemistZ

    Blank Error Message Box???

    I think I did that successfully and I got error code 2169. How do I find out what error code 2169 is?
  19. ChemistZ

    Blank Error Message Box???

    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???
  20. ChemistZ

    UnLoad Event and Primary Key Fields

    Yes, I did but the form can still be closed with the X and that is what I am trying to put validation into and stop.

Part and Inventory Search

Back
Top