Hi
I'm an Access, VBA developer with over 20 years experience.
I'm purely Access VBA, I've focused my career getting to knowing VBA inside and out. I've created hundreds of Access databases over the years, I'm self taught so I'm familiar with just about every mistake it's possible to make! Having honed my knowledge, I can write some truly inspiring pieces of code.
I'll be honest, I've never written a technical article before, however I do possess a very good level of English and my Access VBA is probably amongst the best there is.
Code examples.
I've written code in Access VBA where it takes a dynamic query, exports the data to Excel, creates a graph in Excel and copies the image of that graph to an image control in Access. The process is instant, as far as the user is concerned they are looking at a graph that was created in Access but with all of the features of using an Excel graph. The usr had the ability to change the graph type, apply filters to the graph data, etc.
I've also developed with some and drop tech using code to make a form Opaque, then using it's X and Y coordinates as an overlay to the form underneath. The end result is moving objects around a form with left and right click options.
I use Crosstab queries a lot in my Access databases especially when creating Dynamic data sets. All fine until you try and display a dynamic form. I have code that deals with this.
I look forward to hearing from you.
Kind Regards
Darren