Search results

Ok, new question. I want to make the database (a simple table) loop through every record in the field "Last4SSno" and extract the last 4 digits from "SSno" if the "Last4SSno" field is blank, or if the 4 digits in Last4SSno does not match the last 4 digits of "SSno". I have google searched for...

I know it's something simple like having an apostrophe instead of a quote or something similar, but I am missing it. Every extra pair of eyes helps, we're playing "Where's Waldo" with the error in the code! DoCmd.SetWarnings False If Me.txtLocation = "IN" And Me.txtRecordType = "M" Then...

Hello, geniuses of Access. I am trying to teach myself Access VBA coding to rework a tracker database that has been destroyed over the past year. The database consists of a single table containing some 2200 records with the following columns: LastName, FirstName, MI, Ssno, MOB, Med Status, Med...