Search results

I’ve used ‘=Environ("UserName")’ in a text box on a form to capture the user name and would like to filter a combo box depending upon who the user is. The underlying table has the following fields and values: FileLocation UserName1 UserName2 G:\ Form...

No, I'd like to incorporate it into the drop down list of the existing combo box to keep it all consistent. If all else fails I can use your code (thanks) to put a button on the same form to open the database.

I'm attempting to use the contents of a combo box to direct staff to certain files on our network. I've used the following code: Application.FollowHyperlink Me.Combo41, , True, True It works a treat but I'm unable to link to a secured database. It's straight forward with a MS word file. For...

Thanks for the suggestions so far. I'm not prepared to use the Outlook Redemption programme as it may have further implications for the network at my workplace. Are there any other options???

I've used VBA (got the code off this forum) to e-mail the results of a query to a colleague. The problem I have is where a window appears displaying the following: "A program is trying to send mail using Item.Send A program is trying to automatically send e-mail using a Microsoft Outlook...

I didn't really go into any depth with my initial post - I would like a read only database to start up as soon as I put the CD in, a start-up form will appear with hyperlinks to other files on the disk as well as other items on the database. The information was merely to provide data to a user...

Can anyone please point me in the direction of a user friendly/free programme which can run an access file from a CD???