Recent content by uji_amira

I use Microsoft Outlook to send email from Access. From Refrences In Msft Access, I tick Microsoft Outlook 9.0 object library. I declare mail object and item as below : Dim EmailApp As Object Dim NameSpace As Object Dim EmailSend As MailItem Set EmailApp = CreateObject("Outlook.Application")...

I hv already set it to 10 seconds, but still to no avail.. I set the properties and the timer procedure (2 place). Did I forgot to add anything else?

enable property to YES? Where should I set it? I hv already set the number as 1000 in the form properties for timer interval.

I have 1 form that 1 want to refresh the subform based on certain interval. I have set at the form open procedure to set the time interval as 1 second Me.TimerInterval = 1000 I have also set at the form properties the timer interval as 1000 . In the ontimer event procedure, I hv copied the...

query - group by thanks for the feedback. I hv already tried the statement above before I posted, but it will still gives duplicate records for same tkt_no (problem) if there are any difference in any of the above fields - status, ticket_finish_time. Any ideas how to just select unique record...

I have several records to search for. I need to select just 1 record for each Tkt_no group using Tkt_id (max no). Example, I only want to select Tkt_No Tkt_ID Ticket_Problem Ticket_Status Ticket_Finish_Time 1 14 problem 1 Done 2 10 problem 2 Done 00/01/1900 20:00 3 2 problem 3 Ongoing...