How to tell if a form is open
I want to know how to return a value telling me whether or not a form is
currently open. Something like this pseudo-code:
If Forms![new appointment].Open = True Then
'send harry a box of chocolates'
Assuming Access 2000 or later:
If CurrentProject.AllForms("new appointment").IsLoaded Then
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nick Heath" <NickHeath@discussions.microsoft.com> wrote in messa...Blocking mouse clicks #2
In some lengthy operations, I want to change the cursor to a WaitCursor.
I'm using Martyn's CPersistentCursor to hold this WaitCursor.
But for my surprise, a WaitCursor don't block the mouse clicks.
How could I achieve this?
What's wrong with BeginWaitCursor() and EndWaitCursor()?
"Renegade" <firstname.lastname@example.org> wrote in message
> In some lengthy operations, I want to change the cursor to a WaitCursor.
> I'm using Martyn's CPersi...repetitive windows update
Despite my Outlook 2007 is correctly installed and working, from
several days I am receiving KB980376 security update, that is unable
to install as "unable to find the related product".
Any idea on how to stop this bothering routine ?
I tryed to install manually with Windows XP Pro safe install : no
how can I ban right clicks on my pages - I dont really
want people to click wrongly on buttons. also how would I
stop the code for me to work on it though!!
You can use a event for this
Copy this in the Thisworkbook module
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)
Cancel = True
See Chip Pearson's site also
Regards Ron de Bruin
"amy" <email@example.com> wrote in message news:1df101c50c2b$bf1fb360$a...Publisher file won't open #2
I worked for three hours then Publsher crashed. I had saved my file,
but when I trie to open it it says problem with file, do you want to
report it, and then reboots Publisher. How can I save my work?
Using Publisher 2003.
You may send the file to me. If I can open it I'll save it for you. If it
crashes my system, you may be SOL. (Surely out of luck.)
If you want to accept my offer, send it to jl dot paules at gmail at com.
MVP Microsoft [Publisher]
"Don Smith" <firstname.lastname@example.org> wrote in message
news:r4ns615gkmkm12q5or5nd0k70gac5stjbc@4ax....audible click when opening a new window.
I know I should be able to find this somewhere but I can't seem to figure it
out. When I open a new folder or window there is a "click" sound that the
computer makes. How can I turn this off?
"Start Navigation" and "Complete Navigation" are the relevant items.
Alan Edwards, MS MVP Windows -Internet Explorer
On Sun, 13 Jun 2010 13:56:27 -0700, in
>I kno...Start background thread when a UI button is clicked, and Update UI button from background thread
I was asked these questions during a technical interview:
1) When the user clicks on a button on the form and that invokes a lot
of heavy-duty calculations, what would you do?
I would use "BeginInvoke" to start a background worker thread to do
the heavy-duty calculations, in order to avoid blocking the main UI
Then he asked, "What does 'BeginInvoke' do"? I said it was a .NET
pattern to start a background thread from a UI thread. Did I get it
2) Why can't you simply update a button on the UI thread from a
background ...right click #2
Can a 'right click' menu be changed? I'd like to add some things
For example, I'd like to select some cells then right click on the selection and convert it to values
Also, I've recorded a macro that converts a selection to values, but it's probably not the most efficient way to do it. What's the easiest way to convert a selection to values through a macro?
This macro would add the ability to bring up the sort
wizard from the right click menu. I took the basic idea
from John Walkenbach's book Excel 2000 Power Programming
with VBA. For more information ...Opening Workbook to a specific cell
I share a workbook with other users. We would like the workbook to always open with the cursor at the last edited cell for all users. How can we set a workbook up so that no matter who opens it, the cursor is always on the last edited cell?
this would require VBA (using an event procedure and somethere storing
this last cell information). I'm sure this will get complicated in a
shared workbook so I wouldn't do this honestly
Steve Arrants wrote:
> I share a workbook with other users. We would like the workbook to
> always open with ...How do I set pop-up Reminder Window to turn off Out of Office?
When I return to the office after being out, the older version of Microsoft
used to have a pop-up Reminder that my Out-of-Office was on, and I was
prompted to turn it off if I wanted to. Is there a way to set it up so I get
that Reminder with this version?
what version of Outlook do you use now?
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-R...OL 2003 very slow open HTTP link
I installed Office 2007, hated it, removed it and reinstalled 2003. Now my
OL (2003) acts just like the OL (2007) and takes forever to open links to
the web. Http... any ideas? I removed all folders that reference Office12
...Certain users cannot open attachments
I some users that can't open attachments in Outlook,
saying they don't have sufficient rights.
This is outlook running in a Citrix environment.. seems
like a time out issue. Anyone seen this?
...Question about the Windows 7 API CodePack
A question about this item:
I installed it, built the solution, and figured that I could just set
a reference to the DLL and use it in my code. Instead of getting one
DLL, each of the five projects in the solution creates an 88k
Microsoft.WindowsAPICodePack.dll. And when I set a reference to any of
them from my program, I can't use the various interfaces and such.
For instance, this code:
For Each folder as IKnownFolder in KnownFold...chat box dont appears when double clicking on a contact person
In windows 7:
The latest version msn messenger live:
When i wil chat with one of my contacts, to double click on this contact, my
chatbox dont open! I do see my chatbox below, in miniature on my taskbar,
and also there cant i maximize the chatbox due double clicking on it.
Someone have an idea?
For all the people how can help me, thanks in advantage...
It's probably displaying the window off screen, say if you had some Messenger conversation
windows up before the screen changed resolution for a game or similar.
To bring it back into focus, hover over ...How to open various Excel files on its on windows like Word do?
Tools>Options>View>Windows In Taskbar
Make sure 'Windows In Taskbar' is checked.
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
How do I either: -
(a) Interpret a physical double-click as two successive single clicks.
(b) Receive double-click messages (WM_LBUTTONDBLCLK). I know I have to set
CS_DBLCLKS - but where and when?
Maybe I should add ON_WM_LBUTTONDBLCLK() to my message map...
"Brian Toothill" <.> wrote in message
> How do I either: -
> (a) Interpret a physical double-click as two successive single clicks.
> (b) Receive double-click messages (WM_LBUTTONDBLCLK). I know I have to
> CS_DBLCLKS - but where and wh...Excel not opening with a blank document
When I open Excel, it no longer opens with a blank
document. It is now opening a document without asking for
it. This is happening only on one PC, so I assume there
must be a setting or something to that effect. Am at a
loss of the solution. I would appreciate any help.
I'd guess someone put a normal XLS in the user's XLSTART folder. Excel will
automatically open any files there when it starts.
"Rhonda" <email@example.com> wrote in message
| When I open Excel, it ...Excel window visible!
Can someone tell me why do I see the Excel Window(without the sheet)at
the execution of my script that read the first line third column ofa
specific sheet? This script run's under XP on my local machine. Hereis
Set app = CreateObject("Excel.Application")
app.ScreenUpdating = False
app.Application.EnableEvents = False
app.Visible = False
Set Workbook = app.Workbooks.Open("D:\Robert\DOCUMENT\XLS
app.Application.EnableEvents = False
app.ScreenUpdating = False
app.Visible = False
intRow =...Outlook hanging when I click on a hyperlink.
If I click on a hyperlink within an email, Outlook hangs
and has to be force-closed...anyone have any ideas how to
fix this ?
...Cannot open or import pst file
Have just had to rebuild me PC. I made sure to save and
make copies of my Outlook 2002 pst files before the
rebuild. I have now rebuilt and am trying to configure my
Outlook 2002, only I cannot add my pst files as I get the
following error message.
"File access is denied. You do not have permission
required to access the file".
This is driving me insane, any help greatly appreciated.
Exactly how are you trying to access the pst (file>open, file import, etc),
and where is the pst located (hard drive, CD, Etc)?
"Cathy" <firstname.lastname@example.org> wr...Creating new class on the basis of second dialog window
Creating new class on the basis of second dialog window, which goes in only
One man has the second dialog window (Visual C++ 6), which takes in editbox
- CString variable value. On the basis of it he creates the class CMsgDlg.
As a rule, he must create in the main dialog window class member-variable
m_dMsgDlg with the type CMsgDlg.
Then he insert into file main_dialog_window.cpp before the line
main_dialog_window.H - #include "MsgDlg.H."
Then with the help of the member-variable m_dMsgDlg,
from main dialog window he calls the second dialog window :
if(m_dMsgDlg.DoMod...open dba files
I have Windows 2003 and Palm 1S. Trying to recover Palm archive data in .dba
format. Windows won't let me cut or paste file from archive to pda. Can
anyone help? Thanks.
And your Word question is?
"ShirleyD" <ShirleyD@discussions.microsoft.com> wrote in message
:I have Windows 2003 and Palm 1S. Trying to recover Palm archive data in
: format. Windows won't let me cut or paste file from archive to pda. Can
: anyone help? Thanks.
...Adding Sent date to default new mail form
Is there any way to simply add the "Sent" time and date
field to the default form being used for creating a mail
message? My enduser print ouot the message before sending
it from that form and she woudl like to see the sent date.
...Ability to track open rates, click through rates, and forwarding r
Looking for CRM Add-in or alternative Email program compatible with CRM that
provides the ability to track open rates, click through rates, and forwarding
rates of emails.
...Clicking cells on sheet creates Text Box. How do I turn this off?
I have several sheets of a multi sheet workbook that seem to have Auto create
on for Text Boxes. When I click on a cell, then try to click the lower right
corner to drag the cell ad text box pops up in front of the cell and I cannot
drag the cell since the cursor automatically jumps into the text box.
This happens on 3 of 9 sheets in about half the columns. The sheets in
question originally were clones of a sheet that did not have this problem and
other clones don't have the problem.
Can not figure out how to turn this off!
This sounds like a macro gone awry.
If you clos...