Search results for query: *

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

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

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

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

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

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

I have a text box in my main form. I like to use DLookUp function as its control source to populate it with a single numeric value called CF. The reason I like to use DLookup function because I don't want the table containing CF to be opened when I am on my main form. This is becasue I am...

I have a recordet that I am updating in VBA. That recordset is based on a table and the table is the recordsource of my subform. How can I change the font of data values displayed on my subform' through textbox control when I update my recordet in VBA. I like to change the font or color so that...

I am creating a recordset in VBA using a given Table. I like to move to a particular record of my recordset based uponn a particular condition. How could I do that? Here is the code: Dim MYDB As Database Dim rst As Recordset Set MYDB = DBEngine.Workspaces(0).Databases(0) Set rst =...

I have a "mainform" that has a tab control in its header. One of the pages of the tabcontrol has a graph on it. The data values for the grpah ( 4 columns) are displayed in the detail section of my "subform" that is embedded in the detail section of my main form. I like to update my graph every...

I am struggling with finding the correct syntax to change recordsource of a subform control ("SubFormCtl")embedded in my main form ("IOSForm"). The source object for "SubFormCtl" is a form named "SubForm". This is what I am using but it doesn't work...

I have a subform control in my main form. The source object is assigned to this subform control on the fly. The source object is a separate form in my database. I like to assign a record set to the record source property of my separate form. I used this command" Forms![ISubForm].RecordSource...

I have a tab control in my main form and the tab control has 4 different pages. I like to fire an event when I click on the tab of the second page. The event is not fired unless I click on the 2nd page itself. But this is not desirable because the event (which updates graph on the second page)...

I am calculating the value of a variable defined as double in VBA but when i try to run the code it gives me the over flow error. CFLW = -1 * (WL / SumW) where CFLW, WL and SumW are variables defined as double Can any one tell me please how to get around this error? Thanks

I know how to reset the selection(s) made in a list box by using the itemsselected.count property but it doesn't work for combo boxes. Could some one please tell me how to reset the selection made in a combo box? Thanks!

I have a main table/recordset. The recordset has composite primary key that consists of two fields "Product Group" and "Patch Area". There are 368 different combinations of these fields. I like to create 368 different recordsets so that I could run an independent cumulative sum function on each...