Search results

  1. A

    File selector

    How do I get a file selector(the file browers that opens when you try to save or load files) to load when I click a button. This is to allow the user to select the location of the CSV file they what to load on ther sytem Thanks.
  2. A

    Make a graph from a query

    I am trying to construct a graph from a query which has two columns. One for the labels and the second for the frequency of that age range. The problem is that I can't get the labels to appear on the x axis of the graph. The code below is how I have constructed the graph: Private Sub...
  3. A

    Changing the colour if disabled text boxes

    I'm working on a project in access where the result of a query is returned into a text box. I want the users of this system to be able to view the value in the box but not to be able to change it. This can obviously be accomplished by changing the 'Enabled' property of the box to 'No', but this...
  4. A

    Using info from other forms

    What I want to do is that I have a form which has a list box which is populated through code with all the reports in the system. I then have a Graph button which when pressed would open up the report in a graphical view on a second form. I have got the idea to see which report is selected and...
  5. A

    Help saving record

    I am using the code Private Sub cmdNew_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("select * from Incident") rst.AddNew rst!IncidentID = txtId rst!IncidentDate = txtDate rst!ArrestMade = comArrest rst!CID170FormHandedIn = comCID170 rst!OffenderID =...
  6. A

    Tables fields from more than one table

    What I want to do from form view is to save a a record in my main table (Incident) which takes fields from three other tables. These are the key fields and are foreign keys in the Incident table. These other tables are also sub forms on my form and one of the key fields (Officer's Collar...
  7. A

    Query to make a report

    I have a table called Offender. It has columns OffenderID (Autonumber), Surname, Forename, DOB. What I want to do is to work out the age of each offender and group them into relative age groups: Less Than 21, 21 to 35, 36 to 50, 51 to 74 and 75 plus. These totals shall be then be converted...
  8. A

    Help completing a table record

    I am trying to complete a record to save in my table. My system is saved through form view. With a new button button been pressed which works through a macro to make a new record. The trouble is I have three subforms which control access to my other 3 tables (Officer, Offender and Victim)...
Back
Top Bottom