Results 1 to 8 of 8
  1. #1
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    Barcode scanner for small project

    Hi,
    I need to make small shop with bar-code scanner system.
    First.
    I have entered all my items in table.


    my need now I want to start sell it.
    i made form i want when put that item with scanner read it and show to me
    the quantity i have and sell price.

    My filed names:
    barcodeno (type:text)
    quantity (number)
    sell price(number)

    Thx

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You may get some ideas here. It sounds very much like Inventory management.
    http://office.microsoft.com/en-us/ac...001123097.aspx

  3. #3
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    I will review it

    Hi,
    Friend thanks for that,I am reviwing it ,But where is barcode location in that database.
    my inventory will be with add with barcode scanner and sell in barcode too

    thx

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Google: access barcode inventory
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    I want to my my own

    Dear friends
    I found some peoples ask me to use google
    i need for small shop one user can some tell name of software which good for one only

    thx

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See if this gives you some ideas.
    http://www.granite.ab.ca/access/barcode.htm

    Follow and research some of these links.

    As has been said:

    Use Google and search terms along this group:
    Ms Access barcode inventory example tutorial

  7. #7
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    i am send my database with details info

    Salam,
    Friend so sorry for that,when u will see seller form then in that there is filed call barcode.
    i will put scanner reader in that filed i will search for barcode and give price,in case not find i want massage appear not found that item

    thx

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    This form is to enter record of item sold? It should have tbsell as recordsource, not tblmain. Actually, recordsource should be a join of the two tables, like:
    SELECT tbsell.Barcode, tbsell.Quinitity, tblmain.price FROM tblmain RIGHT JOIN tbsell ON tblmain.ID = tbsell.ID;

    No need for the subform, put those textboxes on main form. Make the price textbox Locked and no TabStop. Saving the calculated value of sum will require code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 08-08-2010, 01:10 PM
  2. Barcode Scan input
    By Nem3s1S in forum Database Design
    Replies: 4
    Last Post: 09-26-2009, 09:43 AM
  3. small if statement help please
    By taylorosso in forum Programming
    Replies: 16
    Last Post: 09-23-2009, 11:23 AM
  4. barcode
    By techker in forum Access
    Replies: 1
    Last Post: 02-21-2009, 09:04 PM
  5. Replies: 1
    Last Post: 12-30-2008, 08:58 PM

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