Access Help

Are you IN or are you out? (Not IN)

This is a part one of two-part on how you can make your queries much more powerful. In first part, we look at whether we're in or not. Part two can be found here. The IN clause is a great tool to have in your arsenal, it can allow your forms to be editable or filter forms using . What is the IN clau [...]

2021-06-10T10:01:32-05:00September 23rd, 2013|

New Access 2013 book, plus meet the authors!

Over the last year, I've been working on a book with Access experts and MVPs Teresa Hennig, George Hepworth and Doug Yudovich, focused on practical examples and techniques for building powerful Access applications. The book covers both new web apps and new solutions to client solutions. Here are few [...]

2022-07-26T03:24:23-05:00August 23rd, 2013|

Maximizing Code Reuse: Writing design-time automation

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 [...]

2013-06-14T19:31:29-05:00June 14th, 2013|

Email reports from Access as PDF attachments in Outlook

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 [...]

2017-02-06T22:06:28-06:00February 26th, 2013|

Please join me at Microsoft's MVP summit next year!

As I write this I'm on my way with Ben to the annual MVP conference at Microsoft's campus in Seattle. The annual summit last four days and all expenses but your flight and transportation on the first and last day are covered. (If you don't share a room with another MVP you do have to pay for half of [...]

2013-02-18T00:09:46-06:00February 18th, 2013|

Access 2013 is here, but where's the SQL Server upsizing wizard?

Office 2013 has gone on sale and already I've seen posts online from people asking about the SQL Server Upsizing wizard not found in the tool. It's no longer available The wizard was a causality in Access 2013 and frankly I say good riddance. I for one thought it was barely usable when it worked, si [...]

2013-01-30T20:21:04-06:00January 30th, 2013|

10 Questions you Should Ask your Access Developer

10 Question you Should Ask your Access Developer Companies are constantly looking for quality Microsoft Access developers, here are some questions to help you evaluate one: Do you provide quotes or estimates? If the MS Access consultant does not provide estimates, it's a major red flag. Quotes an [...]

2022-04-19T04:02:13-05:00January 11th, 2013|

Hello, this is your Access database calling, are you there?

Queries, reports and emails, all standard stuff for Access, but sometimes you  need more options, something innovative that will allow you to do more then you ever thought Access can do, thats where IF THIS THEN THAT comes into play, ( allows you to extend Access' capabiliti [...]

2012-11-28T19:41:42-06:00November 28th, 2012|

ADP, (Access Data Projects), Are no longer available – here are some tips

I was late to the ADP party, having discovered their power for a project I needed to do on a multi-franchise national database. I had started using a regular Access file but quickly grew disenfranchised with the record locks and other issues that propped up. The ADP proved great in both reliability [...]

2019-01-30T14:53:36-06:00November 16th, 2012|

Maximizing Code Reuse: Multiple Event Handlers

This is first part of two-part series discussing about maximizing code reuse. Part two is here. One coding technique that I feel is frequently overlooked in Access application is the fact that we can assign multiple event handlers to the same object event and/or share the same event handler among di [...]

2021-05-08T08:02:23-05:00October 22nd, 2012|
Go to Top