Recent content by hunterw

Negative - the primary key is unique but is not autonumbered. The IDs are generated outside of this database. There are a minimal amount of non-duplicate records on the tables - so few that I could probably match them by hand. The only reason I used a single table was because all 255 columns...

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

my solution to this is to simply not use the OLE garbage. i embedded a macro in the excel chart so that it renders a .jpg of itself, then i just displayed that. pitiful job microsoft.

Doubtful I would use this solution... My master table already has 255 columns, so I can't add any there. I would have to somehow generate a second table for every record, and then convert a large amount of back data to that new format. Here's a solution suggested by google: but what is the...

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

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

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

Nah, no need. I'd actually like to have used an integer variable inside of the form's variable name, like "[Gene" & var & "]", but that didn't work and I couldn't be arsed to go find the syntax, so I just made it ghetto!

dbOpenTable was screwing it up, and apparently was not necessary. It works!!! Here's what I ended up with: Dim dbsNecropsy As DAO.Database Dim rstGenotypes As DAO.Recordset Dim fld As DAO.Field Dim Blah As Integer Dim Blah2 As Integer Blah2 = 0 Set...

Hmm, having some trouble with the WHERE clause. Here's the line: Set rstGenotypes = dbsNecropsy.OpenRecordset("SELECT * FROM FacilityTyping WHERE FacilityTyping.[Animal UID] = " & [Mouse UID], dbOpenTable) And here's the error: The Microsoft Jet database engine could not find the object...

Oh man, thanks SO much! Yes, the table's design is poor - unfortunately, it is an automatically generated spreadsheet exported from a closed-source database called Facility, so I cannot alter its layout. All I can do is try and meaningfully extract data from it to use in my database. Hope...

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

I'm trying to fill data boxes in a form by referring to this table, but the way data is organized in the table is not intuitive. The first column of the table contains an ID which will be searched for. I need the row number since the ID is not simply 1,2,3,4 etc. With row number in hand, I...

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

Yes I'm using it for a VBA If statement - sorry, should have clarified that haha. The reason for it is a bit convoluded - I will explain. I have two comboboxes. One is simple, and one is dynamic, with its Row Source column defined by whatever is entered in to the first combobox. The...