Friends,
RE: Excel 2000
In Tools/Options/Calculation there are radio buttons to choose either
"Manual" or "Automatic" calculation.

Friends,
I am trying to write VBA code that references two cells in the ActiveSheet -
Cell_1 and Cell_2. The code needs to take the value from Cell_1 and place it
iin the "Find What" text box of the Edit/Find dialog box. Then it needs to

I need users to click a button that copies and pastes a current table but
that lets the user name the new table, either by typing the name in a message
box or by previously typing the name in a form.  Something other than
renaming the table once it's been created.

I have several excel workbooks, I need to import data from specific cells
(not the whole worksheet) into specific tables in Access 2000.  I have the
import down as long as I just import a range, however a range is not what i
need.  I need to be able to pick certain cells and ...

I am setting up an automated way of e-mailing reports to certain individuals
at differing times.  I am quite comfortable sending reports from within
Access itself, my problem is that I have a report that is a worksheet in
Excel.  Currently I am saving the selected area within ...

I have a form with a text box that when i click opens a popup form that
executes an on open Sql statement to populate this popup form. The statement
i'm using is a Select command. This form has a continuous subform where the
recordsource is the sql statement i'm using. All the ...

I have a parent form frmDemographics and child form frmVisitIDsubform. On
Parent form I have txtmedicalrecord and on child form I have
txtmedicalrecord1. If I enter a medical record in txtmedicalrecord, what
would the syntax be if I wanted that medical record to show up in

How can I disable, for example, the 'delete record' menu
item from the Access application menu bar?  My dB security
has delete permissions removed for non-admin users for all
forms, but the application menu bar still allows record

The below program works for everything except the update.  I am trying to
make the program apply to various tables and fields.
Thanks for your help
   Dim arg1 As Variant

Help - I want to return the following values in a form:
Most Current Sale by Agent
Month to Date Sales by Agent
Year to Date Sales by Agent

I am using the following routine to extract data from email(web form) form.
The routine works great for single fields however if a field in the webform  
is a memo box. it doesnt work for that field. I believe its because there are
multiple CHR(13) between the fields. For Example ...

How do I convert this code to loop thru tables (instead of forms)?
Sub CloseForms()
   For Each frm In Application.Forms
       If frm.Caption <> Screen. ActiveForm.Caption Then frm.Close

I have more than 100 object in my database ("GTHE.MDB").
Objects are included like Tables, Forms, Queries, Reports,Macros,Modules .
I just wanted to print the list of object names from a Form Command Button
press event :

I am building a process which will ultimately be done in SQL server, but I
am prototyping in Access..
I have a load of tables and a series of action queries which import dats,
manipulate it and the output it.

I have a form in which i have a text box with an after update event. This
after update event executes an Update table SQL command. The problem is that
after this event occurs i get an Write Conflict message. I then click on Save
changes button and the error disappears.