Recent content by Dwaynair

Bellow is the code I use to open one of a possible 20 Forms based on the selected record in the current form. But there has to be a better way so that I do not have to code every new form I will create. Function ModifyOpen() ' 'This will Open selected record and Modify if its from the open...

I would like all my Print Command buttons to use the default driver, which is already set up on all the reports Page setup. So when someone clicks on PRINT it goes to the associated report and uses the print driver (in the page setup for that report). Now when I click the FAX command button I...

The way i did it was to create a data table called parts and include a "key" Id and what ever else you may need. Then creat a combo box or list box which calls to the parts table. Click on the properties, then data under Control Source = should reference to the field you want to store the info...

I would like to Duplicate a selected record using a form with a command button. I can select the record with no problem but the Duplicate button kicks back an error "Some of the field names for the data you tried to paste doesn't match field names on the form" The record in the form is a join...

Does anyone know of a way in Office 97 to fax via tele line not the internet. Is there an add-on or what software might be best? Great Forum Thanks

Trying to Copy a record from a form that is based on two tables. I need to copy everything to the new record except the auto (key) number. My Entry table which issues an auto number[id] and the other table stores this number in [id_numb] as an intreger. What is the best way to do this? Follow...