Click here to Skip to main content
15,905,912 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: HELP Pin
Midnight Ahri4-Jul-12 15:09
Midnight Ahri4-Jul-12 15:09 
QuestionCreating or changing tables in an access database Pin
No-e3-Jul-12 8:33
No-e3-Jul-12 8:33 
Continuing to slug through a VB6 to VS2008 conversion. In VB6 I was able to modify Access databases and add tables using a bit of code similar to the following (simplified for explanation)

<pre lang="vb">MyTableDef = MyDb.CreateTableDef(tblName)
        ' record type
        For i = 1 To UBound(Fields)
            MyField = MyTableDef.CreateField(Fields(i), FieldType(i), Size(i))
            MyTableDef.Fields.Append(MyField)
        Next
        MyDb.TableDefs.Append(MyTableDef)
        MyDb.Close()
        Exit Sub
</pre>


Fields, FieldType and Size are arrays with a name, length and type of field to be created and appended.

I would like to duplicate this type of functionality using AD0 in VS2008. I know I can do it with a direct SQL command, but those could get real long and ugly. With this method I just add fields to an array and send them to this function.

Any suggestions?

Thanks in advance
AnswerRe: Creating or changing tables in an access database Pin
ChandraRam4-Jul-12 4:03
ChandraRam4-Jul-12 4:03 
GeneralIShellFolder - GetThumbnails [edit title] Pin
jkirkerx2-Jul-12 11:40
professionaljkirkerx2-Jul-12 11:40 
AnswerRe: IShellFolder - GetThumbnails [edit title] Pin
Eddy Vluggen3-Jul-12 0:58
professionalEddy Vluggen3-Jul-12 0:58 
GeneralRe: IShellFolder - GetThumbnails [edit title] Pin
jkirkerx3-Jul-12 7:04
professionaljkirkerx3-Jul-12 7:04 
AnswerRe: IShellFolder - GetThumbnails [edit title] Pin
Eddy Vluggen3-Jul-12 7:33
professionalEddy Vluggen3-Jul-12 7:33 
GeneralRe: IShellFolder - GetThumbnails [edit title] Pin
jkirkerx3-Jul-12 7:43
professionaljkirkerx3-Jul-12 7:43 
GeneralRe: IShellFolder - GetThumbnails [edit title] Pin
Eddy Vluggen3-Jul-12 9:28
professionalEddy Vluggen3-Jul-12 9:28 
AnswerRe: IShellFolder - GetThumbnails Pin
Luc Pattyn3-Jul-12 1:21
sitebuilderLuc Pattyn3-Jul-12 1:21 
GeneralRe: IShellFolder - GetThumbnails Pin
jkirkerx3-Jul-12 7:06
professionaljkirkerx3-Jul-12 7:06 
QuestionVB6 Won't Install On Windows 7 Pro x64 Pin
CodeZombie6230-Jun-12 19:33
CodeZombie6230-Jun-12 19:33 
AnswerRe: VB6 Won't Install On Windows 7 Pro x64 Pin
Dave Kreskowiak1-Jul-12 3:54
mveDave Kreskowiak1-Jul-12 3:54 
GeneralRe: VB6 Won't Install On Windows 7 Pro x64 Pin
CodeZombie621-Jul-12 13:56
CodeZombie621-Jul-12 13:56 
GeneralRe: VB6 Won't Install On Windows 7 Pro x64 Pin
Dave Kreskowiak1-Jul-12 14:38
mveDave Kreskowiak1-Jul-12 14:38 
GeneralRe: VB6 Won't Install On Windows 7 Pro x64 Pin
CodeZombie621-Jul-12 15:08
CodeZombie621-Jul-12 15:08 
AnswerRe: VB6 Won't Install On Windows 7 Pro x64 Pin
MikeD 22-Jul-12 0:17
MikeD 22-Jul-12 0:17 
QuestionGeo fix latitude longitude with VB6? for Googlemaps Pin
khardani30-Jun-12 14:11
khardani30-Jun-12 14:11 
AnswerRe: Geo fix latitude longitude with VB6? for Googlemaps Pin
Richard MacCutchan30-Jun-12 21:30
mveRichard MacCutchan30-Jun-12 21:30 
Generalchar detection, for char replacement or formatting Pin
jkirkerx30-Jun-12 8:27
professionaljkirkerx30-Jun-12 8:27 
GeneralRe: char detection, for char replacement or formatting Pin
Luc Pattyn30-Jun-12 9:12
sitebuilderLuc Pattyn30-Jun-12 9:12 
GeneralRe: char detection, for char replacement or formatting Pin
jkirkerx30-Jun-12 19:09
professionaljkirkerx30-Jun-12 19:09 
GeneralRe: char detection, for char replacement or formatting Pin
jkirkerx2-Jul-12 11:28
professionaljkirkerx2-Jul-12 11:28 
QuestionSending URL to an external web browser Pin
Tim Reece29-Jun-12 16:20
Tim Reece29-Jun-12 16:20 
AnswerRe: Sending URL to an external web browser Pin
Richard MacCutchan29-Jun-12 21:19
mveRichard MacCutchan29-Jun-12 21:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.