I have a 3 MB program that we use with access 2003. I need someone to make it
work on Access 2007. Access 2007 is what we now have and my school program
doesn't work. I could tell you what it doesn't do anymore but I wouldn't know
where to fix the problem if you told me. Help ...

I dont know if im not looking in the correct areas, but I cant seem to find
the answer to my question.  All I want is to run a command when the enter key
on the keyboard is pushed.  I have a form with two fields and a button.  User
name, and password are the fields.  Login is the ...

I have 3 numbers (lengths of String's if your interested)
8
14
6

I am using the transfer spreadsheet command, but whenever the Excel
spreadsheet has spaces in the name, I don't know how to deal with that
therefore is doesn't work.
For instance:

I am trying to use a text import spec to import a csv file (no text
delimiter), but rows that have text with French characters do not import.  
There is no error message, and there are no paste or import errors in those
respective tables.  The lines with French characters simply ...

Is it possible to call a query from another DB and have that query create a
table in my current database?

I am trying to create a link of a table present in Postgres database (via
ODBC) into another ACCESS database.
So far, I succeeded in creating the ODBC link to current database and then
exporting the link to the third (target) ACCESS database. But current

When filling out a form that has combo boxes, very often I find data is not
yet in the dropdown list. (Data appearing in the list is entered through
another form.)
I've seen that option in the properties list, and I see that it requires the

I need a lil' help from the folks in here. I have an DB application
which needs to read when an external file was created - I need to
compare that creation date with when the corresponding entry in the DB
was created. I reckon I'm supposed to use the GetCreationTime method

I am using ther RunCode option in a macro to execute a function. The function
exists in a module in the same database as the macro. There are paranthesees
following the function. When I try tp run the macro the message "The
expression you entered has a function name that ...

I access a table that contains dates; however they are all in text format
i.e. 20010924; i would like to create a function that I can use in a query to
return the correct values such as
Mid([field1]![Date Received],5,2) & "/" & Right(RTrim([field1]![Date

I have a db program we had developed 2 years ago.  It is used by a
number of users.  Each time someone goes into the program, the db is
saving itself as dbXX.mdb.   I know have 49 copies each with a change
made by the user.

I have a batch file that runs a report through Monarch and dumps the data
into a "holding database".  I then link to those tables.  If the front end
database is opened, tables are linked and I run the batch file, will the new
data automatically be seen in the front end database?

The following code running in A2K seems work different when running on
A2k3.
On A2k this code changes the background of main Access Window.
On A2K3 it changes the background of Access Forms.

The code
Something = Date
produces error 2427, You entered an expression that has no value.
Substituting DATE() has no effect, because the editor removes the parens.