Ok, I have searched and serached and can't find a decent solution to
my current issue.
I want to assign a unique ID via a modal pop-up form.  The form has 2
combo boxes to refine the data (second combo box is filtered by the

What is inner join and outer join mean?

Hi I am trying to create a employee database that will open other forms that
data can be placed in (tick boxes) to show the employees' level of
competence.  When i create the macro to open the form it doesn't correspond
to the employee i have selected in the original form, it ...

In SP_WHO there's a field called Program Name. I want to customize
what my Access app is writing to that field. I thought I just had to
set the Application Title but it doesn't seem to work. The Program
Name just says "Microsoft Access". What do I need to do? Do I need to

I have a form in which the user selects various properties from drop
down lists.
The idea is that based on the properties selected, a different cost is
associated with that part.

I have a report that runs overnight (to print flight tickets).  This runs
from windows scheduler via a macro that runs a module to print the tickets.
I am trying to get the DoCMD.Quit event to run after the print run.
I have tried putting the quit event into the macro and also ...

We have an access database with several users. I run a number of queries in
sequence via ado.net on the same database form time to time. The problem is
that when the queries are run the users are almost locked out of database
due to low responsiveness of the database during the ...

Is it normal to have to press AND release the alt key for keyboard
shortcuts with custom menus? I thought my shortcut keys weren't
working because if I use alt and the letter at the same time, I get a
beep. But then I discovered that if I release the alt key and then

Does anyone know how I would impliment a multi-user database with
Access 2007 runtime.  I hear that you can't do it with a split
database using the Package Solution Wizard.  Any thoughts would be
greatly appreciated.

I have a report that is generated using the following codes:
If Me.fraReportOption.Value = 1 Then
       DoCmd.OpenReport "rpt_SiteConfiguration_UMTS", acViewNormal,
"qry_SiteConfiguration_UMTS", _

I am doing a very simple query where I need to count by date..the problem is
that the date field is being brought into the table with a time stamp.
Therefore, I cannot group by date, since it is recognizing each record as a
different "date". Example is when I have 3 records on ...

I'm an Intermediate (at best) user of Access 2003.  I'm trying to determine
the best way to resize - for lack of a better word - a shared (Workgroup)
database.  The database in question has already been split and currently the
backend database is upwards of 300 MB.  Is it ...

Using Access 2003 albeit with an Access 2000 database, which due to others
using off-site, I need to retain the 2000 format.
I regularly clear data from a table and populate with new data and as such,
the size of the file grows and grows.  I can manually compress but would

I would like to automatically generate email reminders for say passport
renewals one month prior to their expiry date. How do I do it?

  I made access db on home machine Office 2003 Win2k then took to
office with xp & Office 2003 and it won't open. I looked in file with
text editor and it contains information on path on original Win2k
machine. Why??