Search results

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

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