Recent content by pezman38

I have a table in my Database that uses the feilds Location and partnum. I use a barcode scanner to generate each of these fields. The problem I am having is that when our part number is scanned it contains data such as "des--. 123456 --aa". I have been doing a find/replace on this data to...

I am trying to enter multiple parts into the same field and using commas to separate them. Is there a way to create multiple records with the same information, but change the part numbers in them according to comma's? Would look like this. Primary Key Location Part number 789...

I need to be able to change that logic as I go. Different parts have different lengths to them. One could say aaa- another could be a-. So if possible I would need if logic to decide what label the part has, and whatever code after that to pull out just the part.

I am using a handheld scanner to scan in barcodes. However the part numbers contain more data than I need. Is there a way to get ride of the extra data I scan in in Access. Say I have part ABCD- 7G675 .. I only need 7g675 to be in the field. Is there a way to do this besides a find...

I created a couple database tables to link with my RF scanner for use in a warehouse. Is there anyway that I can take a masterfile table and select 100 records, cut them out and paste them into a new table to import into the handheld? I am pretty sure there is a way, just don't know where to...