Recent content by timitfc

Ok so i think i have found the issue with the whole thing... i found that changing the Controlsource from =Date()+7 to being unbound and then set on Form_load worked great. However, i then ran into another error when trying to use =Date() in a query- "Function is not available in your...

Thanks for the replies - in regards to ArnelGP's solution, this will work as it is a static page that is loading - the idea is to show cashflow for the current monthly period ( see link https:// prnt.sc/h59tzw ) I have just coded this to work on Form Load and it is working, however my concern...

Good Morning, I have an old Access 2003 DB that im trying to access on a new Windows 10 machine. Most forms are working completely fine apart from one that has textboxes with the controlsource set to =Date()-7, =date()=6, through to =Date(). The issue is these are not working. I opened the...

FYI just to let you know this has been resolved. I think Uncle Gizmo might have been along the right lines (although wasn't sure how to actually check this). I managed to get this to work by changing from Dim lfolder As Outlook.MAPIFolder to Dim olfolder As Object Very odd as I much prefer...

Strange that it works in Outlook but not Access though? How would i go about seeing if MAPI had been left out? Thanks Tim

Hi All, Has anyone got any ideas with this one? I'm still struggling to find a solution. Thanks Tim

SOLVED Hi All, I have recently upgraded my machine to Windows 10, and now I'm having issues getting some VBA code within Access 2003 to work. It has ran fine for the last 4 years and since upgraded to Win10 it no longer works. The code simply posts an appointment into a Public Folder Calendar...