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 Chriss 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. phishfn

    Rename table field through a query

    1. I'm having trouble figuring out the syntax (if there is any) for changing the name of a field through a query. For example, I have a table named table1 with fields fld1, fld2, fld3. I want to rename fld3 as fldNewName using a query. In SQL I think it would be: ALTER TABLE table1 RENAME...
  2. phishfn

    Show All Records if Criteria Left Blank

    Omg I can't believe I missed that. Now I feel a fool, lol! Thanks for the help (c:
  3. phishfn

    Show All Records if Criteria Left Blank

    I have a report based on a query that prompts the user for their ID number then generates the report where the records match his ID#. Simple enough. However, if the ID# is left blank the resulting report is then blank. How would I make it where if the criteria is blank, the report would show...
  4. phishfn

    Adding Records Using a Combobox

    Cool, thanks for the resopnse. I'll give it a try and let you know how it goes (c:
  5. phishfn

    Adding Records Using a Combobox

    This should be simple enough but it's stumped me. I have a simple data entry form of user information (name, address, phone number, city, state) that open after someone clicks a "New Employee" button. Currently to add a new employee, you just type in the information in the textboxes...
  6. phishfn

    Using If, Then, Else to generate message

    I'm pretty new to this myself but I'll give it a shot. Also there's not much information to go by, like how/when you want this prompt to activate, from where, whether option buttons are used, or a checkbox, etc. But wherever you launch it from the code should be something like this: If...
  7. phishfn

    Conditional Report

    Thanks both of you! The circular reference with the naming convention was the problem. And the =switch worked as well (c:
  8. phishfn

    Conditional Report

    This should be simple enough and I thought I had it working, but now I can't get it to. I want a textbox in my report to display text based on a field value in a table. Here's what I mean: If there's a '1' in my table, I want to display the word "English" on my report, a '2' in the...
  9. phishfn

    Option Button Values as Text in a Report

    Excellent! Thank you so much for your help. It works great!
  10. phishfn

    Option Button Values as Text in a Report

    I have a form with a group of option buttons, one for "Hardware" and another for "Software". Of course the values that display for these buttons in a report are numeric, but I need them to show up as text on the report. I.e., The user selects the "Hardware&quot...

Part and Inventory Search

Back
Top