Search results

The members of this forum (99%) and I (1%) have created a query to look through a table selecting the number of times a particular volunteer has manned the Visitor Centre in a predefined period. Because of the way in which names are entered into the database I have had to search for (say) a...

I have a table containing the following fields: Automatic ID RealDate Morning Afternoon I use the name “RealDate” as I originally had other forms of storing the date – now dispensed with. It is just a date. “Morning” and “Afternoon” contain 1 to three names which may be of the form “Joe...

I have an Acer Aspire 5742 laptop running Windows 7 and Office 2010 I have just started using and I have reached the stage where I have started using sql to create and modify queries. When I go to the sql window the text is unbelievably small and almost impossible to read. I tried using the...

I have a table in a database that contains the following columns: 1. ID (automatically generated) 2. Month/Year (contains month and year such as "Aug 2011") 3. Day (such as "Sunday") 4. Date (such as "28") 5. RealDate (such as "Sun 28 Aug 2012") The first three columns were created by...

I am very new to access and I am still finding my way around the basics. I have a database that has the automatically generated record number in field 1 and a date in field 2. I would like to generate the value for the date stored in field 2 using the record number stored in field 1. Is this...

I have been using Access 2003, then 2007 and now 2010 for some time but only at a very basic level. I volunteer for a registered charity and I use the database to keep a record of all the volunteers at our nature reserve and to keep an ongoing record of all volunteering in the past, the...

I have read many times that one should not fix a calculated value but to me it is essential that the value is fixed. My problem is twofold. 1. I am a complete ignoramus when it comes to everything access and I have no idea how best to construct a database. 2. My own database is very simple...

I wish to create a a list of dates in a database. I have a database which, amongst other things, holds the list of people who have volunteered to man the Visitor Centre at my local Nature Reserve. This section of the database is effectively just a calendar. The first column holds the ID which...

I am using Access 2003 but I will soon be going onto 2007. Though I am very experienced with Word and Excel I know very little about Access. I have setup up database to record, amongst other things, the days people volunteer to man the Visitor Centre at my local nature reserve. When in the...

Sorry - senior moment - wrong forum - please remove post.

I am using Windows Vista and Access 2003. I have recently been given help via this forum and I was directed to the "Microsoft Tip for Serious Users" (I'm serious but useless it seems!) called "Return to the same record next time form is opened" provided by Allen Browne I am very new to this...

I have a table which is basically a calendar containing the columns (i) date, (ii) special info relating to that date (iii) morning volunteers and (iv) afternoon volunteers. In the "Morning Volunteers" there are up to two names with sometimes a first name, sometimes an initial but always a...

I have a form containing records of volunteers including some that are currently not active. For each volunteer there is a record which contains "Letter", "Email", "Tel", "Mobile or "Not Active" I would like to change the colour of the font, for the whole record if possible, for those that...

I have a database table which is basically a calendar containing 4 columns (i) the date, (ii) special info about that date, (iii) morning volunteers and (iv) afternoon volunteers. When I go to this table the cursor is positioned at the very first date and i then have to scroll though record...

I have written my very first database in Access 2003 but it tells me that it has been saved in Access 2000 Format. My questions are: 1. Why has it done this? 2. Can I change it 2002 or 2003 format?

I am totally new to Access and this is my first database. I have a database for volunteers in which table A is basically a calendar and table B a list of volunteers with their details. What I want to do is construct a report that will allow me to produce a mail merge letter such that: 1. One...

I am totally new to Access and this is my first database. I have a database for volunteers in which one table is basically a calendar. In this table I have fields for the month, day of the week (i.e Monday) and day of the month (i.e 21st). There is also a filed called "Special days" Sometimes...

I am very experienced in Word and Excel but completely new to Access. I have constructed an Access database containing a list of volunteers and the times at which they have volunteered. The Reports I have written are very basic but function as intended...