Search results

Yeah, maybe too much christmas spirt?

Joe, i had a look at your website too & have added it to my favourites. As an enthusiastic amateur, i appreciate your generosity. I wish i were in a position to 'give back' to the community. Cheers.

To my friends, have a merry and safe christmas & thanks for the support in 2021. Appreciate it.

Figured it myself with help from : https://www.access-programmers.co.uk/forums/threads/send-email-without-outlook.295502/post-1544525 Cheers Terry

Greetings from Australia.

Friends, I'm attempting to send an email to myself using outlook periodically. I've attached my 'test' database. In that database is an unbound form 'Form1' on it is a textbox where a number divisible by 100 can be entered (just to test it). After updating this value, if it's divisible by 100 it...

Hey Pat, the application has been deployed. Split database of course. I totally agree with you, but i only have access to the BE when onsite ( infrequent these days) & wish to periodically get a feel for how much use the database is put to. It's a new application & i just wish to monitor usage...

@June7 , i've reached a similar conclusion. My research reveals that the 'sendobject' method, although simple, pops up the warning message. I use outlook automation for other email stuff. I normally select .display so the user can review the email, but will use .send instead and see if that...

@June7 , What if the users PC Microsoft Virus Protection is not up to date?. Will they see the 'warning'? I'm Playing with the following code. Just wanted to silently send myself a periodic status email. Private Sub Counter_AfterUpdate()' mock up form to test concept only. If Me.Counter Mod 100...

Pat, i wish to identify how often my application is used (opened). I figure, a reminder to me, every 100 uses may be reasonable. Ideally, i'd like the application to send me an email including the actual number of uses so i can keep track. This is only an idea. I currently keep a running total...

All did a mock up. 'Mod' works a treat, really simple. Something new learnt. Thanks all.

@arnelgp , the 'count' is saved each time the database is closed via an update query. I want to print a message after each 100 openings, that is 100, 200, 300 etc.I'd assume that @June7 's approach would do that as say at 100 openings, 200 openings etc then the if statement would be true?. I'll...

@June7 , to answer your question i have a counter on the main form that increments by 1 each time the form is opened & saves that value. So will this method work with 'each' 100. That is opened 100, then 200 iterations etc ?. I've not had experience with the 'mod' function so will have a play...

Friends, This must be simple. I currently capture the number of times a particular form is open. At intervals, say after every 100 openings, i wish to advise the user. Just cannot think whether there is a simple routine to do this. Direction would be appreciated. Cheers.

Cheer Abe. Welcome to the forum.

There is also a good treatise on building a search string on AllenBrowne.com. I've adapted this on multiple occasions.

Friends, Works! All Good. Thanks.

@MajP , I suspected something like this. Really appreciate it. Will incorporate you amendment into my code & let you know. To everyone else, thanks for supporting me. Cheers.

People, I've tracked down the offending code, See below. Also see my error trapping. This works. To recap, the error appears to only be triggered when opening the form when no record exists for that user. Once a record is added for that user, all is well. Appreciate any assistance Private Sub...

Gents error is '3021' 'No Current Record'. I've Trapped it with my Error Trapping Routine, but would rather it not occur at all. Will continue....