Is Access Code syntax same as Excel Visual Basic?

[VAer]

Are those two same, in general?

Thanks.

[Robyn_P]

Not quite but they're very similar. Dim for variables is the same, dlookups, if, when, do loops etc all the same. If you can code in Excel, you should be able to code in Access pretty easily. The main difference is obviously what it is you're coding. I don't code in Excel very often these days, but did have to last week and the transition was pretty simple. Little bit of Google help but that's it.

[VAer]

Not quite but they're very similar. Dim for variables is the same, dlookups, if, when, do loops etc all the same. If you can code in Excel, you should be able to code in Access pretty easily. The main difference is obviously what it is you're coding. I don't code in Excel very often these days, but did have to last week and the transition was pretty simple. Little bit of Google help but that's it.

Thanks. I am on the opposite side, I only code with Excel.

[alansidman]

This may be a helpful start. http://www.functionx.com/vbaccess/Lesson01.htm