Search results

I want to append records that I have created in Table1, via a form (Form1), to Table2, using Form1's OnClose event. (Table2 will be amended later, but I need to preserve Table1). Is there a way to append only the records from Table1 that haven't been previously appended to Table2? Also, can I...

I have 2 forms which are based on separate tables. When I open Form2 from a command button on Form1, I would like the common boxes on the Form2 (name, ID #, ets.) to automatically copy the info from the boxes on Form1 with the same names. How can I do this? TIA

I would like to format all text boxes on a form. If there is an entry, I would like the backcolor to be white, else if not, red. Can I do that in the form code level, or would I have to do it for each text box separately?

I have one table (call it tblMax) which holds a number designating a maximum amount for items. I have a second table (call it tblItem) which holds the items current inventory, along with several other values about the item. Is there a way to reference fields from both of these tables on one...

I have a form with numerous fields and would like to be able to move the focus to a selected field by typing the field name into a control box. How can I do this? TIA

I have a database that keeps track of all my different tools. I made a query to search the TOOL TYPE field. This query brings up an input box to ask what to search for. In a normal search you can use wildcards (*, ?, &) and search for part of a field. However, the input box will search only...