Search results
-
U
Lotus Notes to send email from Access
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")...- uji_amira
- Thread
- Replies: 10
- Forum: Modules & VBA
-
U
timer event
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...- uji_amira
- Thread
- Replies: 4
- Forum: Modules & VBA
-
U
select query statement (group by) function
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...