Oops--Please replace my last paragraph in the message sent out a few
hours ago with this one.
Regarding your request to provide for storage of off-line extraction data,
I think this request is easily accommodated. Three possibilities suggest
themselves: (1) make the column labelled str_AliquotID in the table
tbl_Analyses much larger (it is 20 characters wide now) and store all your
extraction data in it, (2) add extra columns for your extraction data to
the table tbl_Analyses, or (3) create a new table for your extraction
data. If you create a new table, it would need at a minimum the following
columns: (1) Mass Spec ID, (2) Integer Analysis Number, (3) Integer Peak
Number, and (4) columns for your information. You may want to create a
new form in LIMS to view your extraction data. Just look at the forms,
table, queries, and code modules to see how you might want to do this. To
see the code and database objects in LIMS, pull down the Main Menu using
the mouse to expose the button that says "Design," and click on this button.
[For ease of debugging, DO THE FOLLOWING FIRST BEFORE OPENING THE LIMS
DATABASE. Open Microsoft Access, select Tools, Options, and Module. Enable
the Debug Window on Top checkbox. I set the Tab Width to 2.] You can add
extra textbox controls to the form that displays the analysis data,
frm_LoginAnal, in order to display your off-line extraction data. You can
write code in either Access or Excel to transfer your Excel spreadsheet
information to the Access database. What you want to accomplish is not
trivial, but should after completion be most useful to your laboratory.
This, of course, is the benefit of working with Microsoft Access. You can
store, display, and report your data as YOU want.
|