The
" Set con = Application.CurrentProject.Connection" is a result of the default startup settings. Just go under TOOLS to STARTUP and de-select the switchboard for now. I beleive that is a result of the conversion, so de-select it and try restarting the mdb. If it solved the problem, go back in and re-select it so you have you switchboard set up as 97 needs it.
It wont matter if I change the list to alphabetise it will it?
No, it wouldnt hurt a thing. This is a simple table to hold the names you need so you can have them for lookup. You only need to enter a name once into the table, and you should be able to enter it in the combo box on the data entry form (if its not there to select).
Regarding the model number, I could kick myself in the ass for not thinking of that. Being a network admin, I know that several different models may have the same info and drivers. I should have compensated for that in the begining, but like I said, I put it together really quick. To accomindate for multiple model number would only require a tbl to hold them. Three fields would suffice, ModID (Primary Key), ModelNum, and PKEY (foriegn key to the data tbl. Now to accomindate for multiple model numbers, we would also change the forms by removeing the the MODEL txt field and adding in a subform based off of the new tbl.
The filename field, can I change this so that a button can be used to browse for it, to finally display the filename without any path. In addition can that full path then be taken to provide data for another field that shows the location? or visa versa.
is this achievable & how?
This is something that I have done once in the past but cant accuratly recall it now. You could try searching the forum for this topic or try the VB section for assistance.
How can a "Chassis" field be added
This would be the same as the Manu and Type tbls. Just create a tbl and to store the information, then in the DATA tbl add a field for it and select the type LOOKUP. When prompted, select the new Chassis tbl and it will create the relationships for you. Add a combo box to each of the forms, and select the option that you want it to look up the values in a tbl. Select the new chassis tbl and you are under way. The form properties are what deligates data entry or not, so you dont have to worry bout the additional settings since they are inherient.
Macro one was my mistake, when going in to code a button I inadvertantly created it.