[mso] Re: Access Question :VSMail mx2

I would rate my comfort level with VBA as moderate to good.  I'm pretty =
good at looking at code and adapting it for my use, not so good at =
coming up with the original code.  Mostly, it's a case of I know what I =
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 =
find that a very palatible solution, if there is something better that =
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 =
simple
way would be to use SendKeys but this is generally a frowned upon =
practice.
The better way but a little more difficult would be to use code to get =
the
current record and go to current record + or - 10 depending on which =
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 =3D
"pagedown".  The form runs off of a query and can have from 1 to =3D
hundreds of records, showing 10 at a time on the form, and I'd like the =
=3D
user to be able to scan up and down the form 10 at a time, without =3D
having to hit each record.  Right now I just put a note on the form to =
=3D
use the up and down page keys on the keyboard to do that, but I'd like =
=3D
to make it part of the form.

Thanks


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




*************************************************************
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: