IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► eMag   Print This    All Groups  
View Group Edition:
Full Edition Your Edition || Prev Next || Subscription Center

Prestwood IT Newsletter Jan 2016 Issue - Access Edition

Subscribe!

Start subscribing now! It's free!

Each month on or after the 1st, and only once a month, we will send you content from up to 5 community groups. If you select this Access group, you'll receive the following content below mixed in with the other groups you elect to include.

Prestwood eMag
Our monthly opt-in coupons+newsletter.
portal.prestwood.com
  January 2016 - Access Edition (233 of 4,778 subscribers receive this group's content.) Year 18 Issue 1  
Your full service technology partner!


Expert guidance from working professionals!
Tech Services Info topic:
New Printer, Local/Wireless
by Eric Prestwood

Setup printer including downloading of latest drivers if needed.


IT Water-Cooler for Power-Users topic:
Stamp Out Spam
by Vicki Nelson

How to fight back against spam and reclaim your inbox. As you may know, the volume of spam messages sent across the Internet has reached epidemic levels. Some industry experts estimate that three out of every five e-mail messages that are sent today are spam. The spam epidemic is costing companies, professionals, and individual users considerable amounts of time, money, and resources.

What is spam, and what can I do about it? Spam is generally defined as an unsolicited mailing, usually sent to many recipients. Most spam is commercial advertising, often for dubious products, get-rich-quick schemes, or quasi-legal services. Spam costs the sender very little to send. Most of the costs are paid by the recipient or the carriers rather than the sender. Some effective methods for preventing your e-mail address from being captured, sold or abused by spammers in the full version of this article. Click the title to read more.


Off Shoring topic:
Off-shoring: You CAN fight back!
by Wes Peterson

Are you fed up with calling a company and finding yourself speaking to somebody in a foreign country? 

I am, and I've just learned of an effective way to fight back, help return jobs to America, and keep them here.

The best part? We don't have to wait for government to do a thing.






 Access Group Top 
Visit Group | My Group Settings
Language Basics topic (classic post):
Access VBA Comments (' or REM)
by Mike Prestwood

Access VBA, like all the VB-based languages, uses a single quote (') or the original class-style basic "REM" (most developers just use a quote). Access VBA does NOT have a multiple line comment. Directives are sometimes called compiler or preprocessor directives. A # is used for directives within Access VBA code. Access VBA offers only an #If..then/#ElseIf/#Else directive.


Language Basics topic (classic post):
Access VBA Logical Operators (and, or, not)
by Mike Prestwood

Same as VB. Access VBA logical operators:

and and, as in this and that
or or, as in this or that
Not Not, as in Not This


 Monthly Access Lesson
Language Details Topic:
Code Snippet of the Month

Access VBA is a non-OOP language with some OOP features. It offers both Subs and Functions. A Sub does not return a value while a Function does. When Subs and Functions are used in a class module, they become the methods of the class.

Sub SayHello(ByVal pName As String)
  MsgBox ("Hello " & pName)
End Sub
 
Function Add(pN1 As Integer, pN2 As Integer) As Integer
  Add = pN1 + pN2
End Function
General, Presales, & Installation Topic:
Resource Link of the Month: Access Team Blog

Keep abreast of what's taking place in the world of Microsoft Office Access directly from the members of the Access Team.

MDB DB & Tables Topic:
FAQ of the Month: MS Access Image Storage
Question: Should I store images in my Microsoft Access MDB database our outside and just store the name?

Answer:

Store the image outside of your MDB Access database. There are many benefits to storing it outside of Access including the following:

  • More easily work with all the images at once.
  • avoid the overhead of an OLE server
  • decrease the size of your MDB file
  • easily reuse images with other development tools such as a website, VB, VS.Net, etc.
  • Metadata is preserved
Language Basics Topic:
Tip of the Month

Execute more common evaluations first! Short-circuit evaluation is a feature of most languages where once an evaluation evaluates to False, the compiler evaluates the whole expression to False, exits and moves on to the next code execution line. In Access VBA, the if statement does not support short-circuit evaluation but you can mimic it. Use either an if..else if..else if statement or nested if statements. You will find that your code that makes use of this technique will be clearer and easier to maintain than the short-circuit equivalent and will execute faster than ignoring this issue.



Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]