Re: Last try PLease Help!!

Two years ago when I was tasked with bringing a bunch of Excel files for
tracking a project into Access I had NO clue what I was doing, and VBA was
as mysterious to me as it would have been to the ancient Egyptians. Since
then I have learned an incredible amount, mainly by watching these forums,
and with the help of a few books by Ken Getz (Access 2000 desktop edition &
VBA Developers handbook). Stick around - learn all you can, and pass on what
you learn to others - it's a great feeling!

Happy coding!
;-)
SusanV

"Doug_C" <DougC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B5381AEA-E11A-4C32-8A60-5CC7FDDCBC06@xxxxxxxxxxxxxxxx
It worked!!!! I have been trying to do all kinds of workaround and finally
something worked. Thank you so much for your help, it is most
appreciated!!!!! This board has help me in many situations and I hope to
someday be able to help others on here.

Thanks again Susan!!!

"SusanV" wrote:

Hi Doug,

In that case, you would use the OnClick of the button to reset the
visible
property, something like

Me.btnCalculate.Visible = True

I haven't tested this against a "live" form, and the On Current *may*
over-ride this reset - let me know if it does.

SusanV

"Doug_C" <DougC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A4418D8F-D3A1-44E5-B83A-7513326D7F3B@xxxxxxxxxxxxxxxx
Hi Susan,

This works great!! Except, I have an edit button that allows edit when
a
password is entered. When I click on the edits button, I would like for
the
cmdCalculate button to be visible. If you know how to do this last
step, I
will be finished and ready to present.

Thanks!!!!

"SusanV" wrote:

Assuming the button is called btnCalculate, use the On Current Event
of
the
form and show the button only if this is a new record:

Me.btnCalculate.visible = Me.NewRecord

--
hth,
SusanV



"Doug_C" <DougC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A196E2B1-B195-4F1E-BB87-05B6B3CDF91B@xxxxxxxxxxxxxxxx
Hello,

Ok, I will make this simple. I have a form that opens to a new
record,
say
this one is record #23. Once the information has been entered and
the
user
clicks AddRecord (now showing record #24) if the user goes back to
record
#23, I want the Calculate button to be "Invisible". How do I do
that?
Please
simplify and if it is with VBA, please let me know which control and
event
to
enter it.

Thank you much!!!!








.