i hav a field which is in subform. i'm named it as location. when user change
the location and i want to know and i want the record to keep it in a table.
i want to know when the user change the location n where they put the things
now. what i can do? thanks!

I want to make a copy of the structure of an existing database. This
database have linked tables and when i want to import the database
without the data, always copy the data too. I don't know how i can
acomplish to copy the database. Could somebody help me!!!. Please.

I want to create a single calendar each month that shows only Monday,
Tuesday, Wednesday, Thursday, and Friday.  I want a template without
weekends.  I usually create my calendars through Microsoft Word Calendar
Wizard, but there is no way to get rid of the Saturday and Sunday ...

Hi experts,
I have a form based on table1.  By selecting the ProjNum from a combo box on
this form, I need to add the selected ProjNum to another table (Table2).
Table1 is the master table with all the projects and related info.  the

Hey All,
I have Me.Refresh in two places, the first example works but second does not
and unless I rem it out the code won't compile.  Can someone tell me why?
Thanks,

I have a data entry form with a command button to open another form to enter
comments.  The form opens as I programmed it with the matching customer ID;
however the form is not updating my underlying table, though it updates the
other keyed in info.  What am I doing wrong???

Hi All - my turn to ASK a question.
I have an application in which some of the forms contain a subform in
datasheet view.  It is set up so that users can hide/unhide columns they
wish to see at any given time.

I am fairly new at using access and have been given the task of coming up
with a timekeeping database for a large company. I have a daily timesheet in
one form and a weekly timesheet in another. I would like the value for the
total hours on a certain day to automatically show up ...

I cannot make the focus of the form stay the same...  I have many pieces of
equipment to attach to one technician... Every time I enter a piece of
information the lookup column goes blank...  how can I make it stay the same
until I change it

Is there a way to suppress this display when data is not yet available to a
textbox? This shows prior to the user selecting a client and looks tacky.
Thanks

I have a combo box that lists names of queries.  Based on this combo box, I
would like a text box to give me it's corresponding code.  ie:  query name is
"number of buys" the text box should have a 1 in it.  I have about 31 query
names and corresponding numerical values.  

I am new to access and databases in general, so forgive me if my questions
seem elementary.  I would like to create a form with a series of check boxes
for questions for potential clients (i.e. Married ?, Children?, Pets ?,
Languages?, etc).  Selecting the box would then take the ...

I have a field that was copied and pasted into an access database.  This
field needs to be separated into separate fields, which are separated by
commas.  I have searched and found an article on The Access Web authored by
Dev Ashish and it appears to be exactly what I need.  The ...

Is it possible to use a command button in a form to
1. Run A query, and
2. Export the Query to an Excel file always saved in the same location
and rewriting the old file?

would anyone know why this doesnt work?
strWhere = strWhere & "([processed_leave_date] = not null AND [date_exercised]
= null) and "
it's a line from a filter i've created...the rest work but i cant get this