Search results

My situation that generated this thought started when I was generating Outlook emails from my Access database. The messages and popups were all centering on the same screen. When youre trying to multi-task you're having to move things out of the way to see the message box. I figure if I can...

Off center. Top left (0, 0) or right of the Access active screen.

It is what we're talking about. Same thing.

As you look at this, does this mean I just get one option in terms of placing this message box? That I couldn't change the position to different locations for different message boxes?

I've got it working. Thanks for the assistance and coaching. The key was making changes to the Public Function as @Gasman recommended. I also like the technique for pulling in icons from the dll. Private Sub Command29_Click() fnCreateShortcut "Database_Shortcut", "\\sharepoint\Database...

@Gasman Can you post the code on both the Public Function and Button that you got to work on your computer? I don't understand your notes below and what you changed to make it work locally.

@theDBguy I got the Website URL and was able to open it.

Good options and if I can't get this to work, what I'll need to do....

Still getting an error when I add 4 parameters. I've tried without the " ", removed the ( ), added Call in front of the whole string. fnCreateShortcut ("Database_Shortcut", "\\sharepointxxxxxx\Files","\\sharepointxxxxxx\Icons\E2E_FE.ico","Database Files")

It needs to be automated. My users are spread across the country. Setting up their computers has to be done remotely and automated to the maximum extend possible.

New user setup requirement. They must have a desktop shortcut to a specific folder that opens a SharePoint site using windows explorer. Here's the code I think should be on the button, that isn't working. Very likely operator error. Compile error expect = Private Sub Command29_Click()...

I need to position the message boxes generated from the below location in different locations on the screen. Autocentering is causing workflow issues for my users. http://blog.nkadesign.com/2008/05/20/ms-access-enhanced-message-box-replacement/#comment-43261 Am I going to have to build some...

@bastanu Nice capability. Is the popMDB_Messages supposed to popup when I double click on a message line? How did you envision it being used? Did you consider using a check box or something other than clicking on the UserName line to select more than one but less than everyone to send a...

Imagine you has some messages you want your users to see. This form would keep showing them, until the user clicked on the trash button (hiding that message but only for that individual). See the attached database to see my starting point. With multiple users, how do I show all of the...

It's working on this end. Thanks for revising the code to allow for this flexibility.

And how about pulling values from 2 different tables in order to search?

Please do.

Since this is just a proof of principal, just add a couple extra characters to get it over the 255 limit. Easier to do it on your end.

Same error of it being too complex. Here's a sample dataset. Instead of using the time codes, I think this one would illustrate the challenge better. 2 tabs in Excel. 1st are various Document Types (Primary Key is DOC_Type_ID). 2nd has a couple documents that have both the DOC_Type_ID as...

stand by.