Posts tagged with 'Access', page 1 of 2

Access

Listing built-in Access database properties

January 20, 2010 by JP

In Checking Access properties using VBA, I posted code for Access that checks if a given database property exists. I also included code samples for adding and setting built-in properties.

But how do you check the built-in properties names to see what properties you can edit?

Filed Under: Access

Tagged With: Access, database, DataTypeEnum, property

Updated Access VBA code to delete empty records

January 13, 2010 by JP

Comments

I recently had to use the code I posted in Clean and Repair Your Access Database to delete blank records from a database. But it failed because one of the tables has spaces in the name. I didn't create the table, I swear!

Filed Under: Access

Tagged With: Access, database, delete, field, GetCurrentDB, record, Row, SQL, table, VBA

Import data to Access from Excel

February 4, 2008 by JP

15 Comment(s)

Back in January, I promised to post a macro that imports data from Excel into Access programmatically.

Filed Under: Access, Automation, Excel, VBA

Tagged With: Access, database, Excel, import, VBA

Check Access table(s) from Excel using Automation – Updated Code

January 31, 2008 by JP

Comments

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 increase over yesterday's code is significant.

Filed Under: Access, Automation, Excel

Tagged With: Access, Automation, Excel, table, VBA

Check Access table(s) from Excel using Automation

January 30, 2008 by JP

Comments

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.

Filed Under: Access, Excel, VBA

Tagged With: Access, Automation, Excel, table, VBA