Thanks Robin, I was trying to emulate a screen capture of the form for a report. The only way I've come up with so far is to manually select the record that is to appear as the first item in the report. I was hoping that I could have the program figure out the row that was at the (current viewable top) of the continuous form and then run the report based on that.
I think I have enough information to solve the problem now. If I use the Pagedown and pageup keys, I can accomplish what I want. I'll refine it a bit and share the solution when I get it done. Cheers Neil Squires -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Robin Sent: Tuesday, July 12, 2005 5:27 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Follow-up to Print a Form Thread (Cross post) Hello Neil, I don't know ifit's what you want but I just uploaded a possible solution to the Files section (I forgot to zip it). Same name as yours with Repair added to the end. Regards Robin. --- In AccessDevelopers@yahoogroups.com, "Squires, Neil" <[EMAIL PROTECTED]> wrote: > 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 > > -----Original Message----- > From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of A.D.Tejpal > Sent: Tuesday, July 12, 2005 1:35 PM > To: AccessDevelopers@yahoogroups.com > Subject: Re: [AccessDevelopers] Follow-up to Print a Form Thread (Cross post) > > > 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 ----- > From: Squires, Neil <mailto:[EMAIL PROTECTED]> > To: AccessDevelopers@yahoogroups.com > 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. > > <?---- LSpots keywords ?><?---- HM ADS ?> > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group " AccessDevelopers <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . > > > _____ Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
