I posted previously, but I'm not sure I did it right, so I'm going to try
again. I'm not sure of the etiquette, so I hope I'm not being a dope:
I would like to transfer this text with the TransferText command to a txt
file, without quotes (which I get when I select Transfer Type: ...

I try to use this:
data = "c:\brugere.mdb"
Const Forbindelsesstreng = "Provider=Microsoft.Jet.Oledb.4.0;" & _
"data source= " & data & ""

"File sharing lock count exceeded
Increase MaxLocksPerFile Registry entry"
I am updating 262,000 records in a DAO loop.
I get this message during the process.

I have the following query that I need to calculate the number of days at
each operation. Unfortunately, the data calculation is from a previous
operation date. I don't know how to achieve this.
Sample date:

From a form, I reference a module that allows the user to select files,
renames them, kicks of a batch file that runs Monarch to strip data and load
back into database.  This works great, but real basic question....
How do I take the user from the Module, back to the code in my ...

MS ACCESS 2003 on XP PRO.
I asked earlier about how to loop through all the controls on a form.
I now have a slightly different question.
I have an array with values loaded into it.  Col1 is full of fieldNames, and

Can the "collect data through email messages" wizard be automated through a
macro or VBA? I need to follow the same procedure 2 or 3 times a week and it
is a little time consuming to have to go through the setup procedure in the
wizard time after time (i.e. allow these fields, ...

I am useing 'DoCmd.TransferSpreadsheet' to transfer a table from an Access
data base to a range in an Excel spreadsheet. Because there are many users
and this is a stand alone data base (everyone has multiple copies on thier
laptops) I need a better way of telling Access where ...

I am attempting to populate a Treeview to display a Build of
Materials.
I used the code from Microsoft which works well to display Employee-
Supervisor Relationships.

Good morning and thanks for reading this.
I have two boxes. 1 List box and 1 Combo box.
The list box is Gender and the Combo box is for Race.
What I'd like to do is is generate a report based on either box or both.

Why doesn't this work anymore?
Function FaxInvoices()
   Dim dbsallinonenew As DAO.Database
   Dim rstCustomers As DAO.Recordset

Iam trying to run this code but i get an error after CASE 1 and then after
case 2 i am new  to programing can anyone help with this?
Thanks Octet
Option Compare Database

I use a Microsoft Hierhical Flex grid control (referencing Mshflxgd.ocx) in
an access 2003 project and it was working fine. But now (April 2009) it
doesn't work, throwing a message "There is no object in thiw control"
I think it might be responsible a windows xp security update.

This is the module I have setup to search through a memo for the character
string "\n" and replacing it with a carriage return and line feed.
It works properly in my test form, but doesn't do anything when added to the
form I want to make the change on.  The test form is using 2 ...

Im using MS Access 2007 and I want to develop an application by which When I
merge my data with MS Word through MS Access 2007, the letters should be
generated automatically by programming and  saved somewhere at our given
location, maybe by the name of the client, and the ...