Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Position (Yes/No) Message Box

Posted on 2013-01-19
8
Medium Priority
?
456 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 49

Expert Comment

by:Dale Fye
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 1500 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 85
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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

824 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