Search results

Thanks for all the advice guys, I really appreciate it! I am currently using the code I posted originally but I have left the combo boxes unbound. The purpose of displaying this information on the work order form is simply for a quick reference. This way when a user enteres a work order...

I tried the Key Press function but when in use, as soon as a single character is entered, the cursor reverts back to the beginning position in the field. I also attempted to code the fields in the reports. This yielded an error message saying I could not define this variable....or something...

Again, thanks for the posts. As for the Before_Update right...as posted that will not work with the dity parameter. Also, the input mask ">" doesn't work. Now, if I knew how many characters would be entered into each field, this method would work with something like >LLLLL (corey - would be...

Thanks for the adise guys, I really do appreciate the free help! I have it working right now using the following code: 'CustomerID After update - Populate related fields Private Sub CustomerID_AfterUpdate() CompanyID.Value = CustomerID.Column(1) FullName.Value = CustomerID.Column(2)...

This mdb stores and creates legal documents. Most of our clients are used to all caps in their documents. The goal here is to ensure the generated report is stored and printed with all caps. On second though, maybe I should just incorporate the ALL CAPS to the reports....?

Hello, I have the following code on my form "Customers Home". Anyone have an idea how I could do this without VBA? I'm entry level with access so nothing to overly complicated please. Thank you in advance!!! 'This section will convert values to ALL CAPS Private Sub Fname_LostFocus()...

Hello, I have a form (Work Orders Home) with a record source (tblWorkOrders). This form also contains a subform (Work Order Details) with a record source (tblWorkOrderDetails). On the top section of my form, the user selects the CustomerID from a combo box. I have various other fields...