learn advanced access + vba tecniques

[GoodCat84]

hi all

I need to learn advanced access + vba tecniques can you suggest a book for this scope?

Thanks

 

[gemma-the-husky]

2 good ones

technical reference: vba developers handbook getz & gilbert

examples of practical use. Access cookbook (o'reilly press)

 

[GoodCat84]

Thanks a lot!

I read that Access 2013 is quite different from older version, but I have not understood if study vba, and in general study access 2010 or 2013, is still usefull or if it is better to change language and sw and jump for i.e. to programming in java.
At work we have Access 2010 but I fear that in a near future we will update to Access 2013! So my efforts will be futil....
Moreover, with Access, you can't run a program without Access software ... or am I wrong?

What do you think about?

Thanks again!

 

[gemma-the-husky]

the look and feel of access is rather different.

I actually liked A97, then got used to A2003 - but I do struggle to like the interface from A2007 on.

The VBA behind the scenes is very similar. They add a few extra instructions into the VBA, but it's basically the same.

 

[namliam]

Access cant run without access, or access runtime version...
Much like excel cant run without excel or word without word....

Biggest "breaking point" of 2013 is it no longer supports databases with the extension of MDB (I believe 97 and older databases). They MUST be converted to ACCDB format/extension.

This and a bug regarding the DoCMD.Transferspreadsheet possibly introduced by a mix of running 2013 and 2010... but also encountered already in earlier versions (2003 and 2010) ... which is REALLY annoying.... Those 2 are the only noticable differences to 2013 as far as I am concerned.

 

[gemma-the-husky]

is office 365 the same as office 13?

I can use mdb's in office 365?

it shows as access 13 in help/about

 

[namliam]

Yes as far as I am aware Office 365 == Office 2013, one small difference may be that Office 2013 is also a standalone version ( I believe ) where as Office 365 is a cloud service.

Any MDB I open I get "Cant open a database from an older version" and am forced to migrate it over to atleast 2010 (I think) accdb
Perhaps if the (source) mdb is 2.0 or 97 vs any other version that used MDB as extension instead of accdb which may make a difference?
Most 'my' mdb's actually still source from 2.0, actual mdb solutions that already live for 20 years or more despite the (usual) resistance to the Access "crap" solutions that I make, I still chuckle when people go "*sigh* not that access shit again? Why is it still around?"

Or go "oh damn can never ever make June 1, must push it back to Aug 1... its Impossible!"
Me: Need it by June 1? Why not get it by May 1st? Wouldnt that be much better?

LOVE IT when you joke with IT people like that

 

[gemma-the-husky]

Yes as far as I am aware Office 365 == Office 2013, one small difference may be that Office 2013 is also a standalone version ( I believe ) where as Office 365 is a cloud service.

Any MDB I open I get "Cant open a database from an older version" and am forced to migrate it over to atleast 2010 (I think) accdb
Perhaps if the (source) mdb is 2.0 or 97 vs any other version that used MDB as extension instead of accdb which may make a difference?
Most 'my' mdb's actually still source from 2.0, actual mdb solutions that already live for 20 years or more despite the (usual) resistance to the Access "crap" solutions that I make, I still chuckle when people go "*sigh* not that access shit again? Why is it still around?"

Or go "oh damn can never ever make June 1, must push it back to Aug 1... its Impossible!"
Me: Need it by June 1? Why not get it by May 1st? Wouldnt that be much better?

LOVE IT when you joke with IT people like that

BIB

I think it's that. A97 has to be converted to A2003 first, then they will open in later versions.

office 365 offers cloud but it isn't exclusively cloud by any means. It works standalone with no problem. I got it because I needed outlook, tbh.

I know what you mean. I didn't use A2.0 but got on very happily with A97, and still have a lot of stuff that has just been converted to A2003, without any other changes.

Yes, they added bits like InStrRev, and other bits that came in handy, but the core functioned perfectly well. Small footprint, and fast execution.

 

[namliam]

BIB ?

Biggest drawback of access still is in the filesystem, only 2 gig filesize and the network traffic generated by the I/O of an average size DB is quite shocking

 

[gemma-the-husky]

bit in bold