Recent content by AJGarriton

got it!!! thanks again

INSERT INTO Studies (Product, MBRStatus, Dating, StudyStatus, StudyLot, Distributor, Manufacturer, SupplierNDC, Method, Lab, BlisterMaterial, FormTool, SealTool, QuotedIntervalCost, SpecialInstructions, QtySmpPerInterval, Bracketed, GenericPC, ProductCode, FamilyID, DateCreated, MBRRev...

All of your help is so valuable! This has certainly been an education for me. I am still getting an error. The error now is 3061, expecting 2. I put the location of the error in red text below. I have double checked all the spelling of my fields. I'm using the csql function as provided...

Thanks for such quick responses. Yes, I have some currency fields and number fields. I will work on this tomorrow. You are teaching me much!!!

Your help has been invaluable. I now have most of the cost working for my specifics, however, I'm getting an error I can't seem to identify and correct. Here is my actual code" Public Sub DuplicateLots() Dim strSQL As String Dim strSQL2 As String Dim rs As DAO.Recordset Dim rsChild As...

Here is some data: StudyTable (main table) Study ID StudyLot Product 1 A21 Acetaminophen 2 A21 Ibuprophen 3 A20 Naproxen 4 A21 Loperimide StudyIntervalTable (sub table)...

can you help me with the VBA? Main Table = StudyTbl Fields = StudyID, StudyLot and Product SubTable = IntervalTbl Fields = IntervalID, StudyIDLink, TimePoint So, I have query "annualstudyqry" that identifies the records in the Main Table that I want to duplicate. Thanks so much!

I have a database used for tracking product testing. I have a study table which has all the information for a specific study which is then linked to a table that has the details for the different timepoints (study interval table) the samples must be tested. Many product have annual testing...