Search results for query: *

Hi, We currently use a few 3rd party tools (Access Memo, Total Visual Agent & Access components, all work fine and are from FMS Inc: http://www.fmsinc.com). I'm looking at adding tools like the FMS Total Access Analyser and Total Access Speller to aid development of our databases. Any one out...

Thanks for the thought but yes, 'Cycle' is set to 'Current Record'. If I spell check a record that isn't the last in the recordet it checks the current record and the next ones in the recordset. I'm not sure if there are spell checker settings I've missed somewhere along the line or what. If...

Thanks everyone, I've got it working. TorF - you're right - it does appear to be normal, when I ran the code with """" it did work and strip out the "s - I guess I wasn't trusting enough of Access,when I saw it change it I just presumed it wouldn't work but didn't...

Hi, I have some code that creates a file with a filename based on data in a particular field. I'm checking the data to strip out characters that might cause problems with the path/filename - :;\/ etc but have hit a problem checking for " When I add """ to the end of the...

order by year(date_field) desc;

Thanks! Both these suggestions worked. Problem solved. Cheers.

Thanks Dan, but this adds two empty squares rather than adding a new line, is there something wrong with how I've included it in the query? "E-Mail subject: " & [forms]![frm_email]![subject] & Chr(10) & Chr(13) & " Message: " & [forms]![frm_email]![message]

I have a query that appends data from 2 text boxes into a single memo field, when I'm using VBA I'd send out a vbcrlf between the two fields to add a new line, but I need to do this in a query and vbcrlf didn't work. The section of the query is as follows: "E-Mail subject: " &...

Hello, I'm experiencing erratic behaviour from the spell checker (Access 2000). I'm in form view and when I invoke the spell checker one of the following occur: It spell checks the current record and stops (This is what I want, and what I belive it is supposed to do) It spell checks the...