After the form opens, could you kindly give some idea as
to how we reach the situation when the desired set of records are displayed
in the viewable area so as to be ready for the snapshot (Alt +
PrintScreen) ?
----- Original Message -----
Sent: Wednesday, July 13, 2005
01:30
Subject: RE: [AccessDevelopers] Follow-up
to Print a Form Thread (Cross post)
A.D.,
The
code you supplied for moving the current record to the top of the continuous
form works perfectly. I was trying to simulate a print screen by using a
report that looked like the form. I wanted to be able to determine the
top-most record without forcing the user to click on it first so that it would
be one less step. (I had contemplated recording the current focus,
moving it to the top, running the report, and then moving the focus back to
the beginning point.
I
spent a couple hours searching through MSDN and the Developer's Handbook, and
came up short.
I
think perhaps it's better to train the user to do it the right way
....
MsgBox ("To Create a Screen Capture of this Form." & vbCrLf & vbCrLf
& "Press <Alt><Print Screen>, Open Microsoft Word and Paste
<Ctl><V>.")
As
most "simple" things turn out. This was a large endeavor and I'm out of
ideas and ready to move on to a new topic. Thanks for the help, and if
you can figure out how to find the topmost record on a continuous form via
code, I'm eager to hear.
Have
a wonderful day.
Neil
Squires
Neil,
Could you kindly re-state the reason for trying to
find (programmatically) the top most record amongst those on display in a
continuous form ? This might help towards exploring a possible
work-around.
As per the thread so far, the impression had
been that in the first stage, the user clicked the top most visible record,
based upon which a report got printed and later you wished to re-display
that very record at the top. Apparently, there is some other compulsion
for seeking to locate the top most displayed record, even when faced
with a random combination of displayed records. More-over, apart from the
huge range of such possible combinations, there can
be no assurance that any of the displayed records should
happen to be the current record.
Best wishes,
A.D.Tejpal
--------------
----- Original Message -----
Sent: Tuesday, July 12, 2005
23:39
Subject: RE: [AccessDevelopers]
Follow-up to Print a Form Thread (Cross post)
I think I've about given up on the topic of
programmatically finding the top most record of a continuous form via
code. Would be very useful, but I think it may be easier to tell the
users to just use <Alt><Print Screen> for the screen
capture.
Thanks for the help.
Neil
Squires
-----Original Message-----
From: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED]
Behalf Of Squires, Neil
Sent: Tuesday, July 12, 2005 10:19 AM
To: AccessDevelopers@yahoogroups.com
Subject:
[AccessDevelopers] Follow-up to Print a Form Thread
(Cross
post)
Hi guy's. I uploaded a demo to the files
section. My apologies for not zipping it. Don't have a utility
installed yet at work.
I'm trying to get the lower right
hand button working to automatically select the top-most control on the
form. Any ideas or solutions are welcome.
http://groups.yahoo.com/group/AccessDevelopers/files/
File
Name FindTopControlOnForm.mdb
Neil
Squires
