Recent content by micks55

As I said previously, DBguy is a Star and yes, I'm now sorry that I didn't comprehend the tip in #6. Thanks to all who contributed.

Great tip, Gasman. Thanks for mentioning that a Function called MsgBox would take precedence over the Access MsgBox. I did as you suggested and created a Function called MsgBox. eg: Public Function MsgBox(Prompt As String, Optional Buttons, Optional Title As String) I found the inbuilt button...

I wanted to check to see if I had my facts correct so I went back to an earlier copy of the FE which uses the inbuilt Access MsgBox extensively. I open frmMain (the start up form with Form_Timer “Detect Idle” code). Two temporary controls are visible: ActiveForm shows “frmMain” and IdleTime is...

Hi Isladogs. Excellent stuff in your web examples and I'll be spending many happy hours studying it all. I'm not a novice, started back in 1985 with an Osbourne "portable" (lol), but I'm not that skilled either and it was never my job, just a hobby. But, I am like a dog with a bone and I...

Hi Isaac. You prompted me to check again. I now find as follows ... I swear it did stop the code but a standard Access MsgBox now seems to NOT stop my Detect Idle code. However, while the countdown continues and my app seems to Quit, the MsgBox remains in the middle of my desktop (and the...

Thanks Gasman and xavier.battle. I seem to be sorted now and my Detect Idle and Eject Users code is not being interrupted when MyMsgForm replaces the standard MsgBox. Have a good evening. Mick

I did use a Public Function and all has tested ok. To test, I replaced one instance of Response = MsgBox ("The blah blah ...) with the new style Reply = MyMsgForm ("The blah blah ...) and it's correctly returning the button pressed as a string "Yes" "No" or "Cancel". So all is good and thanks...

DBguy you're a star. Tried a message form with timer 5000 and one line of code DoCmd.Close,, acSaveYes. It closed after 5 seconds. Tweaks to the message form are needed then I think you've cracked it. Not looking forward to replacing 100's of instances of MsgBox with the new form but maybe...

Excellent observation DBguy. I was thinking I had to avoid a Dialog form because it stops the code. But if I use a Message ‘Form’ that is a Dialog - so that it can return a value (Yes/No/Cancel) - then maybe I can use the Message Form's Timer event to close it if the user doesn’t click a button...

Hi All, When a MsgBox halts execution of code it can be a good thing, you can get a Response. The downside is that my Detect Idle code (1 hour) stops counting down and my Eject Users code stops looking for a tick in the Settings table. My problem is that one user has found that he can pick up...

Just to reassure everyone, it does have table level validations and form BeforeUpdate events so all is ok at the moment and the people who have been using the program for the last 12 years are competent and happy. The question was about adding/editing data validations or rules without issuing a...

Again, many thanks to all. Validation has it uses but the user will typically work on the job over a number of days so lots of messages popping up to nag him/her is not an option. The time to remind them of their failings is when they try to print the reports. Validation at table level is not...

Also. Personally, I would not store an ID anyway. I would expect part numbers to be unique so adding a unique ID is overkill. By storing the part number in full you will know what was fitted at the time of the repair. As Gasman and arnelgp say, your Parts table could/should have a...

Hi, Firstly, I'm no specialist so this might be rubbish. If the combo gets it's data from a table and you are actually storing the ID for a record in that table then I think you can't avoid the source table getting cluttered with a load of one-offs. However, if the Row Source of the combo...

Many thanks for all of the comments. The_Doc_Man and MajP have some great ideas for me to pursue and I've always said Access can do anything so I still think I will find a solution. I just need to find it soon because this will be my last re-write as I can see the tunnel at the end of the light...