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...
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...
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]...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.