Please help me
In my database there is 2 tables, named "MasterStock" and "Voucher".
MasterStock
--------------

I have an Access2000 table with about 500'000 data records. Sometimes it's
necessary to change some values in the records. At the moment I do this with
creating a query with "querydef". This query shows me the records I want to
change. Since the query is linked with the table ...

I have a form and sunform and would like to calculate a control in the
subform. The subform displays records in a Datasheet view.
I place an unbound control on the subform and set its control source to do
the calculation. Some of the data required for the calculation is from a

I have a database based on Settlement numbers.  I have a subform that has
multiple records that correspnd to the settlement number.  Each one has its
own 'status' and when I update the status of all the records to 'closed', i
would like it to show the entire file as closed.  Any ...

Can anyone recommend the most optimized way to extract data from more than
one Access files to other Access file.
Currently I have more than 20 Access files, I need to execute their Queries
(all the same structure), Copy and then Paste to one Master Access file’s

I have the following select statement for a search form in Access:
SELECT ToPrint.[box #], ToPrint.[MATH AREA], ToPrint.topics,
ToPrint.Activity, ToPrint.[More info], ToPrint.Source
FROM ToPrint

I can increase a Form to fill the Access Window with "DoCmd.Maximise". In VBA
How do I maximise the Access Window to fill the screen?

How do I maximize a minimized window from VBA?
I know the title of the application - and using the "AppActivate "apptitle"
" command works when run from an .mdb file. When run as an .mde file it does
not work - so I guess I have to be specific about how I want to activate the

I am using Access 2002 SP3 to graphical present data along with a Data Table
function.  The object class which I am using is: MSGraph.Chart.8 The chart is
updated interactively from a Combo Box so data is constantly updated.
My problem is that the values shown in the Data Table ...

I have two different tables - "Clients" and "Potential Clients." Both tables
have 10 fields, with 5 of these field being the same within each table;
name, address, telephone, contact, email.
Now, when a potential client gets back to me to confirm they would like a

Using VBA, I am trying to force Access 2002 to refresh all the linked tables
each time the database is opened. Can this be done?
Thanks,
Jim

I am getting a compile error...  Can someone pls tell me what I am doing
wrong...
Private Sub Command5_Click()
Dim db As Database                 <<<----debugger highlights this yellow

I'm using Access 2K. I have a concatenation function which creates a memo
field.  I'm trying to write the resulting values to tblFN_Children.  The
three values are:
    FN - string which represents the file number with the format "NN-NNN"

Can anyone tell me how to FTP to and from a site using MS Access??  I've
tried Dev Ashish's code but can't get it working with 2003.  What am I
missing?
g

Could anyone please tell me why I am getting,
"The database has been placed in a state by user'Admin' on machine XXX that
prevents it from being opened or locked"
Private Sub Command0_Click()