Search results for query: *

I am wishing to input pure text from a form into an Access 97 Database using Insert Record. The challenge is the so called "invalid characters" and how to successfully input them. The main protagonists seem to be Single Quote (') and Commer (,). I am dealing with Single Quotes by...

I have a challenge with subforms. Lets say I have two tables, companies and products. I want to create a form with two subforms. The form will list the information about the company, subform1 will list products made by that company, and subform2 will list details about each individual product...

Probably a simple question, but how do I make a button open a URL held in a text field in the computers default browser? I don't want the link in a hypertext field as the database will be used with ASP and so I want the URL in plain text. However I do want to be able to open the link in a...

Using asp to query Access 97 db on IIS5 I need to find exact matches for search terms within a string. EG "cat" will find cat but not catastrophe. I cannot use "=" as that would match the whole string and I only want to find the exact match within the string. I am trying...

Using Access 97 db on IIS5 I am modifying my search algo to find exact string matches using "like '%[!a-z][search term[!a-z]%'" which is pretty clumsy and also doesn't pick up the search term if it is at the beginning of a sentence. Can anyone help me with the syntax here, I am sure...