newby here... so take it easy.
I want my database compact on close since it is an application which deals
with lot of insert/delete kind of things.
I checked the option compact on close.

I currently use the "sendobject" to attach a report to an email with code.  
But the problem with this approach is it can only handle one attachment per
email.  I need to attach multiple attachments to an email.  I currently run
some code that sends several reports to a directory ...

I have a need in an application that I am developing, to invoke the screen
saver under certain conditions.  Any clue how I might programmatically do
this in VBA?

I want to take a string and replace any special characters like ()%$#- with a
space. For example, if the string is '(ABC # 123 $)' I want to return ' ABC  
123   '. Is there a function to do this? Replace only searches for one
specific string, but I need to say replace any single ...

I was just curious if it was possible to use the
http://www.mvps.org/access/api/api0001.htm API to browse for web folders?
I appologize for the bad verbiage as I'm not sure about the correct
termonology, but here it goes!

I use the FTPClient by Stuart McCall to transfer files to an ftp site. I want
to transfer a file with a temporary "tmp" prefix, then when it's totally
uploaded I want to rename it by removing the prefix. Here's my code:
   With New FTPClient

Hi, I'm trying to insert text into a table field. The code I'm using is a
simple "INSERT INTO..." code, now my problem is when I've written my code I'm
using:
...VALUES('" & txtVal & "')

Hello All,
I need some help writing a query that will help me do the following.
Column to be use
1.    Job Code

I am trying to figure out how to assign information from one table to
another. I have created a table of 60 businesses. I have also created a table
of 20 members. I need to assign each member 3 businesses. Anyone know how I
can do this. Help!!!

I get the run-time error '2427' error with the message "You entered
an
expression that has no value" when I run a certain report.  The query
is already difficult enough.  I'd rather just interrupt the message

I have many date fields that I want to validate a range for. I created this
function to pass in the text so that it will verify the date and then display
a message if it is out of range then cancel the change so it isn't committed.
Private Sub txtInDate_BeforeUpdate(Cancel As ...

I have a database that gets updated each year. We update by importing excel
spreadsheets into a new table which we then clean up to get rid of headers
and blank lines and to validate the data. Once that is done we merge the new
data into the existing data. The new data falls into ...

Is there a way to get table record counts from system tables in Access?  
I can do this in SQL server and it's much faster that running a Count(*)
query on each table.

I am priming up an auto number field in a table with a particular number and
then want the next records to be appended with the next numbers in the
sequence. If I prime back to a prior number the sequence seems to start wher
it left off.

I'm new to write VBA code. I have written a code to convert date in my owned
format. I write the code in Module. For example
Sub pDFunction(ByVal pD As String)
...