I have an Access 2003 mdb that I use to connect to a SQL 2005
database. When I open the application in Access 2007 it errors on
using SQL pass through queries.
I see that pass through queries (amongst other options) have been

I am getting a wrong result when I sum up all the hours and I get for
an example 31:59 (31 hours : 59 minutes) , When I need to get is 32:00
Houes.
Is there a problem with the sum function or what?

I currently have a table that contains hundreds of entries by name.  I would
like to create a form on which I can select several of these names(not
necessarily grouped together).  I would like to enter additional data on the
form and have all of it stored with each of the names ...

I have a datasheet with about 6000 records that I keep running in the
background. As I enter a new record from a form, I would like the
datasheet to be automatically updated. As well, it needs to show the
last record. I've tried many combinations of requeries etc all to no

I have found examples of code emailing using MAPI and/or CDO.
Apparently, CDO through smtp.yahoo.com doesn't allow to send multiple emails
at once. I loose the connection after sending 12 emails. Any ideas on that?
Also, if someone can let me know how can I send a html email using ...

Is there a reason the web interface to this forum is not working? It hasn't
been updated since 2007/06/05 (yyyy/mm/dd).  Is MS
aware of the issue?
Daniel P

I have Access 2003 and our school database is on it.  I downloaded McAfee
anti-virus and then we had two power outages two days ago.  Ever since, I
cannot access anything.  I keep getting this "there was an error executing
the command".  What is that?  I am not Access literate so ...

In Access 2003 if had a series of cells in a column that I wanted to type a
pattern of numbers into, all I had to do was hold down the down-arrow and it
would race down the column filling in my pattern.
For example, in 2003, if I typed "2", then down, then "4", then down, then

I'm sorry for this almost frivolous query, but why is the office button
in Access 2007 really slow? It takes up to 20 seconds sometimes just to
show up after clicking it.

Why my Access 97 app can't load jpg file ?
In the other PC, I can load jpg file in report.
Thanks before.
Chlaris

I have a net work of 3 pcs each one with office xp installed on a windows xp
machines .We need to open the same database at the same time to open forms
in design view (each user will open a form deferent than the others ) to
develop an application under Access XP . the problem is ...

I have a form on which I want the rowsource of a combo box to change
dependant on the status of a check box...so that if the check box is
checked the combo box gets its values from one table, and if not from
another table.  Seems like it should be a simple matter but I keep

In my table I have a job code field that is formated 0000. I need to
concatenate that filed with the job title field in a query with a dash
between. Example:
Job Code: 0006

Could anybody inform me about the field property that can contain a number
like this :
2-1124300632
Regards

Storing Calculated Data (I can’t think of another way)
I am creating a database to track residual monthly commission payments over
the life of a contract.  Contracts can be will have addendums each month with
+/- $ affects on the duration of the contracts commission payoffs.