Search results

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...

Sorry do not know what happened Have attached tables Thanks in advance

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.

Hi, Is there some way where you can indicate to the user that code is being processed i.e an Hour glass or status bar. Thank you in advance

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...

thanks That was very informative Regards Desmond

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

Brain the links seems to be invalid

This is the code which used CDATE it worked but return no rows SELECT [TEST Table].[Project code] AS [Project Code], [TEST Table].[Bu Unique Reference] AS [CPN Ref], [TEST Table].[Bu Priority] AS [BU Priority], [TEST Table].[Project title] AS [Project Title], [TEST Table].DESCRIPTION AS...

Thank MSAccessRockie I have tried the statement you suggested but it still returns nothing. I did try with CDATE but just errored with data mismatch Code attached SELECT [TEST Table].[Project code] AS [Project Code], [TEST Table].[Bu Unique Reference] AS [CPN Ref], [TEST Table].[Bu...

I have a query (SQL below) where the user is requested to enter a date and when he does it returns the records as expected. I have a problem when the user does not enter a date, no records are returned. where I would like all records returned. I have tried "OR IS NULL" and it still returns no...

Perfect Thanks Brain

Is it possible to add blank columns into a query? I wish to add some blank named columns into a query so that when exported the spreadsheet can be used to collect data to be feed back into the database.