Recent content by irishtyke

Hiding Access Application Window ************************************ Hi Linq, Many thanks for the tip here. The PopUp & diddle solution works a treat. However, because I am using Access applications with different window sizes, I am sometimes left with an overlap behind my PopUp window even...

Error Quitting A2K7 Runtime ********************************************* Hi Bob, Many thanks for the response and apologies for the delay. I need to find out why I am no longer receiving emails when someone responds in my subscribed threads. Keep smiling.

Yes Please !!! Hi Justin, I would love to see that one in action. Regards: TJ ;)

Window & Form Sizing Hi Shadow, So simple, yet I've been trying to achieve that for 5 years. :confused: Is there any way I can make my form's position centre screen? I have dragged the application window's right and lower borders to set the application window's size, but my popup form is...

When using fso.GetAbsolutePathName in A2K or A2K3 I am able to locate folders and files. However, in A2K7 this command does not work. Can anyone please help?

Given that this error arises whether the application is being quit from VB or by the top-right X, I am assuming that the sequence is the same, presumably to close all forms before closing the application. I've tried replacing the DoCmd.quit line with DoCmd.Close to see if I could trap it, but no...

No Progress Yet I tried the routine again with all 4 command lines bypassed but still received the same message. Am I right to assume that the error is in the Form_Load() procedure and that, because it remains visible at the back of the error message, I am looking at the correct form?

Error Quitting A2007 Runtime ACCDE Hi Bob, Many thanks for the prompt response. The entire error message is as follows: "The expression On Load you entered as the event property setting produced the following error: There was a problem referencing a property or method of an object." I...

I am using the free trial version of Access 2007 and it seems to do all I need. However, I have a glitch that I cannot bottom out. When I quit Access from a .ACCDB file there is no problem, but when I convert the same file to a .ACCDE and quit Access, I receive a message "The property you...

Hi Wayne, That is absolutely perfect. I've been trawling the net for days for such a solution. Many thanks.

Many thanks Sven. I am hopeful that ... DoCmd.RunCommand acCmdAppRestore ... also achieves the same thing.

Can anyone please help me with a little VBA? All I want to do is perform a test within Access to see if a specific Excel file is open, and if so, to close it.

I would be most grateful if someone could tell me how to set (fixed) the size of an application's Access window. The Access window is always fine and centred on my development system, but it always opens in full screen mode on the user's sytem. Although this doesn't affect the application's...

That explains the difference very clearly. I will accustom myself with ShellExecute for all future amendments and projects. Many thanks again. I know I cannot pick your brains on demand but I was intending to start a new thread later asking how to set (fixed) the size of an application's...

I saw that piece of code when I was first browsing for a solution but, to be honest, I didn't know there was a difference between ShellExecute and Shell. Anyhow, many thanks for your time and your advice Roy. You have been very helpful.