I have an application that I developed in Access2003.  I recently made a lot
of changes to it and repackaged it for installation.  I have two Windows-XP
Prof. machines that had the original version of my software up and running
on them.  When I went to copy the new *.mdb file to ...

I got a measurement(measurements are without Unit,mm,cm)
A X B (general format)
eg 10 X 50 , 20 X 5 , 5 X 20
Question: How to prevent the data from being typed into the field and set

Please help if you can:
I have a combo box on a form (frmTest) that contains zipcodes.  In the
'notinlist' function, I have working code that asks, "Do you want to add
'11122' to the zipcode table?" Yes/No.  If you choose yes, then the data

I need to calculate some informations before update the field. I need to link
a calculator to that field in order to calculate and then transport the
result to teh field.
Now we are using the Windows calculator but it is nor very friendly and I

Upon opening a database, I would like for a form to be automatically
maximised so that it covers the whole workspace.
How do I autorun this on opening the database? I know I need the do.cmd, but
what would be the complete code and how do I insert this?

I got a form and a subform
form = fruit , (field = Name)(combo Box)
subform = mass , (field = Weight)
Question : How can i run the (Weight_afterupdate) using (Name_afterupdate)

Anyone can tell me which Microsoft VB reference book is good for usage?
==>provide full definition and how it runs
==>full of examples
Price does not matter,please provide info on author,publisher,where to

I am using Access 2003 and need some help with running functions.  I need to
run 5 functions (function01 thru function05) at certain times of the
hour/day and was wondering if anyone has done this before and if so, how.
eg:

How to fix total number of words in a field?
eg.
30 X 30 ==> 3 words
50 X 89 ==> 3 words

How to extract certain alphabet in a field?
eg
[Fruit] = "I like Papaya"
How to extract the alphabets "paya" to another field [Last] using code?

In my database, there is a 'standard notes' table with text statements in a
field and also a 'show' field that is a yes/no type. I need to take all of
the sentences from the 'standard notes' field that have 'show' turned on, and
concatenate them together in one memo field in ...

I have recently aquired a project written in Access 97. In the project there
are declares for dll entry point into Access.exe which under XP kick out
errors as not existing. The entry points are:
 accFileExists Lib "msaccess.exe" Alias "#57"

We link our Access app to a SQL Server database.  I'm having problems dealing
with the massive amounts of data our server loads up on.  Each database
starts at about 200 kB and after analysis and processing, balloons to 4, 6
even 8 Gig.  Nothing can be lost as the client may need ...

I'm using Access 97 and trying to write a function.  I am calling the
function from a query and am passing several arguments to the function - one
of which is a key field (MSET_ID).  In the code I have:
------------------

Is it posible to force a form to always be Maximized.
This forme is always open, and I do all on top of it.
I have it to Maximize on open, but when i open a nonrelated report, and
close it agen, then my forme is no longer Maximized.