My objective is to compare two fields that are located in different tables
which are in same database.  In a table called ,"TEST", I have a field called
"FILE ID".  In another table called,"IDS" , I have a field called
"CasFileID".  I want to compare these two fields to check if ...

I use an access application to send emails through outlook. But when outlook
is maximized it gets the focus. How do I regain focus to my application with
VBA?

I append data (using DoCmd.RunSQL) to table JobsContWorks which has the
following fields:
ContValID (fk)
WorksID (pk - autonumber)

I have this on a form called "frmInQuiry".
It is a text box and I would like to Filter out the data but this only works
if account = AccSer. How can I put a wild card(*) at the end in the text box
called AccSer.

Does anyone know if there is an easy way to calculate the end date of a month?
When I'm reading dates in a recordset, for example 10/01/2006 then I want to
store the end date of October (10/31/2006) in another date variable to do
other calculations.  

I have a form which is based on a query. Even though fields are not locked or
disabled, when I try to enter data it doesnt allow me to do that.. Do you
have any idea why?

I am trying to distinguish between the properties of value vs text for a
textbox control and am a little confused.  I read the help on it, but still
am a little confused.  I typically use the value property in access, but am
having trouble with null values with the value property ...

Hi Every body
I have a query that outputs students names on certain criteria
I want to collect these names in a single textbox in a form(separated
by space or dash)

I have just created a table for our documents reference, in which we want to
start a new serial number each year without creating a separate table each
year.
Kindly let me know how I can do that in which the starting value is 1 each

I prepared this bit of code over a year ago and it works fine on my computer.
However I have recently been trying to trap a "~" (tilde) symbol to do a
quick form open and can't seem to get it to work.
Question one is how do I trap the "~" key?

I'm using the following code to set up paramenters for a query.  For some
reason, Like '*' isn't returning null values for this field although it is
for other fields.  How can I change this code to read that if Len  = 0 to
return records where Bldg is null as well?  Thanks you ...

I have an ErrorFunction with a select case in which I trap certain errors and
display appropriate messages for them;
The last thing this function does is call an EndFunction where some basic
application elements are reset in case of code interruption; and in which I

First time I've run into this.  I have a split database, MDEs on the
workstations, mdb on the server.  Everything is set to open Shared but no more
than one person at a time can open the database.  I can't even open the back end
by itself.  Could there be anything other than a ...

I am not sure why I get that error I have commented the part of code that
gives an error:
Set CONNTDC = New ADODB.Connection
   CONNTDC.Open connstring

When a List Box Multiselect is set to 'None' I can reset the box with
me.Listbox = null.
When I try this with Multiselect set to 'Simple' , It doesn't clear the  box.
How can I clear the entries in the box.