Search results for query: *

Close, but still not working. I suspect the problem is that the variables end up with quotes around them, but what I need is just the value without quotes What I want to end up with: WHERE tbl_PersTrRequired.01BO = "-1" What I suspect I am getting: WHERE " tbl_PersTrRequired.01BO " = " -1

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

My form is working, but I still don't understand what is going on. It would work if form1 and form2 were pulling data from the same table, but not if from different tables, even though the key field was joined. I finally recreated everything as an mdb instead of a Project then ran the...

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

Thanks guys, Those examples worked great. I had to do a little manipulating to get the output in table columns for presentation, but once I got that it works exactly the way I wanted.

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