Just curious if anyone is having issues with Acc 2007 once the number of
objects and complexity increases? I have a fairly large app, with many
linked tables, 100's of forms, queries, reports, and lots of vba code. I'm
nearly finished with re-doing my app in access 2007, and just ...

Good morning everyone,
I'm producing an A97 database of Mining records.  One of the tables has the
map sheet references as SH/55-14.  The other table has the references as
SH55-17.  I want to add the "/" to the data in table2 (or take it out of

Code--
               objExcel = New Excel.Application
Error/Exception-- I have included all the apis
microsoft.office.interop.excel etc in bin

I am new to Access, trying to figure it out on my own.
I am trying to create a form to input the same information in 3
different tables.  The 3 tables each have a different number as the
primary key, although they each do contain the other 2 numbers in

I want to run the two versions of Access on the same machine (2003 &
2007). I still need 2003 for most of my work, yet I need to start
learning 2007. In my previous attempts at this, right after the
release of 2007, I had problems with the installation dialog running

I have a database that is tracking donors, pledges and the payments
made against those pledges.
I have a table for the donors, the pledges and the payments.
I seem to be having a problem getting the payments to interact with

I have this:
SELECT UserInfo.EmpID, UserInfo.FirstName, UserInfo.LastName,
Sum(SoldItems.Commision) AS TotalCommission, Sum(TIP.TipAmt) AS
TotalTip,(SELECT Sum(SoldItems.Commision) AS MyCommission FROM

Is there a way to have the actual listed items of a ComboBox have a
different background color from the base background color - e.g. all
the textboxes and combos have tan as their background color, but upon
'dropping-down' the Combo-box's items have light-blue as their

This Access app is in Access 2000 format. It is a mature app that is
running on machines all over the LAN. Today when I tried to put it on
a new PC with a fresh copy of Win XP and Access 2003. XP has all
patches installed and is SP 2. I got this error:

--------------------------------------------------------------------------------
I have a subform with the related IDs for each customer on the
customer main form.
I have a button on the continuous subform, which will make the main

Is there some code that will enable me to open a different excel
spreadsheet dependant on the value shown in a form? I've got a number
of projects and i want a button on the projects form that will call up
a related spreadsheet.  each project has its own buying spreadsheet

One of our clients has reported a problem.  Everything was working
fine on Monday, but since Tuesday all is going wrong.  The sysadmin
assures me that there have been no changes to the network, or the
servers.

I have pasted some code from anothere Db that works. the only thing
thats changed is the field names and the query. I then get the above??
I am completely stumped the references are the same and one works on
the same computer and the other doesn't. the following is the code

Does anyone know of a utility that would allow you to compare two
(similar) databases?
I have two projects that started out with the same codebase and sort
of started to branch off from each other.  I now need to merge many of

Has anyone heard of a clock control that works like the calendar
control, but for a time field?
thanks!