Recent content by ems2000

This turns the ribbon and menu bar off DoCmd.ShowToolbar "Ribbon", acToolbarNo This turns it back on DoCmd.ShowToolbar "Ribbon", acToolbarYes

You can also change the value to text. if me.checkbox=0 then me.ctrl ="House" end if if me.checkbox=-1 then me.crtl = Garage endif

Thanks again. I have one equipment table, all relevant to that. 1 Employee table 1 Parts table and 1 table for storing all the records, which all fields within the record are generally populated. The other table is used to collect various details from the forms. In fact the form uses combo...

Thanks for the feedback. The database only has four tables and this one is the master table and these are independent fields. They accumlate over time. I am presently using an append and update query and thought there was an easier method to duplicate the record with some changes using a...

Hi, I have a problem write records from a form that was obtained using a query from a table 1, and want the form to save the record, then create a new record entry to the same table 1, with a couple of fields changed. Table 1 (Actually named Work Order Table) Equipment Name -Boat Sub...

Hi Paul, Thanks for the info, however, you are talking about utility's beyond my level of expertise. Can you please tell guide me to an area where I can learn a little more about the MDB utility and schedule task manager as that would appear to resolve the concern. Thanks, Gord

Hi, I have a WO table with a field last completed and a Fq field. I want to be able to automatically add an entry in the primary table WO, when the last completed date plus Fq, is achieved. IE Last completed date of 7/7/09 and a Fq of 10 would add a table entry on 7/17/09. I have tried many...