2 Questions.
Question 1:
I have tblMain. In one of the columns, I have a reason code, which is pulled
from tblReasons. The next column is reason description, which is associated

Greetings Access Geniuses,
I work for a very large company (100,000+ employees) as a paralegal. I
was hired because of my potent combination of legal and technical
knowledge.

I have the opportunity to purchase the 'academic version of Microsoft
Office Professional 2007.
Is the 'academic' version reduced in capabilities from just the basic
Microsoft Office Professional 2007?

Hello Chaps,
I have a lot of events that finish at midnight, and like I can with MS Excel
I'd like to use the format 24:00 as it makes it easier to add up hours and
feed a FlexGrid.

I have an access 2003 file that looks like this:
Land Vehicle    Water vehicle    Air vehicle
Car                   Boat                Plane
Bike                 Yacht              Jet

I have [text9] which is a text box in a form.
I enter into [text9] the following formular, can't work :
=Round(Pmt([Text7],[Text5],[Text1],0,0),2)
However, after I transformed [text7], [text5] and [text1] into their box

Hello, All!
Is anybody know how detect from Visual Basic??? MS Access 2000-2007
With best regards, Alek Luchnikov.  E-mail:
alekluch---FORSPAMERS---1983@mail.ru

I have searched for the codes to email a form/report in a body of an email
and have Access connect to MS outlook to choose who to email to.  I have
tried several different codes and do not understand code.   None of the ones
that I have tried worked.  The last one I have tried is ...

Hi Everyone,
  I am working on a project where we need to be able to enter the net
number in a series (not an auto number field). So, for instance if I have
DEB-12, DEB-13, DEB-14, how could I find out what number I should use next

In my vb.net app I am trying to open a db via DAO as below;
Imports dao
Dim dbSynch As dao.Database
dbSynch = DBEngine(0).OpenDatabase("C:\MYDB.MDB")

I'm trying to save a .SNP file in a specific directory and with the current
time and date.
The file is saved in the specified directory, but he's always saved as
today.snp

Hi people, I wonder if anyone out there can give me some advice.  I have a
database where users input various requests that have deadlines to be met.
What I would like to happen is for an email to be automatically sent when the
deadline is approaching, say one week in advance of the ...

I have a Access 2002 DB with 2 tables containing 16 columns each. The second
table is a newer version of the first with changes to some of the data. Would
anyone know how to create a report that tells which records have had data
changed and what the new data is?

Hello,
I have a user that refers to enter data into a query so that she can check
the calculations as she enters.
My question is as she enters data and goes from one record to the next

I have a form with a button and 4 text boxes on it, the button has the
following click event:
Private Sub cmdImportFiles_Click()
  GetExcelFileData Me