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

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

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

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

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.

I have been told that they is a way where you don't have to specify the table name for each field you enter into a query reducing the typing and making it easier to read. I have put the code below. how can this be reduced. SELECT DISTINCT RPT_CCC_PROJECTS_DIM.PROJECT_CODE AS [Clarity Ref]...

Allen Browne Truncation of Memo Fields article indicates if your expression is longer than 255 Characters Memo fields will be truncated. Will the SQL code below contravene this rule does it include table names SELECT DISTINCT RPT_CCC_PROJECTS_DIM.PROJECT_CODE AS [Clarity Ref]...

I have read an article by Allen Browne where it describes a workaround for a truncation issue of the Memo field where the DISTINT key word Workaround Open the query's Properties Sheet and set Unique Values to No. (Alternatively, remove the DISTINCT key word in SQL View.) You may need to...

Is it possible to format memo and text fields for instance right justify the text etc Thank you in advance

I have a query which I export the results to an Excel spreadsheet the problem is when view within Access the format in the column is DD/MM/YY but when you look at the exported report it is 23 May 09 what is more strange most of the columns in the report are in DD/MM/YY format so why is this...

I have sent a colleagee a copy of a Access database application I have which has 4 linked tables to an Oracle database. I told to him to place the TNSNAMES.DSN in the same location I have it on my PC. When a query is run it invites to to enter the user id and password once entered the...

I have an Access database which I have developed it has linked tables to an oracle database and therefore requires TNSNAMES.DSN file. A colleague who would like a copy of the database on his PC and would like to know how to install the Access database on his PC. To be honest I have no idea...

I have a VBA module which calls a Excel macro which formats the exported spreadsheet. Its currently working fine on my PC referring to the macro in my personal.xls spreadsheet. I now need to distribute the database out to other users and plan to create a add-in spreadsheet to distribute with...

I am using the above command in some VBA code and it is saving the spreadsheet in Excel 5.0/95 Format I am using defaults. I understand I can use FileFormat:= what value will give me Excel 2003 format Thanks in advance Line of Code below xlObj.activeworkbook.saveas "c:\documents...