Consulting

Results 1 to 6 of 6

Thread: Sleeper: A form to Scan Barcodes & Display already scanned codes in a subform

  1. #1

    Question Sleeper: A form to Scan Barcodes & Display already scanned codes in a subform

    Hello all,

    I have a form set up with a continuous sub form.

    Basically, the main form should accept a number (from a scanned barcode) and the scanner has an enter after scan function so it would enter the information to a new table record and I could scan again. Now that I've added a sub form to display already scanned codes. it will instead tab to the sub form. The sub form is set to not be editable, but I would like a way so that nothing else is clickable/tab-able on this form, as I would also like to add buttons in the future.

    Question: How can I make all objected except for the main form entree box intractable except for mouse clicks.

    Thank you.data base snip.jpg

  2. #2
    VBAX Tutor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    217
    Location
    Maybe set each control as enabled/disabled individually? Also set TabStop to No.
    How to attach file: How to upload your attachments (vbaexpress.com) To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    VBAX Expert Logit's Avatar
    Joined
    Sep 2016
    Posts
    588
    Location
    Posting your existing workbook is the best means of receiving assistance. Pics are nice but don't really serve any diagnostic purpose. Volunteers are not inclined to recreate your workbook from scratch to assist you.

    You can click on the GO ADVANCED button in the lower right corner when replying. There you will find a means of attaching your workbook.

    Thanks.

  4. #4
    VBAX Newbie
    Joined
    May 2023
    Posts
    2
    Location
    Maybe set each control as enabled/disabled individually? Also set TabStop to No.
    It's work

  5. #5
    VBAX Newbie
    Joined
    May 2023
    Posts
    2
    Location
    It works

  6. #6
    Banned VBAX Newbie
    Joined
    Jun 2023
    Posts
    3
    Location

    incredibox

    By setting the "Enabled" property to "No" for the selected objects, users will not be able to click or incredibox interact with them using the mouse or the tab key. However, they will still be able to interact with the main form entry box to scan and enter information.
    Last edited by davidjohnx; 06-08-2023 at 07:06 PM. Reason: change post content

Posting Permissions

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