Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Handford
  • Content: Threads
  • Order by date
  1. Handford

    Second axis on microsoft excel

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

    Trouble adding entries to a subform when new record

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

    Putting IF statement in query to blank restricted info

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

    Displaying number of records in textbox

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

    Enabling a button on record change

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

    Opening windows explorer from a form

    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")...
  7. Handford

    Cancel button in a form

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

    How do I ensure subforms appear only in one tab?

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

    Change form default from datasheet to form view

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

    Delete a record within a macro

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

    Make a column in the table made up of concat of two others

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

    Put results of query into a form based on a value in form

    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.

Part and Inventory Search

Back
Top