Search results

I am running a Make Table query from a macro. How may I stop the Dialogue Box that questions whether or not to delete the target table before running the query? Thank you. wem3rd.

Can one combobox supply more than one field? A combobox supplies the data for one field in the form, and I would like to supply a second field with different data from the same record in the combobox. The combobox is linked to a small table of standards. One click would fill both fields in...

The column heading is a Date expression and I would like the resulting table to sort January, February etc. by using the expression below: MonthName(Format([dte],"mm")) Query sorting just by Format alone is OK, but alphabetical sorting happens once I use the MonthName function. Bummer...

I messed up my main table and need to update the values in one field back to the original copy. The backup is identical save original data in the messed up field. :(

I would like to have a listing in a report show two decimals only when that value has decimals to show (eg >.00), All other values would display with no zeros at all. For example, record #1 = 23.05, #2 = 22.11, #3 = 24, #5 = 23.58, #6 = 22 etc. Any help on how to write a rule for conditional...