I have just obtained a database with 1.7million UK post codes along with there latitudes and longitude's.
I have a list of over 8000 post codes in an excel spreadsheet which I need to get the lat long's for
what would be the best way to this?
Thanks in advance for your help
Thanks DClarke for you reply one query
You say "Then run an append query using an unmatched query"
Is this done with one SQL statement or the unmatched query followed by an append query using the the resulting data
Could you give me an example how the SQL command would look
Kind Regards
Des
I need to write a program which check to see if certain dates in a table have changed basically monitor date changes on a daily basis.
The data is retrieve from another database. I plan to created to create a new table which will hold the dates and on a daily basis check these dates with the...
Below I have attached the table the SQL and the results can somebody explain to me why row id 244, 400, 441 have been returned.
EMPLOYEESTATISTICSTABLEEmployeeIDNoSalaryBenefitsPosition107500015000 Manager1056500015000 Manager1526000015000 Manager2156000012500 Manager2445000012000...
Re: Empty Table Error Trapping
Thanks bob for your reply
Can I ask if your solution would over come the problem of the code falling over if the table is already empty. Would it be able to handle this and allow the code to continue running
Regards
Des
The code below expects the user to input a valid project code which is in the PM000XXX format. What I am trying to do is allow the user to either enter the full project code or the last three digits as the first five digits are the same. I know you would need to test what has been input and if...
I am new to coding and have an issue that when the code below runs and finds the table empty it errors and falls over.
How could I amend the code to accept this condition and continue running the remaining code
Would it be best to test the presence of data in the table before calling the...
Current I update my tables form data on a SQL server. Rather than each time bringing back all the data is it possible for Access to update my tables with just the updates this will reduce the load on the network as it will just be bring back data updates deletes and new records.
Is this possible.
I have developed an applaication which has been sent out to users, how can I prevent the users from change anything basically locking forms code etc
Thanks in advance
Regard
I have a form which requires the user to input a reference. The input takes the form of PM000XXX the PM000 part never changes only the XXX. Can someone explain how I can allow the user to just input the relevant part (XXX) but when the query is performed it PM000 and XXX is concatenated...
Hi Brian
Thank you very much for you reply it worked fine. I am just trying to get my head round the TRUE part of the statement. could explain this to me or point me in the right direction.
Sorry to be a pain
Kind regards
Desmond