Displaying DWG In A Form

[Kre?imir Renic via AccessMonster.com]

I am building a part/drawing database. Each part is associated with an AutoCAD ?.dwg file on the network. I would like a form to display the AutoCAD drawing associated with each part. I am using an Unbound Object Frame to display the autocad drawing in the form, however I can't seem to get the frame to update with the corresponding record.

Has anyone attempted something similar to this?

Using MS Access 2K on WinXP.

--
Message posted via http://www.accessmonster.com

[PC Datasheet]

I might suggest a different approach. Autocad has an object model and is
accessible with VBA. You can open autocad drawings in autocad from Access
through automation just like you can open Excel spreadsheets and Word
documents. Check out the autocad website.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Kre?imir Renic via AccessMonster.com" <fo***@AccessMonster.com> wrote in
message news:83******************************@AccessMonste r.com...

I am building a part/drawing database. Each part is associated with an AutoCAD ?.dwg file on the network. I would like a form to display the
AutoCAD drawing associated with each part. I am using an Unbound Object
Frame to display the autocad drawing in the form, however I can't seem to
get the frame to update with the corresponding record.
Has anyone attempted something similar to this?

Using MS Access 2K on WinXP.

--
Message posted via http://www.accessmonster.com

[Tim Marshall]

PC Datasheet wrote:

I might suggest a different approach. Autocad has an object model and is
accessible with VBA. You can open autocad drawings in autocad from Access
through automation just like you can open Excel spreadsheets and Word
documents. Check out the autocad website.

Now that's fascinating information I didn't realize and my organization
uses Autocad A LOT. Kewl.

DO you know if you can somehow relate polygons and other objects in
Autocad to Access via VBA? We use a very expensive system called
Aperture which imports Autocad dwg files and allows users to draw
polygons over top on separate layers to which text information can be
bound using Aperture's database engine. The lady who has this set up (I
introduced Aperture many years ago and handed it off to her) has made a
magnificently functional building space management application. I
wonder, though if Access could do as well?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[PC Datasheet]

Tim,

I have no personnal experience with Autocad, I just remember reading about
integrating Access and Autocad. I went to Google.com and did an advanced
search on these three words:
Microsoft Access Autocad
The following are the first two URLs:

http://usa.autodesk.com/adsk/servlet...1496&linkID=24
75176

http://usa.autodesk.com/adsk/servlet...7392&linkID=24
75176

Steve
PC Datasheet

"Tim Marshall" <TI****@antarctic.flowerpots> wrote in message
news:ct**********@coranto.ucs.mun.ca...

PC Datasheet wrote:

I might suggest a different approach. Autocad has an object model and is
accessible with VBA. You can open autocad drawings in autocad from Access through automation just like you can open Excel spreadsheets and Word
documents. Check out the autocad website.

Now that's fascinating information I didn't realize and my organization
uses Autocad A LOT. Kewl.

DO you know if you can somehow relate polygons and other objects in
Autocad to Access via VBA? We use a very expensive system called
Aperture which imports Autocad dwg files and allows users to draw
polygons over top on separate layers to which text information can be
bound using Aperture's database engine. The lady who has this set up (I
introduced Aperture many years ago and handed it off to her) has made a
magnificently functional building space management application. I
wonder, though if Access could do as well?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Tim Marshall]

PC Datasheet wrote:

I have no personnal experience with Autocad, I just remember reading about
integrating Access and Autocad. I went to Google.com and did an advanced
search on these three words:
Microsoft Access Autocad
The following are the first two URLs:

http://usa.autodesk.com/adsk/servlet...1496&linkID=24
75176

http://usa.autodesk.com/adsk/servlet...7392&linkID=24
75176

Thanks Steve, I'll root around these for a bit. 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto