Windows Forum

Ask something
Discussion Locked

MS ACCESS 2000 Gantt Charts

0 helpful
2 replies

by rwolinski

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to create a Gantt chart with two date fields in an ACCESS 2000 table. I cannot find a canned approach anywhere,(but I may have overlooked it) and I want this if possible to run in ACCESS or automatically lauch Excel 2000 from an ACCESS window command button. Help Please. This is for a mission critical event.

2 replies

by inspectorclave

I would check the following site for tips on doing advanced Access stuff:

http://www.mvps.org/access

Otherwise, you can call other apps by using the shell function. For example, if you wanted to open a sheet from Excel by clicking on a button, then in the OnClick event of the command button you would put something like this:

Dim retVal
Dim xShare As String
Dim xfolder As String
Dim xSubFolder As String
dim xDoc as String

xShare = "C:\"
xfolder = "MyDirectory\"
xSubFolder = "MyExcelSheet"
xDoc = "MyExcelDoc"

retVal = Shell("c:\microsoft office\excel.exe " & xShare & xFolder & xSubFolder & xDoc, vbNormalFocus)

Good Luck!

by rwolinski

Thank You, I should have know this but sometimes you just get too confused over the content and miss the simple stuff.

This discussion is closed to new replies.