Results 1 to 3 of 3

Thread: Visual Basic Access

  1. Feb 10th, 2012, 06:32 AM #1
    haniffdj
    haniffdj is offline

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    1

    Visual Basic Access

    Hi,

    I would like some advice on Visual Basic Access. I have put the following bits of code in VB.

    Option Compare Database
    Option Explicit

    Dim RS As New ADODB.Recordset

    But for some reason it is coming back with an error saying that it can't recognise it. Are there particular settings or declarions that need to be put in place before the code will work?

    Hope you can help.

    Cheers

    Dave
    Reply With Quote Reply With Quote
  2. Feb 10th, 2012, 08:14 AM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: Visual Basic Access

    Read VB6 ADO tutorials in Database Development FAQ - it has enough information to get you started.
    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  3. Feb 10th, 2012, 10:59 AM #3
    dilettante
    dilettante is offline
    PowerPoster dilettante's Avatar
    Join Date
    Feb 2006
    Posts
    24,487

    Re: Visual Basic Access

    Code:
    Option Compare Database
    This doesn't exist in VB4/5/6, are you talking about VBA?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width