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...

Just thought I would *bump* this into view again 'cos, as I say "This one is still puzzling me." Anyone got any ideas?? Any help would be greatly appreciated.. Onya WozFromOz

Close but no cigar Lonnie, I should have given more information. Subform1 must be a continuous form to display ALL the products from the relevant company in a list. Continuous forms cannot contain a subform. I could do it so that subform1 is a single form containing all the product information...

Thanks Lonnie, got that happening now. However, just to be finnecky, each click of the button opens a new browser. Is there some way to have all clicks open in only one browser window? Like the target option in a html hyperlink? IE., if I move to the next record and click on the URL button I...

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...

Hi Lonnie, thanks for the reply, just getting back to this problem now. What I am wanting to so though is similar to what you have siggested but getting the hyperlink from a pure text field rather than a hypertext field. The reason is that I need to query the database via ASP pages as well and...

I use an unbound text field with the data sources set as =IIf(Count(*)<>0,&quot;Record&quot; & [CurrentRecord] & &quot; of &quot; & Count(*) & &quot;.&quot;,&quot;No Records Found&quot;) Simple yet effective Onya WozFromOz

Thanks Lonnie, I think you do understand me but I am still not sure how to do this. How do I make a button to dynamically pick up a URL from a field and open this in an external browser? Thanks again WozFromOz

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...

Gord & Micahel, thanks very much for you help but I think you are still missing my request. My fault for not explaing enough. I tried both your suggestions in access and asp (pretty much the same thing) and they do work but they don't do what I want. They both find the occurence of a substring...

Nup! Still won't work but thanks anyway Michael. You syntax still only picks up &quot;carr&quot; as the whole field as there are no delimiters on either side. Onya WozFromOz

Thanks Gord, however that routine finds entries that do not contain the search term. I am still looking for an answer. So far I am using SELECT * from Table WHERE (' ' & Field) LIKE %[!#,?]TERM[!#,?]% with some success. Any imrpovements anyone? Onya (Aussie Greeting) WozFromOz (Name) HeHe!

thank Gord, thanks for the relpy, maybe I didn't explain my problem well enough. Like *at* gets &quot;at&quot; &quot;cat&quot; &quot;catastrophe&quot; &quot;attention&quot; etc Like at* gets &quot;attention&quot; only how do I get &quot;at&quot; from within a string? =at matches the whole...

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

Sorry, not enough information in my question. I am using ASP to query access on IIs5 so my question goes to the asp syntax. But then I guess it also relate to SQL. Thanks for the suggestion, I'll try in the access and sql forums. Onya WozFromOz

Using Access 97 db on IIS5 I am modifying my search algo to find exact string matches using &quot;like '%[!a-z][search term[!a-z]%'&quot; 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...