Recent content by cenderawasih

Hi all, Does anybody knows how to stop On Current Event? I have a loop under On Current event which will keep looping until time >= 9.00 a.m. When current time reach or exceed 9.00 am I want to stop the looping under the Form's On Current event.I've tried to put the coding in the On Timer event...

Hi...TheAceMan1...Thank you soooooo....much!!! You're my HERO......

Hi All.... I have a system which record test sessions. I need to automatically CLOSE the test session if the date for that particular test session is equal to today's date and the time is 9.00 am and above. So...I put the code in the On Timer Event for the Sign On Screen so that when the user...

Hi all... I have a program that requires to open the recordset of a query where the query has a few criteria. This is the coding: dim rstQryEmployee as DAO.Recordset set rstQryEmployee=CurrentDb.OpenRecordset_ ("QryEmployee", dbOpenDynaset) The above codes works fine...

Hi GHolden, i'm getting a sintax error from the SQL.This is how i code it: Dim strsql as string '****sintax error here***** strsql=INSERT INTO TBLTEMP SELECT * FROM TBLMAIN WHERE_ TBLMAIN.ID NOT IN (SELECT TBLTEMP.ID FROM TBLTEMP); '************************** DOCMD.RUNSQL "strsql"

Thanks Edski and BNPMike

BNPMike, How is it to do this in SQL....... When u said join...do u mean joining both tables in a query or by using SQL?

I need to add certain data from Table A into table B if and only if the data in table A does not exist yet in table B. The problem is, when i use the DO UNTIL Loop, The 1st data in table B that doesn't match the 1st data in table A is consider as UNMATCH data by the system although if that data...

Hi, I need to copy data from one table into another table and manage to do this if the destination table is blanks.When the destination table is not blank anymore(contains the first time copied data from the main table), then I want to add new data in the main table into the destination table...

The row source of this combo is taken from a query... and the combo is not bound to control source... There is also NO codes to change the data source because its an unbound combobox.

Do u know how to overcome this problem???

On opening one of my forms I have a combo box in one of it's subforms that occasionally will not dispaly the value for the linked criteria it is opened with. It will flash for a split second then disappear. It is also quite whimsical , sometimes displaying sometimes not. The query for this...

Thanks Rolliee......u really help things out..... using the "msgbox me.text0 " I found out that my query contains the wrong data.....after I change the query my Search/filtering function works fine........

Rolliee.... How to do a message box ssql??????

In the query design view. Then right click anywhere on the query....but not in the query fields area.....then select Properties.....then u can find ODBC Timeout field. The default value of this field is set to 60...change this value to 0.... that's it!