I ve managed to make a program that logs the CDR sys parameters from COM1 all the records seems to be ok but i dont know what option is for the agent login and logout and i really need to monitor this operation.
Thanks on advance
How can i transfer a Excel sheet to sql with DTS from Vb code and also create the nessesary table(if possible). Till now i use sqldmo to create the table but i was not able to create and execute the DTS.
Lets say tha my Form1 calls :
dim withevents cl1 as cl
set cl1 = new cl
and do all the stuff that i want .
What if i want to call from another application(or Dll) the cl and raise events; ( i want my form1 to react on the raise event of the second instance of the class)
In other words is...
i created a dll with my forms and the basic ADO recordsets i need.I managed to call the forms (newfrm) and write into the sql table but only the values that comes right througt the dll form (newfrm).
How can i take the public values from my primary from to the newfrm?
MY SQL STRING GOES LIKE THIS
SELECT TOP 50 FROM CUST WHERE CALLTRIGER = 0
LETS SAY THA THE 1ST USER TAKES THESE 50 RECORDS.
HOW THE SECOND USER WILL SELECT NEXT 50?
THANKS ON ADVANCE
LETS SAY THAT I HAVE 60000 RECORDS AND 20 USERS.
THE USERS CALLS 1 RECORD EACH TIME FOR EDITING.
HOW CAN I BE 100 SURE THAT EACH USER IS GOING TO CALL A UNIQUE RECORD.
I HAVE DONE THE FOLLOWING BUT IF 2 USERS CALL THE SQL STATEMENT AT THE SAME TIME ....
DoCmd.RunSQL "SELECT top 1 cust.*...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.