Search results

  1. O

    Totals Query VBA

    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.....
  2. O

    Totals Query VBA

    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
  3. O

    RELATIONSHIPS LAYOUT VIEW

    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!
  4. O

    RELATIONSHIPS LAYOUT VIEW

    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...
  5. O

    Mouse Pointer Dissappears

    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...
  6. O

    Mouse Pointer Dissappears

    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...
  7. O

    Creating a Form that looks like a monthly calendar to input employees work schedule

    Thanks for this, much appreciated!
  8. O

    Creating a Form that looks like a monthly calendar to input employees work schedule

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

    Creating a Form that looks like a monthly calendar to input employees work schedule

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

    Creating a Form that looks like a monthly calendar to input employees work schedule

    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...
  11. O

    Creating a Form that looks like a monthly calendar to input employees work schedule

    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...
  12. O

    Creating a Form that looks like a monthly calendar to input employees work schedule

    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
  13. O

    Access Office 365 64 Bit Random Crashes whilst 32 Bit All OK

    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...
  14. O

    Access Office 365 64 Bit Random Crashes whilst 32 Bit All OK

    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...
  15. O

    Access Office 365 64 Bit Random Crashes whilst 32 Bit All OK

    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...
  16. O

    Access Office 365 64 Bit Random Crashes whilst 32 Bit All OK

    Thanks very much for this detailed response, extremely helpful. To update you slightly I have already taken the step of changing one of the 4 users on 64 bit down to 32. They are a heavy user and went through the entire day without a crash proving unequivocally that it is a 32/64 bit issue. I...
  17. O

    Access Office 365 64 Bit Random Crashes whilst 32 Bit All OK

    Application error is consistent as follows: Faulting application name: MSACCESS.EXE, version: 16.0.12730.20270, time stamp: 0x5eb57471 Faulting module name: OLEAUT32.dll, version: 10.0.18362.836, time stamp: 0xd79b97e6 Exception code: 0xc0000005 Fault offset: 0x000000000008c808 Faulting process...
  18. O

    Access Office 365 64 Bit Random Crashes whilst 32 Bit All OK

    Hi all, I have been slowly developing my DB for 20 years and other than odd little issues it has been extremely stable. The DB users recently requested a basic means of allocating themselves and each other tasks. Rather than reinventing the wheel I used the MS Office Task Management template...
  19. O

    Tab Page Visible/Not Visible Not Displaying Correctly?

    Thanks everyone. I solved this in the end. All it was was there was a 'Forms!Quotes.Refresh' once side of the IF and not the other. I broke it down through elimination in the end line by line and as soon as this was put in it stopped the issue! Always the simple things!
  20. O

    Tab Page Visible/Not Visible Not Displaying Correctly?

    Thanks Thanks for your offer of help, please see attached DB
Top Bottom