Search results

Count me in. Your idea of seeing (not) well is rather far fetched here. Some day dozens of new posts are made to this site. Some people may be away for a couple of days. - Long story short, it is very easy to miss things here. Yes, I know it was @isladogs who brought up the "I have never yet...

You just mentioned the error handler, which doesn't necessarily means that you are aware of the very similar but separately available Code Library functionality of MZ-Tools. If you want to implement similar functionality, either directly in VBA or in an external component, the most common and...

Are you aware that the MZ-Tools Code Library allows you to define custom code snippets that can be easily inserted into your code?

Can you provide a source for this? It seams rather illogical to me that there is a regulation ordering the disposal of backups. I cannot google any reference to this. What did show up in my cursory research however, are regulations about adhering to due process when records are disposed. - This...

Did you look into it and if yes, what are your conclusions? (If this was already mentioned in the thread, I must have missed it.) Compared to some of the other suggestions in this thread, this approach appears to me as much less complex and fragile. I didn't use Service Broker/Queues in...

I think this is intended way by Microsoft to solve your problem. https://learn.microsoft.com/en-us/sql/relational-databases/native-client/features/working-with-query-notifications?view=sql-server-ver15

You might be right. I completely missed those "Resume Next" statements in the code which make absolutely no sense, neither to me nor to the compiler, unless this code is inside an error handler. If it actually is in an error handler, then you made it impossible for anybody to understand the code...

Copyright law differs quite a bit from country to country in that regard. In general, it is very unlikely that just the T&Cs of a website are a legally sound basis for a transfer of a copyright. The likely legal situation is that by posting on the site the author of the post grants an indefinite...

Why do you want to wait before telling the user that the internet is not available? It looks to me as if you are not waiting for a response from the server or retrying to connect in those 10 seconds (actually, your code shown here waits for just one second). You're just waiting for ... what...

Why is the password length limited to 20 characters? That's too short in my opinion.

@The_Doc_Man , in general I very much agree with your opinion and the proposed course of action. In current context of this thread however, I disagree as follows.... They would be upset because globally disabling a standard keyboard shortcut for all applications (as @BlueSpruce suggested) is a...

If I'd do that, a mob of angry users would be at my doorstep with torches and pitchforks that very night. Did you read #51? I would never do that even if I could. (I can't). The people who can would also never do it. This is the most likely explanation. Why would that be relevant? Most users...

Just for the records... I've recently seen the tmpAccMonacoHwnd window (not form!) in a window list on my computer*. I assume, it is perfectly normal that this window exist. However, the dialog asking to unhide that window makes absolutely no sense, as this window is not a normal Access object...

The user never pressed the print button.

I do not know and I do not care. The problem is the other way round. Customers showed up with their genuine signed copy of the contract that according to the application was never printed out. I can't say how often this happened but often enough for my client to present this as a problem to be...

Well, the requirement to not print from preview was the status quo ante. The objective of this thread's underlying question was to get rid of this requirement. That was a problem with the polling of the printer queue suggested by others. Polling the queue is indeed problematic and for exactly...

I do not care whether the customer received their copy. I can change the status to printed anytime. But when do I do that? You leave this question unanswered and this was the core question right from the start of this thread.

I don't like this idea for reasons I will explain in the post after the next (#51). But, this just gave me an idea that would have been a super simple solution... I don't want to rob the users of the possibility to see the report in preview. However, I could show the user a preview but at the...

In theory it could. In practice it makes very little sense because the customer supposed to sign the contract is physically there, in person, expecting to get a paper copy of the contract just signed.

I reply to this because that's the potential(!) flaw with your code suggested in #34. My gut feeling (haven't had time to evaluate) is that half a second is too long an interval to reliably catch a document in the print queue of a PDF printer. At the same time half a second might be shorter than...