|
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
Please zip all files prior to uploading to
Files section.
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
|
