Search results

Ta Paul, it worked a treat

Hi, I am writing a very very simple query to identify postal codes from a list of addresses. The table containing the data has a field called POSTAL_CODE. I need to exclude the last three digits of this postal code so as to only show the first 2,3,4 digits. Example would be simple by...

Hi, I am writing a very very simple query to identify postal codes from a list of addresses. The table containing the data has a field called POSTAL_CODE. I need to exclude the last three digits of this postal code so as to only show the first 2,3,4 digits. Example would be simple by...

Hi, I am running an autocompact module in Access97 which will created a 'compacted version' of my database. I then want to rename this compacted version to the name of the original database I compacted. I cannot however find a way of doing this in code. Basically the idea is to compact every...

Hi, I have created two databases to try and speed up some data manipulation. One database is acting a a 'sniffer' and runs make table, delete, append and normal view queries. the append and make table queries will either write to the other database (the receiving database) or to itself. I have...

Hi, I have created a database with approx ten tables with many queries (make table and append and delete queries). I need to compact this database as I would normally do (usually deal with databases of 500MB and more with no issue) however after over an hour I still get the message 'not...

Hi, I am trying to create a database from scratch, however I need multiple users to have access to it. I do this nearly everyday and have no issues on the LAN we use. This week I have been struggling to create a database on a different LAN. I create the database however I get the message that...

Hi, (Please forgive any stupidity in the next few lines, I am a novice and new to this forum) I am a self taught Acces user so have no knowledge of technical jargon. My problem is I am trying to run a report with numerical data. I want the numerical data to appear as a different colour...