I am using data from oracle to draw a diagram. When I need to know is the vba code to group shapes. They also want the grouped shapes to be surrounded by a dashed rectangle.
Anyone?
Dim db as database
Dim rst as dao.recordset
Dim strSQL as string
Dim lng as long
Set db = currentdb
strSQL = "SELECT * FROM [tblName];"
Set rst = db.openrecordset(strSQL)
rst.movelast
lng = rst.recordcount
NewValues Property
You can use the NewValues property to specify how AutoNumber fields increment when new records are added to a table.
Note The NewValues property applies only to AutoNumber fields.
Setting
The NewValues property uses the following settings.
Setting...
Hey Instructor,
First, do a manual import of text file. On the advanced tab, import the names of the fields you use in your access tables. Then save it.
When you want to call in code, you refer to the import specifications that you saved.
(i.e. DoCmd.TransferText acImportDelim, "New...
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.