Completed

Autocad / Intellicad VBA script to read MS Access table

I'm after a VBA script that I can run from within in Autocad and / or Intellicad. This VBA script will need to connect to an MS-Access database, open up a table and then within that table, go through each record and look at three fields: LName; LNumber and LAnnotation. When the script encounters a record > field in which LName begins with the prefix "CMT_" The script need to concantenate the text strings LNumber and LAnnotation from that record. LNumber is a number field and LAnnotaion is a text field. I've included a screenshot of the fields These concantenations need to then be written to a text file that I can use Lisp's read-line function on. I'm going to need the ability to change the Access database name as well as the table names but I'm assuming that's going to be fairly straightforward within VBA. My primary goal is to have the VBA script run on Autocad (say 2002 upward) but I also use an Intellicad platform so I'd like a quote on doing either AutoCad by itself or AutoCad and Intellicad 6.4

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

Other Files: See Attachment

## Platform

AutoCad 2002 + Progecad 2008+ using Intellicad 6.4 Windows XP and Vista

Skills: Excel, Microsoft, Microsoft Access, Microsoft Exchange, Powerpoint, Windows Desktop, Word

See more: vba code intellicad, work in autocad, vba coder for hire, prefix function, ms access excel vba, hire a vba coder, autocad on line, ms access web database, software autocad, vba access excel, ms access vba, excel vba script, c# autocad, autocad, autocad work , autocad 2, vba open access, access vba open, excel access table, windows vba

About the Employer:
( 2 reviews ) United States

Project ID: #3913096

Awarded to:

Iwin

See private message.

$42.5 USD in 7 days
(48 Reviews)
5.5

3 freelancers are bidding on average $38 for this job

blueflare

See private message.

$21.25 USD in 7 days
(3 Reviews)
3.5
smartsaqib

See private message.

$50.15 USD in 7 days
(7 Reviews)
3.0