topic Access and VB in VBA Forum

Access and VB

Anonymous — Thu, 03 Jan 2002 06:33:45 GMT

I know that I am missing something easy here. How do I connect AutoCAD to
Access using VB 6.0? All I want to do is see if my part number is already
in the table and if not add it to the table.

Re: Access and VB

Anonymous — Thu, 03 Jan 2002 07:05:27 GMT

Have you ever accessed Access before?...

The steps you would take;

1) Read the Drawing Number from you drawing - Stored in a System Variable or
reading the File Name

2) Open a Connection to Access - I recommend using ADO

3) Create a recordset based on a SQL statement that try's and finds your
Drawing Number

4) Check the Recordcount of the recordset - If 0 then add the drawing to the
database

Thats it. If you need more specific code for each step let me know and I
will post

--
Veign
Designing Solutions
www.veign.com
VB Code Samples & Projects
www.veign.com/information/info_main.html

"Chris W" wrote in message
news:0736BACDE7EDF2A525A8E8C0A2B3645A@in.WebX.maYIadrTaRb...
> I know that I am missing something easy here. How do I connect AutoCAD to
> Access using VB 6.0? All I want to do is see if my part number is already
> in the table and if not add it to the table.
>
>

Re:

Anonymous — Thu, 03 Jan 2002 07:12:15 GMT

No I haven't worked with Access before I usually use Excel. Thanks this
will give me a starting point.

"Veign" wrote in message
news:DBBA39EDD57BE2786C6B71BC959FAC1C@in.WebX.maYIadrTaRb...
> Have you ever accessed Access before?...
>
> The steps you would take;
>
> 1) Read the Drawing Number from you drawing - Stored in a System Variable
or
> reading the File Name
>
> 2) Open a Connection to Access - I recommend using ADO
>
> 3) Create a recordset based on a SQL statement that try's and finds your
> Drawing Number
>
> 4) Check the Recordcount of the recordset - If 0 then add the drawing to
the
> database
>
> Thats it. If you need more specific code for each step let me know and I
> will post
>
> --
> Veign
> Designing Solutions
> www.veign.com
> VB Code Samples & Projects
> www.veign.com/information/info_main.html
>
>
> "Chris W" wrote in message
> news:0736BACDE7EDF2A525A8E8C0A2B3645A@in.WebX.maYIadrTaRb...
> > I know that I am missing something easy here. How do I connect AutoCAD
to
> > Access using VB 6.0? All I want to do is see if my part number is
already
> > in the table and if not add it to the table.
> >
> >
>
>