Search results

Thanks Hello all, Many thanks for everybody's feedback. Finally, all that I had to do was change the TRUE statement to FALSE (in the original code I posted) and the email sent without bringing up the error message. (I actually did not want the window box to appear, but being a...

Sorry - this problem now resolved. thanks. Jool

Hello, I've been trying to modify a database I downloaded from the Microsoft site entitled 'Inventory management database.mdb'. Using Macros developed by microsoft for their example database (which I've modified) a macro opens up a list of reports - which can be individually opened up by...

Almost got it.... Just an update - someone from a different forum has suggested this code: Dim strEmail As String, strSubject As String, strBody As String strSubject = "Subject test" strBody = "Test message" strEmail = "mailto:" & Me.Email & "?subject=" & strSubject & "&body=" & strBody...

Just discovered that pressing shift when starting skips the start up screen. Phew....

Hello all, I had just created a startup screen which I wanted my access database application to open automatically in. On the tools menu I selected the startup option and specified the file I wanted to appear in the startup. I used a form for this but noticed that a forward and backwards...

Hi TanisAgain, Thanks for that. However, the 'fix' suggested seems a bit beyond me as I don't have rights to change the mail server settings, and in any event, am trying to set this up on an access form which could be used by several different people with perhaps different server settings...

Update... Thanks Tanis and dsigner I have discovered I had specified the incorrect name for my dropdown menu button and the line should have read: strToWhom = Me.Combo98.Column(2) This however, is equally unsuccessful however, bringing the following error message instead: Runtime error...

Hello all, From a form, I have been trying to send a simple email message to an email address specified in a drop down menu on an access form. I was helped greatly by members of a different Access forum yesterday, but unfortunately I never managed to solve my problem (and today people seem to...

Hello all, I have created a button called 'Notify person' on an Access form. The purpose of this button is to notify a member of staff when an entry into a table has been made against his / her name. I have attempted to do this as follows. In the properties tab of my button, on the event...