Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Organization Chart Connecting lines not moving with nodes
The connectors don't follow. When I'm done, the connectors are still where they were when the node was created. dkalel- dkalel
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
adjusting data using vba access
Try the following code (I hope this is what you're looking for): Sub Convert() Dim X As Integer, SqlString As String For X = 1 To 3 SqlString = "INSERT INTO Table2 ( [Year], [Month], Employment, County )" SqlString = SqlString & " SELECT Left([YrQtr],4) AS Expr1...- dkalel
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Organization Chart Connecting lines not moving with nodes
I am trying to automate our organizational chart slides based on information in an access database. Since some of the slides are pretty crowded, I need to move the subordinates closer together. Problem is, when I do it through visual basic, the nodes move, but not the connecting lines. I am...- dkalel
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
