Monthly Archives: November 2010

File System Objects

Remember to look to use FSO’s such as FileCopy when you are trying to do things outside of Acces from within Access. File System Objects are readily available and require few skills to learn.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Leave a comment

List boxes not populating

If you are using list box(es) and they will not populate with values, check your references in the VBA Editor. Odds are that there is a missing reference to a DLL or two.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Leave a comment

Can’t delete records in SQL Server table from Access

Issue: Table must have a Primary key (or at least a unique index). Resolution: When creating the link to the SQL Server table, and Access prompts for index, this isn’t sufficient. The index must be created on the SQL Server … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , | Leave a comment