Recent content by Kendall

I think you hit the nail on the head here. What is happening is that a validation function is calling a lookup function that queries a table for certain records. The lookup function then returns these records as a RecordSet to the validation function. Both of these function reside in a vba...

Hello again, I used the debug.print statement as suggested, and then copy/pasted the result directly into the SQL view of the Query Designer. Upon running the query, I got exactly the result I should get; this result is different from the result I get when the VBA module runs the query. To...

Both values are set in a 'stub' form that tests a new function. Values for both variables are set in the form, and passed to the function. Neither are empty and the SQL look good. If I use only the <> condition, then the query returns only 1 row as expected. But I can't do that, because...

Hi, Maybe this is a stupid question, but I think this should be pretty straight forward. I have some rows in a table, and I want to select all of the rows that matches an given criteria and does NOT match another. So far I have SELECT field1...fieldN FROM table WHERE [employeeId] = '" &...

I'd hope for a scroll bar :) There really wouldn't be > 10, if even that many. It's a query displaying orders that a specific employee is working on.

Hi, I have created a form that uses a query as a Record Source and displays the results in a Columnar format. However, there is a lot of "wasted space" between the last record and the bottom of the form; is there a way to have this part of the form sized automatically to fit the number of...

You, of course, are right. I added the Text / Label boxes on the form, put in Me.StopTime in the OnUpdate function, and it works nicely. Thank you! edit: Thinking about it, I wonder if not having the StopTime boxes when trying to use the UPDATE...SET...WHERE clause was causing it to fail.

Hi all, I have a form that is setup to display in data sheet view records returned from a query. Lets say there are two fields, called "QuantityMade" and "StopTime." I want the "StopTime" field to be updated to the value Now() when the "QuantityMade" field is updated. I first thought to...