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!

Register Log in
  • Congratulations derfloh 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. sstime

    Validate Access Continous Form Fields

    To "TheAceMan1" - I appreciate all your help, unfortunately I still don't have it working yet and I'm leaving on Vacation for two weeks. I will check again when I get back. Thanks again.
  2. sstime

    Validate Access Continous Form Fields

    To TheAceMan1, per your post coding at 13:06 I have placed the exact coding into the forms "BeforeUpdate". Went to the forms view and entered data into all fields and when I reach the end of the record, I still get the Run Time Error 438, Object doesn't support the property or method. This is...
  3. sstime

    Validate Access Continous Form Fields

    Out of the 27 fields, I didn't put an entry into "ArrTm" and "OBMiles", which were two of the mandatory fields out of the nine. I have a message placed into each of the tag controls for those fields.
  4. sstime

    Validate Access Continous Form Fields

    Sorry, I didn't skip controls, but entering data into fields for validation during data input. I have placed the error messages (in Design Mode) into the field controls in the Tag area, just on the fields that I wanted validated with error messages. Then went into forms view to display...
  5. sstime

    Validate Access Continous Form Fields

    Ooops, I guess I should have told you what the error was. It stated, "Run Time Error 438" Object doesn't Support the property or method.
  6. sstime

    Validate Access Continous Form Fields

    You are right TheAceMan1, I should have not made any changes. I copied your exact coding into the Forms BeforeUpdate. Then I opened the form to do a data input test and came up with an error, I clicked on debug and it had this line highlighted "If Trim(ctl & "") = "" Or ctl <= CheckCode Then" ,
  7. sstime

    Validate Access Continous Form Fields

    I didn't skip over any controls, just wanted validation on nine fields within the record, not all 27 fields. When I went to test the coding, I type data in all fields except for two, and I expected warning messages on data was required. The coding that I entered in the form "BeforeUpdate" is...
  8. sstime

    Validate Access Continous Form Fields

    Hi AceMan1, I made the changes (modified a little), placed the messages in the control tag on certain mandatory fields and placed the following code into the forms BeforeUpdate, tested and didn't get any error messages when a tabbed over two of the mandatory fields. As you can tell, I'm not...
  9. sstime

    Validate Access Continous Form Fields

    Hi AceMan1 Thanks for the response. I changed my coding using the BeforeUpdate on the required fields and removed the forms control coding. When I tested it by tabing or pressing enter past a required field, nothing happened. Am I missing something? Here's a sample of what I entered. Private...
  10. sstime

    Validate Access Continous Form Fields

    I have tried several different versions of the below coding. I also tried it by removing the "Exit Sub" after each group (naturally didn't work either. Coding segment: Private Sub Form_BeforeUpdate(Cancel As Integer) Const CheckCode = 0 Const CheckAlphCode = "A" Const CheckMiles =...
  11. sstime

    Validate Access Continous Form Fields

    I hope someone can help me with problem, I'm getting a little frustrated. I have developed for a customer, a continuous form where they can view their input records and then add new records at the end of the list. The data entry value is set to "No". There are 27 fields within the record and...
  12. sstime

    Access 2007 with MS Vista

    I have written a database systme in Access 2003 for a client, which is working well. When I try to copy it over to another computer that has MS Vista and Access 2007, I receive various security errors and will not run my macros. I enabled macro processing by changing that security (which was...
  13. sstime

    Updating a designed Access Database

    Thank you for all your suggestions, I now have some direction to proceed with. I learned alot with all this help. Thank you again, very much appreciated.
  14. sstime

    Updating a designed Access Database

    Humm.. I guess I don't understand the consept of splitling the front and back ends of the database. Could you elabriate a little more. It sounds like a concept that would solve my problem.
  15. sstime

    Updating a designed Access Database

    I'll look into the transferDatabase command. Thanks for you help, I was looking for a direction to take to resolve this issue. Thanks again.
  16. sstime

    Updating a designed Access Database

    I created a replica as you mentioned, but I don't see how this would solve my problem. Nothing in the repilca runs, macros halt, etc. and they do work in the master.
  17. sstime

    Updating a designed Access Database

    I have been replacing the complete database by transfering it with PCAnywhere to a vendor in Texas. He then copies it to the clients P.C. location. At present, there is only one database, but possibly in the future, there will be multiple locations. I'm not sure, but I think the vendor in...
  18. sstime

    Updating a designed Access Database

    I created a database for a customer and have been making changes, downloading and replacing the complete database. I am looking for some suggestions on how to update the database after it goes into production, since I do not want to replace their tables of employees, inventory, scheduling, etc...

Part and Inventory Search

Back
Top