Recent content by main-man

ok il try that

Can someone please help me?

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

ok thanks mate...u always come to my rescue. cheers

but what if i want dn7, dn9, dn21? how do i write it inthe autofilter box? as it wont allow me to put dn7*, dn39*

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

thanks a great deal !

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

cheers il try this

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

Hey its worked out now thanks a lot neileg! your a pure genius!

Thanks I have changed the columns to 2 "down then across" but when in print preview it still displays it as one long column?