Recent content by Oreynolds

Thanks. The problem is that I have to calculate about 12 values and am currently already using a DSUM for each which works fine. The reason I was looking to try it with a query was to see if speed the process up.....

Hi, I have a totals query in VBA which has only 1 column which creates a single totalled value. Can anyone advise how I can then take this value and then assign it to a variable so I can use it elsewhere? Thanks

Yes could do but when adding tables etc its such a pain to rearrange things so you can see what your doing for it only to get undone by the time you next go into it!

With a growing DB and ever-growing relationships view I keep trying to rearrange it all to make it clearer and easier to understand however after saving and going back in it always seems to condense all the tables on top of each other at the top of the screen. Has anyone else experienced this...

Hi, thanks for the comment. In answer, there is no pattern to the cursor disappearing, it simply happens randomly on any form at anytime. In terms of on timer events there is one that runs on the main switchboard form that runs a small block of code every 1 minute to check user activity and...

Hi, I am experiencing an issue with the mouse pointer disappearing intermittently whilst using Access. It completely vanishes but then just reappears a few seconds later (anywhere between 2/4 seconds). We are using Windows 10 and Office 365 latest version. I thought it was related to my...

Thanks for this, much appreciated!

Thanks for this Gasman, really appreciate it. 32 bit is fine, thanks

Thanks for this. Haha, no I certainly haven't been banned from any forum so definitely not that!

Yes I have tried this but despite registering for a UA account I have never received the validation emails. I have tried resending them and using a different email address but nothing comes through. I have also emails the moderators but no response there so am a bit of a loss on that one. Its a...

Thanks Gasman, yes that link works but there is no download link in that thread. You then need to goto post #5 and click that link which then doesn't work for me? Out of interest are you able to download the file on post #8 of the following link as again it won't let me for some reason...

Hi, I am really interested in the Peter Hibbs calendar module discussed in this thread. I get errors for the links to it on UtterAccess, does anyone know anywhere else I can obtain a demo copy? Thanks

Thanks, no confusion is not great and whilst downgrading to 32 bit is a fix in the short term it doesn't bode well to leave known issues in the DB that will come back to bite you going forward on 64bit as and when MS pull the 32 bit option! I will look at your audit log idea, thanks. In answer...

Thanks, I could do this but as per my previous post the crashes are not related to the task module, they occur randomly from just about anywhere. It’s only that they have started since the task module was introduced back on 15/05. The obvious source would be the tasks but if it’s crashing when...

Thanks again for your response, and the answers to your questions are where my confusion starts. My method for tracking down the source of the issue was to create an Excel log that all users were instructed to record details of every crash they experienced. By doing this I hoped to find a...