Search results

Hi Michael, Would appreciate it if you or anyone on this forum could paste a sample VBA to retrieve emails from a POP server. I've tried another method to retrieve emails, ie via Outlook, but that is not ideal because doing so doesn't capture the email address of the sender, therefore attempts...

Hi, I've created a linked table to a MS Inbox folder. With the linked table, I'm able to retrieve incoming emails to a particular email address. I am creating a Reply button on a Form which will activate MS Outlook, and the content of the email is appended just like any email client would...

Thank you very much Wayne. Got it now.

Hi, If I have a VBA that creates a new record eg: Dim db As Database Dim rsNewRecord As Recordset Set db = CurrentDb() Set rsNewRecord = db.OpenRecordset("uService", dbOpenDynaset) rsNewRecord.AddNew rsNewRecord("ContractID") = Me.ContractID rsNewRecord("DateReported") = Me.Received...

Resolved at last, the solution is to change the Regional Options to Short Date Format of: dd-MMM-yy.

Oops! my conditional check should be: DLookUp("[HolidayDate]","uHoliday","[HolidayDate]= #" & Format([ServiceDate],"mm/dd/yyyy") & "#") Problem remains though...

My regional setting is already set to ddmmyyyy actually, that's why it is so puzzling

Hi, I've a Macro with a conditional check for a date entered by user on a form ([ServiceDate]), which checks againsts a table (uHoliday) which has a date field [HolidayDate]: DLookUp("[HolidayDate]","uHoliday","[HolidayDate]= #" & [ServiceDate] & "#") Is Not Null The HolidayDate is a Date...

Got it. Thanks Dave...

Got it. the criteria for the query is as follows: Like "*cathy@ghi.com*" Thanks for helping...

Hi Dave, Is it possible to achieve the same thing from a query? Thanks...

Well... Thanks man. Truly appreciate your help Dave. Have a nice day.

Hi, I'm having problem in trying to create a query to display records: Eg. If I have a field with the following three records: john@abc.com ben@def.com; cathy@ghi.com cathy@ghi.com If I want to pick up records containing text "cathy@efg.com", the 2nd and 3rd records should be retrieved...

Fantastic! Thank you very much Dave. Your help is much appreciated.

Thank you very much Hay, it's just what I need.

Hi Dave, My table which contains a field for 'OLE Object', is pasted with a Jpg file. I've created a subreport as per your suggestion, but the graphic is not being shown, where could I have done wrong? Thanks for helping...

I'm a complete newbie when it comes to VBA, would appreciate some help here... I have a Form bound to table 'Service' and a subform (datasheet) bound to table 'ServiceEngineer', the linked field is 'ServiceID'. The subform allows user to select the names of Engineers (email addresses of the...

I have a report which has a fixed company logo. I would like to change it so that the logo is pulled from a table field. I will design a form to allow user to upload their own logo to the field. How should I go about doing it? as I'm having problem redesigning the report to use the new image...

Try the FAQ at: http://www.microsoft.com/office/infopath/prodinfo/faq.mspx

Hi Gadi, You may want to explore MS InfoPath, I've recently attended a tutorial organised by Microsoft in our locality. I've found it to be very easy to use.