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 Chris Miller 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. AccessMan

    Problem with Table permissions in SQL 7

    To edit record in SQL through ACCESS, The table you're editing records in MUST have a primary key AND, when you link to it, you must select it. Set up a Primary Key in the table (in sql, not in Access), drop the linked table and re-link... You'll be prompted to select a primary key field. Select...
  2. AccessMan

    Deleting Columns with no data while querying in Access

    I have been trying this code and I fixed a few errors and I keep getting some more as I keep playing around with the code. I was wondering if you could help me out. Also, I have two tables I need to link. One table is the one with the columns I would like to delete if they have no data in...
  3. AccessMan

    Deleting Columns with no data while querying in Access

    Thank you Rewdee. I will see how it works and let you know if I need help. Thank you so much!! - AccessMan
  4. AccessMan

    Deleting Columns with no data while querying in Access

    What I mean is if the data is queried and it has nothing in the column I do not want to show that colum in the query and/or my report. I have some columns that may not have data based on certain circumstances. Does this help?
  5. AccessMan

    Deleting Columns with no data while querying in Access

    Hello - I need some help with querying in Access. I have columns with data and some with out based on what gets filled out in a form. My problem is that I do not want all of these fields in my report if they have no data. I would like to have a program delete the columns as I query and the...

Part and Inventory Search

Back
Top