This is part two of two-parts on maximizing code reuse. Part one focused on assigning more than one event handlers to same object's event or sharing an event handler for several objects. We now turn to looking at how we can write design-time automation to help us save time in coding. If you enjoy lo [...]
It's that time of the year again folks, where the Access team is debating what to include, fix or remove from the next version of Microsoft Access, and if past history is any notion of what to expect, don't expect anything to change on the client side: no new IDE tools, no new coding tricks, nada. * [...]
What does "moving Access application to the cloud" mean? It means you are moving your data to a hosted SQL Server database on the web. You no longer have the data locally and you are still running the Access frontend locally. You may or may not have some tables local, but for the most part, all of t [...]
Working with SQL Server and Access can be challenging, here are 10 things you should know about SQL Server and Access: Using a pure Access solution, (no SQL Server), is almost impossible over VPN, but not a problem at all with SQL Server as your backend. Every table should have a timestamp field, bu [...]
As Access Developers we deal with projects, both small and large, that may span hours or months. Our time is valuable, so it's important we are effective from start to finish with our client's projects, in particular with new and large ones. To that end we hold a Project Kickoff Meeting as our first [...]
On my Access with SQL Server group at LinkedIn, one of our members posed the follwoing question: ADO or DAO for new development work? Let's break it down The question implies DAO or ADODB are mutually exclusive, but they are not. You could easily create an Access app using just DAO that would work j [...]
I've talked about using a recordset with stored procedures before, but this time I wanted to emphasize the importance of always using a recordset when executing a stored procedure from Access VBA. Command Object does not cut it Usually a programmer will use a command object to execute a stored proce [...]
This week's post is by Manuel Perez, a web developer working in our web division at IT Impact, Inc. Manuel has been experimenting with Amazon's EC2 cloud service and I asked him to document how to get started on the service, and pave the way for our readers to start experimenting with their own clou [...]
For some time now I've been posting articles on LinkedIn MS Access groups. The posts vary the gamut, from Access topics to management posts. I've enjoyed the discussion and feedback on the boards, and now I've decided to create a new group: The reasons why I've decided to create my own group on this [...]
Today we launched a new domain and look for our site! We have moved all of our content over to AccessExperts.com and have redirected all content from our old site to our new one. The new design offers two great benefits to the older design: The new site uses Responsive WordPress theme that allows us [...]
I LOVE integrating Access with Outlook, it's really easy to create a system that allows our clients to export reports as PDF attachments in an email. Objective: Email pdf invoice to a recipient using Outlook. Needed Option table to hold templates for the Subject and body of email. Make sure client t [...]
