Search results

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

Re November 31st - just testing to see if those of you at the back are still awake!!! A record inn the database will have the following columns (plus many more) 1. ID (Record ID and day number - to be used to calculate the date shown in the report. 3. Special info (i.e Christmas Day, Fun...

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

My first post was made in error. I talked about a form when I meant report so I deleted the post in the Form section and basically asked the same question here. It's unfortunate that your reply came so quickly that I could not make the cancellation request before it arrived. Many thanks for...

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 tried entering the data from the MS help Sheet and eventually I was able to save without any error being thrown up. The database now works correctly in all respects other than the one below. When I try to view the modified Form in Design View Access crashes so i cannot find any way to view...

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

Hi pbaldy. You are quite correct. In my hast I only saw the "not Active" part of the condition. Now i have looked a little more closely I can see the full condition [contact] = "not active". Thanks to both of you for your help and patience.

I have got the conditional formatting to do a good part of what I want it to do - hopefully I can get it fully working with a little more help. I have a form with details of volunteers including name, address, tel, email, status etc. I have set conditional formatting to turn the background of...

Many thanks. However it seems rather complex to me but I will persevere and give it a try.

Many thanks for the help you have given me. It so easy once you know how. I am amazed by two things - how little I know and how easy it is to get expert help on the better forums.

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

Thanks for the help. I have looked at the link given by Matrix_zero and its very good but it cannot be used in this case as the database will be used by several people all using computers with only MS Office Software. Best wishes to you all for the New Year.

Thanks to you both. I will, as suggested, leave well alone, especially as the database will be used by a small group of people. As you can see I am the perfect newbie, totally ignorant. As my head master used to say centuries ago - "Much room for improvement". Best wishes to you all for the...

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