DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 11 of 11

Thread: Fill a text box

  1. #1
    Gill Guest

    Fill a text box


    Hello,
    I ahve a form whereby the user chooses a Customer No.
    Once the number is choosen I want that customers Name and Address to be filled
    in!
    My problem is that I have put code into Lostfocus on the Customer no text
    box and I'm told that I can't use teh following to fill a textbox.

    Dim VarCustNo
    VarCustno = cboCustomerNo
    Dim Fill as String
    Fill = "Select CustomerName from Customers where CustomerNo = "
    Fill = Fill & VarCustomerno

    txtCustomername = Fill

    I have tried this in a number of ways, but no luck with it!
    Any ideas

    Thanks for any help
    Gill

  2. #2
    HCuteT2000 Guest

    Re: Fill a text box


    Hey "Gill":

    In your code, you did not assign the value for "VarCustomerno", only for
    "VarCustNo". Make sure
    you don't use two different variable names to mean the same thing. Also,
    variable names
    are case-sensitive..

    What to do now is probably change the last line into:
    Fill = Fill & VarCustoNo

    Good luck,

    HCuteT2000
    -----------
    "Gill" <GMaloney@PBS.ie> wrote:
    >
    >Hello,
    >I ahve a form whereby the user chooses a Customer No.
    >Once the number is choosen I want that customers Name and Address to be

    filled
    >in!
    >My problem is that I have put code into Lostfocus on the Customer no text
    >box and I'm told that I can't use teh following to fill a textbox.
    >
    >Dim VarCustNo
    >VarCustno = cboCustomerNo
    >Dim Fill as String
    >Fill = "Select CustomerName from Customers where CustomerNo = "
    >Fill = Fill & VarCustomerno
    >
    >txtCustomername = Fill
    >
    >I have tried this in a number of ways, but no luck with it!
    >Any ideas
    >
    >Thanks for any help
    >Gill



  3. #3
    Arthur Wood Guest

    Re: Fill a text box


    "Gill" <GMaloney@PBS.ie> wrote:
    >
    >Hello,
    >I ahve a form whereby the user chooses a Customer No.
    >Once the number is choosen I want that customers Name and Address to be

    filled
    >in!
    >My problem is that I have put code into Lostfocus on the Customer no text
    >box and I'm told that I can't use teh following to fill a textbox.
    >
    >Dim VarCustNo
    >VarCustno = cboCustomerNo
    >Dim Fill as String
    >Fill = "Select CustomerName from Customers where CustomerNo = "
    >Fill = Fill & VarCustomerno
    >
    >txtCustomername = Fill
    >
    >I have tried this in a number of ways, but no luck with it!
    >Any ideas
    >
    >Thanks for any help
    >Gill



    Gill,

    Your "Select CustomerNo from Customers..." is called SQL (for Structured
    Query Laguage) and is used to get data from a database. YOu must connect
    you application to a database, create a recordset (to hold the data) and
    then execute the SQL command to retrieve the data.

    What tools are you using?(Which Office App are you using, since you are asking
    this in the VBA News Group ?)

    Arthur Wood

  4. #4
    Arthur Wood Guest

    Re: Fill a text box


    to HCuteT2000 and Gill:

    In Visual Basic ( and VBA) variable names ARE NOT (EMPHASIZE NOT) case sensitive.
    Thast is C and C++, NOT VB!!!!

    Arthur Wood


    "HCuteT2000" <HCuteT2000@SomewhereOnEarth.Net> wrote:
    >
    >Hey "Gill":
    >
    >In your code, you did not assign the value for "VarCustomerno", only for
    >"VarCustNo". Make sure
    >you don't use two different variable names to mean the same thing. Also,
    >variable names
    >are case-sensitive..
    >
    >What to do now is probably change the last line into:
    >Fill = Fill & VarCustoNo
    >
    >Good luck,





    >
    >HCuteT2000
    >-----------
    >"Gill" <GMaloney@PBS.ie> wrote:
    >>
    >>Hello,
    >>I ahve a form whereby the user chooses a Customer No.
    >>Once the number is choosen I want that customers Name and Address to be

    >filled
    >>in!
    >>My problem is that I have put code into Lostfocus on the Customer no text
    >>box and I'm told that I can't use teh following to fill a textbox.
    >>
    >>Dim VarCustNo
    >>VarCustno = cboCustomerNo
    >>Dim Fill as String
    >>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>Fill = Fill & VarCustomerno
    >>
    >>txtCustomername = Fill
    >>
    >>I have tried this in a number of ways, but no luck with it!
    >>Any ideas
    >>
    >>Thanks for any help
    >>Gill

    >



  5. #5
    Gill Guest

    Re: Fill a text box


    Hi Arthur,
    Thanks for the response
    I know what you mean by having to assign the sql to a dB.(am using Access
    2000)
    I used the following

    Dim db as Database
    Dim rst as recordset
    set db = currentdb
    dim sql as string
    Dim VarCustNo
    VarCustno = cboCustomerNo
    Dim Fill as String
    Fill = "Select CustomerName from Customers where CustomerNo = "
    Fill = Fill & VarCustno
    set rst = db.openrecordset(Fill)
    txtCustomername.text = rst("CustomerName")

    the thing about this is that I have to set the focus to the textbox everytime
    in order for that code to work and the code has to be in the customername
    textbox.
    I would prefer if the user could just choose the customerid number and get
    on with the rest of the screen instead of having to enter the customername
    textbox and the the address, phone number etc...
    It works with Listboxes, ie. if I fill the listboxes on lostfocus of the
    customerNo. But when I navigate through the records the listboxes don't change
    data and I was having a problem saving teh info to the table.
    So what I wnat to do is pick a customer no from a combo box and then the
    other details fill in automatically from this without the user having to
    enter the text boxes, and that the navigation through records worked whne
    used!!







    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >"Gill" <GMaloney@PBS.ie> wrote:
    >>
    >>Hello,
    >>I ahve a form whereby the user chooses a Customer No.
    >>Once the number is choosen I want that customers Name and Address to be

    >filled
    >>in!
    >>My problem is that I have put code into Lostfocus on the Customer no text
    >>box and I'm told that I can't use teh following to fill a textbox.
    >>
    >>Dim VarCustNo
    >>VarCustno = cboCustomerNo
    >>Dim Fill as String
    >>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>Fill = Fill & VarCustomerno
    >>
    >>txtCustomername = Fill
    >>
    >>I have tried this in a number of ways, but no luck with it!
    >>Any ideas
    >>
    >>Thanks for any help
    >>Gill

    >
    >
    >Gill,
    >
    >Your "Select CustomerNo from Customers..." is called SQL (for Structured
    >Query Laguage) and is used to get data from a database. YOu must connect
    >you application to a database, create a recordset (to hold the data) and
    >then execute the SQL command to retrieve the data.
    >
    >What tools are you using?(Which Office App are you using, since you are

    asking
    >this in the VBA News Group ?)
    >
    >Arthur Wood



  6. #6
    Gill Guest

    Re: Fill a text box


    upps, just a typing error on my behalf there hcute..
    I meant to call that VarCustno, but i was just rewriting some of the code
    I used and made a blunder..I understand the whole variable thing (+ caps
    don't matter in VB!!)Thanks for responding so heres an update on what the
    problem is:
    I need to be able to fill a text box from a function without having to go
    into each textbox. A text box requires Focus in order for you to put data
    into it! I don't want the user to have to go into every text box when they
    choose on a customerno from a combo box!I wnat all teh data to come up automatically
    Any ideas????
    Thanks again
    Gill

    "HCuteT2000" <HCuteT2000@SomewhereOnEarth.Net> wrote:
    >
    >Hey "Gill":
    >
    >In your code, you did not assign the value for "VarCustomerno", only for
    >"VarCustNo". Make sure
    >you don't use two different variable names to mean the same thing. Also,
    >variable names
    >are case-sensitive..
    >
    >What to do now is probably change the last line into:
    >Fill = Fill & VarCustoNo
    >
    >Good luck,
    >
    >HCuteT2000
    >-----------
    >"Gill" <GMaloney@PBS.ie> wrote:
    >>
    >>Hello,
    >>I ahve a form whereby the user chooses a Customer No.
    >>Once the number is choosen I want that customers Name and Address to be

    >filled
    >>in!
    >>My problem is that I have put code into Lostfocus on the Customer no text
    >>box and I'm told that I can't use teh following to fill a textbox.
    >>
    >>Dim VarCustNo
    >>VarCustno = cboCustomerNo
    >>Dim Fill as String
    >>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>Fill = Fill & VarCustomerno
    >>
    >>txtCustomername = Fill
    >>
    >>I have tried this in a number of ways, but no luck with it!
    >>Any ideas
    >>
    >>Thanks for any help
    >>Gill

    >



  7. #7
    Arthur Wood Guest

    Re: Fill a text box


    Gill,
    You want to use the fact the the .text property of a text box is its DEFAULT
    property - that is, if you just use the control name, that is the property
    that is assumed, without having to name it explicitly. Naming the property
    explicitly, in VBA, requires that the control have FOCUS. Using the default
    property does NOT require that the control have focus.

    If you change the line:

    txtCustomername.text = rst("CustomerName")

    to

    txtCustomername= rst("CustomerName") (drop the .text)

    the error message should vanish, as if by magic.



    "Gill" <GMaloney@pbs.ie> wrote:
    >
    >Hi Arthur,
    >Thanks for the response
    >I know what you mean by having to assign the sql to a dB.(am using Access
    >2000)
    >I used the following
    >
    >Dim db as Database
    >Dim rst as recordset
    >set db = currentdb
    >dim sql as string
    >Dim VarCustNo
    >VarCustno = cboCustomerNo
    >Dim Fill as String
    >Fill = "Select CustomerName from Customers where CustomerNo = "
    >Fill = Fill & VarCustno
    >set rst = db.openrecordset(Fill)
    >txtCustomername.text = rst("CustomerName")
    >
    >the thing about this is that I have to set the focus to the textbox everytime
    >in order for that code to work and the code has to be in the customername
    >textbox.
    >I would prefer if the user could just choose the customerid number and get
    >on with the rest of the screen instead of having to enter the customername
    >textbox and the the address, phone number etc...
    >It works with Listboxes, ie. if I fill the listboxes on lostfocus of the
    >customerNo. But when I navigate through the records the listboxes don't

    change
    >data and I was having a problem saving teh info to the table.
    >So what I wnat to do is pick a customer no from a combo box and then the
    >other details fill in automatically from this without the user having to
    >enter the text boxes, and that the navigation through records worked whne
    >used!!
    >
    >
    >
    >
    >
    >
    >
    >"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>
    >>"Gill" <GMaloney@PBS.ie> wrote:
    >>>
    >>>Hello,
    >>>I ahve a form whereby the user chooses a Customer No.
    >>>Once the number is choosen I want that customers Name and Address to be

    >>filled
    >>>in!
    >>>My problem is that I have put code into Lostfocus on the Customer no text
    >>>box and I'm told that I can't use teh following to fill a textbox.
    >>>
    >>>Dim VarCustNo
    >>>VarCustno = cboCustomerNo
    >>>Dim Fill as String
    >>>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>>Fill = Fill & VarCustomerno
    >>>
    >>>txtCustomername = Fill
    >>>
    >>>I have tried this in a number of ways, but no luck with it!
    >>>Any ideas
    >>>
    >>>Thanks for any help
    >>>Gill

    >>
    >>
    >>Gill,
    >>
    >>Your "Select CustomerNo from Customers..." is called SQL (for Structured
    >>Query Laguage) and is used to get data from a database. YOu must connect
    >>you application to a database, create a recordset (to hold the data) and
    >>then execute the SQL command to retrieve the data.
    >>
    >>What tools are you using?(Which Office App are you using, since you are

    >asking
    >>this in the VBA News Group ?)
    >>
    >>Arthur Wood

    >



  8. #8
    Gill Guest

    Re: Fill a text box


    Yea thanks Arthur, Just got that after I last mailed to this page!! Always
    something simple isn't it. Thanks for your help, I really appreciate it!!!
    Gill


    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >Gill,
    > You want to use the fact the the .text property of a text box is its

    DEFAULT
    >property - that is, if you just use the control name, that is the property
    >that is assumed, without having to name it explicitly. Naming the property
    >explicitly, in VBA, requires that the control have FOCUS. Using the default
    >property does NOT require that the control have focus.
    >
    > If you change the line:
    >
    >txtCustomername.text = rst("CustomerName")
    >
    >to
    >
    >txtCustomername= rst("CustomerName") (drop the .text)
    >
    >the error message should vanish, as if by magic.
    >
    >
    >
    >"Gill" <GMaloney@pbs.ie> wrote:
    >>
    >>Hi Arthur,
    >>Thanks for the response
    >>I know what you mean by having to assign the sql to a dB.(am using Access
    >>2000)
    >>I used the following
    >>
    >>Dim db as Database
    >>Dim rst as recordset
    >>set db = currentdb
    >>dim sql as string
    >>Dim VarCustNo
    >>VarCustno = cboCustomerNo
    >>Dim Fill as String
    >>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>Fill = Fill & VarCustno
    >>set rst = db.openrecordset(Fill)
    >>txtCustomername.text = rst("CustomerName")
    >>
    >>the thing about this is that I have to set the focus to the textbox everytime
    >>in order for that code to work and the code has to be in the customername
    >>textbox.
    >>I would prefer if the user could just choose the customerid number and

    get
    >>on with the rest of the screen instead of having to enter the customername
    >>textbox and the the address, phone number etc...
    >>It works with Listboxes, ie. if I fill the listboxes on lostfocus of the
    >>customerNo. But when I navigate through the records the listboxes don't

    >change
    >>data and I was having a problem saving teh info to the table.
    >>So what I wnat to do is pick a customer no from a combo box and then the
    >>other details fill in automatically from this without the user having to
    >>enter the text boxes, and that the navigation through records worked whne
    >>used!!
    >>
    >>
    >>
    >>
    >>
    >>
    >>
    >>"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>>
    >>>"Gill" <GMaloney@PBS.ie> wrote:
    >>>>
    >>>>Hello,
    >>>>I ahve a form whereby the user chooses a Customer No.
    >>>>Once the number is choosen I want that customers Name and Address to

    be
    >>>filled
    >>>>in!
    >>>>My problem is that I have put code into Lostfocus on the Customer no

    text
    >>>>box and I'm told that I can't use teh following to fill a textbox.
    >>>>
    >>>>Dim VarCustNo
    >>>>VarCustno = cboCustomerNo
    >>>>Dim Fill as String
    >>>>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>>>Fill = Fill & VarCustomerno
    >>>>
    >>>>txtCustomername = Fill
    >>>>
    >>>>I have tried this in a number of ways, but no luck with it!
    >>>>Any ideas
    >>>>
    >>>>Thanks for any help
    >>>>Gill
    >>>
    >>>
    >>>Gill,
    >>>
    >>>Your "Select CustomerNo from Customers..." is called SQL (for Structured
    >>>Query Laguage) and is used to get data from a database. YOu must connect
    >>>you application to a database, create a recordset (to hold the data) and
    >>>then execute the SQL command to retrieve the data.
    >>>
    >>>What tools are you using?(Which Office App are you using, since you are

    >>asking
    >>>this in the VBA News Group ?)
    >>>
    >>>Arthur Wood

    >>

    >



  9. #9
    Gill Guest

    Re: Fill a text box


    Thanks Arthur, that worked, always something simple eh!
    I had actually tried that originally but I must have been doing something
    else wrong at the time for it not to work! oh well!!
    Thanks allot, really appreciated
    Gill

    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >Gill,
    > You want to use the fact the the .text property of a text box is its

    DEFAULT
    >property - that is, if you just use the control name, that is the property
    >that is assumed, without having to name it explicitly. Naming the property
    >explicitly, in VBA, requires that the control have FOCUS. Using the default
    >property does NOT require that the control have focus.
    >
    > If you change the line:
    >
    >txtCustomername.text = rst("CustomerName")
    >
    >to
    >
    >txtCustomername= rst("CustomerName") (drop the .text)
    >
    >the error message should vanish, as if by magic.
    >
    >
    >
    >"Gill" <GMaloney@pbs.ie> wrote:
    >>
    >>Hi Arthur,
    >>Thanks for the response
    >>I know what you mean by having to assign the sql to a dB.(am using Access
    >>2000)
    >>I used the following
    >>
    >>Dim db as Database
    >>Dim rst as recordset
    >>set db = currentdb
    >>dim sql as string
    >>Dim VarCustNo
    >>VarCustno = cboCustomerNo
    >>Dim Fill as String
    >>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>Fill = Fill & VarCustno
    >>set rst = db.openrecordset(Fill)
    >>txtCustomername.text = rst("CustomerName")
    >>
    >>the thing about this is that I have to set the focus to the textbox everytime
    >>in order for that code to work and the code has to be in the customername
    >>textbox.
    >>I would prefer if the user could just choose the customerid number and

    get
    >>on with the rest of the screen instead of having to enter the customername
    >>textbox and the the address, phone number etc...
    >>It works with Listboxes, ie. if I fill the listboxes on lostfocus of the
    >>customerNo. But when I navigate through the records the listboxes don't

    >change
    >>data and I was having a problem saving teh info to the table.
    >>So what I wnat to do is pick a customer no from a combo box and then the
    >>other details fill in automatically from this without the user having to
    >>enter the text boxes, and that the navigation through records worked whne
    >>used!!
    >>
    >>
    >>
    >>
    >>
    >>
    >>
    >>"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>>
    >>>"Gill" <GMaloney@PBS.ie> wrote:
    >>>>
    >>>>Hello,
    >>>>I ahve a form whereby the user chooses a Customer No.
    >>>>Once the number is choosen I want that customers Name and Address to

    be
    >>>filled
    >>>>in!
    >>>>My problem is that I have put code into Lostfocus on the Customer no

    text
    >>>>box and I'm told that I can't use teh following to fill a textbox.
    >>>>
    >>>>Dim VarCustNo
    >>>>VarCustno = cboCustomerNo
    >>>>Dim Fill as String
    >>>>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>>>Fill = Fill & VarCustomerno
    >>>>
    >>>>txtCustomername = Fill
    >>>>
    >>>>I have tried this in a number of ways, but no luck with it!
    >>>>Any ideas
    >>>>
    >>>>Thanks for any help
    >>>>Gill
    >>>
    >>>
    >>>Gill,
    >>>
    >>>Your "Select CustomerNo from Customers..." is called SQL (for Structured
    >>>Query Laguage) and is used to get data from a database. YOu must connect
    >>>you application to a database, create a recordset (to hold the data) and
    >>>then execute the SQL command to retrieve the data.
    >>>
    >>>What tools are you using?(Which Office App are you using, since you are

    >>asking
    >>>this in the VBA News Group ?)
    >>>
    >>>Arthur Wood

    >>

    >



  10. #10
    Tonny H Guest

    Re: Fill a text box


    Pretty stupid it is in VBA you cannot use text1.text, however, text1.value
    will do your job. In VB, text1.value is non-existance

    -t-

    "Gill" <GMaloney@PBS.ie> wrote:
    >
    >Thanks Arthur, that worked, always something simple eh!
    >I had actually tried that originally but I must have been doing something
    >else wrong at the time for it not to work! oh well!!
    >Thanks allot, really appreciated
    >Gill
    >
    >"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>
    >>Gill,
    >> You want to use the fact the the .text property of a text box is its

    >DEFAULT
    >>property - that is, if you just use the control name, that is the property
    >>that is assumed, without having to name it explicitly. Naming the property
    >>explicitly, in VBA, requires that the control have FOCUS. Using the default
    >>property does NOT require that the control have focus.
    >>
    >> If you change the line:
    >>
    >>txtCustomername.text = rst("CustomerName")
    >>
    >>to
    >>
    >>txtCustomername= rst("CustomerName") (drop the .text)
    >>
    >>the error message should vanish, as if by magic.
    >>
    >>
    >>
    >>"Gill" <GMaloney@pbs.ie> wrote:
    >>>
    >>>Hi Arthur,
    >>>Thanks for the response
    >>>I know what you mean by having to assign the sql to a dB.(am using Access
    >>>2000)
    >>>I used the following
    >>>
    >>>Dim db as Database
    >>>Dim rst as recordset
    >>>set db = currentdb
    >>>dim sql as string
    >>>Dim VarCustNo
    >>>VarCustno = cboCustomerNo
    >>>Dim Fill as String
    >>>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>>Fill = Fill & VarCustno
    >>>set rst = db.openrecordset(Fill)
    >>>txtCustomername.text = rst("CustomerName")
    >>>
    >>>the thing about this is that I have to set the focus to the textbox everytime
    >>>in order for that code to work and the code has to be in the customername
    >>>textbox.
    >>>I would prefer if the user could just choose the customerid number and

    >get
    >>>on with the rest of the screen instead of having to enter the customername
    >>>textbox and the the address, phone number etc...
    >>>It works with Listboxes, ie. if I fill the listboxes on lostfocus of the
    >>>customerNo. But when I navigate through the records the listboxes don't

    >>change
    >>>data and I was having a problem saving teh info to the table.
    >>>So what I wnat to do is pick a customer no from a combo box and then the
    >>>other details fill in automatically from this without the user having

    to
    >>>enter the text boxes, and that the navigation through records worked whne
    >>>used!!
    >>>
    >>>
    >>>
    >>>
    >>>
    >>>
    >>>
    >>>"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>>>
    >>>>"Gill" <GMaloney@PBS.ie> wrote:
    >>>>>
    >>>>>Hello,
    >>>>>I ahve a form whereby the user chooses a Customer No.
    >>>>>Once the number is choosen I want that customers Name and Address to

    >be
    >>>>filled
    >>>>>in!
    >>>>>My problem is that I have put code into Lostfocus on the Customer no

    >text
    >>>>>box and I'm told that I can't use teh following to fill a textbox.
    >>>>>
    >>>>>Dim VarCustNo
    >>>>>VarCustno = cboCustomerNo
    >>>>>Dim Fill as String
    >>>>>Fill = "Select CustomerName from Customers where CustomerNo = "
    >>>>>Fill = Fill & VarCustomerno
    >>>>>
    >>>>>txtCustomername = Fill
    >>>>>
    >>>>>I have tried this in a number of ways, but no luck with it!
    >>>>>Any ideas
    >>>>>
    >>>>>Thanks for any help
    >>>>>Gill
    >>>>
    >>>>
    >>>>Gill,
    >>>>
    >>>>Your "Select CustomerNo from Customers..." is called SQL (for Structured
    >>>>Query Laguage) and is used to get data from a database. YOu must connect
    >>>>you application to a database, create a recordset (to hold the data)

    and
    >>>>then execute the SQL command to retrieve the data.
    >>>>
    >>>>What tools are you using?(Which Office App are you using, since you are
    >>>asking
    >>>>this in the VBA News Group ?)
    >>>>
    >>>>Arthur Wood
    >>>

    >>

    >



  11. #11
    John Maloney Guest

    Re: Fill a text box


    Gill, I recently went thru the same thing. Really, the easiest way to fill
    the textbox is by using the DLookup funtion in the Change event of the combo
    box.

    Public Sub cboCustNo_Change()

    Dim strCustNo as string
    strCustNo = Me.cboCustNo.value
    Me.txtCustName = DLookup("[Customer Name]", "Customers", _
    "[Customer Number] = '" & strCustNo & "'")

    End Sub





    "Gill" <GMaloney@PBS.ie> wrote:
    >
    >Hello,
    >I ahve a form whereby the user chooses a Customer No.
    >Once the number is choosen I want that customers Name and Address to be

    filled
    >in!
    >My problem is that I have put code into Lostfocus on the Customer no text
    >box and I'm told that I can't use teh following to fill a textbox.
    >
    >Dim VarCustNo
    >VarCustno = cboCustomerNo
    >Dim Fill as String
    >Fill = "Select CustomerName from Customers where CustomerNo = "
    >Fill = Fill & VarCustomerno
    >
    >txtCustomername = Fill
    >
    >I have tried this in a number of ways, but no luck with it!
    >Any ideas
    >
    >Thanks for any help
    >Gill



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center