Hi, I am using the following code in MS Access to genereate the
appointments in MS outlook. everytime when i click on create
appointment, it creates a new appointments in my personal calender in
outlook. Instead we have a shared calendter called "Assessments

I have created a database in Access XP to record details about companies, and
I would like to have command buttons on the data entry form to copy data
where the same person occupies more than one position (to avoid having to
repeatedly enter the same data). For example after ...

I'm using the following code to update 2 fields in a table:
Private Sub Form_Unload(Cancel As Integer)
Dim strSQL As String
strSQL = "update [tbl-offsites]" _

I had develop an 2k3 Access database for management to project the sales. The
user will select any prior period information to compare with current
information.
For example:

I have an array that I use as the criteria for a query (the real array is
much longer):
   IR_List(1) = "IR-7"
   IR_List(2) = "IR-8"

I am new to VBA and could really use some help.  I have a main form called
'Issues'.  It has a bound control with a combo box and drop down list  with
'Limit to List' set to Yes. When the user tries to enter information that
isn't in the list, the error message tells them to ...

I have a form that is instanced several times.
How can I RESTORE an instance.
I am at this stage in my code:
Set frm = colForms(Handle & "")

I want to create a toggle button which allows a user to change the height of
a detail section from one height to another.  Does anyone know how I can do
this with Visual Basic?
Thanks,

Hi,  I was wondering what the easiest way to duplicate data entered on a form
is? Say for example, I have a form with 6 fields that link back to a table.
If a user enters "50" into the first field, I would like to have a button
that the user can press that duplicates the data in ...

I have a form that has a subform with Child and Master fields linking
the data.
The data source for the subform is a query.
I have a button on the master form that changes the query to show

Hey everyone... my database is starting to do some strange things, and
I was wondering if that might be because some of users are using
microsoft Service Pack 1 and others are using Service Pack 2? Has
anyone noticed access doing some strange things because of this? Thanks

This locks my field from entering any data
Me.Feildname.Enabled = IsNull(Me.Fieldname)    but i want it to enabled only
after i enter a number in this field   can this be done

i have a numeric field in a form where i enter numbers      someone keeps
deleting numbers in certain fields   i want to use the enabled property so
that when a number is entered and then you tab to the next field it greys it
out and you cant change it anymore.   i can do it with ...

Most of our users have Access 2000 and Access 2002, but we have some users
with Access 97 on their computers.  That's why we haven't converted some of
our applications to Access 2000 format.  Is there a way to prevent the Access
2000 and 2002 users from converting to the newer ...

I would like to have a textbox show the result of a query.  The query
will only return one value, based on the following:
The table has two fields:  Artist_Num and Artist_Name.
On my form, there is a combo box that shows all rows of Artist_Name.