Recent content by Dan25e

Thanks Minty. I amended... Set rs = db.OpenRecordset("Select [OR IR No], " & "[Attachments.FileName] From qryAtts Where [OR IR No] = " & ORID & " ;", dbOpenDynaset) in my original code and it worked first time. That's some useful Air Coding you did there! Thanks again.

Hi peeps, I have come up with this code... Private Sub Attachment_s__AfterUpdate() Dim AttList As String Dim db As Database Dim rs As Recordset Dim ORID As Integer ORID = [Forms]![IR Config]![OR IR No] Set db = CurrentDb Set rs = db.OpenRecordset("Select [OR IR No], " &...

The back end table has a field of the data type' Attachment'.

Hi peeps, My back end tables seem to have lost their attachments! I have requested backups of the tables from our IT dept going back between one and two weeks. While everything else is there they don't contain the attachments either. Anyone know what might have happened? :banghead: Cheers

Except it doesn't! The old method I used to send emails was the DoCmd.SendObject method and the database would 'wait' until the email was sent before running the next piece of code. In most cases it was a DoCmd.SaveRecord (important for some auditing code I have running) and then set a value or...

Actually I googled about and found this https://msdn.microsoft.com/en-us/library/office/aa220082(v=office.11).aspx From which I extracted this... Private Sub...() Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp = Outlook.Application With objMail .To = [a...

Thanks Uncle Gizmo. Problem is when I compile I get an method or data member not found error pon the bold and underlined... Set objMsg = Application.CreateItem(olMailItem) Any ideas? Is it a references thing?

Users are often swamped with emails during the normal working day and as such have requested that emails sent from the database either have the email subject as a coloured font as seen in Outlook or better still a category be assigned. I am not after personal control over anyone's inbox but the...

Peeps, Is it possible to send an email from an access 2007 database with a category? Cheers Dan

It's looking like one way to do it is on the On Current event set all the fields to .Locked = False and then do the lock...

No. I have a temporary field on the form that displays the DPLLock field so I can see that when the email is sent the value is being added. The records that have not had the email sent are all empty.

If the value in DPLLock is 1, lock all the fields listed in in the On Current event. As far as I can see the form is bound as each of the fields are linked to a table and it displays one record at a time.

Hi Peeps, I'm trying to lock certain fields on my form based on the value in a particular field. It seems to work the first time but applies itself to all other records in the database from then on! The starting point is a command button that sends an email and makes Me.DPLLock = 1. The...

Hi Folks, I need a nudge please. I have a timer form which closes the database after a period of time with DoCmd.Quit. Another form is open at this point but if a user has left it in the middle of editing it I want to be able to save the record in the other form and close it before the timer...

Turns out to be something to do with the first record in the table. I nulled the value and the error stopped showing up. Subsequent records do what they're supposed to. Anyone know why this is so?