AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question Hi,
Just a quick question I thought you could help me with. I have recently been using VB in Excel to do things. I am a beginner but not too novice with most VBA code that I write and I have seen all the things I can do in Excel. I dont know access well at all and I am a real novice in that but I do know it a little. Just kind of running around I saw that in Access you can code some VB scripts. Can you tell me what the difference is between coding scripts in VB access as opposted to VB in Excel? is the syntax about the same or would I have to learn a whole new way of writing my scripts. I would think there would be some differences but not many or am I wrong. Just curious.
Thanks
Vaughn
Answer There are major differences between Access VBA and Excel VBA (in fact there are major differences in all the application VBAs). Excel is very oriented towards manipulating individual or ranges of cells. Access is more oriented towards working with data in tables and on forms. So there is a learning curve between them. With Excel you tend to be manipulating single pieces of data, while Access deals with large sets of data. Another difference is that Access has many different interface components. While there are forms in Excel, you mostly deal with the actual spreadsheet.
Many of the functions are the same or similar, but the Collections of objects are very different.
However, 75% of programming can be summed up with IF...THEN...ELSE and LOOPING. The bulk of programming involves checking a value or set of values and performing some action based on the value. The other 25% is interface design. So, its just amatter of learning how to use those concepts within the language. I will say that I haven't done much with Excel VBA. My forays into it haven't been too sucessful. I find it more complex than Access VBA. But Access VBA is more powerful for designing full fledged applications.
You might find my book useful (shameless plug ;) )
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
"my background is derivative risk management but I am now working for an Oil company in derivates but it seems like knowing access and VBA with access is now almost a Prerequisite these days for any time of job you look for in my field."
Is it really? I'm looking for a job and I see lots of Excel VBA jobs in the derivatives and risk mgmt fields, but not much calling specifically for Access (which is why I'm still out of work :( ).
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
