Wondering if someone can help (1 Viewer)

[rshaw]

Hello Access world I am new here and would offer a great big hello to all of you

Secondly after hours of scouring the internet for an example to use on this form i had created. I have came up empty and at a loss on how to do this. I know it can be done i just dont know coding enough yet to make it work.

So my issue is this:

I have a form that users fill out all the information and it performs day counts, etc ( simple stuff) what i would like to do is i have a field called [DelayDays] and a textbox104 that contains the message "Delay Noted" . What i want to do is when the user clicks the delay button it adds 1 to the field [DelayDays] and unhides textbox104. I currently dont have that text box bound to anything as i was trying to get the button to update that [DelayDays] field.

Thanks in advance
any help offered is appreciated !!!

 

[CJ_London]

suspect you also need a button to reduce the delay - situation may have changed for the better or the user might have clicked the button too many times.

Your image does not show which box is which - two textboxes are highlighted, so best guess at this point is in the button click event you would have code along these lines

me.delaydays=me.delaydays+1
me.textbox104.visible=true

 

[Micron]

Not sure if you should be doing something else - like binding the delay textbox, giving it a default value of 1, and unhiding the 2 controls upon button click. Or not hiding, but disabling (at least that gives someone a clue that they are there). Unbound controls add a level of complexity that's often not necessary. It makes even less sense when the rest of your form is bound. Even unbound controls should have better names than text104.

 

[rshaw]

thank you so much for your reply
I am getting this error when i used your example any ideas?

 

[rshaw]

Not sure if you should be doing something else - like binding the delay textbox, giving it a default value of 1, and unhiding the 2 controls upon button click. Or not hiding, but disabling (at least that gives someone a clue that they are there). Unbound controls add a level of complexity that's often not necessary. It makes even less sense when the rest of your form is bound. Even unbound controls should have better names than text104.

Thank you for your response as well
the Textbox is unbound for now at least while i figure out the delaydays issue not adding one to the total in the field.

 

[Micron]

That's my point. There is no need for a solution to that problem if you bind it. You are making problems that you don't need to make.