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!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
passing Variable to WHERE clause in VBA
I'm trying to pass a variable into the WHERE clause, but it is not recognizing it. Is it possible to do this? If I use the WHERE that is commented out in the code below it works, but If I try to use the strCode variable inplace of it, it will not work. I have played around with ' and " aroung...- zmsm18
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
DoCmd.OpenForm with criteria
In Access mdb the following code would open form2 to the record that was selected via an click event on form1. It doesn't work in Project. Form2 opens, but goes to record 1, not the record selected on Form1. Am I missing a step in this? Any help is appreciated. Private Sub HLTAG_Click() Dim...- zmsm18
- Thread
- Replies: 4
- Forum: Microsoft: Access Project (ADP)
-
alphabet bookmarks for dynamic list
I would like the alphabet across the top of the page with a list of names below so the user can click the letter, and it drops down to the corresponding letter in the names list below. However, since the list is dynamically created I don't know how to generate the <a name="letter">letter</a>...
