Recent content by m2boost

they all get imported and no issues. The problem is if field on the table that have "" on the data, that will will not import properly, basically nothing import on that line after the ". PatID WorkOrder Nest Qty Bd Feet Sales Order# Due Date Item # Item Description Ship To Num Ship To Desc A...

The VBA script I'm running is below Private Sub ImportButton_Click() 'Option Compare Database 'Option Explicit 'Function DoImport() MsgBox "This process will take a longer time - Please wait for another message to display", _ vbExclamation, _ "Attention! Attention...

It will check a table for ImportErros and the record error say Unparsable Record

I'm try to import a file into a table the is formatted using "" like I have one item description that will use a text as BACK "RAF" TWO the field on the table is setup as short text and when I run the script I get one error. This is using a vba script that will import a csv file into the table...

Thanks again jdraw, it was the last piece to the puzzle that I was missing. The DB just take a data dump (CSV) files and import them into a table on access then remove the CSV files from my network drive. I using that data to generate labels but as part of the data it tell me how many pieces...

That's perfect and simple! Thanks for the help jdraw!!!!! :D

Hi all, I had never done something like this and looking for some help. I have a Table ([tlbStickerData]) that contain a field ([Nest Qty]) and I'm looking to print a label report ("LblStickerData") but my output to be base on the [Nest Qty] from my table. I have all the format on my label...

Hi, I am not a super user with Access but I been working with Access for the passed 15 years or so, always learning and challenge with the power of it. Looks like an excellent forum and place to be, I'm looking forward to being part of it. Searching on google I had see a lot of stuff from...