Thanks again for posting this code. I don't make a lot of pop-up forms and finding this code again was a big help!
VBA is still relevant in 2023!
Hoopla3000
Last Activity: Oct 8 '24, 03:47 PM
Joined: Oct 17 '12
Location: Pittsburgh, PA
-
It looks like the file SOC_AccessSolut ions_Infographi c.zip contains a copy of SOC_MSAccess_In fographic.zip inside it.Leave a comment:
-
Thank you missinglinq for the code. I was able to use this to work around another issue. If you have a textbox that is set to show the value as a hyperlink, so that the user sees the hand/finger cursor. I was using the OnClick event of the textbox to launch a form but nothing I would do would get the hand cursor to change to an hourglass. I suspect this is a bug in Access with the hyperlink feature.
Using the API code that you...Leave a comment:
-
I just noticed today that this doesn't work in Access 2013 as well as it does in 2010. It may be that the window height is returned differently in 2013 with the flat metro styling. Does anyone know a quick fix?
The attached image shows how the sizing differs between two versions of Access but the same application.
I just realized and should note that the Access 2013 image was taken from Windows Server 2012, which may...Leave a comment:
-
Cool idea Smiley. I've used this twice now with great success. In setting the window height, I added to the lngWindowHeight calc:
... + IIf(Me.Navigati onButtons = True, 250, 0) + ...
in case the form has the navigation buttons enabled.Leave a comment:
-
Be careful when using the formatted message box. If the content you want to display contains the '@' symbol, it will mess up the formatting. Maybe you could adjust your function so if the passed parameters contain @, it reverts to the standard message box (without the eval() function).Leave a comment:
-
Hyperlinks in Access have #'s too.
A hyperlink entry contains three parts separated by pound signs (#). The template is:
display text # file name # any reference within the file
The following link explains in more detail:
http://allenbrowne.com/casu-09.html
Hyperlink fields can be challenging to work with if you don't use them a lot. For storing paths where a clickable hyperlink...Leave a comment:
No activity results to display
Leave a comment: