[AccessD] Question 2...returning to a form

Gary Kjos garykjos at gmail.com
Fri Jan 8 13:49:22 CST 2010


HA!  No no no.... I don't use data entry forms either. Anyforms for
that matter. I just write queries against Oracle tables. I used to do
forms way back in Access V 2 in 1996 or so.

I do remember that Data Entry forms behaved differently than forms
that weren't flagged that way though.

GK

On Fri, Jan 8, 2010 at 1:23 PM, Max Wanadoo <max.wanadoo at gmail.com> wrote:
> Don’t know Gary, do you know, I have never ever used data entry
> form....true.
>
> So John, if it is a data entry form you are using, Gary will give you the
> answer.
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> Sent: 08 January 2010 19:21
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Question 2...returning to a form
>
> If you have the form set as a data entry form maybe you can't return
> to an existing record?
>
> GK
>
> On Fri, Jan 8, 2010 at 1:07 PM, John Clark <John.Clark at niagaracounty.com>
> wrote:
>> huh?! ;o)
>>
>> Seriously though, I'm not sure what this is. I will look it up
> though...thanks for the tip!
>>
>>>>> "Max Wanadoo" <max.wanadoo at gmail.com> 1/8/2010 2:00 PM >>>
>> If you want to return to the record, save the Bookmark and then
>  reposition
>> on it.
>>
>> Max
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
>> Sent: 08 January 2010 18:54
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Question 2...returning to a form
>>
>> OK, for those of you that might have read my other post, this is the next
>> question...
>>
>> For those of you that may not have read it...or maybe your attention span
> is
>> like mine and...where was I...oh, yeah...maybe you just need a reminder...
>>
>> I've got an entry form, w/a button on it. Press the button and a voucher
> is
>> created from the data, and you get a print preview of said voucher. When
> you
>> close the preview, you are returned to the data entry form. But...and
> herein
>> lies the question...you are returned to record #1, and not where you were.
>>
>> This isn't a huge problem, because in reality, you would almost always be
>> done w/a record, once you print and wouldn't need to return to it. But,
> the
>> whole reason it goes to a preview to begin with, is that you can check and
>> amend data. So, if there is a reason to change something, I don't want it
>> going to record one and need to travel back to the current record.
>>
>> An easy, although not perfect, approach to this, might be to just open the
>> form to the last record...contemplating this anyhow. Most of the time we
>> will be printing the last record anyhow, so this would probably get us by,
>> for the most part.
>>
>> However, if for no other reason, I'd like to do this, just so I can learn
>> how to do it. So, how can I have my calling form return to its last known
>> record?
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
>
> --
> Gary Kjos
> garykjos at gmail.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com




More information about the AccessD mailing list