Results 1 to 2 of 2

Thread: Help ...

  1. #1
    Join Date
    Jun 2004

    Unanswered: Help ...

    i have a database.mdb. In it theres a table called "database". I have 4 fields, one of which is called "block". A user need to enter only the number 1,2,3,4 and 5. The letter 'S' is automatic cos i've put "S"& in the input mask at the database. So when i change to datasheet view, the values under 'block' will have S1, S2, S3, S4 and S5.

    However, when i use Visual Basic 6.0 and create 4 'textbox' and 'data' which is use as a controller, only 1, 2, 3, 4 and 5 appear. Why is this so? Why doesn't the 'S' appear as well?
    Last edited by adiboy; 11-16-04 at 21:16.

  2. #2
    Join Date
    Nov 2004
    if you go directly to the DB and add the data does it adds the "S"?

    I have never use a mask within a database but usually the default values work when no data is entered to a particular field

    maybe you should add the "S" in VB and send it with block number entered by the user to the DB
    to err is human ; to really mess things up requires a computer

Posting Permissions

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