Search results for query: *

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.

I am not au fait with the workings of VB and have been tasked with a very simple database - so I decided to try and use a couple of simple macros. It is mostly in place although the last thing I need to do is find some way of deleting a record in a table as part of macro. Is this possible? I...

I have a table with primary key defined as a person's first and last name- so it only allows one instance of each persons name in the table. I was wondering if it is possible to make a column which is always the concatanation of this first and last name - hence make this a singular primary key...

Ok yes, I have got a form called Booster_Main_Page with a combo box called Booster_Combo. I would like the results of this query to apear in the same farm. Here is SQL code: SELECT [Boosters].[Booster_ID], [People_List].[Ohter] FROM People_List INNER JOIN (Boosters INNER JOIN Booster_Att_LNK...

I am a bit of a novice and trying to produce database. I need to put the results of a query into a form. However the query itself depends on a value selected in a combo box in the same form.