I need some help regarding the creation of an auditing facility with
Access 97.  First off, let me say that the following design is not my
idea but I'm in the unfortunate position of trying to implement it
somehow.

I have a small database I use to keep track of the people that work
for me (about 200).  They work all over the region and are divided
into a few work groups.  I need to know every day that they are
working where they are supposed to.  Having each of these people call

I wanted to start a thread that might help many of us.  I worked for a
company for 12 years, until this past Christmas when they let me go.
Getting rid of the higher dollar guys, in favor of more profit, was the
reasoning.  Oh well.

I'd like to open a discussion about the state of the industry. For the
past year, I've been unable to find competent Access developers
available for hire. I'm worried about that.
I think there's great demand right now, and that's keeping the good

I'm working on upsizing an application from MS Access MDB -> MDB backend
to MS Access ADP -> SQL Server backend.  The application has the ability
to create a new, empty database.
Right now all the code is generating DDL statements inside VBA and then

Oh, how memory fades.  I have forgotten how to have a single two-column
drop-down feed two fields.
As I don't want to limit to the list, I can't get away with a join.
Table: Transactions

I am trying to go through a list of files in a folder and then add a
hyperlink to each one in a table.
I am having a difficult time figuring out how to add that link into the
table and do it in such a way that the entire path isn't displayed in

Can anyone tell me how to do this? I have a table (TableBuildings) that
I want to auto create data to its sub datasheet (TableDaysOfWeek)
whenever a new record is added to the parent table (one to many). The
data that I want to auto create is each day of the week (Mon - 1st

Anyone know how to pass a parameter to a query via a report in Access
2003?

I'm tearing my hair out on the simplest of queries (SQL Server 2k).
I'm using ASP and the code I was using worked fine when attached to an
Access MDB, but I can't crack it under SQL Server.
This is the code I'm trying in the SQL Query analyzer:

My boss just got some new data tables.
The problem is they are overlapping data and everything is fine.
UNTIL
ok show me everyone in table 1 that doesn't match anyone in table 2.

Help, i want to run an update query from a form..
and was wonderin..
Can the update query run if i want to update a value manually inputted
from a form (e.g. [Forms]![frmUpdatePW]![txtConfirmPW]) to a table

I hope that someone can offer a little advice on this one - I've
searched the group but can't find an answer.  I think that I'm doing
something really stupid or missing something trivial, but see what you
can make of this...

I'm having a problem with the menu bar (e.g. File Edit...) in MS Access
2000 - it has disappeared no matter what database I have open.  Can
anyone help me to get it back?  I have Reinstalled, Repaired and
Uninstalled and reinstalled Access - nothing worked....

I have a subform that is populated by a table that holds lots of yes/no
values.  The user sees points at the side and then periods across the top.
So they decide they want point 20 for period 5 and go click that checkbox.
This in turn fires of various calculation code in the ...