Recent content by Davidp

Hi All, We are a small UK charity and have a MS Access 2007 database split with the backend on our ageing office network server and a front end on 5 users PC's. I have read it is possible to move the backend onto a cloud hosted Linux server, is this possible or will it slow down the use of the...

many thanks for the fast reply Mr Smin. The HistoryID field is not a Primary Key as it can have many records with the same HistoryID, (EG if a client calls several times). But the ClientID from which it is derived is indeed the Pk for the Clients table. It's a one to many relationship. Hope this...

I work for a UK charity giving out free advice to the public on energy efficiency and we have an Access 2007 database split into one backend and multiple user front ends. I’m not good at coding as I do it so infrequently so wonder if someone can help. The db has a form called “ClientFormNew”...

Thanks you for that but reducing the number of commas still gives me the 80020009 'cant assign a value to this object' error. So something else is wrong. Cheers, David

Have just got this to work on existting records but adding new records gives a run time error 80020009 'cant assign a value to this object.' with the debug showing an error in the lastt line. [Forms]![ClientFormNew].ClientUPRN = [Forms]![ClientFormAdd].UPRN now I'm confused

Hi All, I am working for a UK charity which has an Access 2007 database populated with over 1 million property addresses in a table called ‘residential’. Each address has a unique number (UPRN) and this is the primary key. I have a related table called ‘clients’ which fills up with information...

Thanks Paul for the fast reponse, that works a treat!

Hi All, I am currently working for a UK environmental charity. They have an Access 2007 database populated with 150,000 records of property addresses and details of energy efficiency measures. Each record has a unique 8 number code (UPRN) which is used as the primary key but this is not an...