To All,
This issue was never resolved, so if anyone else has any input I would greatly appreciate it.
Thomas
jaegertw2
Last Activity: Nov 18 '08, 03:10 PM
Joined: Apr 9 '07
Location:
-
Thanks for the response.
I don’t think it’s a virus, because the database is working perfectly from a functional standpoint. It’s just an operational blip, but the action taking place is kind of reasonable.
This is not a computer I have access to or permission to scan, and getting IT to do it would require justification and time, and I’m not sure how much it would accomplish.
I do think it is...Leave a comment:
-
Inconsistently Occurring Parameter Dialog when there should be Nothing
Hey guys, I have a weird one. My database has about 25 users, and today one of the users came to me and informed me she was getting an error message, which turned out to be query parameter dialog box. When she hit the exit button of a search form, this dialog box would come up sometimes. There doesnt appear to be any consistency in the search criteria or actions taken on the form that cause this message to come up, and I cant get it to come up... -
When tables are deleted in Access, the space allocated for them remains. This means, in many cases, the tables can be restored if the are accidently deleted. That space is cleared by using the 'Compact and Repair Database' option in Database Utilities, under the Tools menu. I was debugging someone else's database that started at 30 megs or so. By compacting it, it went down to less than 4. The backup most likely kept the deleted tables, forms,...Leave a comment:
-
The one thing I left out before is that my query was built on a series of other queries that have a lot of parameters in them, because access was crashing with them all together.
(See http://forums.microsof t.com/TechNet/ShowPost.aspx?P ostID=606327&Si teID=17) for details)
But after specifying all 34 parameter values programatically in my function, it works perfectly. Thanks a lot for your help. I've been working on this...Leave a comment:
-
Here is the query:
Status Criteria:
[Forms]![Input Search]![OpenY] Or <>[Forms]![Input Search]![OpenN]
Impact Criteria:
[Forms]![Input Search]![ImpactY] Or <>[Forms]![Input Search]![ImpactN]
Priority Criteria:
0 or (1 and [Forms]![Input Search]![Priority1] = true) or ( 2 and [Forms]![Input Search]![Priority2] = true) or (3 and [Forms]![Input Search]![Priority3] = true)...Leave a comment:
-
Richard,
Thanks for taking the time to look at my code. I inserted the code you suggested, unfortunately, its still giving me the error: "Too few parameters. Expected 34"
This is access 97 with DAO 3.51. I have read several places that 3.6 needs to be included, but when I tried it, it didnt make a difference here.
I will continue to try whatever I can think of, but if you have any other suggestions please let me...Leave a comment:
-
Openrecordset invalid operation
Hi guys,
I've seen a few other similar posts, but i still cant figure out exactly what I'm doing wrong or what i need to do to fix it.
I'm trying to find the ID number of the last record in a stored query. This method worked perfectly for a stored table, but with this query reulsts in an invalid operation error.
If I remove the DB_OPEN_TABLE parameter it says "Too few parameters. Expected 34." The criteria for this... -
Changing criteria of a stored query with code
I've been working on this for a while and I can't get the syntax right. I'm trying to use code to change the criteria of a stored query so I can toggle whether or not Null values are included in the search. If anyone knows a better way, or can just get the me proper coding to do this, it would be extremely helpful. Thanks.
No activity results to display
Leave a comment: