hi,
i have set two textbox on a sheets, name "code" & "product name"
i want to set once i input "code" than use the code to search the product
name in product datebase, than copy to textbox "product name.

Am trying to link Access Data Base with Word Application want to pass data
from Access to Word. Have application working under Access 2000 now as we are
getting ready to upgrade to Access 2003 the line of code with DDEINITIATE
gives me a typemismatch error#13

Is there an easy way to get around the outlook security messages?  I am
trying to use some vba code to loop through a report and email each person's
report to them using the sendobject function.   I keep getting a message for
each person's email from outlook asking me to "allow" ...

I am trying to produce what the following code would do, if only it would do
it. What I need is a suggestion as to how to accomplish it. I could always
use and array or a recordset, but was wondering if there isn't some kind of
loop I could use that would do it.

I have a sub that uses code like:
With Me.EmailAdd1
...
I am trying to switch the sub into a function that I could use from multiple

I use a macro to update a table with data from several sources. after runing
it I can close the data base but I can't close access itself.
any sugestions
MarkS

For all you expert VB programmers this is probably a no-brainer. But, How can
I change information in a particular field in a particular record in a table
programmatically.  Of course you can do it in a form - just scroll to that
record and change any field in the record  - but ...

Is possible to convert mdb to mde when you have link tables with the
database?  I try to convert the database to mde and received the following
message: "Microsoft Office Access was unable to create an MDE database".  I
only have 5 link tables, 3 queries, 6 forms and 2 reports.  ...

Hi,
I have searched for this question but can't seem to get an answer.  I need
to insert a new record to the ROHeader table and many records to the RODetail
table.  It is a one to many relationship between the ROHeader and RODetail

I am new to access-vba and I have got the following problem.
In the Form_Load()-Event my DB trys to import CSVs from a Remote Location.
If there is no connection it freeze for about 30sec and then the
error-handler becomes active. Is there a way to fire the error handler

I'm trying to count missing dates in the [CalDue] field of the table tblCal.  
It seems that the following code should work but it always yields a zero
count.
DCount("[CalDue]", "tblCal", "IsNull([CalDue])")

I have a large file that I import on a weekly basis.  Currently it is almost
196,000 records and grows each week.  I am running through the following code
and I noticed afdter about 70,000 records it starts slowing way down.  I
believe it is because I am reading in 1 line at a time ...

While searching I read a long but interesting discussion of fso vs. MkDir as
a way to create a folder.  Both appear to work for me, so I lean toward the
simplicity of MkDir, but two questions:
BOTH options appear to create the folder as Read Only, and I can't find

Hello,
I made a database that was working correctly before, but when I split the
database into two parts (Tables and one mdb and others as the other mdb), I
got this message: Operation is not supported for this type of object.  Can

I have a report which uses the attached code to filter the report by items
selected in a MultiSelect listbox.
But when i run this code I have the following problems:
When I run this code I get the following error when I select one item from