I have an unbound form with a combobox that list Year (e.g 1,2,3,4,5,6). On
the unbound form I have a subform to display data for each year that select
in the combobox (e.g. the subform would list projects in year 1 if the
combobox selet 1 and so one). Now come the difficult part ...

I have a form that I return to periodically in a file I'm working on.  It is
a data entry form linked to an append query.  (I select an employee in the
form, the populate that employee's record into a temp table.)  When I return
to the form though (after I've made the edits and ...

Hi...
I am a beginner in Microsoft Access.
I have an access application that is used by 70 different users at the same
time... It works fine most of the time but it gets locked at times and no one

I am developing a system which lets users search on multiple fields.
I have a form for the search part and a form which will display the
results. Ive used this code: http://allenbrowne.com/ser-62code.html as
a starting point however this displays the results in the current form.

I am a computer idiot and I need to know how to increase a firld size to
accept more then 255 characters.  Is that possible?  If so please tell me
exactly what I need to do to do so.  Thank you so much:)

Can I trigger an "After Update" event from
code? I have an application wherein a text box
gets updated from code and I'd like that event
to "fire". The identification of the text box is

I have a form "A" that has as its recordsource
a simple query. Form "A" opens form "B" that
amongst other things might add records to the
recordsource that underlies Form "A". What

I have written a macro in an attempt to revise the record source of a
subform. I have an SQL statement that returns what I want, but the line I
have to revise the subform keeps pulling up the error screen with the words
"Object doesn't support this property and method". Any ...

I have a complex query with multiple rows and columns of criteria that
I am modifying for a new issue for my client. Originally I had a
Network field in the query that set the criteria string as:
In("choice1","choice2","choice3","choice4","choice5", "choice6")

All,
I have a continuous form that list our sales persons, and a link to send Off
Day Deliveries
I am using the SendObject.  What I would like to do is, in the morning have

Does Can Shrink work on a form.  I have tried it without success.
Thanks,
Steven

Is there a record limit in a normal table?
for example:  9,999,999 records?

I have a report that in the group footer are 5 txtboxes.  Each textbox is to
count the number of different items each text box is for within each group.  
The field that each textbox is to count is ProjectType.  I am able to get the
count of all with =Count([ProjectType]) but it ...

I have a subform with about 8 tabs, and I would like for when a user
hits the new record command button >* for the new record to be
defaulted at the first tab in the order of 8. The tab name is Visits,
and I need the user to enter data in here first before anything else on

I have a combo box based on a query that will allow a user to select a name
from the list. If the name is not in the list, the Not In List event will run
the following code, and add the name that they entered to tblContacts.
However, I need more information (such as phone number, ...