Search results for query: *

Thanks a lot PH. I will work this way!

They both have predetermined fixed number of columns. I am not concerned about those records that are not in recordset 1 but are in recordeset 2.

What do you think of this: r1.MoveFirst r2.FindFirst (criterion where product location are equal to product location of r1) Should it work?

They have the same number of columns. Ideally they should have the same collection of (product,location) but it's not necessarily the case. That's why i thought that I should link my recordsets first so that I compare apples to apples when I perform my calculations.

I can do them in SQL but it would be very labor intensive/manual. I could get the calculation done in a sec through VBA code if I could figure out how to link my recordsets. Do you know a way I could do that in VBA ? Jay

This is the code I am using but I don't know how to link record sets 1 and 2 in the code with the same fields "product" and "location" Thanks! Public Function Comp() Dim ObjMyDB As Database Dim r1 As Recordset Dim r2 As Recordset Dim r3 As Recordset Set ObjMyDB =...

I have two recordsets. Each one of them has the fields: "Product" and "Location" and some other fields shown below. recordset 1: Product Location LW WK2 WK3 WK4 1 10 2 20 recordset 2: Product Location LW WK2 WK3 WK4 1...

Thanks a lot PHV

Thanks PHV. How would I go about If I need to create a table on the fly in VBA code with number of fields equal to the number of fields returned by my crosstab query. I think I need to create a table on the fly because my crosstab query doesn't always return the same number of fields in the...

I have a cross tab query whose output looks like this: Product Location 11/5/2004 11/12/2004 11/19/2004 1 1 20 10 30 2 1 100 40 50 I like to copy these values from my cross tab query and put them in a table with the following...

Thanks a lot. It Worked!

I have a texbox control "RP_tbx" on my form that shows all records at the same time (continuous form view). I like to lock only records(values) in my "RP_tbx" textbox field that have a fiscal week less than the current fiscal week. Here is an example: FiscalWeek txtbox Feild1 txtbox...

It worked. Thanks a bunch Fancy!

I am trying to go to a particular record in my recordset and I using this line of code rst.FindFirst "[Weekending] =" & 1/14/2005 and it doesn't take me to the current WeekEndingDate record in my recordset. I tried using: rst.FindFirst "[Weekending] =" & #1/14/2005# but it doesn't work...

Thanks a lot VBSlammer. I really appreciate your help

Thanks Fancy for the reply. Once I change the value in my text box ... It turns to red like you said ... Now I only want it to change back to black only if my text box value returns to the original data value. My form is in form's continuous view showing all records at the same time. Plz let...

I have a text box contriol that is bound to one of the fields of the table. I like to hightlight/changecolor of the data values in my textbox control when they are updated. Can any tell me how to use the oldvalue property of the text box control to do it. Thanks! Jay

VBSlammer, I really appreciate your feedback on conditional formatting but I am having a hard time understanding your code. Can you be more specfic on how the above code will work. I am new at VBA programming and doesn't know much about all the powerful features it offers. Thanks!

Thanks Roy, It Worked!

I am assigning a value to the variable in a subprocedure behind my second form. When I move to my first form, value of the variable is gone. I like to save this value even when I navigate from my second form to my first form. I tried to define my variable as static but it doesn't work. Any...