Results 1 to 2 of 2

Thread: Changing the SQL statement in the Data Environment Designer Dynamically

  1. Apr 15th, 2002, 06:06 PM #1
    WinterMuteUK
    WinterMuteUK is offline

    Thread Starter
    New Member
    Join Date
    Sep 2001
    Location
    Aberdeen - Scotland
    Posts
    12

    Changing the SQL statement in the Data Environment Designer Dynamically

    Hullo...

    I'm trying to, well no, sorry, I *have* connected my database to my VB program via the data environment designer, and also a secondary link via the ADO...

    Using the ADO I can dynamically change the data shown using:

    frmMain.dbaccess_controls.RecordSource = ("SELECT * FROM customer_account WHERE customer_number = '" & txt_custNum.Text & "'")

    followed closely by:

    Call frmMain.dbaccess_controls.Refresh

    Now this allows me to have a search form... is there any way I can do this using the data environment designer?

    i.e. similar to the above code?

    Your befuddled...

    Chris!
    WinterMute.
    Reply With Quote Reply With Quote
  2. Apr 16th, 2002, 09:05 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    http://www.vbforums.com/showthread.p...ht=CommandText
    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