Expand|Select|Wrap|Line Numbers
- Public Sub PrintColumns()
- With frmHeader
- 'all columns
- If .colFPH.Value = 1 And .colMPF.Value = 1 And .colTGas.Value = 1 _
- And .colMeth.Value = 1 And .colEth.Value = 1 And .colPro.Value = 1 And .colIBut.Value = 1 _
- And .colNBut.Value = 1 And .colMWtIn.Value = 1 And .colMWtOut.Value = 1 And .colMTmpIn.Value = 1 _
- And .colMTmpOut.Value = 1 And .colAnhy.Value = 1 And .colChalk.Value = 1 And .colLime.Value = 1 _
- And .colDolo.Value = 1 And .colShale.Value = 1 And .colSand.Value = 1 And .colSilt.Value = 1 _
- And .colCoal.Value = 1 And .colChert.Value = 1 And .colNoSamp.Value = 1 Then
- Print #1, depth & vbTab & fph & vbTab & mpf & vbTab & slide & vbTab & _
- pdc & vbTab & tgas & vbTab & c1 & vbTab & c2 & vbTab & c3 & vbTab & _
- c4i & vbTab & c4n & vbTab & shale & vbTab & silt & vbTab & _
- sand & vbTab & chalk & vbTab & lime & vbTab & dolo & vbTab & _
- anhy & vbTab & coal & vbTab & chert & vbTab & nosamp & vbTab & _
- mwin & vbTab & mwout & vbTab & mtmpin & vbTab & mtmpout
- End If
- If .colFPH.Value = 1 Then
- Print #1, depth & vbTab & fph
- End If
- If .colMPF.Value = 1 Then
- Print #1, depth & vbTab & mpf
- End If
- If .colSlide.Value = 1 Then
- Print #1, depth & vbTab & slide
- End If
- If .colPDC.Value = 1 Then
- Print #1, depth & vbTab & pdc
- End If
- If .colTGas.Value = 1 Then
- Print #1, depth & vbTab & tgas
- End If
- If .colMeth.Value = 1 Then
- Print #1, depth & vbTab & c1
- End If
- If .colEth.Value = 1 Then
- Print #1, depth & vbTab & c2
- End If
- If .colPro.Value = 1 Then
- Print #1, depth & vbTab & c3
- End If
- If .colIBut.Value = 1 Then
- Print #1, depth & vbTab & c4i
- End If
- If .colNBut.Value = 1 Then
- Print #1, depth & vbTab & c4n
- End If
- If .colMWtIn.Value = 1 Then
- Print #1, depth & vbTab & mwin
- End If
- If .colMWtOut.Value = 1 Then
- Print #1, depth & vbTab & mwout
- End If
- If .colMTmpIn.Value = 1 Then
- Print #1, depth & vbTab & mtmpin
- End If
- If .colMTmpOut.Value = 1 Then
- Print #1, depth & vbTab & mtmpout
- End If
- If .colAnhy.Value = 1 Then
- Print #1, depth & vbTab & anhy
- End If
- 'fph & mpf
- If .colFPH.Value = 1 And .colMPF.Value = 1 Then
- Print #1, depth & vbTab & fph & vbTab & mpf
- End If
- 'fph,mpf,& tgas
- If .colFPH.Value = 1 And .colMPF.Value = 1 And .colTGas.Value = 1 Then
- Print #1, depth & vbTab & fph & vbTab & mpf & vbTab & tgas
- End If
- End With
- End Sub