Creating Timeline Reports

[Joakim N]

Hi,



I have written a database in Excel. I use a lot of VBA programming in this application. When upgrading Excel from 2007 to 2013, there was a graphical issues. The graphic gut stuck so it was impossible to see what actually happened on the screen after a while. To get the graphic to work we had to reinstall Excel 2007 and run the application from that version.

Using Excel 2007 is a temprary fix. I'm looking for another program and I am investigating Access. Just a general question: Is it possible to create a report in Access looking like attached Excel timeline report? I have seen it's possible to insert an Unbound Object like Excel Worksheet in an Access report. But I don't know if it's possible to create that complex layout as attached file. Maybe I have to invoke Excel from Access by VBA programming and make the report in Excel. However, I don't know if I will experience the graphic issue again.

Can anyone give a tip how I can create this timeline from Access. Maybe give some tip where to look for information.

Regards

Joakim Norrman

[ranman256]

Excel is NOT a database. Access can do charts, but they are fairly simple. Bars, lines, pie.
if you are using complex graphics ,then excel is the better chart, but use Access to pull your data then export to excel to chart.

[Joakim N]

OK.

Thanks for your answer. Then I know I have to use the data in Access and then make the quite complex report in Excel. Useful answer for me.

[rpeare]

What you are talking about is a gantt chart, which is possible in Access alone. I created an example for vacation scheduling a while ago on this forum but I can't find a link for it. they are code intensive (depending on how intricate your rules are) but possible in Access without having to involve Excel. I have not messed around with it in quite some time but I do not recall any on-board gantt chart producing options out of Access.

If you want a sample database I may be able to come up with the one I originally posted but it may take me a few days to find it.

[Joakim N]

I'd really appreciate if you could find the sample database. My objective was in the first place to not use Excel due to the graphic issues I experience from 2013. The same in 2016. So, you'd be my hero if you'd find the sample.

Thanks in advance
\Joakim

[rpeare]

https://www.accessforums.net/showthread.php?t=18459

Found it Just open the form put in the dates 8/1/2011 through 8/31/2011 then click the button, then open the report.

the 'boxes' in this example are full days. you would have to have minimum time increments on your report to make this work (i.e. 15 minute increments to account for someone's time every day might be the minimum time increment)