I have a table that has two key fields...
System (Text)
SeqNbr (Text)
Hours (Integer)

Several times a week I get this error.  The missing reference is always
owc10.dll in the web components common files.  The file has never been moved.
The references in the application have not been changed.  Yet mysteriously
Access seems regularly to lose track of it.  ...

I have 3 pc's looking at the same database stored on a server PC. 2 run win98
and 1 runs xp pro. I have set the table field to short date and the form
fields to short date but when you open a form the xp PC shows 01/08/2006 and
1 98 pc shows 01/08/06 and the other 98 pc shows ...

I've got this error when i run my mde: 3709
The search key was not found on any records
What is that means?

I have an Event set up to automatically send an email when a form is closed.  
In that email I list the information that is in several of the fields.  How
can I make it put that information on separate lines in the email: example
1  2  3  4  to look like:

I have tried this option but it does not work in my case.
What I'm tring to do is hide the database window when I display my own
forms. But I can see it appearing and disappearing in the background which is
not very professional.

I have created a form in my database which I allow users to attach supporting
documentation.
When the documents are attached I change the file name to include the record
ID number, date attached, revision level and then copy the file to a

I have seen a lot of good examples where one would open a recordset by
running a query and then add or change records. However, I would like to open
an empty tecordset based on an access table. Is there a nice way to do this
without having it run a query you know will return 0 ...

Thanks for taking the time to read my question.
I have code that is running a docmd.runsql on a table (Append query). After
I run the query I want to delete the table.  I can't becuause the table is
still in use.

Is there a fairly easy way to loop through the table collections and if a
table has a number field to loop through each row and replace with zero if
null?
It can be multiple fields in the table.

In code, is there a way to refresh a report control while the report is open?
Thank you

I recently developed a simple Access database for a small company.  All the
previous trial versions of the database I sent the company worked.  The final
version is not working for some reason.  I can open the database perfectly on
2-3 different computers but for some reason, ...

I have got split databases and use the coding below to auto reconnect
them on install. How do I amend this coding to allow for the backend
database being password protected?
Regards

I have a table in ms access that is linked to a file in excel. For
reasons that are complicated to explain, my vba code must change a cell
in the excel file (i do that using a ADODB connection), and then launch
the excel file (i use the runapp macro), which refreshes the sheet

  i'm currently using the IIF statement to extract the dates out as shown
below:
"
IIf([dbo_currency].[curr_code]='sgd',#1/1/2001#,[Forms]![Year_Month_M]![cur-month] & "/" & [Forms]![Year_Month_M]![cur-year]) "