Search results

  1. C

    Action when DB Closes

    I will try to attach it again.
  2. C

    Action when DB Closes

    Yes/No I have a form where the user enters in his/her user name and password. Then clicks enter. The code then searches the table tblPasswords to see if the user name and passowrd are correct. If it is, then the user is granted access to the system and a query is run to update the field inside...
  3. C

    Action when DB Closes

    Thank you very much, Gotta get back to work now. These forums are great. Very helpfull.
  4. C

    Action when DB Closes

    Let me rephrase my quesiton. I have disabled everything on the users forms and through the Startup options. But the toolbar still allows for the File Exit and the Edit and Help and some other things. Anyway to get rid of all of that?
  5. C

    Action when DB Closes

    Any way to keep a user from using the File, Exit? Is there anyway to get that entire toolbar to disappear?
  6. C

    Action when DB Closes

    I have a table that lets me know what users are loged into my database. In that table whenever a user logs in, the YES/NO field for that user changes from a No to a Yes. I need that field to return to a NO, whenever that user exits the DB. I have a button that I have told all users to use to...
  7. C

    Date Field

    Thanks I will try to implement that. Thank you
  8. C

    Date Field

    I have a field on a Form that is a Date Field. I have an input mask on the field so the user must enter in the date in the correct format. MM/DD/YYYY However, I have tried to trap the MS ACCESS generated error that appears if a user enters in invalid data such as 12/3#/####. Where the #'s are...
  9. C

    Maximum # of records?

    In Access 2000 what is the maximum # of records that it can hold? Is there a maximum?
  10. C

    Password Input Mask?

    I mean it actually changes the data in the table to all *'s for the field Password. I set the field to equal what the user enters in text box. But instead of it inserting in the password that the user enters it inserts all *'s
  11. C

    Password Input Mask?

    I have 2 unbound text boxes where a user enters in a new password and verifys the new password. I put the password input mask on these two text boxes. Now when I change the password it makes the password all ******* it does not change it to the real characters that the user types. Any ideas? so...
  12. C

    Stop Automatic Tab to next record

    Thank you! Thank you!
  13. C

    Stop Automatic Tab to next record

    I have several forms where a user can edit whatever record he or she requested from the previos form. The problem is when the user tabs all the way through the form. When the user does this it automatically brings up the next record. The user did not request this record and therefore could...
  14. C

    Checking two Fields at once

    Thank you Thank you very much I will try that right now
  15. C

    Checking two Fields at once

    I have two fields where a user inputs data. These two fields make up the primary key. When the user enters in the data, a button is suppose to check whether or not that exact record is in the table. What is the best or easiest code to write to check and make sure that those two fields which are...
  16. C

    HELP Have you ever seen this before

    I have a project that I have been working on and I imported some forms into it and now when I try to debug the Code it gives me an error message "Error Accessing File. Network Connection may have been lost." Nothing in this file is on any network its a small 3 table database that has about 12...
  17. C

    Have you ever seen anything like this?

    I tried it but I eneded up getting the same thing. This is the strangest thing I have seen from Access in a while. But the report works so thats all that matters. I just hope it does not give me problems in the future. Thanks again
  18. C

    Have you ever seen anything like this?

    This is very strange. I have a query which is shown below. SELECT Mid$([DCN/Serial_No],1,3) AS DCN, [Subject], [Action_Complete] FROM newtaskerform WHERE (((Mid$([DCN/Serial_No],1,3))="SMC")); When I run this query, I get the anticipated information back, then about 3 seconds later I get an...
  19. C

    Automaticly populate a field on a form?

    I will give it a shot and let you know how it goes.
  20. C

    Automaticly populate a field on a form?

    I am creating a form where the user enters in Case informaiton and the first field which is the Primary key needs to automatically populated with the next case number. Case numbers go like this. 02-001, 02-002, 02-003, 02-004, and so on. The only problem is that the first two digits depend on...
Back
Top Bottom