[mso] Re: Access
- From: Glenda Wells <gwells@xxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Tue, 4 Jun 2002 10:21:58 -0400
Actually, this is more what I had in mind, immediate, on-line and free. /gl
http://www.vbatutor.com/vbatutor.htm
-----Original Message-----
From: Colli, Anthony G [mailto:Anthony.Colli@xxxxxxx]
Sent: Tuesday, June 04, 2002 10:08 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access
gl-
Microsoft Press has a good book.
Microsoft Access 2000 Visual Basic For Applications Fundamentals
ISBN: 0-7356-0592-0
It's a pretty good book if you are learning VBA, but the examples are not
really all that useful for real world situations. There is a version for
Access 97 too, ISBN: 1-57231-319-6, it's basically the exact same book.
-Anthony
-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Tuesday, June 04, 2002 9:56 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access
Who's got a good source for learning VBA...the very basics? I want to do
the Select Case Peter mentioned but don't even know how to get started. /gl
-----Original Message-----
From: Colli, Anthony G [mailto:Anthony.Colli@xxxxxxx]
Sent: Tuesday, June 04, 2002 9:18 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access
gl-
Peters way is better if you might be changing, or adding to, the values in
the list. Creating a function to return a value will be faster, but if you
need to modify the code it will be more difficult to update.
If you create a table of numbers and values, use the Dlookup() function to
return the value you need.
-Anthony
-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Tuesday, June 04, 2002 8:56 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access
This looks good, but how to use it? gl
-----Original Message-----
From: Peter Chiavaro [mailto:kp@xxxxxxxx]
Sent: Monday, June 03, 2002 7:01 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access
Hi gl,
How about creating a simple definition table with 2 fields.
Num Value
36 1600
35 1580
34 1520
33 1470
etc.
Peter C.
Stuart, Florida
? Kp@xxxxxxxx
-_-_-_-_-_-_-_-_-
ICQ =3D 412633
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On = Behalf
Of Glenda Wells
Sent: Monday, June 03, 2002 5:05 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Access
I need to convert values in Access.=20
Example, 36 =3D 1600, 35 =3D 1580, 34 =3D 1520, 33 =3D 1470 etc. I = tried
nested IF, but it only let me do 13 at a time. There are about 60. I'm
reading = about Function Procedures, but it doesn't seem right.
Any advice appreciated.
gl
*************************************************************
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?Subject=3Dunsubscribe
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).
//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
*************************************************************=20
*************************************************************
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?Subject=unsubscribe
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).
//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?Subject=unsubscribe
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).
//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?Subject=unsubscribe
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).
//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?Subject=unsubscribe
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).
//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?Subject=unsubscribe
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).
//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?Subject=unsubscribe
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).
//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:
