Search results

Novice here. Yoda are you there? I have to be doing something wrong. My Link VBA procdure took way less time than my Import procedure. I hate to do this but here is the nub of my import procedure. DoCmd.TransferDatabase acImport, "ODBC"...

Novice here. I exported a macro to a Module and learned quite a bit. I am trying to do an unattended procedure which will delete many records in a series of tables. It would stop to ask if I really wanted to delete the records. I decided Keypress would work to answer the question (being...

I want to convert answers from a survey to a different form. In Table1 my fields are SurveyID, Q1, Q2,Q3,Q4. I want to convert them to Table2 that has the fields SurveyID, Question#, Answer. At one time I knew how to do this in DOS Paradox scripting language with an array, some loops and...