Search results

My Dilemma The main reason I am approaching it this way, is I am printing the totals onto a pre-printed form (which I wish I could change, but which would require much bureaucratic effort!) I'm basically forced to use this accounting method, as the form is an official record. I must print an...

No duplicate tables They are not duplicate tables. The first is an initial inventory. The second one will build off the first, change info from the first, and add info to other fields. I must preserve the first so that I can print it at a later date for auditing, if need be, and, so that...

Shorter Way? Thanks. I see what you mean with the "Appended" field. My table has several dozen fields which need to be appended. Is their a shorter way to append using this method, without having to type in all the fields? Can I set the warnings to false, initiate the append query, then set...

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

Tab Control Confusion Sorry for my late reply. I still don't understand what you're saying. If I use the tab control, won't I have to have a common source for both pages (e.g., tblMyTable) in order to make a parent/child link between the common field (MyID) for both forms/tables? I need to...

Actually, the only reason they are 2 different forms is that I have too many fields for just one (well over 300). The original hard copy form was double-sided. All of the information is related via the ID #.

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

D'oh! Thanks! :o

Thanks. Can you tell me the name and what sort of code would be entered if my table's name is tblInventory?

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

Thanks Wayne!

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