We have an Access database that works with a SQL Server database.  Since
installing Access 2003, the users can add new records, but not update records.
The following code is triggered by a button on a form, but generates a
message saying "ODBC -- Cannot lock all records".  When I ...

If I have
UPDATE T1 INNER JOIN T2 ON T1.t1 = T2.t1 SET T1.t2 = [T2]![t2];
and T2 returns multiple rows on the inner join, which row's t2 value Access
will use to do the update? The first? Last? Or Access will choose randomly?

I am using the VBA function WEEKDAY() to convert dates into the day of the
week. But it is too slow. Here is the detail of the problem:
I have a Access table named "TestTbl5" with three fields, one named
"Tran_Dt" (Date/Time type) and another named "DayOfWeek" (Number type,

I made a form with 2 command buttons: a button to apply the filter and a
button to remover the filter
I would like to filter on client name
e.g. If I type Royal* or Royal? I would like to see all the records starting

Does anyone have some good code for checking to see whether or not a file is
locked in VBA/Access?
I am needing to do 2 different things here:
1) Check a text file to see if it is locked by another user before opening

On a form I am creating, in multiple areas, one combobox result enables a
second combobox.  I've done this in code on the AfterUpdate event of the
first box.  Additionally, using the OnCurrent Form Event and the NewRecord
property I reset all of the appropriate comboboxes back to ...

How can I automate the distribution of the frontend to the workstations?
Make a batch file using xcopy?
Or has someone figured out a better way.
Thanks.

I'm building a where clause for a customer name.
The problem occurs when a customer's name has an apostrophe in it.
Here's what I have now that doesn't work:
strWhere = strWhere & "CNME LIKE '" & Forms![frmLookup]![cboCustName] & "*'

Thanks for taking the time to read my question.
I have a string of data that is comma delimited.  I want each value to be
placed into seperate fields.
how can I iterate through the fields of a recordset on the same record?

Someone told be today that if you have two Access applications that have the
a Global (Public) variable defined with the same name, that they could
overwrite each other.  I've always that that each instance of Access has it's
own memory blocks allocated and global variables ...

I have a linked table to Access that consolidates sales history into 12
entries within a single field. I would like to query this table based on a
date range - say July 2003 through September 2004. In order to do this I need
to sum the proper elements of the field. Is there a ...

Thanks for taking the time to read my question.
I went to this site http://www.mvps.org/access/modules/mdl0057.htm for some
code to help me import files into my db.
The problem is that the copied code gets stuck at this line:

I am new to vba and I am learning to create functions. I copied this function
from MSDN. Would someone be kind enough to explain to me:
Why variable Globalflag is needed to be declared in this function?
What does   “GlobalFlag = x” do at the end?

I'd like to change the appearance of a detail section of a report to display
the data left to right instead of top to bottom.  There are never more than 4
records in the detail section for each group.
For example, I have a report (based on a query) that displays in groups like

Thanks for taking the time to read my qestion.
How do you open a text file for reading?
Thanks,
Brad