Search results for query: *

Remou, I was creating my wherecondition dynamically, And as I got ready to paste my where clause, I noticed my error in creating the dynamic where clause! (in certain scenerios, I didn't enter a space between two OR conditions!) I modified my code and everything works fine now. Thank you for...

If I understand correctly, the above statement reads that I should use the OpenForm method of the DoCmd object in VB as opposed to the OpenForm method in MS Access VBA! IF that is the case, I need to look for an alternate method to open a form with the dynamically generated Where clause while...

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...

I thank George for his efforts and providing me with the code to create 320 insert statements. Although, I wouldn't want to have my client view a stored proc. with 320 insert statements, and I think you will agree. I was hoping for a solution for something along the lines as this: . . declare...

Both the location and value variables are defined as Numeric(7,3).

I actually receive the datetimestamp value as year, month, day, hours, minutes and seconds that I convert into a datetime format within the stored procedure. But for simplicity sake, it is ok to assume that I get datetimesamp as one entity. And yes, I have 320 parameters for loc values and 320...

thanks George for your prompt response. I don't yet know if I have the capability of receiving the vals and locs in the comma delimited file format. Can you also provide me with an alternate solution? thanks. Jay.

...as to the question George posed, currently, I am planning on receiving the vals and locs as individual IN parameters to the stored procedures. (The stored procedure is being called by a third party application - RSsql) I am, therefore, not sure about sending the list of locs and vals as a...

I am planning on populating close to 300 rows (320 to be exact) with this stored procedure. Thanks.

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...

Did you actually buy the courses from AppDev? I am curious as I am seriously considering doing that myself. Books don't cut it for me as well, and I don't have the time to attend a training course on VB.NET. Besides, when compared to the training in a classroom environment, the CD courses are...

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...

Alright, I understand now. Thank you, mattKnight and Golom. Jay.

Do I need to go to my menu-bar and select: Projects > References ..and then the appropriate Available reference for me to use this API ? And if yes, then which one is it? A bit lost here... Thanks.

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...

I finally found the solution to the message text truncating - problem that I was having with Microsoft Outlook 2000. Hopefully with this solution posted, someone won't be going crazy trying to figure out the problem like I did! Apparantly, I had an older version of MS Internet Explorer...

Joegz, MS Word is NOT being used as the email editor. The message format under Options -> Mail Format tab is HTML. This problem seems to happen on all formats. Following are a few things that I have noticed with my Outlook 2000: Brian Forwards an email to Me and Bob at the same time. I...

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...