[mso] Re: Access - James offering help with Module :VSMail mx3

Glenda,

The first thing I would do if I were you would be to go into your Macros tab
and right click one of your macros.  Select Save As and change the Save As
to Module.  Then allow Access to convert your macro into a module.  Make
sure to check the boxes on the resulting pop up to have it add error
handling.  Once it is done, go to your modules tab and you will see your
converted macro.  Open it up and take a look.  It will give you the
rudimentary structure of the function and of error handling.  You can trap
for specific errors and handle them and/or trap for general errors and
handle all errors the same way.  How do you handle a report that has no data
(2501) for instance?  If you know what errors are likely to happen, you can
trap for those and handle them via your code without the end user getting an
ugly error that just tosses them out or just freezes.

James La Borde
South Western Federal Credit Union


-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Wednesday, May 28, 2003 9:54 AM
To: Glenda Wells; mso@xxxxxxxxxxxxx
Subject: [mso] Access - James offering help with Module :VSMail mx3


Hi All.

I read about Modules in the Help file.  Then I opened a new module just
to see what I'm getting into.  It looks scary but I'm ready to take the
leap.

I have several databases consisting of tables linked to ODBC databases
(SCT Banner).  I mostly use make table and append queries to extract the
data I need to work with then select queries on those results for
reports which can be columns of figures, letters, mailing labels,
exported to Excel (for charts & graphs) or Word (usually for mail
merges).

I "run" the data using a macro, linked to a button on a form, that
processes each make and append query then have other buttons on the form
to display or print reports.

My users only need to open the form and push whatever buttons makes them
the happiest.  For tried and true processes, the  database opens up with
just the form in view so my users have no clue as to what's going on in
the background.

If it can be made easier or more efficient, bring it on folks, I'm on a
roll (cinnamon bun actually)  ;) /g



-----Original Message-----
From: Glenda Wells=20
Sent: Thursday, May 22, 2003 6:39 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: RE: [mso] Re: Access Report Unbound :VSMail mx2


I'm willing to do the module thing.  It's just another option I know
nothing about.  ALL the help appreciated.  /g

-----Original Message-----
From: James LaBorde [mailto:jlaborde@xxxxxxxxx]=20
Sent: Thursday, May 22, 2003 6:04 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access Report Unbound :VSMail mx2



Glenda,


AAACCCKKKK!  All that work to make things run just right and you are
going to use a macro to run it?!?  Maybe next week we can walk you
through writing a module with error handling to run it for you.  Using
macros is a lot like driving your car without wearing a seatbelt, not a
big problem when everything is running smoothly, but if something
unexpected comes up, ouch!

James

-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Thursday, May 22, 2003 2:06 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Report Unbound :VSMail mx2



It's all working...PERFECT!  I just made a macro to run the process and
it's beeeeaaaaauuuuutiful!

This will replace a process that takes typically 5 hours a week,
sometimes more.

Thanks for holding my hand through this. Now I can take the holiday
weekend and enjoy it.  Yippee!

-----Original Message-----
From: James LaBorde [mailto:jlaborde@xxxxxxxxx]=3D20
Sent: Thursday, May 22, 2003 4:55 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access Report Unbound :VSMail mx3



Glenda,

Open the Sorting and Grouping Dialog Box from the buttons in the task
bar. There is an option for a section footer.  Change that from no to
yes and you will get a footer for each group of records.  Add it on the
grouping for your id or whatever you are using to id the person and you
will get a footer for each person.

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