| Author |
Message |
sent
Guest
|
 Posted:
Mon Mar 28, 2005 11:31 pm Post subject:
Linking Autocad2k and Access with VBA |
|
|
Hi all!
I'm in trouble.
I have to make a program under acad2000. That isn't a "big" problem, but i am very novice in this part of the programing. My problems are the following:
I have a database in Access with forms, tables, i have also blocks in AutoCAD. My job is linking the object in acad and the blocks in a access database.
How can i do the following with the help of vba:
I want see a list in acad2000, this list will be the one of the access databases table (example apple, pear, orange), and if i choose one item from the list that calls a block from what i made before it and insert it at the modelspace some x,y,z co-ordinates.
If somebody has it in a program and can send it that would be great and helpfull.
Pls help:)
Many thanks.
|
|
| Back to top |
|
 |
Paul Richardson
Guest
|
| Posted:
Mon Mar 28, 2005 11:47 pm Post subject:
Re: Linking Autocad2k and Access with VBA |
|
|
You will find many topics on this in the Customization Group. Also
there is a sample in the help menu. Think it was there in 2000.
"sent" <nospam@address.withheld> wrote in message
news:17036253.1112034711478.JavaMail.jive@jiveforum2.autodesk.com...
| Quote: | Hi all!
I'm in trouble.
I have to make a program under acad2000. That isn't a "big" problem, but i
am very novice in this part of the programing. My problems are the
following:
I have a database in Access with forms, tables, i have also blocks in
AutoCAD. My job is linking the object in acad and the blocks in a access
database.
How can i do the following with the help of vba:
I want see a list in acad2000, this list will be the one of the access
databases table (example apple, pear, orange), and if i choose one item
from the list that calls a block from what i made before it and insert it
at the modelspace some x,y,z co-ordinates.
If somebody has it in a program and can send it that would be great and
helpfull.
Pls help:)
Many thanks. |
|
|
| Back to top |
|
|
Paul Richardson
Guest
|
| Posted:
Mon Mar 28, 2005 11:48 pm Post subject:
Re: Linking Autocad2k and Access with VBA |
|
|
Sorry..."Connectivity Group"
"Paul Richardson" <noSPAM@nospam.com> wrote in message
news:42485118$1_1@newsprd01...
| Quote: | You will find many topics on this in the Customization Group. Also
there is a sample in the help menu. Think it was there in 2000.
"sent" <nospam@address.withheld> wrote in message
news:17036253.1112034711478.JavaMail.jive@jiveforum2.autodesk.com...
Hi all!
I'm in trouble.
I have to make a program under acad2000. That isn't a "big" problem, but
i am very novice in this part of the programing. My problems are the
following:
I have a database in Access with forms, tables, i have also blocks in
AutoCAD. My job is linking the object in acad and the blocks in a access
database.
How can i do the following with the help of vba:
I want see a list in acad2000, this list will be the one of the access
databases table (example apple, pear, orange), and if i choose one item
from the list that calls a block from what i made before it and insert it
at the modelspace some x,y,z co-ordinates.
If somebody has it in a program and can send it that would be great and
helpfull.
Pls help:)
Many thanks.
|
|
|
| Back to top |
|
|
John Goodfellow
Guest
|
| Posted:
Tue Mar 29, 2005 2:18 am Post subject:
Re: Linking Autocad2k and Access with VBA |
|
|
You will need to use one of the Microsoft data access libraries, either Data
Access Objects (DAO) or ActiveX Data Objects (ADO) from an AutoCAD VBA code
module to access the MS-Access table your information is stored in. As Paul
mentioned, AutoCAD comes with a sample showing how to do this. Take a look
in the Program Files\ACAD2000\SAMPLE\ forder for "db_samp.dwg" and
"db_samples.mdb". DAO and ADO help should be available from the main Access
help, probably under the "Programming Information" book. See if they make
any sense to you, then ask some more questions.
--
John Goodfellow
irtfnm (presently available for projects)
use john at goodfellowassoc dot com
"sent" <nospam@address.withheld> wrote in message
news:17036253.1112034711478.JavaMail.jive@jiveforum2.autodesk.com...
| Quote: | Hi all!
I'm in trouble.
I have to make a program under acad2000. That isn't a "big" problem, but i
am very novice in this part of the programing. My problems are the |
following:
| Quote: | I have a database in Access with forms, tables, i have also blocks in
AutoCAD. My job is linking the object in acad and the blocks in a access |
database.
| Quote: | How can i do the following with the help of vba:
I want see a list in acad2000, this list will be the one of the access
databases table (example apple, pear, orange), and if i choose one item from |
the list that calls a block from what i made before it and insert it at the
modelspace some x,y,z co-ordinates.
| Quote: | If somebody has it in a program and can send it that would be great and
helpfull.
Pls help:)
Many thanks. |
|
|
| Back to top |
|
|
sent
Guest
|
| Posted:
Sat Apr 02, 2005 4:38 pm Post subject:
Re: Linking Autocad2k and Access with VBA |
|
|
Thx for the help.
I will do that. |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in