Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lalbay

    Access Table Link to Excel - Loose Memo Field

    Hi! I have an access table that I built, but then I needed features in excel so I have now have a spreadsheet link to the table. The data gets entered in an access form. The problem is that when I linked the table and spreadsheet it changed "memo" fields to "text" fields and...
  2. lalbay

    Not Print on Reports - Field/Labels with "0" Value

    Thanks all for the help - I have decided to put the chemicals in a seperate table - I can see the advantages to this. Thanks! Leigh Ann
  3. lalbay

    Not Print on Reports - Field/Labels with "0" Value

    Okay I am probably doing something wrong, but I put this: Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.BENZENE = 0 Then Me.BENZENE.Visible = False Else Me.BENZENE.Visible = True End If End Sub and I am getting the message error...
  4. lalbay

    Not Print on Reports - Field/Labels with "0" Value

    Yes that is a crucial to know. They are fields in a single record in a table.
  5. lalbay

    Not Print on Reports - Field/Labels with "0" Value

    I tried to do this. And my table has 173 records and when I run the query it comes up with 0 records. Thanks [sunshine] Leigh Ann
  6. lalbay

    Not Print on Reports - Field/Labels with "0" Value

    Thanks for looking at my message and change my title to Beginning Programmer. I have a report that has 20 fields that are chemicals. I only want to print on the report any chemical field whose value is greater than 0. For example I may have Benzene 2 Chlorobenzene 3 Toluene 0 Xylene 0 Aniline...

Part and Inventory Search

Back
Top