I want to design a tool to import data from an excel workbook with multiple
tabs into multiple tables in a database. The excel sheet will be used for
field staff to enter data into, and will be set up ahead of time so it will
be consistant as far as field names etc. They ...

At my office we have create databases 3 months that we have to distribute to
25 different departments, each requiring a certain subset of the data for
only their department. I would like to know if I can get it automated where
it can take the file and only have that certain data ...

Hi I am currenlty working on a report to show the costs of usage for a cars.  
I have split up into quarters but the following code is not returning any
information. I'm not sure what I'm doing wrong. Any asstiance would be
helpful.

One of our users reported this error:
DoCmd.TransferDatabase acLink, "ODBC Database",
"ODBC;DSN=DB2;UID=xxxxxxxx;PWD=xxxxxxxxx;DBALIAS=DB2", acTable,
"U.D604_RO", "U_D604_RO", , True

In a form called frmQueue, I have it set up to show one record at a time.
When a person closes this from by clicking btnAccept, It sends an e-mail to
one person called the Requestor. What I would like this form have do now is
also send out e-mails to those who were assigned tests ...

I have made a screen with code that allows users to link in tables for other
databases, using ODBC. I then use the DoCmd.TransferDatabase - to do this.
But, the program must know the name of the DSN to connect through. I have
made an entry field so the user can type in this name.

I am trying to write code where an If statement woud look at a cell and
determine if the cell contains certain data elements and, if so, then the If
statement will perform a function. This, however, is not working for me:
If ActiveCell.Value = "* STREET" Then

Was just wondering how I would use a Date variable declared in my vba code
on a form as the criteria in query.
What is the synax is what i mean. I can only seem to find it for text box
values this is 2 variable StartDate and EndDate that get their vaues from 6

I have written and use a database to control a maintenance contract. I have
written a bit of code below to remind the user that a report needs to be
compiled.
Function Reminder()

It could be because I have looked at this too long but I just can't find
what is wrong.  The problem is in the DLookup statement below, where the
error shows    
' [strUser] = John Doe'

Using Access2007, I have been working on a db. The debugger was
working normally, but now I can't get it to stop at breakpoints.
I can't get any breakpoints to cause a pause in execution.
I have compiled, decompiled, and created new then imported, in

We moved an Access 2002 database to Access 2007 and are now receiving an
error stating the system can't findthe name "DBEngine" entered in the
expression. No code changes were made. Any ideas?

I'm probably wrong here, but I couldn't find a suitable group:(
does anybody know how to make a JET database kana sensitive?
Thank you in advance
Konrad

I have a SQL backend database which is accessed through an Access front-end
with tables linked with a DSN-less connection.
I need to modify one of the linked tables via code (I don't have direct
access to the SQL database via Enterprise Mgr, etc).  With an Access BE

I have a DB with a size of aprrox 1.1 GB,it's that big cause it contains my
products with pics stored as OLE objects.
When trying to secure it or even part of it the file "CRASHES(DOES NOT
RESPOND)"! The reason I want to secure it is because I don't want it to be