Search results

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.

Access 2007 finding Word 2003 -------------------------------------------------------------- Hi Roy, Many thanks, once more, for your response. In fact, the only way I had been able to overcome this challenge IS, as you also suggest, by specifying the precise path to the OFFICE11 directory...

Access2007 Runtime cannot find Word2003 & Excel2003 Files Hi Roy. Many thanks for your response. The utility has been successfully using command buttons within MS.Access to open Word & Excel files. I have used a mixture of CreateObject and Shell to open the files. Pre-Access 2007, I have had...

Many thanks for the response Aikea. The user's system has Access 2007 Runtime with command buttons that are trying to open Word 2003 and Excel 2003 documents. The user's system certainly has Excel 2003 and Word 2003. I am unable to test for compatibility because my development system always uses...

Hi Aqif, Did you ever solve this problem? I have the same problem with Word & Excel files when using Access 2007 Runtime.

I have been using an Access database for, among other things, opening Word & Excel documents from a click on a cmd button. I've had no problem in A2000 & A2003, nor do I have a problem in A2007 if the Word & Excel files are also in 2007. When the Word & Excel files are 2000 or 2003 though, I am...