I have a form in access, I want to transfer fields within the form to a word
doc.  I'm using a command button on the access form to open the word doc and
move the data to word, everything works.  I'm able to move 25 of the 26 field
of data to the word doc except the memo field, ...

I'm using the following code developed by Dev Ashish, to locate the temp
folder on a users pc. The "String$" function is causing an error on soime
users machines (perhaps because they are using MS-Access 97 or an older
runtime version or don't have a correct reference - not sure ...

I recently migrated from Access 2003 to Access 2007.  I've got a form with a
list box; when an item in the list box is double-clicked, another input form
is supposed to open for the selected item.  It worked fine in Access 2003 and
was working fine in Access 2007; however, I just ...

I am having a problem with the following code in Access 2007 ACCDB file with
relinking tables. Error is Run-time error -2147467259 (80004005) Could not
find field. I get to the replace part where it fails. The same code works in
MDB file ok. References are ok and code is as follows:

I am attempting to loop through a set of Excel files in a specific
directory, extract the data from two cells and write the content of each
cell into a table field. The cell references are the same between all of the
spreadsheets.

Hi to everybody,
I have been disappointed after having tried for so long to get an answer to
this question but I will give it a last try.
I am trying to learn object oriented programming and for this purpose I

how can I change to following to reflect the path that I have stored in a
table named "location", field named "server"
extracted from (rogersaccesslibrary)
Function getpath(FileName As String) As String

I had to change an export I'm doing to use a query instead of a table because
of some formatting issues. I ran the export manually to test it, using File,
Export, etc., and it worked fine. But when I run it from a macro I get an
error message saying that one record wasn't copied ...

My access database (format 2000) ran fine on Access 2003  under Windows XP
perfectly fine. When I got the file into Access 2007 running under Windows
Vista, Access complained the Mid function I used in query and reports as
UNDEFINED.  The error message is "Undefined function ...

I need to export data from many tables into a flat file as an interim
procedure as we switch from tracking work in Excel to Access.
I have created a temp table to collect the data, which can then be exported.
Basic structure is:

-Access 2003:
-Running an MDE on many different client computers
Errors Encountered:
"There is an invalid use of the .(dot) or ! operator or invalid parenthesis"

Access 2003/Windows XP  --  have a form and subform.  For a given record in
the form, subform can have up to several thousand records.  Subform records
include a flag field that can be used to perform certain batch actions on
flagged records.  Subform has a button that will flag ...

What is the best way to connect to and send data back and forth to a remote
computer? I want to store my tables in SQL Server on a computer that is not
part of the network. Our inventory data will be in SQL Server, our customers
have an MS Access 2007 front-end as their user ...

I am exporting a table to a CSV text file. I need one of the fields to have a
leading zero in it. I have it defined in my table as a text field with a
length of 2. I look at the data that is being exported, and it has "01" in
the field (I format it that way when I create the ...

i want to pull records based on random sorting. i want that each time when
user asks for the report, the records are shown in different behaviour. how
can i apply it in my access database using VBA?