Search results

Hello, 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? Thanks, Mila

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

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

Please explain how I would "tick it". Thanks

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

Hello, What is the best way to return ‘no’ in a query, if all of the alleles for the same marker are less than 1000, otherwise return ‘yes’? Please see the attached example. Thank you very much, Mila

Hello, I would like to consolidate data in a table and write it to another table (please see the attached image). Is this possible to accomplish with a query, if so how? Thanks, Mila

Never mind...it doesn't always populate the number. Any suggestion which event should fire the code?

perhaps it was how I was referencing the form in the code: This seems to work: [Forms]![frm_total_report]![frm_reportable_comments].[Form]![frm_citations].[Form].Requery vs. Me.requery

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

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

I apologize for not mentioning that I've corrected the original post. thanks

@Minty The symbol returns the correct values but Expr1 returns Null value for some reason. Thanks for your help.

Yes, the query executes fine inside the query wizard, however, i can't figure out how to write it in vba.

Hello, 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 FROM tbl_citation_symbols; I have tried: SQL = "SELECT...

I'm not sure how this will solve the issue with pasting the text via vba code. Thanks, Mila

Hello, I would like to append lines of text to a form bound textbox when a button is pressed. I’m using the following code to move the cursor to the end of the text and append a line. With Me.CommentTxt .SetFocus .Value = .Value & final_citation...

Yes, each user has his own front end. The error went away after few minutes. I still would like to know what caused it.

Hello, I have a split database that is showing the following error message each time a user tries to import new data via VBA code. This code has been tested many times and I'm not sure what is happening. Error updating: The Microsoft Access database engine cannot open or write to the file. It...

Hello, I have a form that is bound to a table. Is there a way to give user control to save the changes if a button is pressed? Right now all the changes are automatically saved. Thanks, Mila