Recent content by pedrocat

I thoroughly recommend the accessdatepicker created by ' Copyright (c) 2003 Brendan Kidwell ' The latest version of this software can be found at ' www dot glump dot net/content/accessdatepicker/ It is an amazing bit of software; and easy to adapt to your needs.

Re: FileDialog that Works in Access 2010 Thank you to everyone who contributed to this code that I put together for a 2010 application ... for picking one file from a specified folder 'create dialog Dim f As Object Set f = Application.filedialog(3) Dim varFile As Variant ' my name for the...

The above code refers to queries which pick up the next action record. the caption includes the company/contact name so when you minimize the alrm form, you can see whose it is. Alarmpopquery sql SELECT TOP 1 Calls.ContactID FROM Calls WHERE (((Calls.CallDate)=Date()) AND...

Hi thaks again. In the end it was LAGBOLT who provided the solution with multi-form. The Search for info on 'non-default form instance.' pointed me to a great bit of code by Allen Browne in Australia. It works a dream. The only tweak that was needed to make the btnClose sub work, was to put...

Thank you for your thoughts. The multi-form looks like a work around I may need to try I have tried Ling's DoEvents, which would have been the neatest way to make work what I have. However it didn't work. tried putting it in twice. as suggested, then at the beginning of the function. But...

Hello All This is my first post here! I have been working with Access since Version 2, and have stuck with DAO and version 2000 format databases. I have CRM customer management database, which includes an action diary attached to the contact table. I can set an action for a...