• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by MilaK

  1. M

    spell checker for rich text memo field bound to textbox on a subform (Access 2016)

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

    Database corruption resolution needed

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

    Database corruption resolution needed

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

    Record Selector Funtion

    Please explain how I would "tick it". Thanks
  5. M

    Record Selector Funtion

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

    evaluate multiple records as a group

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

    consolidating data with empty fields

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

    Recordset AbsolutePosition

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

    Recordset AbsolutePosition

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

    Recordset AbsolutePosition

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

    Recordset AbsolutePosition

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

    translating a query to vba

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

    translating a query to vba

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

    translating a query to vba

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

    translating a query to 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...
Top Bottom