Function UpdateUnmatched(WordDoc)
   Dim RecordNo                    As Long
   Dim myDb                        As DAO.Database
   Dim MySet                       As DAO.Recordset

This was working fine untill I changed the form and table to a variable.(
frm As Form.tbl As DAO.TableDef.)  Now I'm getting an Argument Not Optional
message.  Any help appreciated.
Thanks DS

Anyone know if this one is possible:
in table1 there are X number of location names based on input from a form,
is there a way to make table2 using the data in table1 as the field names.
Thanks

My database has a sendobject to send an e-mail.  My problem is that some
users have a web based e-mail system (Lotus Domino Web) which will not work
with a sendobject and produces an error.  How can I test if the sendobject
will work prior to running it?

I wrote a function but it returns zero.  There are definitly records in the
table.  Any suggestions on what I might be doing wrong?
Thanks
DS

I have a function where I want the table and the form to be able to change
as needed.  I don't want to write a new function for each table and or form.
Public Function NODIS(CDQuantity As Integer, CDPrice As Currency, CDCheckID
As Integer, CDDiscountDP As Integer) As Currency

I’d like to take a value from a combo box and load it into a table named
tblLoginSettings.  I am trying to figure out how to get the value into a
field named ‘CurrentUser’ into the table named tblLoginSettings.  Not sure
how to start.  I guess it would be done by passing a ...

How do I use the Format statement to force leading zeroes on a date? I tried
Format(myDate,"MM/DD/YYYY") but this doesn't give me the leading zeroes. Any
help is appreciated.
Thanks,

How to write a VBA code into Ms Access 2003 to calculate difference days
between days minus Saturday, Sunday, And 10 days Holiday?

When I open 1, and only 1 specific form, and then close my app, ms access
appears to close but the process remain in the task manager stoping the db
from being reopen unless you kill the process manually.
I have been trying to identify the source, but haven't managed! I commented

I have a list box which is updated via a control source which gets typed in.  
I would also like it to update if the user presses page up/down.  Can I put a
refresh somewhere in a form event to make that happen?

I created a telephone log in MS Access and would like to know if there is a
way I can copy my notes from a form in Access and past it to my email message
automatically?  Also, is there a way to have an entry added in my notes to
indicate that an email was sent?

This looks like a bug in Access 2007 / DAO 12
Have tried to run the following but this gives error '3824' INSERY INTO
query cannot contain multi-valued field.
INSERT INTO [;database=C:\Data\DBexchange.accd].MyTable (ID, Field1, Field2,

I have no problem cloning a forms recordset, but I'm getting the following
error when I try to clone a reports recordset:
"Run-time error 32585: This feature is only available in an ADP."
The report had been open using the following command:

I have a networked Access2007 database that I'm building, it runs fine over
our local network, but when I try to run it over our VPN I can not setup the
trusted site, and the best I can get it to do is read only.
Thanks