Category Archives: Access 2007 problems/solutions

Access 2007 is really buggy. We at Data Control have to use it because our clients want to use it (or have to use it). So, while we wait for Service Packs to be released that solve these issues, or while we find work arounds to get the job done, we’re going to post our findings on this blog.

Hope this helps everyone!

Referencing values on subforms

Remember the syntax for the way to recall information from a subform to a form is [subFormName].[Form]![FieldName]

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

VPN

Take advantage of free resources to create a VPN for remote access. LogMeIn is one such resource. Use it to create a VPN between your base location and any remote users you might have. That way you can remote into … Continue reading

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

Security

The first and most important step in creating a security process is to establish and maintain a solid backup process for ALL files! Whether they are only in Access or in Access and SQL Server.

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

DLookup

Doing an If clause with DLookup genereally means usin a comparison of the lookup result to a value using the equals function. Most other functions do not tend to work well with DLookup and especially not the IF ISNULL structure.

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

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

CSV Importing

The solution for importing a CSV file is to link to it instead of importing it. Linking to it, all the fields are correctly formatted and populated. One problem to watch out for; commas in the data. So I am … Continue reading

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

Importing CSV files

Importing files can be tricky in MS Access. The application tries to set the property for each field and even with preset values you can still get data imported incorrectly. I don’t have a complete solution for this problem just … Continue reading

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

Parking Lots

Central Parking System needs a database application to manager the paperwork and finances for the parking lots they operate in the City of Virginia Beach.

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