Search results for query: *

Hello everyone, I would like to know if you can do the following in Win2000. For each user, limit their time usuage to 15 min. A screen will pop up and ask to extend their time if they want to. The system will store the total time period this user has logged on for his session. Can I do...

good ideal...thanks for your help.

Cause I have a program that needs to check the text the user entered while they are inputing the form. Some user will press enter, others may use the tab to move to the next block.

I use the key tab in the axcStringField. The 'Tab' key didn't trigger the KeyDown, KeyUp, or KeyPress. Therefore, i can't compared with vbKeyTab. Other keys like the 'Enter' key will trigger the KeyPress event.

Hello, I tried using KeyUp, KeyDown, and KeyPressed, but none will catch the key 'Tab' when I pressed the keyboard. Why event I should use to catch the user entered this key? Thanks.

Wow...that did the trick...you are my life saver...thanks vb5prgrmr

How can I have a user defined type with a user defined type? The follow would generate a compiler error of "Forward Reference to user-defined type". Thanks in advance. Private Type InputDetail RecordCode As String * 1 ResultCode As String * 5 detaildata As DetailRecord...

I tested and it works. Thanks. But how can I changed the Source name under the Source column in Event view to my application name? thanks

Thanks for all the information. You guys are great. Thank you.

Hello All, can anyone please tell me how to write to window NT's Event Log? A link to a site is good enough. Thank you.

Thanks for your help Sunaj, I didn't know .RecordCount does not work with Forward only cursors. But that didn't solve my problem either and time was running out. So I decided to changed to user function instead. At least that returned a recordset I can open in VB. Thanks for your time...

Thanks for your reply, but I need to compare a column's date with today's inside the function. What other ways I can get around this error? Thanks.

Hello, I am getting a 'Invalid use of 'getdate' within a function.' error when I use this GETDATE() function in my user function. Is there a way to work around this? thanks in advance. Create Function tb_getCustID () Returns @getCustIDTb TABLE ( [ChangeType] [char] (1) , [BeforeID] [char]...

Hello, I have a local table variable @tableTmp in my stored procedures. How can I output the whole table variable back to the caller? thanks in advance.

Thanks for all of your explanations folks. I now understand my problem clearly. Thanks

Hello, I am having difficulties with table variables in SQL2000. I have a stored procedures that select * from @tableTmp at the end of the script. Now, suppose I pass this table variable back to vb's recordset. Unfortunately, it said the object or variable is close when I try to use it in VB...

Hello, I am having difficulties with table variables in SQL2000. I have a stored procedures that select * from @tableTmp at the end of the script. Now, suppose I pass this table variable back to vb's recordset. Unfortunately, it said the object or variable is close when I try to use it in VB...

Hello All, I just want to know what does the 'GO' command do in a stored procedure? I noticed there is a difference when I put it in or when I left it out. It will usually cause compiler error when i put it in. Can anyone please let me know? Thanks in advance.

Oh I got the answer...cannot use Table.columnName only Select columnName From table

Server: Msg 170, Level 15, State 1, Line 27 Line 27: Incorrect syntax near '.'. Thanks