Search results for query: *

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.

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

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.

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

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.

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" ,

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

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

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

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 =...

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

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

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.

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.

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.

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.

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

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