After I enter information in Microsoft Access, such as customer name,
address, date of sale/price and sales person who sold to them, how would I
pull this information back up as well as other sales persons customers to
print on one sheet of paper so I am not wasting paper. I know ...

Does anyone know how to avoid the user open the same Access "mde" file more
than 1 time? I know how to do it on Visual Basic, but it won't work on
Access program.
Thank you in advance.

Can I create form letters using Access 2000?
I am trying to create a "mail merge" type letter and want to use Access 2000
where my data is located instead of using Word' s mail merging feature.  I
have seen it done before, I just can't figure out how to do it myself.  Any

I am trying to bind a form to a record set using access 2003. However, I can
not edit the data in the form. I made sure that the record locks are set
correctly. Does anyone know how to bind a recordset to a form and allow the
records to be edited (i.e. not read only)? I used the ...

Please can you help?
I have a Number field for 'Received', one for 'Issued' and one for 'Balance'
in a table.
Is there anyway the 'Balance' field can automatically update, so it takes

I have an Access database that I want to use to store data for lesson plans
for different courses that I teach.  In my database, the lesson plan for a
particular course is actually a report output based on a query of data from
multiple tables.  These tables, for example, relate ...

Tiit,
 My e-mail hasn't worked for months,  But I finnally got it fixed today.
My e-mail address you have is correct.
Thanks,

I have a query that is using a combo box on a form for criteria.
This has been working for a year.
Now I am getting parameter messages when ever I try to run the query for the
value in the combo box, which is a date. This is a criteria statement.

I'm kinda new around here.. I've been using Access on and off for a
couple of years..
I'd like to find some good resources-- like websites-- for Access
2007.. are there any Access 2007 specific websites that are important

Hi, is it possible to select the last record entered, if so how ?
Thanks in advance

I thought this would be easy but evidently it's not. I have a table of
Employees sorted by Division and Name. When the Division field changes on my
data entry form I want the Name combo box entries to reset with the
employees from the selected Division.

I have a form that has a button to open another form.  This form opens to a
specific record depending on what MSA_LeNum they choose in the first form.  
It is possible that the LeNum does not exist in the table used by the
subform.  I want access to enter the LeNum from the first ...

The only "Help" I can find for macros in Access Database are for actions.  I
want to set up a macro to repeat street addresses for apartment buildings,
for a mailing database, so I can print envelopes.

I suppose you can not have the dropdown list Colour different from the
actual window showing the data.
Reason: So when the drop down list appears below , does not get mixed up
with what is already on the screen

I created some test DB's for test data by copying and relinking the FE and
BE of an existing DB that is having problems. My queries are giving me
a"compile error" when I try to open them. The error is in the Criteria which
is just a date expression