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

    Do not want my form to update my table

    Thanks. I think I've got it now. Deleting the Control Source and Record Source properties didn't do it, as the drop down either had no information to view (to set the criteria) or, the information wouldn't populate to my query/report. Also, for whatever reason, my Access 97 doesn't appear to...
  2. ACSeval

    Do not want my form to update my table

    Hi All. I have a form with a combo box used to select the criteria for a report. The drop down is linked to a table with all of the possible choices to be used for criteria. However, when the user selects from the combo box, the program tries to add an entry to my table (from which the choice...
  3. ACSeval

    Opening one form causes two forms to open. Why?

    Thanks... I put that code into my Code builder, but upon further testing discovered that the problem was my setting this same information in the box for OnEnter. I suppose the macro would have worked too if I eliminated the info from OnEnter. Anyway, you helped me overcome that hurdle...thanks...
  4. ACSeval

    Opening one form causes two forms to open. Why?

    I've got a form that allows the user to select one of two options via "buttons." If they select one button, it should start a macro which is set to open another form. If they click on the other button, it should start a macro which is set to open a report. The wierd thing is that...
  5. ACSeval

    Using a form to set my query criteria... why isn't it working?

    Ginger, you rock. Thanks for setting me on the right path. I knew I was close, but there have been certain little things of which I was unaware. I've got the program working now, doing the things I need it to, and I am grateful for your help.
  6. ACSeval

    Using a form to set my query criteria... why isn't it working?

    Ah, I'm relatively new at this. Sorry for the lack of info. 1. List Name is the variable I wish to set as the criteria. It is also the name of the combo box, from what I can tell. It is what should be chosen from the form (or, what might be set manually in the criteria statement if the...
  7. ACSeval

    Using a form to set my query criteria... why isn't it working?

    Hi all. I am designing a report that allows the user to choose from a list of really long-winded names as criteria. I was recently informed that a combo box would be helpful, as this would allow a drop down menu, instead of manually entering parameters and opening up room for errors. I've...
  8. ACSeval

    Can a drop down list be used to set/select query criteria?

    Thanks to both of you. It appears that a combo box is exactly what I need. I had never worked with these, but have since created the drop down I need with a form containing a combo box, which links to my table of names. However, now I am confused about how to set this as my criteria. I put a...
  9. ACSeval

    Can a drop down list be used to set/select query criteria?

    Hi all. I am a relatively novice user of Access 97 essentially figuring it out as I go, and do most of my work in the Design view (as I am unfamiliar with SQL). I have setup a report that brings information together out of a table (that is regularly updated with a form) and groups the...

Part and Inventory Search

Back
Top