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
