Search results

I am storing values on scales. I would like to store an equation which would use those values and return the result. I am not sure how to do this. Here is an example: I stored the values on a number of scales: S1 = 3 S2 = 5 S3 =10 Now the user can specify an equation which I store as text in a...

You execute the QueryDef and put its result to a RecordSet. I have copied here the Sub from Access help. Once that is done you have to navigate to the record you need, but if you are certain that the query will only return one and only one record you can skip this. hth SWK...

I created a sub that accepts parameters to build the pivot table. I can call it like: PivotFormat rst, "C_SNAME", "RowAxis", "CandidateInstanceID", "RowAxis", "ScaleTag", "ColumnAxis", "Score", "DataAxis" I would like to make sure that no subtotals are displayed when the table is created. I can...

I still couldn't find a proper documentation, but I got somewhere after I found the following page: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03l7.asp Could somebody tell me how to make the Grand Total row and column disappear from code? thanks SWK

I just realised that I can use pivot tables in AccessXP but I don't seem to be able to find any reference on how to manipulate the pivot table from code. Could somebody refer me to some examples\documentation\tutorial? Many thanks. SWK

I haven't tried this but this would be my guess: Me.ctlList=Me.ctlList.ItemData(Me.ctlList.ItemsSelected+1) hth SWK

As I see form footers - logically - appear from the bottom of the form. If the detail section doesn't fill out the whole page there can be a gap before the footer comes. Is there a way to change the footer section so that it would appear immediately after the detail section? Thanks. SWK

One thing you can do is leave ADO out of the whole thing like this: SQLstring = " Select * from TableName" Forms!FormName.RecordSource = SQLString This will work on earlier versions of Access as well. On AccessXP you can assign the recordset if you want to Set cn = CurrentProject.Connection...

I am not sure that I fully understood the problem, but will give it a try. The code below puts the key of the expanded node into a control. When you cliks on the tree it checks if you clicked on a node and if the key of the clicked node is the same than the one we stored during expand pops up a...

I attached a picture of the sort of the slider I am looking for. If you know where can I find a similar one please let me know. Thanks. SWK

If this is not doable with one control I might be able to do it with 10 sliders under each other. But than I will need to repeat every code for each slider ...

Ten cutpoints are placed within a range and I would like to let the user modify them. I thought that a slider control would be ideal to visualize the cutpoints (the relative distance between them and that cutpoints can only be moved within the range of the neighbouring cutpoints), but the...

The previous one did not always returned a result. This one does. SELECT TOP 1 x.CandidateScaleValue FROM ScaleData x CROSS JOIN ScaleData y GROUP BY x.CandidateScaleValue HAVING SUM(CASE WHEN y.CandidateScaleValue <= x.CandidateScaleValue THEN 1 ELSE 0 END)>=(COUNT(*)+1)*@P ORDER BY SUM(CASE...

I think I have it now. The syntax here is for SQL server but the logic will be the same for Access. Set @P=0.01 SELECT x.CandidateScaleValue FROM ScaleData x CROSS JOIN ScaleData y GROUP BY x.CandidateScaleValue HAVING SUM(CASE WHEN y.CandidateScaleValue <= x.CandidateScaleValue...

I have a table with one column (for the matter of simplicity). I am looking for the number where X percent of the numbers in that column are smaller than that number. When X=50 the number I should get is the median, but that is just an example I would need to find a generic solution to this...

I have a report which displays correctly on screen, but I found absolutely no way of outputting it to anything including: - printing the document to printer or pdf - publish it to Word or Excel - Save As anything When I try to do any of these Access flashes up for a moment something that might...

Jon, I've got the ide and have it working now. Thanks for your help. SWK

I got over the problem (thanks Pat again) and thought to share how I did it. Finally I had to modify the rowsource of the chart in design mode and save it in code. Since I work with an Access project and ADO I couldn't play with QueryDef so this ugly thing was the only solution I could find...

I have a table which contains 3 columns. For each CompID CutPointValue goes from 1 to 10 and I have a count for it, like this: CompID, CutPointValue, CountCutPointValue 1,1,20 1,2,30 1,3,14 .. 1,10,14 2,2,15 2,3,10 ... The problem is that in a few cases a few CutPointValue numbers may be...

I am creating a report in an Access Project. The report contains a graph. I couldn't find out how to specify the RowSource of the graph. I wanted to supply the rowsource when opening the report, like this. Dim objGraph As Object Set objGraph = Me.Histogram SQLString = " SELECT ........"...