I panic'd there - I have typed this code so many times without the MoveNext I thought I had done it again.... My laptop has a built in function to tell me when I have made this mistake - The processor fan starts going like a jet engine!
loop through a table (vba)
- Thread starter lala
- Start date
boblarson
Smeghead
- Local time
- Today, 09:23
- Joined
- Jan 12, 2001
- Messages
- 32,059
Thanks, now I know how Pat Hartman must have felt when I said the same thing to her several years ago
Hard to say really. I'm mostly self-taught, so I have learned what I needed when I needed it. If I haven't needed it, I probably haven't learned it (some things yes, but mostly no). For example, I don't know a lot about the User Level Security (of course it is gone with the new file formats) as I only used it ONCE about 10 years ago. I've played with it a little just to familiarize myself with it for answering simple questions here and on other forums, but I'm in no way an expert on it.
Also, ADO and DAO. I know enough to be dangerous, but I can't explain the details behind some of it. I look to LPurvis (Leigh Purvis) and datAdrenaline (Brent Spaulding) for that. I have had some of it explained to me, by them, over and over and over again and yet I can't retain most of it at this point.
Writing SQL by hand is something I don't normally do. I use the QBE grid most of the time to set things up and then I modify it if necessary. If I see a very long string of SQL, I'm likely to "Shut down" as I just can't seem to digest it. I've gotten better over the years and can handle longer strings than I used to, but I still have troubles with very long SQL code.
So, anyway, I find that there is always something new to learn about Access. I guess that is what keeps it fresh. I don't think I have to worry about knowing it all as it is hard enough to keep up with one version and another version comes out, with changes. For example, now we have to learn DATA MACROS in Access 2010. And there is a whole lot of other new stuff in 2010 as well to work on.
So, just progress at your pace and don't worry that you don't know it all. It is all relative. You can help someone else coming up behind you and you just keep learning and passing it along and pretty soon you'll be amazed at how far you've actually come. I know it took me about 8 years on the forum here before I really "got it" and started answering posts on a blistering pace. Before I would hesitatingly answer questions, but something clicked about 3 or 4 years ago and that was great.
One thing I did do to learn was to find questions posted on the forum that I wanted to know the answers to. I subscribed to these posts (you can do that without answering, did you know?) and then when someone answered I got email notification and came back and looked. I learned a lot that way without having to post questions myself.
Though embarased as I am to say it I do it way too often!my case exactly, and ive never had a problem that i didn't eventually solve either. so the things that i don't know are things i haven't had to use, not i couldnt learn
what do you mean it's gone with the new file formats? there's no user security in the 07 version?
)))))))))))))))))))))))))))))))))))
that's another thing like the declarations, on my list of things to learn
i'm not even to being able to be dangerious level
what's that? i use this little program someone has wrote to convert sql to vba, but looking for something better
i like your manner of writing))))))))))))))))))
what's that?
and are you the person that always says that you don't use macros? or it's someone else?
also, macros are usually just the easy way to code, no?
blistering pace it is. you're always the first one and 99% the correct one. i sometimes wonder where you get the time
my version of doing this is just reading the forum when i have free time
i just go from thread to thread and read
it's always useful
i praise this forum every chance i get
every time i was stuck and was 100% sure that noone can answer my question it was answered here.
so thank goodness that you and people like you don't mind spending your time on helping others
i understand that it's interesting to you too, it's like a test in a way, or an excersize
but still, even if you do it for your own pleasure, thank goodness you feel the need)))))))))))))))))))))))
Funny you saying that about BOB - I tend to feel the same looking at his posts! - Bob you must be blushing by now...!
i'm sure)))))))))))))))
but ive been coming to this forum for about 8 years and even though we never spoke, him and Pat (whom i never spoke with either) are the only 2 people whose nicks i know because they answer 99% of all the questions
