Search results

  1. StacyStacy

    Update Query

    Yes, I get the message when I tab through the fields. No, I'm not changing anything. As many times as I have done this, this has never happened before. Thanks for helping me.
  2. StacyStacy

    Update Query

    Fields With A Problem No. I didn't. We are talking about 2 different issues. I am no longer addressing the update issue. My problem is that when I am in form mode and when I tab through the fields in my form, I get the following message: "The Value you entered is not valid for this field...
  3. StacyStacy

    Update Query

    I am still having the same problems ("The Value you entered is not valid for this field. For Example, you may have entered text in a numeric field or a number that is larger than the fieldsize setting permits"). None of my fields are numeric. They are text and this doesn't make sense. I've...
  4. StacyStacy

    Update Query

    Thanks, I cannot get past this error msg: "The Value you entered is not valid for this field. For Example, you may have entered text in a numeric field or a number that is larger than the fieldsize setting permits" To eradicate that error, I have to re-create my fields all over again. I tried...
  5. StacyStacy

    Update Query

    I'm modifying an existing db that has a field in the table named "city". To reduce errors, I have created in the form a dropdown field for the city. In the dropdown menu, the city field is blank. I also created an update query to update all records with the city named "Sardis" . I'm getting...
  6. StacyStacy

    Password Issues

    Thanks. I will try this on my laptop when I return home. ;)
  7. StacyStacy

    Password Issues

    I believe I have to remove the workgroup information. But how do I remove the workgroup setting? Should I open up a black database, go into workgroup and remove all settings? Protect all tables, all databases?
  8. StacyStacy

    Password Issues

    I don't know. I need some direction as to how to rectify this problem.
  9. StacyStacy

    Password Issues

    I created a password in a database that I created last year on my laptop. I copied a totally different database onto my laptop and tried to open file and it thinks it's associating the old password to the old database with this one. Help. I looked into the registry and *.mde files and...
  10. StacyStacy

    Not Advancing to the next record

    I fixed It! After printing out the documenter, I could not easily tell what was different. Additionally, I created another form with tabs and I could advance to each field without going back to the first tab. This is what I did: I went back to the "forms" property, and removed the following...
  11. StacyStacy

    Access Documentor for Forms

    I figured it out. All of my forms are hidden. I unhid the form I needed documented. In the pulldown menu, go to: "Tools" "Analyze" "Documenter" Choose Forms
  12. StacyStacy

    Access Documentor for Forms

    How do add a specific form in the documentor under "Analysis" in the pulldown menu? I see all of my tables and queries, but not my forms. Thanks,
  13. StacyStacy

    Not Advancing to the next record

    Please help me with an issue that an end user has described: If we are on any tab other than the first one ("provider-training location"), and we scroll to a different record, the next record defaults back to the first tab. In other words, there appears to be a set focus on the first tab. This...
  14. StacyStacy

    Scrambling of records

    Here's a problem from my end user. Can you assist me with problem: Whenever we add something new (i.e. a new record or new course code), the existing records are "scrambled." Instead of being in numerical order according to provider code, they are rearranged in order according to course code...
  15. StacyStacy

    The Cancel Button

    Does Anyone Know? This is my last try: Does anyone know how to resolve this issue? Thanks,
  16. StacyStacy

    The Cancel Button

    It doesn't work. Here's the error message: … the field ‘COURSE NUMBER.COURSE_CODE’ cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field. I don't want he end user to have to enter bogus info. Here's my code on my cancel button...
  17. StacyStacy

    The Cancel Button

    How do I clear all transactions, even edit checks from all fields on a form when the "cancel" or "find" button is clicked? Thanks,
  18. StacyStacy

    Cancelling Out of Edit Checks

    Need Help Again ... I'm still having problems with this issue. The end user has changed their mind and wants to be able to keep the edit checks and be able to click onto the cancel button without putting bogus information into the first field or any field for that matter, which is a required...
  19. StacyStacy

    Viewing an Archived Table & Form

    Got a question: What is the best way to view an archived table and form within the existing db? I do not want the end-user to modify the table/form as well. Only view it. Thanks,
  20. StacyStacy

    Adding an AutoNumber

    Thanks Pat. I used a "Around the World" method which worked as well: I inserted a field entitled, "RecordID" and made the data type to "auto number". I then indexed the field, "Rec" to Yes(Duplicates OK). Next, I exported the table to an excel spreadsheet. In Excel, I filled in the RecordID...
Back
Top Bottom