Re: disabling memo field when form is entered if there is data in
- From: "Ron2005" <Ron.Nemec@xxxxxxxxxxx>
- Date: 28 Dec 2005 05:48:51 -0800
Well, I was finally able to open the file you sent me the second time.
I ended up opening it from the ZIP directory without saving it to a
special copy.
I got the forms to work and sent the mdb back to you last night, Hope
you got it.
Here are some comments I added to a "Read Me Form"
1) I changed the after update for the txtnumber field
2) I added the horizontal bars, but that may not have been necessary.
I was worried about the middle sub form and seeing all of the data.
3) I changed all the subforms to be dataentry and then changed them all
back and that seemed to make the biggest difference AND THEY WORKED
AFTER THAT.
4) I had to comment out the on current event for the documentation form
once the other part started to work. Probably should be on the after
update of the txt field. but that will overwrite what ever is there, so
I am not sure you even want to do that at all.
5) I would suggest NOT using the format for the date, because then the
person have to put in ALL 8 characters. If you change the format to
short date, which I did here, it will work just like an excell
spreadsheet date field.... a month a slash and a day will default to
this year.
6) I suggest making a small table for each of those dropdowns , and
forms to maintain them, that way all you have to do is add it to the
table and the form takes care of itself. If you end up having more
forms that have those dropdowns then you don't have to remember where
they all are later on when they change - people leaving etc..
7) the disappearing forms was because of not allowing adds but am not
sure what caused it to be off and then back on.
8) You might make sure that the vertical scroll bars are not on top of
one another, It makes it difficult to navagate if that is the case. And
that is part of why I added the horizontal bar. You may have to make
the fields smaller to get everything in in the form size. Particularly
with the documentation subform.
9) Somewhere as I was going through the forms I found a filter field
and took it out. But I could not find it on the original so I may have
added it myself by accident.
And these I thought of this morning while in the shower:
10) I believe there is a way to make icons etc internal instead of
through an external link. Because I was running it from a location
other than the original I got error messages whenever I opened the form
in both edit and run mode. If you make them internal then when you move
it to production you do not have to go around and find all the
locations / forms that have the icons and change the references. So
Make them internal and no changes will need to be done when moving it
to production or to another production site.
11) Make the mappings to the tables etc (and even icons) in a
HTTP/Server format as opposed to drive letter format. That way it will
work even on someone's system that has different drive mappings.
Hope all of this helps.
Ron
.
- References:
- Prev by Date: Tick a checkbox, unhide a tabpage
- Next by Date: Re: Maximize
- Previous by thread: Re: disabling memo field when form is entered if there is data in
- Next by thread: On Got Focus
- Index(es):
Relevant Pages
|
