Do you need just one at a time or a few of the same type?
How long do you need the data?
Will it change?
One value should be read into a simple local variable
Dim sName as string
sName = rs!FirstName & " " & rs!LastName
Multiple Values should be in an array
rs.MoveLast
lNumValues =...
Documentation on SHAPE command is hard to come by.
Try this
KB Article
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q189657
Also the data form wizard in VB6 helped me in the beginning to utilize the SHAPE commands
Good Luck
If the form is to be used in multiple instances with little or no changes then set it up once and declare new uses in the code
Dim fFormA as New FormA
Load fFormA
With fFormA
.Caption = "Whatever"
.Label1.Caption = "Whatever"
.Show
End With
Each instance will be...
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.