i want to pull records based on random sorting. i want that each time when
user asks for the report, the records are shown in different behaviour. how
can i apply it in my access database using VBA?

I can send vanilla text in the body of an Outlook message but I have no idea
how to construct a HTML message with pictures.
Any ideas?

I have a recordset that has multiple "CustID" values for a grouping. I want
to concatenate the "CustID" values into a string. I can do this via code by
opening the recordset and advancing through the records, creating a
concatenated string and adding each string to a table.

I have the code below that would copy data from one table (rsSource) into
another table (rsTarget). Is there a loop code that would enable me to do
something like the following:
Loop for N =1 till 40

How can I determine whether or not Outlook or Outlook Express has been
installed locally on a pc (VBA code)?

How to deal with the message that Access requires an exclusive lock on the
data base (for example when I come back to modify VBA code in a standard
module)? The message says that the user, "admin" (which is me!) has done
this? The file extension does not indicate that it is ...

We have 3 thousand vendor folders with 10 subfolders in each folder.
Many of the subfolders are blank and need to be identified so we can aquire
the information from that vendor to make the folder complete.
Could a script or macro be created to identify the empty folders, either by ...

I'm currently using Access 2003 and quite satisfied with what I can get from
it. I am just thinking if upgrading to Access 2007 will offer any
improvements apart from the UI (from a programmer's point of view).
Can somebody please tell me a few good reasons why I should upgrade, ...

I have a module that uses Outlook automation such that I need to define the
following,
         Dim objOutlook As Outlook.Application
         Dim objOutlookMsg As Outlook.MailItem

I have a report in Access 2007 with Grouping on BungalowNo and I am trying to
display the Name related to BungalowNo in the Group Header using DLookup.
However as the BungalowNo changes, the Name does not change.  
How can I get the looked up value to change as the group value ...

Can somebody please show me how to do this ?
I'm using Access 2003 (mdb). I've two tables 'tblCustomers' and
'tblAccounts', which have Many-To-Many relationship, ie one customer can have
many accounts and an account can be linked to many customers.

Can someone please tell me the best way to accomplish the following:  I have
a subtable with fields (Department, Job Title, Date In, Date Out, and a
Service Time field that automatically computes the weeks between the Date In
and Date Out fields).  If the Date Out field is Null, ...

I have a access table with a mere two vairables one uniqly identifies the
individual and the other identifies the group i.e:
John Doe       Alpha
John Roe       Alpha

I have my database split into a FrontEnd (FE) containing all the modules,
forms, queries, etc., and a BackEnd (BE) containing all the tables.    The BE
is linked.  I am trying to write some VB code that will automatically back up
the BE when the user is running the application.  ...

Can someone explain this to me? I sure hope this isn't something obvious....
I have a VBA statement:
       strWhere = ""
       strWhere = strWhere & "((BAND([Availability],1)) > 0 )"