Results 1 to 4 of 4
  1. #1
    acm007 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    12

    Question How to prevent a barcode from being deleted from a form?

    Click image for larger version. 
<br /><script async src=
    Name: 002.jpg  Views: 18  Size: 92.8 KB  ID: 32525" class="thumbnail" style="float:CONFIG" />


    In this application I have two forms:

    1) Where the employees needs to enter some information such as: Customer Name, Purchase Order number, etc.
    2) Where they scan items.

    I have already blocked all fields from the subform, however, I cannnot block the barcode filed as the cursor needs to be "blinking" in order for the employees to scan an item.

    The problem that I have it that if the employee wants to delete the items which were already scanned, all he has to do is hit the backspace button (or delete button) and the whole line is deleted. I would like to prevent that from happening. I have thought of trying to block these two keyboard keys so they are disabled on the subform, however i am not sure that this is the best way to solve this issue. Does anyone have any suggestions?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    What you can do is disable the control with conditional formatting once a value has been entered. The rule would be

    Field Value is...Greater Than..."" and select the disabled option

    This will grey it out

    You can prevent the user from deleting the row by changing the form properties for allow deletions to No

  3. #3
    acm007 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    12
    Hi Ajax,

    I am relatively new at access. I did the first step but was no able to find the "disable option". Nevertheless it worked, so thank you very much for your help! Screenshots below:
    Click image for larger version. 

Name:	005.JPG 
Views:	13 
Size:	40.8 KB 
ID:	32545
    Click image for larger version. 

Name:	006.JPG 
Views:	13 
Size:	34.6 KB 
ID:	32546

    I did not have to do the second part "You can prevent the user from deleting the row by changing the form properties for allow deletions to No" but when I tried it caused other problems in the database.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    the disable option is the one you have highlighted - looks like a letterbox

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Is this barcode a working barcode?
    By panoss in forum Access
    Replies: 2
    Last Post: 11-06-2014, 10:10 AM
  2. Date/Time Stamp on barcode input form
    By computersnack in forum Access
    Replies: 3
    Last Post: 04-30-2014, 07:11 PM
  3. Barcode input form
    By computersnack in forum Access
    Replies: 1
    Last Post: 04-24-2014, 01:05 AM
  4. delete query produce #deleted in all deleted values
    By learning_graccess in forum Queries
    Replies: 2
    Last Post: 03-31-2012, 07:20 AM
  5. #Deleted On form
    By terryvanduzee in forum Forms
    Replies: 2
    Last Post: 10-23-2009, 07:07 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums