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

    Google Redirects and Spyware Scanner Disabled

    Hello All. I started my computer this morning and my spyware program, SUPERAntiSpyware popped up a notification that it had to close and asked me if I wanted to send an error report to Microsoft - that was my first clue that something was up. I searched on Google and my browser tries to...
  2. eagle11232

    Link Combo Box and Query

    Hello all. I am currently working with a form where I catagorize graduates of a University based on campus, degree level (BS, Master's, MBA, etc) and then major. All of these entries are done via combo boxes Currently everything works, however, when I select the campus from its combo box, and...
  3. eagle11232

    Limiting Options in Combo Boxes

    I hope everyone had a nice Memorial Day. Thank you both for your helpful suggestions. The code that YoungManRiver provided works well, however, I am looking to refine my statement some more. I looked at faq702-3924 for help in making the statement SQL= "SELECT City FROM tblCities WHERE [State]...
  4. eagle11232

    Limiting Options in Combo Boxes

    I removed the equal sign and that seems to have resolved the error. However, now when I select a state in the first combobox, that value is copied to the second combobox instead of allowing me to select a city. As for spaces in my select statement, it is entered in Access as: SELECT DISTINCT...
  5. eagle11232

    Limiting Options in Combo Boxes

    Hello everyone. The first combobox, State, has a value list of FL;TX;OH,PA;MI;KY.The second combobox, City, is unbound, but instead of a value list I am using a Table/Query as the rowsourcetype and I am using a Query called querycities as my row source. Cities is table of cities in all of the...
  6. eagle11232

    Limiting Options in Combo Boxes

    Hello All. I am working to limit the options in a combo box based on the selection of another combo box. I found the FAQ on the topic, faq702-681, but I am having trouble working through the query builder. The first combo box has four options and are sourced from a Value List that I manually...
  7. eagle11232

    AfterUpdate Event Procedure Error

    Success! Works like a charm. Thank you all for your patience and help with this issue. I can tell you that I am impressed by the knowledge of each of you as well as the forum as a whole. There are very few forums out there where the new guy can post a question and receive so much help, so...
  8. eagle11232

    AfterUpdate Event Procedure Error

    Thank you all for all of your assistance thus far. I have been able to update the code so that it runs, however, I am not seeing the results I expected; namely, when the test is false, the other fields are still visible and available to input data. As MajP correctly stated in one of the earlier...
  9. eagle11232

    AfterUpdate Event Procedure Error

    Thank you all for the help. I have put the code in that Nim suggested, yet I am still getting a 424 Error. My best guess is I don't fully understand how VB associates file names and such. If I correctly understand the code that Nim provided, Me! refers to the form name that I am using. If the...
  10. eagle11232

    AfterUpdate Event Procedure Error

    Its a Runtime 424 Error Object. I will change the spelling of visible when I get to my computer (sent this from my phone) Thanks guys
  11. eagle11232

    AfterUpdate Event Procedure Error

    In a single form I have one dropdown field that is a yes/no option, based on the input, in this case a no, I want to either lock out or simply hide the following four fields (3 dropdowns and one text). I checked the FAQ and searched the forum, but didn't find anything that helped me. I have...

Part and Inventory Search

Back
Top