Search results

  1. J

    Input Box Help with Code

    Agreed. But I dont exactly know how to do that. I have about 20 forms and on each form I need someone to be be able to click on a command button for either yes or no, and then enter a password. I'm not sure hwo to do that. If no command button, I need two textboxes to be password...
  2. J

    Input Box Help with Code

    Here it is
  3. J

    Input Box Help with Code

    BTW, thank you again for all the help. cant thank you enough
  4. J

    Input Box Help with Code

    Could you possibliy take a look at a stripped down version of mine. Im hopelessly lost. I will have to go find someone to zip it, my machine is a POS and keeps freezing. I hate networks
  5. J

    Input Box Help with Code

    Can somebody post a database that uses the DKInputBox code from above?
  6. J

    Input Box Help with Code

    From a newer version of windows, or a newer version of Access. You think if I swtich to 03 or 07 for Access it might work?
  7. J

    Input Box Help with Code

    When I check that line of code thats in red in the Immediate pane or window: hHook = SetWindowsHookEx(WH_CBT, AddressOf NewProc, lngModHwnd, lngThreadID) I get this error message: Compile error: Expected: Expression
  8. J

    Input Box Help with Code

    Okay, I was able to open that one. I copied the module in that one exactly into the module in mine... Just to make sure, in access 97, I am supposed to copy that into a new module under the modules tab all the way to the right, correct? Then on my form on clicking the command buttons I have...
  9. J

    Input Box Help with Code

    I should mention I am using MS access 97. Gotta love my company...
  10. J

    Input Box Help with Code

    I cant open it, I am getting an unrecognized database format error which doesnt make sense. Maybe its because I am behind network or safeguards of some sort at work? Anything else or another way I can look at it? Sorry for the inconvenience.
  11. J

    Input Box Help with Code

    Getting There... When I run it, I get a Compile Error, Syntax Again, right above the red out comment at the bottom of the code, I get a yellow arrow pointing to Public Function InputBoxDK(Prompt, Optional Title, Optional Default, Optional XPos, _ Optional YPos...
  12. J

    Input Box Help with Code

    So I just create a new module, paste all that in there, and go from there. If some of the code is red after copying and pasting it in there, what does that mean? I am completely new to using VBA. Sorry Specifically, in the link above, I am getting a syntax error at the very very bottom with...
  13. J

    Input Box Help with Code

    Hi everyone. First off, thanks for any help. I have an input box that asks for a password and then checks and locks a checkbox. Its on a bunch of forms that Quality Assurance is going to use as their digital signature to sign off on forms. I asked this yesterday, how can I mask the password...
  14. J

    FINISHING Touches :)

    Hey everyone, I THINK I am almost done with my database, thanks large in part to everyone here. I have one last question (I think). I have a password protected command button that has the user enter a password. If correct password is entered, a check box is marked off and locked, if not, its...
  15. J

    Need help: How to hide #Error message from textbox until values are entered

    GOOD TO KNOW. Thanks everyone. Problem resolved:)
  16. J

    Password Protect a Textbox???

    Do you know how to actually password protect the textbox though. When the user clicks the textbox, how do I prompt the user to enter the password. Also, once they enter the password, how does it check it against the table where the passwords are stored etc etc etc?
  17. J

    Password Protect a Textbox???

    I am making a database for my company that includes build sheets for items we manufacture. During each part of the bulid process (and on every form) there is a textbox where the Quality Assurance officer's name who is overseeing the manufacturing will be entered. Is there a way to have this...
  18. J

    Need help: How to hide #Error message from textbox until values are entered

    I just did Nz([TextXX], " ") which worked and displayed absolutely nothing when there were no values in any of the textboxes used in the calculation. However, when i placed one value in one textbox used in the calculation and nothing in the other textbox used in the calculation, i receieved...
  19. J

    Need help: How to hide #Error message from textbox until values are entered

    Awesome, so I simply put Nz([TextXX],0) before every component used in the calculation. Is there any way to have even no 0 there, just blank space? Thanks for the help, especially so fast!
  20. J

    Need help: How to hide #Error message from textbox until values are entered

    Hello. I am having a bit of a problem. Some of my forms contain textboxes which perform calculations. For example, one textbox performs a calculations such as = [Text10] + [Text20] This textbox takes the values stored in Text10 and Text20 and sums them. However, I want to hide or remove...
Back
Top Bottom