Is it possible?

Phorp

New member
Local time
Today, 04:40
Joined
Sep 7, 2007
Messages
8
Hello there. I am somewhat new to using Access. I have been using it since I was a little kid, BUT we never went into details past the table design. I need to design a db that has Inventory Numbers, Product Names, Description, Customer Name, Shelf Found On, ID Number, Date Sold, Amount Sold For, Shipping Price, Total. I want to print barcodes and attach them to each item. I have a POS scan gun, and I want to be able to scan the barcode and have a form or whatnot come up and ask me all the information that I listed above. Then when the item sells, I want to be able to scan the items barcode, bring up the records I entered before and input the fields: Date Sold, Amount Sold For, Shipping Price, Total. Then i want to be able to print a sheet with all that information and a copy of that barcode. So if I ever need to go back into my hard copies and say hey this doesn't look right all I have to do is scan that barcode. Is there a way I can do this? I have searched the forums for about 3 hours. I couldn't find what I was looking for so I registered and well here I am. I apologize if this is a 'newbie' question but I honestly don't know the answer to it. If anyone has any sample databases similar to what I need it would be greatly appreciated if you shared them with me. :] Thanks -Matt. I apologize I posted this in the wrong forum before.
 
As long as your barcode reader just outputs text to your computer, that shouldn't be any problem.

You would just need a field on a form which filters for whatever ID that your barcode is made for.

All you need is a free barcode font:

http://www.squaregear.net/fonts/free3of9.shtml

On your report for each item when you sell it you can have a field with large size set to that font and it will print the barcode.
 
As long as your barcode reader just outputs text to your computer, that shouldn't be any problem.

You would just need a field on a form which filters for whatever ID that your barcode is made for.

All you need is a free barcode font:

http://www.squaregear.net/fonts/free3of9.shtml

On your report for each item when you sell it you can have a field with large size set to that font and it will print the barcode.


Where do I paste those fonts at?
 
Open Fonts in the Control Panel.

Just drag and drop there to install.
 
Thank you so much. I understand all of this now. I just needed to know where to start. Thanks again. Kudos to you!
 
Got it working. I should just play with it more before I keep asking questions. Thanks :]
 

Users who are viewing this thread

Back
Top Bottom