On 16 Feb, 15:03, "giannis" <zzzinob...@freemail.gr> wrote:
> How can i refer to a form's textbox.text inside a SQL clause ?
>
> I know how is that in Access* but at VB i receive error.
>
> * SELECT FIELD1 FROM TABLE1
> WHERE TABLE1.FIELD2=[FORMS]![TEXTBOX].[NAME]

"giannis" <zzzinobios@freemail.gr> wrote in message
news:eYoHludUHHA.4756@TK2MSFTNGP06.phx.gbl...
> How can i refer to a form's textbox.text inside a SQL clause ?
>
> I know how is that in Access* but at VB i receive error.
>
> * SELECT FIELD1 FROM TABLE1
> WHERE TABLE1.FIELD2=[FORMS]![TEXTBOX].[NAME]
>

"Kevin S Gallagher" <kevin.s.gallagher@state.or.us> wrote in message
news:uh7BMieUHHA.4404@TK2MSFTNGP03.phx.gbl...
> You could use String.Format as done in the example code which can easily
> be modified to suit your needs
>
> Using command As New OleDbCommand(string.Format("SELECT * from customers
> where = {0}",TextBox1.Text), connection)
>
>
>
> "giannis" <zzzinobios@freemail.gr> wrote in message
> news:eYoHludUHHA.4756@TK2MSFTNGP06.phx.gbl...
>> How can i refer to a form's textbox.text inside a SQL clause ?
>>
>> I know how is that in Access* but at VB i receive error.
>>
>> * SELECT FIELD1 FROM TABLE1
>> WHERE TABLE1.FIELD2=[FORMS]![TEXTBOX].[NAME]
>>
>
>

"giannis" <zzzinobios@freemail.gr> wrote in message
news:uvm5hOeUHHA.3316@TK2MSFTNGP02.phx.gbl...
> Adamz5 wrote:
>> SELECT FIELD1 FROM TABLE1 WHERE TABLE1.FIELD2= " ' " + textbox1.text
>> +" ' "
> The query builder change the textbox1.text in textbox1.[text] and thereby
> i receive error.
>
>

On Feb 16, 9:01 am, "giannis" <zzzinob...@freemail.gr> wrote:
> Dim connection As New OleDbConnection(connectionString)
>
> What must i write as connectionString in this example ?
> I use a .mdb Access database.

Adamz5 wrote:
> SELECT FIELD1 FROM TABLE1 WHERE TABLE1.FIELD2= " ' " + textbox1.text
> +" ' "

"giannis" <zzzinobios@freemail.gr> wrote in message
news:O41vMxlUHHA.3592@TK2MSFTNGP06.phx.gbl...
>I receive the :
> Provider=MSDASQL.1;Persist Security Info=False;
> Data Source=MS Access Database;Initial Catalog=c:\my.mdb
>
> is this correct ?
>
> The :
> Provider=Microsoft.Jet.OLEDB.4.0;
> Data Source=c:\my.mdb
>
> is wrong ?
>

On Feb 16, 10:24 pm, "giannis" <zzzinob...@freemail.gr> wrote:
> I receive the :
> Provider=MSDASQL.1;Persist Security Info=False;
> Data Source=MS Access Database;Initial Catalog=c:\my.mdb
>
> is this correct ?
>
> The :
> Provider=Microsoft.Jet.OLEDB.4.0;
> Data Source=c:\my.mdb
>
> is wrong ?

On Feb 16, 10:37 pm, "RobinS" <Rob...@NoSpam.yah.none> wrote:
> Did you try it?
>
> A good place to look for help with connection strings ishttp://www.connectionstrings.com
>
> Robin S.
> ---------------------------"giannis" <zzzinob...@freemail.gr> wrote in message
>
> news:O41vMxlUHHA.3592@TK2MSFTNGP06.phx.gbl...
>
>
>
> >I receive the :
> > Provider=MSDASQL.1;Persist Security Info=False;
> > Data Source=MS Access Database;Initial Catalog=c:\my.mdb
>
> > is this correct ?
>
> > The :
> > Provider=Microsoft.Jet.OLEDB.4.0;
> > Data Source=c:\my.mdb
>
> > is wrong ?- Hide quoted text -
>
> - Show quoted text -