Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Datasheet hell.

3 views
Skip to first unread message

Trevor Bradley

unread,
Mar 16, 1995, 11:58:13 AM3/16/95
to
OK guys... Come up with an explanation for this one... I'll simplify
the problem significantly.

I have a table with 3 columns, A, B , and C. I make a form for data
entry... and I want B to be changed whenever A is modified, and vice
versa. C will also be on the form, but will not have any event
procedures tied to it. A and B both have fairly strict formatting:
00/ 00/ 00.999 for an input mask, and format #.### (I think that's
right).

Anyways, A and B both have OnExit Event Procedures. I'm using the
datasheet view of the form exclusively. When the cursor is in these
two fields (A or B) in and record, I can move the cursor left or
right, but not up and Down! The only way I can move from record to
record is to move right to field C, move up and then move left! The
Record Navigation buttons go dead, and I can't even use the design
view button.... Everything works again when I move into field C. A,
B, and C are stored as text boxes on the form.

I recently fixed this problem by changing the onexit property and
moving the code to the Before and after update events. It now updates
properly when the data has been modified. I tried moving it the the
onChange event and it was able to move up and down, but no updates
occurred. (I assume this has something to do with a cascading
update.) I also tried LostFocus, which allowed me to move up one
record by hitting the upkey TWICE. GO figure.

Anyways: I have these specific questions:

1) Why could I not move up and down when the update code was stored in
the OnExit property?

2) Why did OnChange not modify the data? (Probably infinite loop, but
then why no time lag?)

3) Why did two up keystrokes move up one cell when the code was in the
Lost Focus Event?

I have one last question. When I attempt to delete one of my
formatted cells:
00/ 00/ 00.999

When I attempt to delete the cell outright by highlighting it, I can't
leave the cell without entering a new value. Null values are
permitted in the cells. How do I make this cell null?

Thanks for your time...

--
Trevor Bradley (tbra...@sfu.ca)
Simon Fraser University, Burnaby, BC, CANADA!
WWW (SFU LOCAL ONLY): file://localhost/home/tbradley/html/homepage.html

0 new messages