Search results
-
J
"You Can't Assign a Value to This Object"
So, how do I have this control's value calculated using the function? If I call this function from an event, such as the forms On Open event, it works. I want the calculation to be performed continuously on every record, without depending on an event to occur, since the calculation will...- jastek
- Post #4
- Forum: Modules & VBA
-
J
"You Can't Assign a Value to This Object"
I am trying to set the Control Source for a textbox = to a function in a global module that contains an elseif calculation. When I open the form, I get the error "You Can't Assign a Value to This Object". Anyone know why I get the error? Attached is a very simple database to illustrate what I...- jastek
- Thread
- Replies: 8
- Forum: Modules & VBA
-
J
After Update, On Change, On Exit, On Lost Focus
Pat - Thanks. You were right about the parenthesis. I still have the issue with getting the "you can't assign a value to this object" error. Anyone ?? -
J
After Update, On Change, On Exit, On Lost Focus
Here is the function I have: Option Compare Database Option Explicit Public Function CountDaysToSchedule() 'If not work is not completed and not scheduled and not started, then count days from initialized date to today' If IsNull(Forms!Input!dtFinished) Or Forms!Input!dtFinished = "" And... -
J
After Update, On Change, On Exit, On Lost Focus
That is what I did when I got the error. -
J
After Update, On Change, On Exit, On Lost Focus
My calculation is a lengthy if, elseif statement, which I have made a function in a global module. When I call the function from the after update event of "textbox2", it runs OK. When I set the ControlSource of "textbox1" to the function, I get an error "You can't assign a value to this... -
J
After Update, On Change, On Exit, On Lost Focus
I want a calculation for "textbox1 (called from a module function) to execute when the value in "textbox2" is entered or changed. Which event for "textbox2" is the best one to call the function; After Update, On Change, On Exit, On Lost Focus? Is there a disadvantage to making all of these... -
J
Memory Issue
Yes. I tried all the basic things such as shut down and re-boot. Nothing worked. -
J
Memory Issue
I created a moderately complex query, which works great. However, when I try to go back into the query in design mode I get the "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again." message. To see if it was an issue with my database...