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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.