Search found 7 matches

by Chints
Tue Dec 16, 2008 10:09 am
Forum: ActiveX
Topic: Can't get multiline property to work
Replies: 13
Views: 11800

I've used the 'snap' setting for the cursor and the Locate function now works fine.

Thanks for your help :)
by Chints
Mon Dec 15, 2008 5:02 pm
Forum: ActiveX
Topic: Can't get multiline property to work
Replies: 13
Views: 11800

Thanks for the support - the 'Locate' method looks like the answer, but it just returns -1 for all cursor positions on the chart.

Does the input parameter for the Locate method need to be in a specific format ?
by Chints
Mon Dec 15, 2008 4:33 pm
Forum: ActiveX
Topic: Can't get multiline property to work
Replies: 13
Views: 11800

OK I seem to have solved the initial multiline problem: - I removed the following for each series - .Labelsource = "Datetime" lines - and added the following for each series .XValues.Valuesource = "DateTime" - and used the setminmax method as you suggested However, this is now causing problems with ...
by Chints
Mon Dec 15, 2008 2:16 pm
Forum: ActiveX
Topic: Can't get multiline property to work
Replies: 13
Views: 11800

Fair enough, but is there a property of the bottom axis I can write to to set the start datetime label value of the axis ?

The vb example you referred to starts from the current datetime but I'm not sure how.
by Chints
Mon Dec 15, 2008 10:54 am
Forum: ActiveX
Topic: Can't get multiline property to work
Replies: 13
Views: 11800

It's difficult to produce a cut down example because the query won't work without the back end SQL Server database. However, am I right in thinking there are two ways of producing the bottom axis labels, ie: 1) Currently I am using the following VB code to associate each point in the series with a d...
by Chints
Mon Dec 15, 2008 10:06 am
Forum: ActiveX
Topic: Can't get multiline property to work
Replies: 13
Views: 11800

Yes, the example works fine on the same machine. The main differences between my project and the example are: - My chart has multiple series sharing a common bottom axis - The series data is from a query recordset Just a thought - The bottom axis labels are releated to the column in the query caled ...
by Chints
Sat Dec 13, 2008 1:20 pm
Forum: ActiveX
Topic: Can't get multiline property to work
Replies: 13
Views: 11800

Can't get multiline property to work

We are using a Line Chart, on an Access 2007 form, to plot floating-point instrument values against a common datetime bottom axis. However the bottom axis labels are not being wrapped over two lines even though the multiline property for the axis is checked. The data is being fetched from an Access ...