Search results

where do type definitions belong? Hi there! I got your code and it works fine :) Thanks for that! The documentation on MSDN definitely isn't nearly as helpful :) However, I'm having a problem trying to put the code for the OPENFILENAME type definition in a place where a button on my form will...

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.

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

Excellent, thanks, I knew there was an easy way to do it :)

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

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

I am now getting the run-time error Method or Data Member not found. Relating to Me.OffenderID of the line: rst!OffenderID = Me.OffenderID There is no textbox called this on the frmOffender object. The OffenderID is hindden from the user.

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 =...

I'm new to Access so I would appricate it if you could tell me how to do this. Thanks

Thanks for the help. How do I actually do a query on the tables to produced the wanted Victim, Officer ad Offender. Can I use the CurrentRecord function to construct the table. Thanks for all the help.

I realised that I posted in the wrong section. I have read your reply and I wasn't clear to the situation I am trying to model. A Incident key fields are the Id and Date. THese are entered by the user from handed in forms. So they have to be typed. The relationship I am using is right...

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

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

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