Solved

Position (Yes/No) Message Box

Posted on 2013-01-19
8
416 Views
Last Modified: 2013-01-22
Is it possible to position a yes no message box.

Reason is that when yes/no is pressed, whatever is directly under the button goes into focus and its very difficult to change it.

Any ideas welcome (except making own message box - too time consuming)

Thanks
0
Comment
Question by:SweetingA
8 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38797358
I've never noticed that.  But if you must, you could insert a line of code immediately following the msgbox call that sets the focus to the control you want to.
0
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 38797427
How about importing a msgbox form that someone else already made.  Since it's a form, you can position it using the DoCmd.Move function.  A  couple I know of are the MBox function found in:
Dimitri Furman's code and utilities

And the Enhanced message box in:
http://blog.nkadesign.com/2008/ms-access-enhanced-message-box-replacement/
0
 
LVL 84
ID: 38798160
Are you referring to a MsgBox call? If so, then I don't know of any methods (short of perhaps API calls, and I'm not even sure of that) that could be used.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 38798772
Could you set the focus to the appropriate control after getting the user's selection in the MsgBox?
0
 

Author Comment

by:SweetingA
ID: 38798838
fyed - makes no difeerence, can't seem to shift it

IrogSinta - thats a smart piece of code, i like that, but how do i position it one the form when it pops up?

LMSconsulting - yes a MSgBox call and from all info i can find seems its not possible

Helen_Feddema - as with fyed, for some strange reason its won't let me change the focus to somewhere else on the form

Regards
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38799002
Which of the two functions were you referring to?
0
 

Author Comment

by:SweetingA
ID: 38799062
Sorry, you lost me.

I was trying to use the designer message box but i have encountered two problems.....

- when i run the enhanced rich box version i get an error that all png files are missing
- i don't know which variables to change to position the text box somewhere other than the middle of the screen.

Before i was pressing standard text box and assumed the details had been very carefully copied but i just realised that is the Access standard message box as i used before

Regards
0
 

Author Closing Comment

by:SweetingA
ID: 38807795
The designer message box option works but there are a couple of errors thrown up which need to be  addressed.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question