Recent content by wem3rd

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.

Setting the control source property with =[SvcCombo].[Column](1) populates the form's field successfully, however the field no longer is related to its underlying table. I have not figured out how to make this happen. ???? wem3rd

Thank you Uncle Gizmo! I will review both videos with interest. How might I sign up for your YouTube? 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...

I see now that the Format function eliminates the need to use MonthName() at all, and correct sorting of date headings is achieved just by using Format([Date],"mmm") and the Column Headings property! Thank you wem3rd

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

Thank you once more - all went smoothly this time around! wem3rd

Thank you Doc_Man! I will be super careful with this, and will let you know if I succeeded. wem3rd

I am a bit gun shy after botching my update efforts. The table has 11 fields, one of which is incorrectly updated. Thank you for any tips that will help me restore the original values.

One Field with some 1800 records. Both table have identical primary keys.

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

I am running win 10 and have experienced problems when extending the desktop. After multiple "flashes" and messed up icon organization on the desktop, I had to restore windows from the system image for Win 10 just stopped operating at 100%. The restore worked and I have not extended the desktop...