I would like to implement a spellcheck for a rich text memo field bound to a textbox on a subform. From what I've found, the DoCms.RunCommand acCmdSpelling command doesn't work with rich text format. Is there is anything thing else that would work with this type of text format?
I have compact and repair on close set. The size of front-end is 19700 Kb and the current size of the back end is 153,704 KB. I'm mostly looking for suggestion about moving the tables to SQL server and this will help resolve the issue. Thanks
I've made a split database (current size 157,234 KB) and it was working well, until recently it begun to crash during data import. The error it gives "Unrecognized database format...". I have several procedures in the main module that first import data to temp tables and later insert...
I’m looking for a function that will return true or false if a record is selected with a record selector on a continues form. My intention is to select multiple records and use the output of this function to apply conditional formatting to the form.
Any input on this method would be...
The code is numbering each record on continuous sub-sub form. I put this code after-update event of text control so it would update the row number as a new row is entered. It doesn't always update right away (sometimes after entered several records).
I use the following subroutine to populate record number into a field on a continuous form. I've tried to put this code behind a button on the form and test it as I add more records to the form. It seems not to work well. Could someone please suggest another method?
Dim rs As...
How to translate the following query to vba so I can use it inside a module to open a recordset.
SELECT DISTINCT ConcatRelated("id","tbl_citation_symbols","symbol like '*" & [symbol] & "*'") AS Expr1, tbl_citation_symbols.symbol
I have tried:
SQL = "SELECT...