When running this command, I get an Outlook message box telling me that "a
program is trying to automatically send an e-mail on my behalf using the
item.send propery, and do I want to continue".
it's very annoying and unnecessary for what I'm trying to do - how do I turn

Need code example of how to save an open table to new .mdb with VBA?
I want to create a command button in a form that will save data just entered
in that form to a new .mdb at a specified path/folder. I got the command
button part need the code.

I'd like to place a button my my form that will clear all data entered into
fields on my form. I've tried using the command button wizard: form options:
refresh form data, but that's not really what i need.
any ideas?

when i start a programm every option, which is before (12) makes two things:
open a report (which is ok) and open a msgbox from section (12) (what should
happen olny when i choose option (12)). When i choose option (12) it opens
itself and option (13). What is wrong in the code? ...

I have a couple of text boxes in my form that need to be locked once data is
entered so that it cannot be amended.
Can anyone assist??

I have a sub form within a form and when a second person opens the form the
sub form is blanked out on the latter person to open it but the form itself
is ok. It also takes about half a minute to open the form for the second
person.

I have a text box with code that when the user enters a customer number, a
message pops up that they must also enter a company name if the company name
field is blank.  How can I prevent the user from going any further if the
company name is blank.

What I woudl liek to do is have a field on a form (not linked to any
datasource) which shows how many records in a table have a certain parameter
(in this case if a yes/no field is yes)
So basically I want the field to show a number indicating how many records

I'm trying test whether a folder exists using a filesystem object (never
used this before - starting simple but I do need to do more compex stuff).  
I've set the FSO in one module using >
Set fs = CreateObject("Scripting.FileSystemObject")

I and using the LimitToList Event to be able to add new data if it is not
existing in my table
my problem is the event does not seem to fire at all, the code I wrote is
fine (I think ) and the Limit To List is set to No.

I am new to access development and VB code.  I have an Access form based on
a parent table with 2 imbedded sub-forms from a second table.  The subforms
display different data fields from the child table. The reason for 2 subforms
is that I can't display all the necessary fields ...

Created a combo box that looksup a table.  Works fine.
Can add entries by selecting 'No' in Limittolist.  Works fine.
I seem incapable of making Access add the new entry into the source table!
Please explain the exact code/ [event procedure] that is required, along

Hi;
I newly upgraded my OS to Windows XP+SP2 and wanted to work in it.In my new
project,i have to use some right to left properties.From inside Access
2000,I made a new blank DB,but saw that many properties that are available

I would like to be able to change the background colour for a particluar
record based on what is contained in a field.
At present, It changes all records displayed.

I'm would like to calculate the age a person was from a given date--not
today's date.  My form name is frmEntry which has two fields called
DateScreen and DOB.  I would like the following functions to calculate what
age the person was at the time of DateScreen and return the ...