Search results

hello i would like some advice so i do this correctly. I have a access database with a customer table. And a excel spreadsheet wih customer details. I wish to transfer all the excel spreadsheet customers into the database - customer table. The format of the customer table in the database...

Hi there i no this is an access forum but i guess a lot of u guys r excel experts to. what i need to know is this... i havea spreadsheet with a list of postcodes e.g "DN14 4TH" and have been given the task of searching and extracting various postcodes. i Have to therefore find all the...

Hi im trying to run a search in a query. I have a list of business names and i want to search for all the businesses with "manufacturer" in there name, what do i put in the search criteria for the query? please help!!!! thanks

Hi can some one please help me? i have a query that uses parameters...e.g dates and also a combo box where a person on a form can choose the relevant sector. I have made a button on a form which when depressed should run the query, but its not working? im not sure how 2 link it to the query...

I have a table that keeps crashing. The only error message I get is "Invalid Argument". Each time, a single record will turn into "#Error". Each field says this in the row. When this happens, Access won't let me delete just that row, Any ideas how to delete them?

i have a problem. The access database we use has been working perfectly on a query which asks for a set of dates to be entered. We have recently added more records and since i tried to run the query i get a statement geting back saying "invalid arguement" why is this? Can someone please help

How do i group the following records ID Surname Pack 29679 Minican 1 29679 Minican 2 27818 Oliver 1 27818 Oliver 2 27818 Oliver 3 so its will show ... 27818 Oliver 29679 Minican ... on a spreadsheet

Hi I have 6123 records in a database. I need a report that prints the Customer ID and the Postcode I have managed to do this but it comes to 196 pages! Is there n e way i can format the report so instead of it being like this:- Customer ID Postcode 2334 LS89 8UJ 2333...

I have a database with 3000 + records all with customers from all over the UK. The CUSTOMER table contains >customer ID >name >address >postcode I have been asked to produce reports from the database. These reports should group all customers into postcodes regions and then display...

Hi i really need help! i need to be able to use "lookup", i have a set of postcodes from 3000 customers, i need to extract these and compare them to lists i have of postcodes, which make up a region. And run queries from these e.g a customer on my database has the postcode BD21 7KK On my...

I have a database with 3000 + records all with customers from all over the UK. The CUSTOMER table contains >customer ID >name >address >postcode I have been asked to produce reports from the database. These reports should group all customers into postcodes regions and then display...

Hi I was wondering if any one could help me. I have a database at work with 5500 records, how ever the first 1000 have been lost. There remains records for each customer but the first 1000 records showing what they ordered have disapeared. I have back ups of the database going back with the...

Hi If i wanted to run a query from customer records in my database and wanted a list of specific postcodes that matched the criteria how would i do this? For example each customer records has a postcode BD4 4KL, LS9 7YH ETC I want to categorise each postcode set to see for example all the...

Hi I would like some advice or opinions from people who have worked with access and mysql. Currently we run a large database in access which holds around 3500 records. It is actually running quite slow at the moment. What would you suggest to speed it up? ive heard running it on a sql server...

Could someone please help me? At work we have a website with a mysql database attached to it. It keeps data such as customer name address postcode contact id etc. Currently our main database is made in access. I need to transfer data from the website database (which is in mysql) to our...

Hi i have recently started a new job and require immediate help if possible! Im not an expert in using MS Access but know bits and bats. I have a list of emails which i can send to a excel spreadsheet but how do i go about automating the database so once it receives an email address with a...