Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    49

    Unanswered: check content in textbox.

    Hi,
    My project is in MS Access 2002.
    In that I have two forms which I am using for Shipping Entry.
    Now First Form(ShippingAlerts) Is fillup by persons working in customer services.and the Second Form(ShippingEntry) is fillup by workers operating Hi-Low machines to put Boxes in Trucks.

    Now In First Form(ShippingAlerts)I have some fields like
    AutoNo,BillToAddress,ShipToAddress. and some other like
    CustomerCode,ItemNo,PONo,LONo,PalletNo etc.all fields in this line are dependent fields.
    AutoNo is automatically generated.and allocated to one ShippingAlert Form at a time.
    Now in that Form when person select Customer from CustomerCode(ComboBox) then it will generate list for another ComboBox(ItemNo).Now when person select Item form ItemNo(ComboBox) then it will generate list for PONo(multiple select ListBox).same thing happen when select PONo(multiple select ListBox) then generate list for LONo(multiple select ListBox).and when select LONo(multiple select LIstBox) then generate list for PalletNo(multiple select ListBox).Now person have to choose which PalletNo he has to ship from that list.when he select mutiple PalletNo from list then it will automatically enter in new TextBox(FinalPalletNo).in that value is like this
    24914;24913;24912;24905;23105;;23205.
    Here I used ";" to seperate PalletNos.and sometimes there is no PalletNo then it will be like ";;" as I shown in upper line.

    Now In Second Form(ShippingEntry) person working on machine has to select AutoNo of First Form(ShippingAlerts).So it will automatically fill some fields from that form.like
    BillToAddress,ShipToAddress And value TextBox(FianlPalletNo) allocated to Another TextBox(PalletNo) on this form.
    Now person working on machine scan the barcode of PalletNo and automatically it will enter data regarding that PalletNo in form.At the same time I want to higlight the same PalletNo in that TextBox(PalletNo).So person will know which PalletNo are remainng and which already done.I can do this thing if single value in TextBox(PalletNo).But there is value like this
    24914;24913;24912;24905;23105;;23205
    So I don't Know hos to seperate it


    Anyone have solution to this problem then plz give me.
    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Billy

    Your problem here is you are violating the first normal form. You will continue to have problems with this model. Any data in a column should be atomic.

    In any event, it is not possible to highlght a portion of text in a texbox. Unless you mean select a portion. But I would still strongly urge you to look up normalisation - this road you are on is littered with problems.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912

Posting Permissions

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