I downloaded Office 2007 for this reason :
It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.
The save button remains desperatly grayed.

I am editting a database created in access 2003 by another programmer.
This person has left the company for which the database was created and
no documentation.  So that I could work on this database at home, I
have converted this db to 2000 which is the version I have i have on my

Does anyone know anything about barcodes in Access.  I don't want to
create them in Access.  I merely want to scan whats already been created.
I need to scan Liquor bottles.  I have the scanner hooked up.
Any help is appreciated,

I've been clicking around Access 2007 Beta 2 and can't see the custom
menu bar designer.  Is it in the beta?  Maybe I'm blind. The question
that comes to mind is: Will custom menu bars be the same height as they
were in previous versions or will they be the "ribbon" style that takes

Anyone know of any features of the new Access 2007 that will improve on
the ability of Access to work in a web environment???
Bob

Can one programatically create a file folder which has the same name
as a key field, using a command button?
Or,
Can there be a a command button which opens up a directory tree to a

i am trying to put a space between title_the and title ONLY if title_the is
not null.  below is what i have, but it is returning the empty space
regardless of whether the value is null or not.  ideas?  thanks!
iif(title_the is null, '', [title_the] & ' ') +''+ title as movie

Would like to create a database named 20060602Data.mdb
and populate it with the data in 31 local tables in the current
running database. I would like to do it all with a single button
click. Was wondering if someone knew of suitable sample

Hi,
I am trying to work on an employee database. The tables and fields that I am
working on are listed below.
I created a query because I wanted to separate the employees by department

I have a database that is tracking dimensional data.  In order to do some
further analysis of this data I use a program called Mintab.  So I'm
entering the data into Access, querying the data using Access, then
exporting the data to Excel, and finally copying and pasting into Mintab ...

I've inherited a SQL statement that looks approximately like this:
SELECT Sum(tblA.A9A) As [1990],
      Sum(tblA.A9A)/Sum(tblA.I9N) As [1990P],
      Sum(tblA.A0A) As [2000],

I use the following script to open an Access app, to avoid the security
warnings:
dim o
set o=createobject ("Access.Application")

hello everyone...
after several days trying to find the right command.. i have to ask you
people...
this is the deal:

Is this (subject) a possiblity in access?  I need to link the 'id'
field in two tables in my database together so the auto number provides
unique identifiers ACROSS the two columns.  IE if the first 3 entrys in
table a are id 1, 2, and 3 the next entry in table b will be id 4

I've read up on Access and the limits of creating visible controls at
run-time.
I'm using Access 2003 and assume that it cant be done.
I did find a clever method of having a main form (and in it's code)