[mso] Re: Access Question :VSMail mx5

Thanks James.  I think this will work.  Gotta figure out the exact form =
I want to use for error trapping.  The form will pull up different =
numbers of records as it is used, so I'll have to figure a way to get it =
to handle that, but I think I'm on the right track now.

Kelly

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of James LaBorde
Sent: Wednesday, March 24, 2004 5:17 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access Question :VSMail mx5


Kelly,

The code for each button is but a single line for the basic =
functionality:

Page Up:
DoCmd.GoToRecord acDataForm, "Form1", acPrevious, 10

Page Down:
DoCmd.GoToRecord acDataForm, "Form1", acNext, 10

Just replace Form1 with your form name.  You will also want to add a =
little
error checking to ensure that the user doesn't try to move past the last
record or prior to the first record.  This should get you well on your =
way
though.

James

-----Original Message-----
From: Nix, Kelly [mailto:knix@xxxxxxx]
Sent: Wednesday, March 24, 2004 2:43 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Question :VSMail mx5


I would rate my comfort level with VBA as moderate to good.  I'm pretty =
=3D
good at looking at code and adapting it for my use, not so good at =3D
coming up with the original code.  Mostly, it's a case of I know what I =
=3D
want it to do, but not sure how to tell it to do it.

I got another recomendation to use sendkeys, but as you said, I don't =
=3D
find that a very palatible solution, if there is something better that =
=3D
doesn't involve hundreds of lines of code.

Any help appreciated.

Kelly

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of James LaBorde
Sent: Wednesday, March 24, 2004 4:33 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access Question :VSMail mx2


Kelly,

How comfortable are you with VBA?  There are few ways to do it.  The =3D
simple
way would be to use SendKeys but this is generally a frowned upon =3D
practice.
The better way but a little more difficult would be to use code to get =
=3D
the
current record and go to current record + or - 10 depending on which =3D
button
they pushed.

James

-----Original Message-----
From: Nix, Kelly [mailto:knix@xxxxxxx]
Sent: Wednesday, March 24, 2004 2:08 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access Question :VSMail mx2


Hello All

I want to put a button on a tabular form that will "pageup" or =3D3D
"pagedown".  The form runs off of a query and can have from 1 to =3D3D
hundreds of records, showing 10 at a time on the form, and I'd like the =
=3D
=3D3D
user to be able to scan up and down the form 10 at a time, without =3D3D
having to hit each record.  Right now I just put a note on the form to =
=3D
=3D3D
use the up and down page keys on the keyboard to do that, but I'd like =
=3D
=3D3D
to make it part of the form.

Thanks


Kelly S. Nix=3D3D20
Technical Support / Systems Administrator=3D3D20
Waterstone Benefit Administrators, Inc=3D3D20
knix@xxxxxxx < mailto:knix@xxxxxxx>=3D3D20




*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
=3D
or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=3D20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =3D
quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will =3D
also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
=3D
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =3D
invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
=3D
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=3D20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =3D
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will =3D
also allow you to change your email settings to digest or vacation (no =
=3D
mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
=3D
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
=3D
invitation with instructions.  Once you are a member of the files group, =
=3D
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =
quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will =
also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will =
also allow you to change your email settings to digest or vacation (no =
mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation with instructions.  Once you are a member of the files group, =
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: