Recent content by wobrown

I am looking into addressing a situation similar to the OP's. My database (Access 2010) currently depends on several linked tables that connect to an Oracle server via ODBC using a system DSN. The database can only be used when it is connected to the network, but I'd like to be able to work...

I ended up changing a .requery to .refresh and the problem was solved. Thanks, again

So I have my frmCollection set up backwards. I'll rebuild another frmCollection when I have a chance and will let you know how it goes. It's strange that the way it is set up now worked for a while, but this should be fixed in any case, it sounds. It follows that to normalize the...

Thanks, Bob! I had felt that I probably shouldn't be storing the SN in both tblLIMSpipettes and tblCollection, but...hmmm... There are a finite number of pipettes, each with a representative record in tblLIMSPipettes. For each pipette, many calibrations will occur over time. A...

Greetings, I've been teaching myself Access and VB to establish a chain of custody tracking database. I'll hopefully be able to attach the current version of my .mdb so that I might receive some guidance regarding an issue that suddenly appeared. Here's an outline of my intentions and the...