I have an ongoing problem with a single machine not recognizing the
REPLACE function.
This is a WinXP Pro machine, running Office 2000 (SP3) with MDAC 2.8
(SR1) and Jet 4 installed.

I created a database form with a simple Form_Load procedure and a simple
Form_resize procedure. Both work fine on one machine.
On a second machine I get a "Error loading DLL" on these procedures,
even if i comment out all the code inside these procedures. This is very

Dear group,
I have a list in an access97 database that causes me trouble. The problem is
that as default all the columns in the (multiselect) list are aligned to the
left. I guess the trick somehow to set the property "TextAlign=3", but how

Here is part of my database:
tblStudents: StudentID
tblMajorsAndStudents: StudentID, MajorID
tblMajors: MajorID

I get Too few parameters expected 2 error and "The MS Jet Database
engine cannot find the input table or query "myTempTablename". Make
sure it exists and that its name is spelled correctly. 3078" after I
migrated "MS Access 2000" to "MS SQL Server 2000" and relinked all

In Access 97 under options/edit find/Confirm - Record Changes, Document
Deletions, Action Queries.  Can someone tell me if these options are
specific per each MDB file or are set by each PC's copy of Access?
Thanks

I have a table which asks how people heard about a subject. As it is one to
many I have created checkboxes for each option. Trouble is I now want a
report which will give each option and a count of how many times it has been
selected.

When I open an ADO Recordset, I close it.  However, it seems that there may
be some difference in this manner of opening a Recordset:
Dim rL As ADODB.Recordset
Set rL = New ADODB.Recordset

It's confusing. Many people here and elsewhere make many different
predictions:
There's an introduction mentioning some aspects of this at
http://msdn.microsoft.com/data/mdac/techinfo/default.aspx?

I'm moving an Access application to .net +sql server.
First step is to make Access front-end for sql server.
I've moved the tables to the SQL Server and linked them through ODBC.
Mostly it works alright, but ometimes it stucks. It happens like this:

Is BXOR a JET 4.0 SQL operator?
How can I get DAO to use BXOR in a query,
eg SELECT ID, (ID BXOR 2) as IDBXORedWith2 from Table1
?

Dim vDateE As String
vDateE = #7/12/2005#
The following works to find Cost in TblExpenses for 7/12/2005:
MsgBox (DSum("Cost", "TblExpenses", "DateofPurchase =  #7/12/2005#"))

Can anyone help me get this update query right?
The SELECT subquery does select the rows I want to update when taken on
its own.
However when I add the UPDATE piece it finds no rows to update. What am

Been having a lot of trouble lately getting one very large ADP file to
save as an ADE.
-All modules (including form and report modules) using Option Explicit
(checked and double-checked that.)

I have a table that has a column for the number of workdays in the
month.  
I found the NetWorkdays function and assumed that I could use it in an
update statement to calculate the number of workdays between two