I would like to change the labels on my input controls programmatically which
I realize I can do with Me.Caption = ...
But I need to change all the labels on a form from one language to another.
I can store all the label texts in a table with a column for the target

I need to evaluate a series  of statements to determine whether  to hide
tabs on a form.  Orginally I placed the following code in the Form's load
event.
If DLookup("CustSpecs_Present", "CustSpecs", "CustSpecs_RoomID=11

Can anyone give me a information on the differences between ADO and DAO?
Also can you recomend a good beginners site,articles etc that would give me
a good and clear understanding?
Thanks in advance

I have the following code attempting to save an open xl workbook as a tab
delimited text file from with Access.  When it runs I get the following error
and the sheet is not saved.  Any suggestions will be greatly appreciated.
Here's the error "SaveAs method of workbook class ...

How do you delete a watermark from a cover page when
Format>Background>Printed Watermark>No Watermark doesn't work?

Using Access 2002 SP-2.
I want to join a native table to a table that is imported from a query in
another DB, so I started with the sample CreateRelation code in the Help
file.  The first line is

I'm trying to use an sql statement in VB to append records from on table to
another.
"INSERT INTO tmpCustomers (ID, name) " & _
"SELECT customers.code, customers.name FROM Customers"

To avoid the security dialog, tried "ClickYes" works
great. But wanted to try Redemption, and the following
does not include the ATTACHMENT in the Email.  Same sort
of idea works fine with the Object Model.  Any ideas why

I Access 97 this worked fine- I found the requisite 160,000 or so files.
We just converted to Access 2003 and am stuck at some 65,530 records which seems to be the upper limitation for this.  When I look at the documentation it says that the foundfiles count is a long.  Does ...

"Shell" (Access 2003) gives only indication that the spawned command was
invoked. And return is immediate. So, you have to "doevents" until
who-knows-when, rather than simply wait on the completion of the child
process. This is stone-age!

If I use KeyPress the KeyAscii parameter returned for the"#" key is 35.
If I use KeyDown the KeyCode parameter returned for the"#" key is 222.
The 35 I understand and is documented in the VB help. However the 222 is a
mystery to me. The help for KeyDown is a little vauge in this ...

Hello again,
in my endless voyage through the wonderfull world of access Programming
(acc97) i found a new magic trick , where i need an explanation for.
My Prob: i have an Update SQL - String with a where condition who seek for

I'm trying to create a database in which there is only one table that
contains all of the payables for a company. All the payable invoices have
primarily 3 fields: 'type of cost', 'date due' and 'amount'. The object of
the database is to obtain a printout of expenses categorized by ...

Am I able to intercept run-time error messages and replace them with a more
meaningful message of my own? If so, how?
Thanks

The following function works good in DAO
DAO:
Public Function AddRecsPPMs()
Dim DB As DAO.Database, strSQL As String, RS As DAO.Recordset