Recent content by GeoffT

Hi I am hoping that through the convolutions of the site this will get to a moderator. I have a simple enquiry about adding a page to a form but am reluctant to start a new thread as I feel it must have been answered in the past. However, when I go to FAQ's and search "new page" or even "page"...

Have copied one of my databases, re-named it and deleted all records. I want it for another purpose but in terms of fields, design and reports it is just what I need. However - I have an auto field - record number - this obviously remains at the number of the last record in the (deleted)...

I am designing a report and somehow in the process a short horizontal line has appeared - a line which I did not insert. The line appears on the print preview and also on the hard copy printout. I want to get rid of this line but[B] it does not appear in the design view and so I can't delete...

I have a short horizontal line which has appeared on a report which I am designing. I have not put this line into the report design, and I want to remove it. The line appears on the report print preview and also on the printed version. However, the line does not appear in the report design...

For dbDamo And Galaxiom Many thanks for your replies. I have to be off-line for a few days now but will be doing a bit of reading whilst away. dbDamo I'm a bit lost as to whre I should be looking for relationships Front End / Back End . I'm using Access 2007 and can find only one route to...

Yes Understood and problem solved. Many thanks for the time taken to read problem and send replies. Very much appreciated. Regards to all. GeoffT

I have been asked to make some changes to an existing database. This database has worked well for five years. Within the central form (containing records with people details) there are four existing sub forms, the tables under which each contain only an ID field and a date field. I am going...

Sorry, ladies and gents - I am new to the forum and blundering about a bit. I can't see any way of marking my own threads after they have been fully answered. At the same time I would like to say thanks to those who have helped me. Regards to all. GeoffT

Have problem with operators entering dates as I cannot put input masks into the dialog boxes when they ask for a date. So I decided to have a Table [DateFromTo] with two fields (Obviosly DateFrom and DateTo). All OK, but wandering fingers always find an error in this sort of thing and as I...

I want to make a note of changes I have made to a database, to be kept in the database for the benefit of any future programmer(s). I thought the best way was to set up a table with one field - a text [I]memo[I] field, and an overlying form. Obviously no problem there and happily recorded...

I'm almost certain you can use the DCount function. If I understand correctly what you are asking is the overall number of errors irrespective of batch number. Got me at a time when I must go off line, but will look later and suggest a syntax, but you may like to look at my posting under general...

I have a table [DateToFrom], with three fields [ID],[DateFrom] and [DateTo]. I have a table [Teas] with two fields [ID] and [Date]. I wanted to count the number of records in the table [Teas] between two dates, and show the result on a report. I created a report [TeasReport] with it's source...

I have a report which provides annual statistics. The report source is a query which, amongst all, contains a "year" field and a "boat" field. The Year field is a choice field with values 01;02;03 etc. The Boat field is a choice field with values AWB;ILB;XP . I have been specifiying the year...

Counting Records Moderator , please say if this is thread continued or should be a separate posting. I'm new to this forum (and to Access as well). I'm using Access 2000 Similar problem. I can get the Count(*) function to work well. However, my problem is that I want to count the number of...