Skip Navigational Links
LISTSERV email list manager
LISTSERV - LIST.UVM.EDU
LISTSERV Menu
Log In
Log In
LISTSERV 17.5 Help - ISOGEOCHEM Archives
LISTSERV Archives
LISTSERV Archives
Search Archives
Search Archives
Register
Register
Log In
Log In

ISOGEOCHEM Archives

Stable Isotope Geochemistry

ISOGEOCHEM@LIST.UVM.EDU

Menu
LISTSERV Archives LISTSERV Archives
ISOGEOCHEM Home ISOGEOCHEM Home

Log In Log In
Register Register

Subscribe or Unsubscribe Subscribe or Unsubscribe

Search Archives Search Archives
Options: Use Forum View

Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
CORRECTION Re: LIMS database questions
From:
"Tyler B Coplen II, Research Chemist, Reston, VA (Tyler Coplen)" <[log in to unmask]>
Reply To:
Stable Isotope Geochemistry <[log in to unmask]>
Date:
Tue, 20 Apr 1999 21:40:14 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (27 lines)
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.

ATOM RSS1 RSS2

LIST.UVM.EDU CataList Email List Search Powered by LISTSERV