Recent content by Handford

Sorry, was a typo. I simply want to put the percentages on the RIGHT axis of the graph. Just a set of tick marks to show what the absolute figures on the left mean. Sorry about confusion! Chris

I have a graph with a plot of how the readership of a magasine changes with time. On the left hand axis is quoted number of readers. I would like to put on the left hand axis the percentage of population covered (i.e. number of readers/total pop *100). I am having difficulty doing this. Any...

I have made a database which assigns people to an event. There is a form called "Event" which has an entry for each event in the database (with autonumber primary key). Whithin this form there is a subform listing the people associated with this event. This subform is simply taken from the link...

I have a database of people and informaation about them (such as DOB). Each person is allowed to make thier information restricted so that it is not published in reports. I have go a Yes/No Feild called [Restricted Toggle] which records Yes if the information is to be restricted. What I would...

Sorry about this. I have tried both and neither seem to work. However when I put the =Me.RecordsetClone.RecordCount into the control source property it automatically adds brackets and becomes =[Me].[RecordsetClone].[RecordCount] on lost focus. Chris

Thanks, but I don't seem to be able to get hat to work. I put =[Me].[Recordset].[RecordCount] in the control source property of the text box but unfortunatly it did not recognise it. Am I using it right? Chris

I would like to display the number of records (like seen using the navigation buttons) in a text box on my form. Is this possible? Will it update when filters are added to the data? Thanks, Chris

Thanks that worked a treat...

Thanks I was being dense!

Looking through the possible events (onchange onopen etc.) I cannot find an event for when one changes from one record to another within same form. I would like some buttons and features to enable themselves based on particular information in a record. i.e. a button which leads me to a separate...

I have a database which lists events. Each event has a folder on the network drive associated with it. I was wanting to make it possible to have a button on the form which links the user to a windows explorer view of the required folder. I have put in a text field (called "Folder Address")...

I have a form I use to enter new data into a table. When it opens it goes to new record. I would like to add a button which allows the user to leave this form without saving the new addition (and not forcing user to enter required fields). What is easiest way of achieving this? I am very much...

I have written a form with the tab control to split it over a number of tabs. In one tab I wanted a subform, but not on the rest. However when I built it the subform appears on every tab. Is there a property or some other way of ensuring it only appears on one form? Thanks Handford

I have got a form (which I am using as a subform). It defaults into datasheet view when it is opened but I want it to default into form view (like my other forms). Is there an easy way of doing this. I cannot find anything obvious in properties. Thanks Handford

It opens up a table - then applies a filter leaving only the record I want to delete. it was then the idea to delete this record and close the table.