Subject basically says it all however I'm trying to change all existing
memo fields to text of 255 in length.  Is there a single SQL query that
can be used for all of them?
Thanks.

I've created a form that contains a single unbound combo box and two
subforms. The two subforms display the results of a query (driven by
the combo box selection) in both tabular and pivot chart formats. The
problem that I'm having is that the Pivot Chart that I've created

And if I cannot, what is the best way to look for occurrences of CRLF
pairs in a text field? Of course, I'm talking about Chr$(13) and
Chr$(10).

Hi I was wondering if there was any way of making the windows for the
currently opened objects in access invisible on the bottom toolbar. Iam using
Access 2003 also is it possible to turn of the right click facility on the
mouse to prevent the user from getting into the 'background' ...

I have a parameter query named "qry_employee_info_reports" that I need
to run in the OnOpen event of a form.  I'm after its total number of
records.  The query's got several joins in it, and one of them is to
query "qry_last_transition," which is also a parameter query.  Both

I have a form linked to a Table.
In the form, I have some textboxes, some checkboxes, and a AddRecord
command button.
I set the validation rule of the txtEmpNo textbox to Is Not Null, I

With Access 2003 SP2, no problem having a field with date type of
Date/Time and default to today's date (with default to date()), and
let's call it DataEntryDate, however, when adding another field, call
it DataUpdateDate (of date/time data type and default to date()), this

Can someone point me to the best concentration of info on manipulating
an MDB file via VBA and HTTP?
Need to do all the standard stuff for a flat-file database: locate and
retrieve records by ID col, Insert new records, edit and delete

Is it possible to force a Decimal type field from an ODBC source to
become a Double type field in the destination table when using a Make
Table query ?
Thanks in advance.

I have a table that looks like below:
Name, Address, Favorite Pet
Bill Smith, 123 Smith St, Dogs
Bill Smith, 123 Smith St, Cats

I have a main form with two continuous subforms - neither is using
master/child fields.  Subform2 is bound to a local temp table.  When I
update a record on subform1 it executes a function on subform2 that deletes
the records from teh temp table and repopulates it and of course ...

I would appriceate any help to correct the code error that I am getting
for the onclick event of a cmd button. I have two forms. Main Form
"frmQuestion" and form 2 "SfrmQuestion". FrmQuestion shows the details
about Question and by clicking on one for the cmd button on this form

I am creating a simple bug tracker application (in Access db) and i
created a hisotry table to
log the bug history.
The history table contains details like ProblemRecordNo (PRN),

I have an .adp (Access 2003) file and I need to store files in a field
on the database.
I have figured out that I need the data type to be 'Image', so I have
my table with the this datatype.

I'm using Access 97, Jet 4.0.  the data resides on a Win 2000 domain server.  Using .Net 1.1 and IIS 5.0 on a local
XPPro computer I am trying connect to a Jet database on the server.   If the data source is on the local computer I can
connect ok.  If it is is on the server I ...