Solved

Position (Yes/No) Message Box

Posted on 2013-01-19
8
397 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
 
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now