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 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 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 , 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 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, 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, I have created a switchboard for a very basic DB and the first button is "ADD A NEW ENTRY" When I click on this a form comes up but it bears the data from the first record. How can I edit it so that a blank form comes up ready to receive data? Best regards Keith:(

Can anyone advise me on the following please. I have built a very straightforward contact name and address DB to record all enquiries coming in to my business. I don't want to enter any duplicates and I thought the best field to allow no duplications on was Address 1. Unfortunately this didn't...

Hi, Can you help me? I am very new to using MS Acess and have just built a very basic DB to store enquiries coming in to Head Office from potential franchisees. Within this DB I have included a "Yes/No" box with a Title of Live Franchisee. When an enquiry becomes a franchisee I tick the box as...