Recent content by jwalacha

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