Search results

Thanks. That works fine.

Is it possible to have a count of field in a text box on a Form. I am trying without success and keep getting "#Name?" in the text box. I am using the =[CountOfFieldName] as the Control Source and the text box is in the Form Footer. The Field (Type is Number)is not used on the Form but is in...

I have a primary key field "BirdID". Also a Field "RingNo" and a Field "Year". With this set up this way you can keep entering the same ring number and year as many times as you like and each time you do this the autonumber creates a new BirdID. What I want to achieve is to only be able to enter...

I am working on an application related to Bird Breeding records. Each year an exhibitor must purchase rings which are fitted to each bird for identification. I cannot set the RingNo field in the Table to indexed and no duplicates because there is a possibility (very slim) that one could over be...

Have attached File. Queries show each "Section" where I have sorted Novice Exhibitors. I want now to sort the "Sections" to include only those which contain 3 or more exhibitors. From that point I wish to select the Best Novice. Thanks for any help.

can anyone please explain how I send an attachment

Tried to attach an image (in Word) of relationship but it did not appear on Post.

Tell me how to attach a file size 1350kb this is with all the unnecessary data removed. It is a little awkward to explain relationships and name all the fields. There are 5 Tables and from 4 to 11 fields in these tables

I have been working for some time on an application relating to showing birds. I have a table called Sections where there are eight species of birds from which I am trying to sort out the Novice winners from these groups of birds. There must be 3 or more exhibitors in each Species grouping...

I wanted to attach a file but even after eliminating unnecessary data it is still to large (1350kb). I am trying to sort records from 8 different Sections. I have done that all right with a query on each section. What I want to do next is to select from those 8 sections just the sections which...

Thanks Brian. Will try that

I have a query where I have sorted some data but need to eliminate some more. I have more than two fields but it is only two which I am concerned with. The first is Class and the second is EntryNum. I have a Form that each time a Class is typed in I am able to have the EntryNum increase by 1...

Sorry to have taken so long to get back. Have sorted problem

Thanks for reply. Am using Access 2007. I am doing what you have said. The difficulty is when I press the command for the Print Preview I cannot see the page to click on it. It is always hidden right at the back of Open forms. I have to move the forms to get at the screen to be able to click on...

I want to print two reports using a command buttons on the same Form. The data on one is info regarding entries to a Bird Show the second is to print labels with similar data. At present I can Print the reports okay but to do so I need to remove the paper and replace this with the label page...

I have used in Events Me.InsideHeight = (You need to use a number that suits, I use 10500) then under Other set PopUp to No. This works fine for me.

Sorted problem. Needed to add another group to sort out SectionId from the SectionHeading. Thanks for help

Thanks. Will check on my setup of the Design of my form. Suspect the problem may be there.

Thanks for reply. That has not worked for me. #1. I never thought it would have a bearing but did not mention in first post that in this case the page is set for columns. They are set to go across and down. When I insert the code it is forcing the content of report to simply go down the page in...

I have a page where I have invoked a Force New Page on a Section Header I have set up. When the numbers of the pages appears they are number 1 to 26 through each Section(the whole document) where I would like the page numbers to begin at 1 again for each section. Is this possible and if so can...