Search results

llkhoutx THANKS!!! You saved 2004 for me :D it works great!!!

probably a stupid question: but where to put the code then?! i now put it as code under a button... now i get an Error 91 -- Object variable or With block variable not set in: rso.AddNew

Dim db As DAO.Database Dim rs As DAO.Recordset Dim rso As DAO.Recordset Dim iLast As Byte Set db = CurrentDb Set rs = db.OpenRecordset("Query2", dbOpenSnapshot) db.Execute * from tbTemp it fails on the last line (Sytax Error). i'm not quite sure why, my vba knowledge is nog that hardcore :)...

Hello, i have a query and i must compact the results... The results are: date, time, eventID 25-10-2004 | 11:01:00 | 0 25-10-2004 | 11:03:00 | 0 25-10-2004 | 11:06:00 | 9 25-10-2004 | 11:07:00 | 9 25-10-2004 | 11:08:00 | 9 25-10-2004 | 11:09:00 | 0 25-10-2004 | 11:10:00 | 0 25-10-2004 |...

I found the solution myself: Query1 takes 2 seconds > MAKE-TABLE Query Query2 takes 2 seconds > MAKE-TABLE Query Query3 (which combines Q1 and Q2) takes 4 seconds total :p I'm happy!!! This is the code: DoCmd.SetWarnings False DoCmd.OpenQuery "Query1", acViewNormal, acEdit...

The problem is to get a unique ID for each returned result. Anyways, i'm also looking into this...

Hi i found this thread very usefull for a query i'm building. My problem is however, i used the example of EMP (Time In and Out A2K.zip ), the final query takes about 30minutes to complete. The first query shows the activities of a specific person: 10:01:12 Fred Login 10:03:10 Fred Loading...