My DB seems to have lost this link (?) and my date update macro won't run
unless I do it manually. I didn't create this DB and can't find how they set
it up.
Any ideals would be approeciated.

My question is a application performance issue so maybe the wrong forum.
I have a SQL Server 2005 Express database and connected Access 2003 clients.
The performance seems to have degraded since moving from SQL 7.
The users are seeing delays when clicking on menu optiosns that have ...

I have the following code behind one of my forms to automatically fill in
the LastName, FirstName & Division when a hang tag number is typed into the
form. The data is retrieved from tblName which also has a “year” field in it.
Since tblName can contain many years worth of data ...

I am not an expert in Excel and Access, but after trying to create Macro
using VBA in Excel and I also have developed a simple Access database in
tracking supplier invoices including it's aging. I do not know what is the
difference between excel and Access in term of it's ...

I have a date field that has the following input mask: "99/99/9999;;_"
I have a bound text box control on a form that is bound to this field.
I am trying to accomplish the following:
1) When a user clicks or tabs to the control, the cursor should start

I have a table (tblStoreInv)  with these fields: Index, Store, Product,
Quantity.
A form (SetInventory)  that is connected to that table has these fields:
StoreID, Product, Squantity.

i have two tables, that contains data in two columns. I want to
display only these rows from Table A that do not exist in Table B.
Rows are considered equal if data in both columns are equal.
I have an idea how to to it, but its too complex (needs at least 3

I'm getting this error message when trying to use several of my combo boxes.
"The record source does exist..." I typed in the data myself in the lookup
wizard from within my table's design view.  To try to trouble shoot, I
created my record source as a unique table (entries ...

I've somehow managed to lose my main menu bar.  I can't click "tools" or
"file" or "help" because that's the tool bar that is now missing.  I don't
recall making any changes that would affect this area, but my computer
updates automatically.  So who knows?

I've posted an example of the Query results I would like returned from
my Data Source.  Basically, I want to have one row for each item, then
have columns for the Months and show the Qty for that Item under the
given Month.  I know I can get my desired results using VBA, but was

I have a form that has a calculated field  - check box - called "Audit Met."
This updates to "true" if all the audit requirements were met on that same
form.  What i want to have happen is to update another field called
"AuditComplete" in another table - ProjectInfo - to "true" ...

For some strange reason none of my Event Procedures are running in my
access database. I can use macros for events just fine, but if I want
to use a VBA event procedure nothing happens. If I put breakpoints in
at any event in the VBA code, I never see a single one come up. What

Hey.  This is my opinion, but this ebook comes in handey.  I really suggest
you get it if you are learning Access.  The only draw back is his focus on
DAO.  I would say ADO is the way to go nowadays but he's old school and I
can't blame him.

I have a form which is linked to a query/report.  The general idea is
that the user can fill out the form with combo boxes that have been
populated with items in a table, to narrow down a search with a piece
of equipment that crushes rock.  The form has two date boxes (start

This database is set up so that when I open it up, a form loads that has
about 12 sequenced events that run one after the other to update the data
every day.
I want to run the following script: