Search results

Hi There, I am trying to copy a table and put the copy in a folder called "My Data Sources". The reason being when I set up a mail merge letter it defaults to "My Data Sorces" for the recipient data. I also need the second table to be updated every time we enter data in the original table.Has...

Hi There, I have built a fairly basic DB to record incoming sales enquiries to our business. When we contact some of those enquiries later we are often asked to call back in 2 months time or 3 months time etc. There is a form within the DB were we can enter the outcome of conversations with the...

Hi There, How can I get my reports to display dates in ascending order i.e. 01.01.2007 to 31.01.2007. Best Regards Keith:(

Hi There, Can anyone tell me a way of protecting the data stored within a table, so that users cannot inadvertently change or delete data from it??? Best Regards Keith:(

Hi There, I am having difficulty inserting our company logo into a report. The problem occurs when I try to size the logo, in design view, when it's in the report using the grab boxes around the edge of the image. The image does not shrink instead the box shrinks but obscurs the logo. Has...

Hi Richard, What I want to do is run a search for the correct enquiry, then enter data into the "Comments" field but protect all the other fields from damage. I can enter the data via a form but how do I link the query that finds the correct entry to the form for editing the comments. I hope...

Hi There, We have a fairly basic contact db at work which we use for incoming enquiries. Users need to be able to make ammendments to one particular field "Comments" after they have spoke to or received a call from someone. What I want to do is protect all the other fields in the table so a...

Hi Michael, Thank you for your help on this it has been most welcome Keith B

Hi Keith, Many thanks for this advice it's working well Keith B

Hi There, I am an Access novice and have managed to create a DB to record all incoming enquiries to my business. The enquiries are entered via a form onto a table and one of the fields is the date of the enquiry, which is entered as 01-Jan-07. What I want to do is build a query that will find...

:( Hi Guys, I have a very basic DB of customers names and addresses. What I want to do is find all the enquiries within the months of August, September and October, send all these enquiries to a new table so that I can use this new table for a mailshot. The date of the incoming enquiry is in a...

Hi Mick, Many thanks for your reply. Forgive my inexperience but what is my starting point to open the toolbox? Keith

Hi , I have developed a very basic contact DB to record enquiries coming into my business. The last field on the DB is for comments, so that anyone entering the DB can see the latest conversation we have had with a particular customer. What I want to do is create a means whereby I can find a...

Hi Gemma, I'm not sure my reply got through last time. Can I open the table up via the switchboard. I can open the table manually but I will then have to trawl through overr 800 records to find the one I want to delete, unless you know of a quicker method??? Best Regards Keith

Is it possible to open the table via the switchboard? If so how do I do that? Best Regards Keith

Hi All, I have a very simple name and address DB. What I would like to know is "What is the easiest way of finding a record using the switchboard and then deleting that record from the DB?" I am an Access novice so nice easy replies would be appreciated. Many Thanks Keith:o

Hi Statsman, Many thanks for your superb help on this it's working like a charm. All the best from an Access amateur in the UK. Best regards Keith

Hi, I have built a very simple database to record names and contact details for all enquiries coming into our business. What I want to do is create a means whereby anyone in the company can enter a name of a specific town or county and the DB will produce a list of all enquiries that have...

Hi There, I have built a very basic DB and am running it alongside our existing Excel system of recording customer data. I have transferred a lot of data from the Excel spreadsheet to the DB Table using Cut & Paste. For all future incoming data is there any way I can just enter it onto the...

Hi Rak, This worked as well. You're a star! Best regards Keith