Transferring Data in Table to Form

[DrFoster01]

We are trying to organise existing contact data from various files and formats, mostly Excel and Access, into one Access Database.

We have now imported some further data from an Excel Spreadsheet and whilst the individuals associated with a Company now appear to be listed in the ' Customer Table ' we need the ' Customer Form ' to be populated with the relevant Company Names and Contacts (the Company Names appear to have copied across, but we also require the individuals).

I am hoping there is a link process to map fields from Table to Form although am struggling to find the answer(s).

Also, getting error messages ' you do not have exclusive access to the database at this time, design changes will not be saved '. We're trying to start up an Access database that everyone can use simultaneously (about 30 Users) instead of numerous different versions of Access and Excel files.

Would appreciate your help.

 

[KenReay]

Hi

Most simple way to populate form is to use bound forms

You cannot have 'n' people making design changes in same db at same time

You need to think about splitting the db into two mdb files (the front end contains forms, reports queries etc) and is located on each users PC, with links to the Backemd. The backend is located on a network share. The front end uses the linked tables technique to connect to the data in the back end.

Using this technique allows for 'offline' chanegs to the database, with testing etc in a seperate environment, before issueing to users, plus other benifits



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[DrFoster01]

Thanks Ken, managed to link some contacts to company name in the form from the table but there's an enter parameter value which keeps popping up prompting me to put in a customer id. On doing this when I put in say 1 the contacts for Superdrug appear but the prompt doesn't go away and I need all 1500 companies to have contacts lsited.

Thanks

 

[KenReay]

Hi

You probably have an error in your query (SQL), this is the most common reason for unexpected prompts for parameters popping up check for miss-spelled column names, or if you are in process of development, columns left in the query which you have deleted from table(s)

I take it you are in UK by the way, from the company names mentioned

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[DrFoster01]

Sorry, I'm not and Access expert and still struggling a bit, I'm in a copy database so hope I can't do any damage.

The contact names seem to be coming across but only one entry at a time if you type the Customer ID in the parameter value - is there something I can type in here to ask it to transfer all 1524 records ? Also the Company name sometimes disappears. I'm in Forms by the way, but everything I want is in the Customer Table in datasheet view.

 

[KenReay]

Hi

If you care to compact and zip the (copy) database and EMail it I will take a look, no promises kenneth.reayATtalk21.com, the AT is @ of course

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK