Please,Help!!!
How can i  copy text box value from Access form to the cell in Excel using
VBA code?
Thanks a lot

I'm having trouble using ODBC from Access 97 to an SQL Database (which
uses a FoxPro front end, if that matters).  I believe the SQL Database
is MS SQL Server 2005.
I do not get any error messages but the important tables are not

I am trying to create linked forms however Access will do nothing but give
the error "The Expression you entered refers to an object that is closed or
doesn't Exist."  I know the object exists because it is in list in the
Database Objects panel.  Two questions:

I am working wtih Access 2007 and writing my VBA code that connects to
my backed database wtih ADODB (ADOX).  I have found lots of examples,
many of them work, but I am looking for a reference that explains all
of my options for connection properties, data source syntax, etc.

My database has a a table and a field called "OrderID" which holds invoice
numbers in sequential order. Sometimes there is some invoices missing for
example there may be:
53591

I'm having a table that gets data rows from an external application, and I
need to manipulate or insert similar rows according to specific field data.
Is it possible to "listen" to a table and run a subrutine each time a new
record was instered or updated?

I have some code that takes a variable from a list box (an internal area
name) in a form, applys that variable to a query, runs the query and outputs
this to MS Excel.  It also copies the Excel template
and renames it the same name as the variable.

My keyboard language is automatically changed from Swedish to English when
the first form is opened in some of my databases (MS Access 2003). The
problem seems to follow the database and other users have the same problem.
Why does the keyboard language change when a form opens ...

We have an Access2003 applications which retrieves data from an oracle
database.
We create an ADODB.recordset  and set the Form.recordset to this specific
recordset.

I want to compare two fields of data in my table (tblhistory) - dateID and
projectID and if they are the same for more than one historyID (record) then
I want to delete the record with the lowest historyID number. Thanks in
advance for your guidance/suggestions.

My form is set up based on a query with a subform.  I have an unbound text
box which has the following code:
=====================================================
Private Sub CallEvent_AfterUpdate()

this is from a biz friend - coding an app in Access 2007
I'll get the snipet of code from him later tonight...
---
Hey - I am starting to launch Word 2007 from Access 2007.

I have this at the beginning of my code:
Public intPhoneErrorCount As Integer
...I make it Public so that I can access that integer from different
Functions that are called.  This variable doesn't clear itself after my code

I am trying to create a button on a form that when clicked will access a
field in a table which contains a file name.  I am using the FileCopy
statement to copy this file to a different location and renaming it at the
same time.  I am receiving a type error on the function call.

I am trying to work with recordsets and have the following code. I want it to
add a new record if there are no records in the table and add a new record if
there are existing records. I get duplicate records and can't figure it out.
Would appreciate help. Thank you.