Search results for query: *

I am trying to run the following function. I am testing two variables (whcih I have declared as public in the general declaration section): SFsum and rcount. I want to warn the user If SFsum <> rcount. It works fine when I have SFsum and rcount both equal to 1, 2 or 4. But When both of them are...

I had various controls on my form like tabcontrol, text boxex etc. for some reason i right clicked on my form and then clicked on Form Header/Footer and it removed header and footer from my form. Now all my controls are gone. Is there a way I could undo this or recover it. Thanks a lot for your...

Thanks. Let me see if I could make it work.

You mean it loses its value at the End Function Statement? I am using a standard module and I like to preserve the value of my variable so that I could refer to it in other standard modules. Thanks for your help Jay

Thanks but how could I keep the value of the variable live so that I could refer to the same value when i use it in other modules. Using the static keyword is not helping me.

I like to define a public variable in my module that can be accessed from other modules within the same project but I also like my variable to retain its value (life). Public MyVar as string (in the general section) This way my variable is accessible from other modules but it doen't take its...

Thanks a lot.

I am trying to execute this code: dim i as variant dim count as integer For i = 3 to 1 count = i+2 Next i It works when I say for i = 1 to 3. Any ideas or thoughts how to run a for loop with decending values like for i = 3 to 1? Thanks a lot in advance. Jay

I have a two dimensional array that I am using in my Access VBA code. I can reinitialize the values of my array (setting them equal to zero) by using the Redim statement. But whenever I use Redim statement I have to give dimensions for my array. Is there any other way I could reinitialize my...

Thanks a lot

Is there a function in Access VBA that converts a negative value to 0. I know there is a NZ function that converts null values to zero. I am just wondering if we have a function that converts negative values to zero. Thanks a lot in advance. Jay

Thanks a lot for your help.

I am trying to compute a varaible through the following formula: dim avg as integer dim test as integer test = 1 avg = (test = 1)* 4 Debug.Print avg it gives me -4 instead of 4. My test condition (test = 1) should return me 1 and my average should be 4 instead of -4. Any ideas why it's...

Thanks a lot

Is it possible to check the value of multiple variables at the same time through select case statement. In other words can i do this: Select Var1, Var2 case 2, 3 Code comes here End Select If Var1 is 2 and Var2 is 3 then execute the code. Thanks a lot in advance for your help. Jay

Thanks, That wizard helped. Once I know what my duplicate records are, how could I go about deleteing them? Thanks!

I like to find duplicate records in an access table and also want to delete the duplicate records once I find them. How could I do it in Access Query or Access VBA? Thanks in advance for your help. Jay

How can i define "n" in the query design window. "n" is the index number of the ItemsSelected collection but if i select multipe items how it's gonna work. Thanks

I have a list box whose multiselect prpoerty is set to "Extended". I like my query to filter data based upon the selection(s) I make in my list box. But it doesn't work. I am using this as my criteria: Product Field Criteria: Forms![MainForm]![lbx_Product] I also tried to use this criteria...

I have a combo box which shows me two columns when I click on the little side button but once I make my selection it only shows me the first column. I see all of this when I click the right scroll button on the combo box. 1100 Fix 1200 Play 1300 King But Once I make my selection (for...