Search results

  1. I

    Normalising (?) data

    Hi all I often have a requirement to 'normalise' (not sure if that's quite the right term?) population data with lots of age columns () into a single table with few columns and multiple rows (). I wrote the code below to do this. Briefly, it: i) Cycles through the field names of the...
  2. I

    Replacing strange text

    Hi all I'm pulling text out of a LIMS Database via ODBC and the bit I want is surrounded by strange characters which I'd like to remove (example attached). Any ideas how to do it in VBA or what the character code is? Thanks, Iain
  3. I

    Rename most controls in all forms in a database

    Hi! I've got ~10 forms in a database, each with numerous (say 15) option buttons in frames. Each is named [variable name]Frame, but I'd like to name them all to [variable name]YN to reflect their purpose. Rather than renaming each by hand, is there a piece of VBA which will do this...
  4. I

    Change chart image

    Hi! I've got an XY chart (objScatterGraph) which I use for mapping. The background image is the whole of England and Wales, and I'd like to be able to change this to specific regions depending on the choice of a combo box (cmbRegion). However, the following... Dim RegName As String Dim...
  5. I

    Mark duplicates without deleting them

    Hi all! I wonder if anyone can help? I have a table (FoodCore) which contains duplicate entries (up to ~10) based on five fields (Dup, CleanedRef, YearOfReceipt, LB2LabName & SeroAFLP). I want to identify these (in the Dup field) but not delete them. I could just mark them via a query, but...
  6. I

    Problem referring to a control in another form

    Hi! I thought that this would be simple. I created a form (frmProgress) to act as progress informer when a series of longwinded queries run - the idea that the user would be a bit more informed than they would by staring at a progress bar. It has several labels (e.g. lblLB2, lblMol...
  7. I

    Searching on a highlighted word in a form

    Hi! First post... I have a MS Access 2003 form for classifying various drugs that patients take. Several drug names are written in the same field and users can currently look up a description of any one drug by highlighting the word, copying it to the clipboard and then clicking a button which...
Back
Top Bottom