Monthly Archives: February 2011

Likesearches in large SQL tables

Posted on February 28, 2011 by rawilken

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

Posted on February 22, 2011 by rawilken

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

Posted on February 8, 2011 by rawilken

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

Posted on February 8, 2011 by rawilken

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