Category Archives: Uncategorized

64 Bit

Be aware that 64 bit operating systems along with 64 bit MS Access could spell trouble for your code. It will spell trouble for any libraries that you may hav e obtained along the way. There is a nearly total … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , , | Comments Off on 64 Bit

Improve Db Performance in a Network Environ

Installing the following code into the first form that opens in a database will increase the database performance in a network environment, especially with Windows 7. Option Compare Database  Public Function PrintISAMStats()     ‘ Print the values returned by … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , | Comments Off on Improve Db Performance in a Network Environ

Likesearches in large SQL tables

I’ve had several clients now that have requested a stored procedure that will return records based on key words entered by a user. There can be one or many key words and all have to match in order to match … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Comments Off on Likesearches in large SQL tables

SQL Server and Visual Basic

Remember when casting values that there are some cases where a null value will result in an error and no conversion. Check your properties for your variables in VB and you fields in SQL.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Comments Off on SQL Server and Visual Basic

SQL or Access Adding Records

Suggestions on how to let users enter new data into SQL or even Access. 1) Build them a real data-entry app (could be web-based, but doesn’t have to be) that will check all the inputs before submitting the data to … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Comments Off on SQL or Access Adding Records

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 | Comments Off on Referencing values on subforms

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 | Comments Off on VPN

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 | Comments Off on Security

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 | Comments Off on DLookup

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 | Comments Off on File System Objects