Hi.Can you please help me with my problem.I create my database last
week.At first,the database worked smoothly.But,when I when  I reopen
my database,my last forms was dissapeared.Can you help me to solve my
problem?Any post will help.Thank you.

I'm running the following query in my Acces DB:
select field_num,field2,field_name,SUM(sold_1_,sold_2,sold_3,sold_4) as
total_count from table1 INNER JOIN table2 ON table1.index=table2.foreign
WHERE [table1.update] >= '2007.11.1' AND [table1.update] <='2007.12.1' GROUP

I have been working on my new data base for some time now and i am in a place
where i am stuck I want to be able to make a form to change my labels name's
the labels are to describe the texbox and i can edit my text box and link
those but is there a way to do the same with a ...

I'm building a form in Access that I want to be able to print out and mail.  
There are a few pages to the form, as there's lots of information I need.  
The page setup will not allow me to go past 22". I've tried to change the
number in the columns tab under the Page Setup button, ...

i will apologize in advance for asking again...
database set up:
table: classes available
        fields: class

Can I autumatically generate a new record adding information (future date)
from a current record?

I set a password so no one else can change anything in the database, but I
need to remove the password.

I have users using the run-time version of access which does not allow the
newer (access 2002 and up) FileDialog functions.  
I found great information about using a direct call to the API from
http://www.mvps.org/access/api/api0001.htm on another post in this forum.  

test

How can I set up Access to consider more than 4 decimal houses?
I have tried to do this through property both in the tables and in forms,
but it doesn't seem to work.
Thanks in advance!

I would like to lock my existing records, unless I press a button "unlock"  
on the screen. From earlier posts on this forum, I found the hint that I
should try the tips page of Allen Browne, found here:
http://allenbrowne.com/ser-56.html

Is it possible to have a two page form and only print the first page or
second page when needed.?

Has anyone ever used windows scheduler to launch a routine witin Access.  I
have a routine, that runs on an "on click" event.  I would like to have this
routine kick off at 4:00 a.m. every morning.  Through the schedule wizard, I
have been able to get my application launched, but ...

I have a subform for a call log.  When you input something into a field on
the subform and tab it saves it.  I have a save button to save on the
subform.  I only want the data to save when the button is hit not when the
focus is away from a field or if the database is closed

I have a simple database that contains only contact information. I'd
like to add a button to the input form that will invoke Outlook or
Outlook express and open a new email to the current contact. Is there
a simple way to do this? I've read elsewhere on this list that you can