Archive for the ‘Access’ Category
Wednesday, September 10th, 2008 81 views
Here is a simple UDF that adds an appointment to your Outlook calendar. It can be used from Excel or VBA, and it should be usable from Access as well (untested). It uses another concept I've also been trying out: checking functions to make sure they are successful by using ...
Posted in Access, Excel, Outlook, UDF, VBA, automation | No Comments »
Monday, February 4th, 2008 592 views
Back in January, I promised to post a macro that imports data from Excel into Access programmatically.
(See My First Access Macro.)
It takes a given spreadsheet and imports it into a given Access file/table. The spreadsheet must have a header row, with no blank rows or columns inside the table block. ...
Posted in Access, Excel, VBA, automation | No Comments »
Thursday, January 31st, 2008 17 views
Here is the revised and completed code that I posted yesterday. The DAO declarations are moved outside the Sub procedure and the 'Set' statements are outside the function loop. Also, the table & column headers are now passed as arguments to the function, making the code more compact. The speed ...
Posted in Access, Excel, VBA | No Comments »
Wednesday, January 30th, 2008 37 views
Finally, with some help from the good folks over in the microsoft.public.access.modulesdaovba newsgroup, I was able to complete my code to search an Access database for some information stored in an Excel worksheet.
This code will cycle through a list of numbers in column B, starting in cell B2, then check ...
Posted in Access, Excel, VBA | No Comments »
Friday, January 18th, 2008 66 views
I wrote my first Access macro today! Now, I am not a big fan of Access, but unfortunately I have to use it at work because it is the first choice for most people looking for a db (short for "database") program. For most situations, I prefer Excel.
At work I ...
Posted in Access, Excel, VBA | No Comments »
