Recent content by JPritch

Thanks Lagbolt, I tried the code and some combinations close to it, but I'm still required to click the listbox in order for the subform to change. Am I missing something?

I have a series of drill-down combo boxes on a form, to keep from having to list hundreds of employees at once: 1) Dept_combo, (shows available department names) 2) TL_combo, (looks up team leaders in the selected Dept) 3) EmpName_combo, (looks up employees for the selected Dept/TL) 4)...

Exactly, it's built Switchboard-Report-Query. However, the prompts in the query are setup as: >=[Start Date] And <=[End Date] on the same line. So I should use Between/And? I will give it a try.

to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables." I did a search and it looks like date prompts cause this error sometimes. The message pops up when running from the...

Thanks Wayne, works like a charm~!

I did some searching and found this function posted by someone in response to the exact same problem I'm now encountering. But how do I call this in my query? Function StripZeros(pstr As String) As String Dim n As Integer n = 1 Do While Mid(pstr, n, 1) = "0" n = n + 1 Loop...

I query against a table with 380K records and growing. There are approx 14 fields in the table, but I only retrieve 7 in my query. Does having those extra fields in there slow the query down, or does the query ignore them? Just trying to figure out ways to improve speed. Thanks.

Thanks Jon K! Everything works the way I wanted it to now!

Found a similar thread where a poster had two subforms on his main form, but he didn't want the subforms to load until after the main form opened and he pushed a button because it was slowing his form down. Ruralguy suggested the following: 1)You should be able to leave the RecordSource of the...

I have a database with a table that contains 360,000 rows. I built a form with four boxes where a user can specify values to limit the result set. And instead of having a new window open with the results, I built a subform and placed it on the main form to display the results. Here is how it...

Got it! I tried searching here to no avail...but after writing my post, I thought of some new search terms and found a post by Pat Hartman: http://www.access-programmers.co.uk/forums/showthread.php?t=95810&highlight=ignore+null It's true: you can't do it in the regular query grid. I typed...

I have a form with 4 different search fields used to query a table and limit results: Policy#, SSN, Credit_Amt, Debit_Amt. Any matching rows based on the search criteria are returned in a subform. My problem is how to handle any fields where the user doesn't specify a search value. In my...

It was the bloat. Compacted and Repaired, and it runs like a charm. Thanks for the help.

I've actually tried that and it gives me a different error message about asterisks and the whole bunch. I've tried the error message suggestions to no avail. I just noticed that my database size has ballooned to over 2GB. I wonder if this could be the problem. This is weird b/c when I was...

Trying to use an append query to append records from Table1 into Table2. They are identical in structure...even went so far as to copy Table1 structure, and paste as Table2, just to make sure there were no discrepancies. I am unable to run the append query. I get an "Invalid Argument" error...