Monthly Archives: February 2011

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 | Leave a comment

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 | Leave a comment

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 | Leave a comment

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