Change chart x-axis with VBA in Access

[Linus_99]

Hi,

I'm trying to put together a charting routine to chart some values over a range of times.

I would like to enter the start and end dates and then extract values from a table to chart just that date range. [This is not too difficult in Excel, but is obscure to me in Access].

FYI, there is a Microsoft Knowledge Base article (KB198468) on re-scaling the y-axis, but I need to re-scale the x-axis, i.e. the time data.

Because this has to be driven by a number of users, I would like to do it in VBA, with just some text boxes for the start and end date, and a button to make it go.

Any advice would be appreciated. Thanks.

Linus.

 

[Parra]

Is the data that is being used for the excel chart being accessed from a query or report?

If its a query using the date field criteria type:
Between [Start] And [End]

This will prompt the user to enter a start and end date range. Then the query will only give you that range.

 

[Linus_99]

Thanks Parra,

The chart has to be in Access, & I wanted it driven by text box input. In any case, after trying just about everything else, I've used a pivot chart, so the user can select the period when the chart is displayed.

Cheers,
Linus