Need Help In barcode Scan to Load the Item Detail in POS Subform

[ZKHADI]

Hi my respected teachers.

i need help in above subject. i am working on my POS i put image and database below.
in the image there is a list box of items on double click on any item it load into subform
but barcode is not connect because i dont know how do i connect. give me suggestion or work
in my uploaded database.
the item box is based on calculated query name ItemLiqQ1 and need to pick data from query or listbox because table is not calculated

waiting for reply

 

[Ranman256]

in the afterupdate event of the barcode box, run an append query to add that item to the target table
then refresh the subform so it shows: subfrm.requery

 

[ZKHADI]

I will try this

in the afterupdate event of the barcode box, run an append query to add that item to the target table
then refresh the subform so it shows: subfrm.requery

 

[Gasman]

I am curious, what do you intend to do with this POS system?

 

[ZKHADI]

I am curious, what do you intend to do with this POS system?

Use for my shop

 

[Gasman]

Use for my shop

TBH, whilst I can see the attraction of creating something yourself, I think you'd be better off just purchasing a regular POS system?

Who knows how long this will take you and it is not that an easy task?

Good luck anyway.

Edit: Could you afford something like this? https://squareup.com/gb/en/point-of-sale

 

[ZKHADI]

As I mentioned in your other thread, you would be better off hammering out the steps you need to take before you start undertaking any work. Your first step should be to successfully capture the barcode.

I usually capture the barcode into to an unbound text box. I do this because you don't necessarily want to store the barcode straightaway. For instance what happens when somebody scans something that isn't in your database? To tackle this possible error you need to scan the item, then search the list of products to see if the product actually exists! If it doesn't exist you tell the user that they've either scanned the barcode on the sandwiches they just bought in Marks and Spencer's, or they've got a new product which needs entering into the products table before it can be scanned into the line item table.

The other possibility is that the user may scan in 6 identical items now instead of having 6 line items added you might want to add one single line item and and show it as 6 items being added. What do you do if someone scans the item twice and it's added to the list twice question mark you will need the ability to scan it gain and remove it from the list.

More Info on my Website HERE:-

Barcodes - Nifty Access

Nifty Access Barcode Pagex Nifty Access Barcodes Home About Contact Barcodes Bar-codes along with a bar-code scanner can be a very useful feature to add to your database. You can quickly scan in serial numbers from mass deliveries of items / components. Bar codes are also very handy for managing...

www.niftyaccess.com

Yes i visited and i watched the video. but! i didn't see where is coding or example file?

 

[ZKHADI]

There isn't an example file/code.

However I can outline the steps you need to take.

First step, have you been able to capture a barcode into a text box with a barcode scanner?

i know how to capture a code in txtbox. but how to load information about that item which is scanned to the related boxes. like price quantity. if we scan again and again the quantity should be increase.

 

[ZKHADI]

not coming in my head

 

[wanmurat]

Hi my respected teachers.

i need help in above subject. i am working on my POS i put image and database below.
in the image there is a list box of items on double click on any item it load into subform
but barcode is not connect because i dont know how do i connect. give me suggestion or work
in my uploaded database.
the item box is based on calculated query name ItemLiqQ1 and need to pick data from query or listbox because table is not calculated

waiting for reply

create combox and point to location to sending, refer attachment