Search results

Ben, ntp and Rich, Thanks. I was trying to create a text field with YYWW in Access. I'm not a VB person and figured out how to do it with many functions in Excel. I had to get to the custom format "00" to get 1/1/01 to come out 0101. "WW" is sweet. I used build and did something like...

Alexandre - looked there in my Access 97 - no day Seem to remember that too, from class or when I was on another system. Probably is in Access 2000. The turn warnings off and on worked great in the function. I am doing this for a client, so I want to make sure they have the protections of...

Pat - 2nd thanks this evening. Yep. I sort of knew that. Without taking out the stopwatch, both procedures seemed to take the same amount of time. Then it changed once I took out the stopwatch - by a factor of 10 or more! Could be other gremlins at work like my network and power of all...

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"...

Abby - thanks I will investigate your approaches. I picked up a "Visual Basic 5 Database, How-To" book published by Waite Group Press for 10% of its original price. It is a thick book but not really a see spot run learning kind of book. However between that, help and converting macros, I am...

Just the kind of thing I was looking for. I knew there was a better mousetrap. Thanks.

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...

thanks for the tip on arrays and the use of collections. Now I am beginning to understand - he said for the 20th time today.

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...