Search results for query: *

I added couple of Me.FilterOn = False ..... still no luck. ~~~~~~~~~~~~~~~~~~~~~~~~~~ Private Sub cboQF_AfterUpdate() Me.FilterOn = False If IsNull(Me![cboQF]) Then Me.FilterOn = False Else Me.Filter = "[PERIOD] = '" & Me![cboQF] & "'"...

How do you clear the filter? I think I am just stacking it. The code above is all I have in my DB too.

.... By the way .... if I select the "second" or "third" value, then the filter works correctly. But it gets frozen then. Doesn't allow me to select any other values from the drop down. If I select the first value then it lets me selects 1 more. Then the forms stops to respond. If it helps the...

that kinda worked.... only loops thru 2 times. e.g. I selected the first Value in txtTime drop down list. It worked. I selected the second one it worked. but when I selected the 3rd. That value didn't even get assigned to the "txtTime". It looked like the form hung up on itself. But no error...

PHV .... tried it put gave me a "Exit Sub not allowed in Function or Property" error now. "LockPeriod" is a function in my case.

hi All, Can you please help me with this error msg. I get an "Unexpected Error" Message box with a Big Red X followed by the message "0:" I have a form with a "FilterOn" based on a text box's after update event. This in turns calls a function that gives me the error. After that my Filter on...

I tried the cross tab ..... but in the form, i cannot get it to line up like. FW19 FW20 FW21 FW 22 ......... John D A 1,000 B 500 I get FW19 FW20 FW21 FW 22 ......... John D A 1,000 John D B 500

Sorry the spacing got deleted when I posted. Jane's data for A and B code .... 1,123, and 1,120 should line up below FW20 (column).

hi i have a table with rows of data As below (Reaseon Delay can only be A, B, C, or D) Order# CustomerName Price FiscalWeek ReasonDelay 1 John D. 1,000 19 A 1 John D. 500 19 B 1 John D. 1,500 19 C 1...

Hi, I have 2 tables. One hold header info .... like nameID (primary key) name, address, country. The second table holds donor info: nameID (primarykey), amt, etc...... I QUERY these 2 tables linking by "Name ID" to get the following data: NameID Name Country Amt When I DO NOT do...

did you try DoCmd.Refresh .....

Thanks ..... was using IFF .... that was it. but now it's pops up a msg box as below: Enter parameter value ColA blank space ........... And when i just hit "OK" without any value the result is the CORRECT one i.e. the way I want values in ColC and col D. Any suggestions on a fix or...

Hi, Can you please tell me how I can do a IF in a query design view. Basically I have a query as follows: ColA ColB ColC ColD 12 14 11 10 In ColC: If (ColA-ColB>0, ColA-ColB, 0) In ColD: If (ColA-ColB<0, ColB-ColA, 0) Please suggest if there's a simpler alternative...