Search results

  1. H

    Combining two tables with respect to each unique record's individual data cells

    Howdy folks! Have a bit of a problem...developed a database for a client, works great. At some point they decided to back up all of their data, and unfortunately they were simultaneously using the original database as well as their backup for a few months. I need a way to merge the...
  2. H

    SourceDoc does not work for reports - workaround?

    I have an external excel chart stored for every record. In a form this works great, I just use the following code: ' excelpath = "\\ccri-srv01\M2600\Labs\Keller\Images\" & [Mouse UID] & "\TumorSize.xls" ' ' If Dir(excelpath) = "" Then ' Me.TumorChart.SourceDoc =...
  3. H

    Printing multiple forms with linked images...How can I make the images work?

    I have a form with multiple linked images. In design view, the image frames have "none" specified for their image link. I've simply used VBA to replace that field with the specific record's image link which is stored as a text field in its table. What I want to do is be able to print out...
  4. H

    Trapping error 3022 in order to automatically navigate to the pre-existing record

    Howdy all, I've hit a snag. I have a surrogate primary key - a unique ID that is input by the user. Frequently people will enter an ID in order to fill out a different part of my form, and they will have no idea if the record exists yet or not. I need to trap error 3022 and automatically...
  5. H

    Transposing data from one table to another using DAO recordset...

    I am trying to copy some data from one table to another, but not in a simple way. I need to look up an index number, then using that record, cycle through all the fields past field 11, and for every non-null entry, copy both the entry as well as the name of the field in to my new table...
  6. H

    Question Need help with VBA syntax for table lookup

    I'm using a table imported from an external spreadsheet for some of my form data. The first thing to do is look up an ID in the first column of the table. This should store the row that the ID is stored in. After this, I need to look through its row, and if a field is not NULL, it needs to...
  7. H

    Question ComboBox list displays blank data entries - annoying!

    I have a table I'm using for ComboBox list entries. Each column has a varying amount of fields (rows) utilized for their specific list. The ComboBox which uses the column with the greatest amount of fields in the table has no problems, but every other ComboBox displays blank data entries. Aside...
  8. H

    Question SetValue for an OLEObject in a table - what to use to accomplish this?

    SetValue has a couple of limitations - it can't modify values in a table, and it can't set the value of an object, therefore I cannot use it to do this task. What can I use to do this, then? I'd like to have a macro button on a form that when clicked sets an embedded OLEObject (in this case a...
  9. H

    Need to start new form entry with default image but also be able to modify them

    I work at a cancer research lab. The current method of recording autopsy data on our lab mice is all on paper, and my job is to replace this system with a database that can be used on a tablet PC while the autopsy is taking place. Everything is elementary data fields except for (I'd assume) a...
Back
Top Bottom