Search results

Hey, one more question regarding the MakeTable Query: Right now I use a form to show the user that the vba query is running, and in order to do so it starts the vba after a 1/2 second timer (then turns of the timer, zero duration). Said form dies not have any active controls, only some hidden...

@isladogs First, as I said I have a locked-down computer to work with, I cannot install software such as this on it, it is forbidden. As for the MaxLocksPerFile idea, like I said I do appreciate all the ideas submitted but that said I feel this is likely not the issue, and don't feel it is...

Thank you for all your replies. I appreciate ALL your suggestions and comments, and do take them seriously. Regarding the "never ending IIf()": After Access tries to create the table, and fails with the "Access has stopped working" error, when reopening the db I have a properly completed table...

Yes, re-read my last post, I edited it, it's moot, if that's the problem I can't do anything about it anyway. Thanks for the thought. I may just have to tell them I can't do it, and abort the project.

I just confirmed that Access actually does stop working, it won't help to ignore the error message, the logging stops, and CPU usage drops to zero. The application grey's out, the db has saved itself, and the attached error message comes up. The making of the table stops. There is no choice...

It doesn't hang. If Windows did not shut it down, it would complete. See the attached log file. It would be complete when reaching ID = 555.

"Oops! We ran into some problems. Please try again later. More error details may be in the browser console."

Thank you for your response, I only just now saw your edit. Problem: this is not for me, it is for another coworker (my customer), and I don't want them to discount the tool and just tell me "it doesn't work." Well how would I do that? If I break it up, the application still has to wait for...

Thank you for your responses. Well first, I'm not sure what "SP" is, stored procedure? Secondly, I believe that breaking it up into more functions is not going to increase the speed of the result, if anything the overhead of the procedure calls should slow it down as far as I know. Third, I...

Too big to post inline, and has many dependents too. Attached. EDIT: The attached text is now obsolete, I have reworked the function. The code has been changed quite a bit, the SQL recordset has been removed in favor of an append query which is now ran before this obsolete subroutine (which is...

Hello again, I am making a database for a institutional reporting and error-finding tool in a Sharepoint table. I have a complicated vba query that runs on several thousand records (currently, and will grow with time) and a few dozen fields per record. I have ran this before successfully, but...

TY, GTK.

Sir, I know you are right, and I strive to do the right thing too. But this button selects the record, and therefore it sets the record to be used. It is a record selector button, in a list of multiple records. That said, reading your post I figured out what the problem was, and I thank...

Update 1/27/21: Well I worked around the problem by adding vba that required a second button press to activate the "On Click" code. I never did figure out the problem, on the first press it always just selects the first record, so I added a count to ignore the first press, and code on other...

Oh, sorry, yes. As a matter of fact the subform does not have a visible header/footer.

Subform. Well there is another issue: previously I had both the OnKeyUp and the AfterUpdate events of the criterion textbox control (on the main form) tied to a subroutine on the subform that requeried the subform. I believe this may have been the problem, as when you go to click the button on...

Something just occurred to me: it might be in my live search code. It relies on two events: OnKeyup & AfterUpdate - for the textbox control on the main form. Could it be that the list is created on OnKeyup, then when you click on the button it runs the AfterUpdate event, which also requeries -...

Hello, As some of you might have noticed a few months ago, I have a very complicated and automated multi-institutional database. Here is the problem: I have a form and subform that selects a person's record, to fill in that component of another form. Sometimes the button works, and other times...

It's weird, Sharepoint seems to be the new big thing here to bring user input to a central server database from the masses, but when I did a little bit of Googling on the subject and watching Sharepoint training videos it appears to me (I may be wrong) that a traditional database is still used...

Yeah well it wasn't without it's (usual MS) hiccups either: Then when I tried to export to Excel: I've quit using macros months ago. FYI. Also: my institution won't pony-up for the 64-bit office, nor more than 4GB RAM, I wonder if the above overflow would've happened with 64b & 32GB RAM.