Search results for query: *

The combo box has been working correctly for about 2 years. Now the scroll bar works and you can select an item but cannot see the list of items. When you select an item, it appears in the Combo box. The Combo box is based on a table. I created a new combo box based on a query from the table...

This is an inspection record form. I use three combo boxes to get the model, vehicle number and part number for the inspection. The vehicle number is where the problem is occurring. When the form opens a model number is selected in Program combo box. The code listed below is in the On Change...

One table in my database has information I down load from a mainframe database on manufacturing information. A field named “Part Number” has part numbers but also contains codes for the manufacturer and other junk. There is no fixed length or layout for this information. My user has a list of...

My users produce three different serialized numbered reports and email them. Variables are passed down to the sub procedure listed below which exports the report based on the format they select and attaches the report to the email. The varible 'docname' is the report to open and the 'RefCtl' is...

I am revising a form to me a customers needs. They want to select more than one defect and write a descriptions with the code. To do this I set up a sub form on a tab control. Many of the fields including the defect codes change based on the contractor involved. So when the select a contractor...

I use the code listed below to enable\disable a subform based on a selection in a combo box. The changing colors, locking and Enable = False work fine in the Else part. Every thing works in the If part except the 'Enabled = True'. The form is not enabled so data can be entered into fields. The...

I have a form with and subform on a tab page. I am using AcformEdit in the code to open the form. I can change the data on the main form but cannot change data on the subform. The forms are properly linked and on a field named "Audid Id". The correct data appears on the subform. Both forms are...

I have been developing a database since January. Making changes while poeple are recording data. Last week we starting getting this error message when a form is opened or when I try to run the query by it's self: "The field is too small to accept the amount of data you attempted to add. Try...

The code below worked fine on a TAB form for a record with 16 characteristics. They changed the number of charactersitices to 50 so I wanted to use a subform so the other TAB formating would not be affected. The problem is with the statement "Me(MCharF).Value = MCCF" which sets the value of...