Search results

I thinks it Looks like you will have to dip you toe into programming! You need to create a button and on the click event set the states for the check boxes to true. For example Sub button1_click() me.checkbox1 = true me.checkbox2 = true .... end sub If the check boxes are on the subform then...

Hi All. I have a query that I have created dynamically using VBA The VBA being: strSQL = "TRANSFORM nz(Sum([Duration]),0) AS SumOfDuration " & _ "SELECT " & strGroup & " AS F " & _ "FROM (SELECT tblDowntime.Reference, tblDowntime.Stopped, tblDowntime.DowntimeStartDate...

Can you sum the fields in the parameter query? Why do you need to create a crosstab? If you post the sql for your query, or be a bit more specific then you are more likely to get an answer. HTH T

Try http://support.microsoft.com/kb/186855 This has a access 97 graph with vba attached Other than that, it is hard to find data & a good object model. :banghead: :) I did try Microsoft Web Components but this had its own set of problems. Good luck and if you find something please...

Have you tried to specify all the colors in VBA for all your fields? Otherwise, I guess that the system defaults will take over? T

If i can recall correctly. I had problems creating new series with the number of fields. I created a recordset RS... With rs rsCount = .RecordCount rsFields = .Fields.Count ' Debug.Print rsCount If .RecordCount > 0 Then .MoveFirst ReDim...

Have a look at the help files OWCDCH11.CHM and also http://support.microsoft.com/kb/235885/EN-US I assume that you know what to do with Sorry I cant be more help as I'm at work and supposed to be doing other things :-) BR TimW

Hi Sherry I have posted my final code for this below. To be honest I have stopped using Microsoft web components for my graphs because everytime I updated my database half the computers that used it lost its reference to the OWC file. (Even though I had adapted some code to stop this...

I dont know if Bob solved your problem but i would write the sql like this. Dim qry As Recordset, sql As String sql = "SELECT tblPremises.Licensees, tblMunicipalities.MunicipalityName, tblReps.Sales_rep_desc WHERE (((tblReps.Sales_rep_desc)='" & Forms!frmPremiseSelection!cmbRep & "'));"...

Hi & merry christmas [Please enter the ProctorID you woud like to make the graph from] is a parameter that would pop up and ask you for an input. however, this does not work on your report. I am not sure where you have the Query. If I had this in VBA i would have a msgbox pop up and prompt me...

Hi All, This is my current solution for the Pivot chart click to drill down information. I have used the Before Screen Tip event and the selection change event. Not very elegent but there you go! :o It requires the user to hover to obtain as screen tip before clicking the data point that they...

Hi All, I have created a chart using the form PivotChart view. I have done this initially using VBA, but i have also tried just using a query and puting two text boxes in the form. The data is a summary of some other data in the database. (Number of faults, between 2 dates, for any selected...

hi b71 without the table structures I cannot be definate on how I would to it. But it looks if you need to use a subquery to collate the data into days worked in a month and then join this to the table showing available days. Using the individuals id as the join condition. Perhaps if you post...

Wow thanks Leigh. This shows the value of a forum instead of just googling the problem.:) I follow what you are getting at with the recordsetclone. Its just the same object, with a different pointer and therefore when I try and be neat and tidy and destroy it then, bang does not work. Nice of...

Thanks to everyone who had an input. I gave up on the recordsetclone idea. (as it probably was not comprehensive enough anyway!) I came up with the code below which works and is more comprehensive This checks a repairs database to see if a meter is already in the repairs department and...

Thanks Bob I just googled Equals(=) Vs Like and it is equals what I need (I still would like to know what made the recordsetclone go legs up though):) Tim

vbaInet Thanks for your reply. I may use DCount. My code is not well documented!! The IsNull check checks if I have a value in the field, and therefore I have not used the recordsetclone yet <g> The LIKE in the criteria works (the once anyway and is valid SQL synatax) is this not right? Anyway...

Yes, I think so. you need to be grouping on your ChartOrder Link Master fields ChartOrder Link Child Fields ChartOrder The graph needs to be in a ChartOrder Header The graphs can only be viewed in Print Preview mode Tim

Hi Catch How I achieve this was to Put the graph into a selection head and to link the master and child fields On the Group header print section I put the following to update the graph Private Sub GroupHeader1_Print(Cancel As Integer, PrintCount As Integer) On Error Resume Next Dim...

Hi All This is driving my crazy! I know I could do this another way but I would like to solve this. The code below works the first time. (It is to see if a duplicate barcode entry is entered for an order, the data is on a sub form) However, If I try to enter a second deplicate entry i get an...