The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community

Geekfinder
UFie Gear
Advertise on UF

Forum Rules
& FAQ


Username

Password


Create a New Account

 
 

Back to UserFriendly Strip Comments Index

Open MS Access database in VB 2008 by SnappingTurtle2008-10-21 15:05:13
  Use the Old Darn Bitmangler Crud. by aix tom2008-10-21 15:20:53
    I'm sorry but it's just not happening by SnappingTurtle2008-10-21 15:45:10
      Ah, No more DAO, it's now ADO. ;-P by aix tom2008-10-21 15:55:09
        OK, at least making some progress by SnappingTurtle2008-10-21 16:09:53
          Do you want the how-to code or how-to poke? by Danu 2008-10-21 17:48:55
Global cnn1 As ADODB.Connection


Public Function taggit (some_value as long) As Boolean

Dim rstMyTableA As ADODB.Recordset

Set rstMyTableA = New ADODB.Recordset
rstMyTableA.CursorType = adOpenDynamic
rstMyTableA.LockType = adLockOptimistic
rstMyTableA.Open "Select my_col1, mycol2 from MyTableA " & _
"Where my_col2 = " & some_value & "", cnn1

'.....blah, blah, blah

rstMyTableA.Close

'.....doo, doo, dee-doe-doe

End Function
[ Reply ]

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)