Recent content by palmer.rp

Thanks @June7 . This works. I inherited this dB; Sun = 1, and Sat = 7, so using '3' for Tuesday. Thanks again

Hi, In a single table I am updating the field Route_Class. Pretty straight forward. UPDATE workingtable SET workingtable.route_class = Switch( WorkingTable.Stop_ID = '04434MAXXIS', 'MAX-04434', WorkingTable.Stop_ID = '04434MICHELIN', 'MIS-04434', WorkingTable.Stop_ID = '04434TOYO TIRE'...

It does make sense Isladogs, my problem is I do not know how to. a) Something like this? or this? DoCmd.RunSQL "UPDATE NS_Import2 "SET NS_Import2.NS_RouteFileName'" & strFile & "' WHERE NS_Import2.NS_RouteFileName'IS NULL;" or Set rs = CurrentDb.??("NS_Import2") rs.AddNew...

Hi Gizmo, See attached. Tab separated.

Hi, Thanks for any assistance in advance. I have VB code using the DoCmd.TransferText which imports multiple files and loads the data into a table. I would like to add part of the file name as a value in a given field in the table. The table name is NS_Import2 The field name is NS_RouteFileName...

Hi, I am an avid user of MS Access; I have good Knowledge of Sql and db. I am a VBA rookie; I have achieved many changes and goals getting solved issues from Access Programmers site. Thank you for that. RP