Access / VBA guide
In the Open Standard
James BarnesMember for 19 years 1 month
- Created
- 4
- 3
0
Can anyone recommend a good Acces / EXCEL / VBA & SQL guide.
I have a good knowledge of both Access and Excel GUI use but not how to implement scripts macros and all that. Specifically I’m after being able to use the linked Pervasive ODBC access tables to produce automated worklists, 3 day lookaheads, progress reports etc either outputting them to Access reports or to Excel sheets for graphing etc. I am making progress on this on my own, but it would be useful to have some sort of reference guide to refer to
So, the guide should provide me with;
- advanced tools in the Access / Excel GUI
- VBA and SQL scripting guide for Access and Excel
- VBA and SQL reference and syntax guide, general and specific to Access / Excel
- How tos for common tasks
- a tea maker and possibly a cigarete roller
Thanks
I have a good knowledge of both Access and Excel GUI use but not how to implement scripts macros and all that. Specifically I’m after being able to use the linked Pervasive ODBC access tables to produce automated worklists, 3 day lookaheads, progress reports etc either outputting them to Access reports or to Excel sheets for graphing etc. I am making progress on this on my own, but it would be useful to have some sort of reference guide to refer to
So, the guide should provide me with;
- advanced tools in the Access / Excel GUI
- VBA and SQL scripting guide for Access and Excel
- VBA and SQL reference and syntax guide, general and specific to Access / Excel
- How tos for common tasks
- a tea maker and possibly a cigarete roller
Thanks
4 replies
Oldest first- 0Alexandre Faulx-Briole ·James,
do you read french? www.editions-eni.com has plenty of things for you, i.e.
VBA Access 2007 - Programmer sous Access
Auteur : Michèle AMELOT,
C# 2.0 et SQL Server 2005
Maîtrisez le développement et l’accès aux données
Auteur : Jérôme GABILLAUD - Hervé BERTHET
and many others
Alexandre - 0James Barnes ·My french is servicable in a bar or down at the market, but not good enough to read technical manuals!
Actually, I think I’m going to give the O’Reilly "integrating Excel and Access" a whirl, I have a few of their books already and they seem to take an approach that suits me.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?