Recent content by George Moore

  1. G

    Duplicate or Replicate Entry???

    You need at least two records before the SQL will work correctly The SQL criteria does not cater for the scenario of trying to find duplicate entries in a table which only has one record
  2. G

    Duplicate or Replicate Entry???

    The Tables in your database only contain one record The SQL needs at least two records to find overlapping entries
  3. G

    Combo Box Column not populated (Run Time Error 424)

    Hi Fabio The .Column(x,y) property is read only so you can't set it You could try the following.... Use a variable to read the value of .Column(1) at row number(n) Then remove row(n) completely using the .removeitem(n) method Then re-add the row using .additem YourVariableName & ";" &...
  4. G

    Combo Box Column not populated (Run Time Error 424)

    Sorry....may have misread your post, is Column One already populated and you are just trying to populate column2 ?
  5. G

    Combo Box Column not populated (Run Time Error 424)

    To leave column one blank and just populate column two, try... me.combo0.additem ";" & strProj & ";" ....and delete the line in red
  6. G

    Statistics about the code

    Hi Ridders Suggest you upload your version as it is a clear enhancement which will satisfy the curiosity of many a developer. I wrote the original purely because I wanted some facts for a Powerpoint presentation
  7. G

    Statistics about the code

    I have added it to the code repository, it will viewable after it has been moderated Quite happy for anyone to adapt, enhance and repost it to the repository My code count is current 284 functions and 131,761 lines of code
  8. G

    Get Stats About VBA Project

    Hi This is something I wrote for my own curiosity because I wanted to know how many lines of code were in a project but it may be useful to other developers. It is a fairly simple sub which seqentially examines all tables, forms, reports and modules in a project and produces stats about...
  9. G

    Statistics about the code

    Hi Arnel is correct, this is only for use on design masters not ACCDE files issued to users and "yes", it should count itself in the stats as it saved in a module Count of code lines is somewhat subjective as there will be rem & blank lines which I haven't bothered to exclude
  10. G

    Statistics about the code

    Hi This will give tell you anything you ever wanted to know about your VBA project In addition to modules, this will count code hidden behind forms and reports. You will need to close/open your database after it has run as it opens and closes all forms, reports etc etc. Sub ProduceStats()...
  11. G

    Joins between 'almost' identical fields

    and following on from CJ..... MetricsGraphAptCount.right([CCC-AAA],6) needs to be Right(MetricsGraphAptCount.[CCC-AAA],6)
  12. G

    Joins between 'almost' identical fields

    Suggest you post the SQL you are trying........there may be an obvious syntax error
  13. G

    Emailing Multiple specific users using record set.

    asSql = "SELECT mailings.Email FROM mailings WHERE mailings.reportsto = ' " & asMatch & "'" Looks like there is a space in the criteria which will affect results, try mailings.reportsto = '" & asMatch & "'"
  14. G

    example vba code to open recordset

    Thanks Colin - I usually list variables vertically but thought I'd try and save some space given the verbosity of the code
  15. G

    example vba code to open recordset

    Luchi - This is a skeleton to which you need to add flesh It is written using Access 2010 and I have tried to explain the code as much as possible Sub Test() '''''''''''''''''''''''''''''''''''''' ' a) This assumes outlook is your email client ' ' b) In Tools/References you may have to tick...
Top Bottom