Search results for 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...

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

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

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

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

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

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

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

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

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