I have purchased the royalmail PAF file. It came on disc and is basicaly a text file (CSV)
From this i created a database and linked to the text file as a table. then i created 2 forms:
1st form is were you enter the postcode and then when you press the command button it uses a simple query i created to filter the linked table and then it displays the found address in the 2nd form.
It all work perfect except for a big problem "SPEED" as the CSV file has 1.7 million postcodes and 13 columns it takes a good 3 min to search the table.
What can i do to make it as quick as i see other peoples postcode programs work?
have i done this right in using a query to search the tables? or should i use VBA. my database is a basic access MDB type. I have also tried importing the data instead of linking but this doesnt make any difference.
I have thought about can you index a table, if so how? also maybe spliting the tabel into many tables but then how would i get the query to search many tables?
Any help would be great
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Overview: This article:
(a) explains one principle method to cross-reference invoice items in Quickbooks®
(b) explores the reasons one might need to cross-reference invoice items
(c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…