I have an append query to add data to a table.
I would like that only the data gets added where in the clientnumberfield is
staying a clientnumber.
Something like: everything which is <0.

I have a Close button on my switchboard that (surprise, suprise) shuts my
database.
This leaves the main Access screen open, with just the toolbar at the top
and a full-sized empty grey screen.

Hi, i have a table with a few check box fields in but they dont save and i
have to choose the check box option for each field every time i open the
database, any clues please?
Also the rows and column heights wont save to what i put them at.

When I click create I get a list of fields side by side.  I tried various
things, including office online, to get the table to column view.  
Can someboy help?
dennist

I've locked one of my ms access vba project by password for sometime and now
i forget abt it, are there any utilities can review maybe just 2 charaters
or more ?  if i can know that i can remember. Thanks
Daniel

I have been asked to create a PO tracking system for repairs and maintenance
for  116 retail stores.  I've already created the Lease Management database
with all of the store information, and plan to link the store information to
the PO tracking.

I have three groups of users (representing three distinct sales orders
processing stages, if it matters) and a form for each group. Assuming I have
Workgroup Security set up properly (I'm still trying to understand this -
let me study it a little more) can I have the appropriate ...

I have a form that adds a new Job record to my database. The record
has an autonumber key field. Instead of putting the next highest
number in, the system has suddenly started again at 1 when it should
be 1694!! Trouble is, 1 already exists, so it now has an error- can't

I have a person that keeps getting unconnected to the database.  He doesn't
know it is happening and forms look ok so he has lost data.  Right now he is
the only one doing entry to this db.  Is there anything in access that could
cause it to do this.  I suspect the network ...

Im tring to categorise some records based on a rule which says;
we have a 2 hour grace period, then every thing is categorised different.
we have a bunch of duration values, ie 2hr, .25hr, 1 hr, whatever.
If the event is over 2 hours- then it is category 2.

Rebuilt my system last week.
Since then, when I run Access 11, I get the following two dialogs:
=======================================================
"Security Warning: Unsafe expressions are not blocked.

I am using Access 2007 to open databases in Access 2000 and 2003.  Most of
the functions I have tried so far seem to work, once I get past the sandbox
and other security issues.  Is there a compelling reason to convert these to
Access 2007?

I have an update where I specify the following:
    string updateSQL = "update  Perform " +
    " set venueCd = ?, " +
    " performanceDTTM  = ?, " +

Hi, im using access and want to filter some results so the first 2 hours get
flagged as one category and everything over 2 hours a different category.
Ive got a field returning the hours, so i want someting like; "if the 2 hr
limit hasnt been reached, return a value but if they ...

how to use macro with a list of RunSQL statements in it that delete
records and apend records to a new table?
I have a database to save records for tool performance everyday.
how i can create a macro that make a copy of the current access file