Search results

Thanks for your suggestion. Unfortunately, after importing all objects, the Problem Form is listed in the Form section, however, when I try to open it to display or design mode, I recieve a message: "The Microsoft Jet database Engine could not find object Problem Form..." In the VB Editor, the...

Help- I think I have messed up something seriously because I can no longer edit a form. This is what happened... I started some code for a form button and I closed the VBA Editor without saving the code... I was asked to save Module1, but because I had so much open at the time, I had...

Thanks for the suggestion, but I can't get it to work...??? I programmed the "On Load", but then I open the form, it still opens with the old recordsource...

I am trying to set a form's Recordsource with a macro. Based on the user's input on an input form, clicking a button opens a 2nd form whose recordsource is determined by in the input of the 1st form. I have a macro that basically says, if checkbox1 value is -1, setvalue of...

Calculation Here is the main calculation. How would this be written in VBA? Or as a function in a module? Calculation: IIf([CPR]<[Min] And...

Thanks! That is a very good suggestion. My only concern is that the main calculation is already a long string of iif statements. Is there a limit on how long an iif statement in a query can efficiently run? The second calc is not long and could be added to the main iif statement...

clarification Actually, no. The calculation change would apply to all records in the query. On the input form, I'd want to have a checkbox for A-B and a checkbox for A+B. Which box that is check would determine which calc was in the query. Thanks for your response!

I have a query that contains a field with a calculation (a long series of if...then) Forgive me if my terminology is not right. I would like to be able to change the calculation in that field depending upon user-input on a form. Here is an illustraion of what I would like to do: Take query...

I have a query that contains a field with a calculation (a long series of if...then) Forgive me if my terminology is not right. I would like to be able to change the calculation in that field depending upon user-input on a form. Here is an illustraion of what I would like to do: Take query...