Search results for query: *

Hello, Can someone confirm the character limit of the wherecondition in the command: DoCmd.OpenForm stDocName, , , stWhereclause ? I have defined my variable stWhereclause as a string (also tried it defining it as a variant) and I run into a 3075 syntax error when my variable is greater than...

Using a stored procedure that takes input parameters, I would like to do the following: Insert into table1(datetimestamp, seqno, loc, val) VALUES (@datetimestamp, 1, @loc1, @val1) Insert into table1(datetimestamp, seqno,loc, val) VALUES (@datetimestamp, 2, @loc2, @val2) Insert into...

I present a simplification of my problem here: I have two tables, Table1 and Table2, both of which contain a column: City. Table1.City contains 3 entries: Rome, Delhi, Boston. Table2.City contains 2 entries: Rome, Delhi. I want to select the city from Table1 that EXISTS in Table1 AND NOT IN...

Hi, I want to use the Object "WIN32_FIND_DATA" in my Visual Basic 6.0 module, but unfortunately, I get a Compile Error message "User-Defined type not defined" when I try and run the code. Can someone tell me what references do I need to add in VB6.0 so that I can use this...

Can anyone tell me how to access the MS Outlook Reminder window using VBA? I want to write code using Outlook VBA that will automate pushing the "Dismiss" button when the reminder pops up. Thank you.

Hey guys, I am executing VBA scripts based on the Application.Reminder of the ThisOutlookSession in MS Outlook 2000. I want to automate the Dismissing of the Reminder after I am done running the VBA script. Currently, If Outlook is running and there is no one to manually dismiss the reminder...

Hello Outlook Gurus! I am having trouble with a few PCs running MS Outlook 2000. The OS on these PCs is Windows 2000/ win 98. On one particular PC, each time I reply or forward a message, it seems to truncate the message text prior to sending. If the message is sent to 2 people, one may get...

Hello, I have defined the following cursor in my stored procedure: CURSOR CSrc_Dir IS SELECT dir_location FROM InvRelief_Dir_Info WHERE stock_or_ca = 'REPORTS'; I used the following cursor in my procedure body using the OPEN CURSOR - FETCH INTO variable - CLOSE CURSOR commands. If the...

Hi, I am getting incorrect results for my select statement when querying the table with the following information: Timestamp ID ------------------------------- 08/03/02 03:06:18 100 08/03/02 03:06:59 101 08/03/02 03:16:57 226 08/04/02 12:12:12...

Hi, I am creating a text file using the UTL_FILE package in my stored procedure. I specify the filename extension to be uppercase .TXT, although the file created has a ".txt" extension (or least it does when I look at the filename in Windows explorer") The problem is that some...

Hello, I have a VB application that uses DDELinks to monitor five (5) items and triggers respective subroutines when the item value changes from 0 to 1 (using the 'Change' procedure of the objects - item1, item2....item5) When 2 or more items change values at the same instance, one or more...

I have a PB8.0 Build 6028 application that is connected to an Oracle8i database with Oracle Failsafe installed. I would like my PB application to acknowledge that the database is failing over, and therefore not lose the SQLCA connection to the database during the time it is failing over to...