Search results

I have a table which contains a list of names and the trades that each one is qualified for and a second table for a project which requires a number of different trades to fill specific roles. How do I set up a proper relationship between the two tables. Tbl_employee. empl_ID| Empl_Name |...

I have several forms that can be called from more than one other form, but I need to build my forms so that the user is returned to the form from which they started. I have looked in the help files and FAQ and I can't find what I am looking for. Please, can someone direct met to the required...

Run Time error updating record -- Help ! Please... I have an orders Form with a subform for products. In the subform the user selects each product by first selecting the product category from a combo box, which filters the query for the second combo where they selects the product. Once this is...

I have a subform with two combo boxes. These boxes select product catagory and products. The main form sets the supplier from which to select products. If the user can not find the product they require they can double click thje product combo, which opens the product input form I need the...

I have an 'add new order' form which opens with all the fields blank and focus set to a combo box. The first thing the user must do is select a contract name or number from an unbound combo box. I then want the form to update and show all the relevant information in the form fields. In the row...

I have a combo where the list is populated with a bit of VB code to create a two field list. When the user selects the item they want from the list it displays the item in the combo box and should populate a text box in the same row with the value from the second column. This combo is part of...

I have a combobox selection ('product description') in my orders form which when updated must populate the product_id field. The combo box displays both fields, but once the user selects the item then the value of the combo is set to the product description and the product ID field should...

I have and order entry/lookup form with a subform to view the line items on the order. Once an order has been saved and status is ‘placed’ I want the records for that order to be locked. I would also like to display a message box with a yes/no answer to confirm that they want to issue the...