Writing and learning code for Access, how to work it out tips

[djspod]

Hi,

I am now at this level of Access and VBA programming:

• I Understand Modules, Procedures, debugging and calling a procedure or function.
• Know how to link in with Access events (Open, on load, After Update etc.)
• Calling a Query, opening/closing a form
• Select Case - I know and understand part of this
• Left, Right and Mid functions - I know and understand most of this
• Loops ,Ffor Loops , Do Until loops - I have used some and have some knowledge on what they can do.
• Variables - I understand and know how to pass values around
• Lastly I am familiar with Iff statements and Goto
• Need a little exposure on Error handling

What I now need is some experience of solving a problem with some or all of the tricks above to get the level of some of the great programmers on this Forum.

I am learning via YouTube, Books, PC Courses etc. etc. but I now need the mind set of what you see when presented with an Access problem.
What's the process, paper pen? Break it down with one code function and then another to get to the end result.
I Imagine most of you are now know straight away what to use, what approach to take as I'm guessing most techniques apply to most problems.



Can any help myself by providing any examples of a problem, of what thought path you had and approach you had to solving it.

Any ideas, comments, book scenerios and examples you can provide I will be grateful!

Thanks

Darren

[andy49]

To be honest Darren I was once in your position and I just started trying to solve some of the issues on here when people were kind enough to leave their db here

Practise as they say, makes perfect

[orange]

See this link/post for more info

Good luck

[djspod]

Thanks for the answers guys, I'll have a look at them all.

I've been watching the Steve Bishop ones for a while and I learnt loads from his great video tutorials.

It's mainly for me the problem, Analysing it, breaking it down and getting fluent in my approach to solving the puzzle with different methods, just struggling to get that to go in and click into place with myself.

[orange]

OK. There are a number of Analysis related "nuggets" from BA_Experts on youtube.
These are quite humorous in approach, but really do a good job on concepts and techniques.

There are several subjects in these nuggets.
See this for starting point.

Enjoy. Let us know what you think.

If you have specific/general problem re approach to something, post it and you'll get responses.

[djspod]

Thanks Orange, Good flow charts and thought provoking.

I'll check these out too.

Thanks for taking time to answer.

Cheers

[orange]

Happy to help
Good luck