Recent content by Mtdew4243

This reply is to both Uncle Gizmo and sneuberg. First sorry for the delay in responses and Thanks for all the information! Phase one of the project is now complete which is why I was absent for awhile. Phase two starts in two to three weeks so, I have already started to redesign my DB in a...

Holly Crap... Thanks! The code is a bit above me but, what I have stepped through so far, makes sense. It will take me some time to step through it all. Please I can't ask you to do more. I get this is some code you had and modified but that is more than you should have done. I have...

FYI, the "G1" data string is over 255 so it needs to be in a long text field.

S/C = Skid / Carton, the barcode I scan when starting a new Master Carton Data = S-001/C-01. For Skid 001 and Carton 01. I know that 63 Master Cartons fit on 1 Skid so, I pre-printed them all. The 2nd Master Carton label is S-001/C02... The 1st carton of the 2nd Skid is S-002/C01. G1, UPC...

Uncle Gizmo YouTube link appears to be broken. Unless I can't get to it from the US. After /msacce... it shows the three dots like the entire link didn't post. Also, the one thing I liked about my solution, I only needed to scan a carton barcode once and then 18 serial numbers. Unless I'm...

I have had a entry level Access class two years ago and do remember some thing of normalization. (Though this current DB wouldn't prove that.) And I understand that for maintaining long term databases the need to structure them appropriately. The last thing I want to do is upset anyone here...

Here is a blank DB of what I did.

Attached are screen shots of the Table and Form. I get the desire to have all the serial numbers in one field. But, I needed a really simple way to capture the data. By using a Form and a hand held scanner, the warehouse associate (limited PC skills) just needed to scan barcodes. As part of...

Newbie Question #3: First, Thanks to Everyone who have been so helpful on all my previous questions regarding this current project. Not sure this should be posted under Form or Table but here goes. (Also not sure if my explanations are to verbose but, I want to make sure everyone understands...

Thanks All!, Once I created the "Join" field in my table as Long Text and performed an Update query, all is good. When I first attempted a join, I was just creating it in a new query column and gave it the name Join (w/o having it in any table) before typing the formula. Doing it that way...

Hello All, I need to generate a concatenate around 262 characters. But when I try, my results get truncated. Is it possible to make a concatenate in long text? I have created a simple Form to capture the carton id, and then 18 product serial numbers. I then created the concatenate query to...

To Pyro, HUGE Thanks! That worked perfectly. (It also reminded me of where to look in my class notes to the solution. :o) MtDew

Hello, I have seen the post on Union All and manage to make that work. My need has a twist in that I want the current primary key to be repeated in each new record. I have records containing 19 fields, a Carton ID and 18 Serial Numbers. I want the Carton ID repeated in each new record (Col1)...

I've taken an intro Access class but still need more help. Thanks in advance to anyone that will take pity on me!