I am displaying a list box in a form that runs off a query, the list box
should display 146,600 records in the list box, however it seems to stop
somewhere around the middle of the list. Is there a size restriction for a
listbox? If so is there a way to increase the list box ...

I have a text box that I need to auto populate after I select a value from a
dropdown box.
I have three tables-
Table 1 (Order) is set up like this:

Hi!  I have a field that is indexed with duplicates OK and that's the way I want it....however, I would like to be alerted that the entry already exists, do you want to continue, if a duplicate is entered into that field on the attached form.
Example: Account #1234 already exists ...

When opening a form, the top and left are hidden and have to scroll to
display the whole form. Properties are set to autocenter. Any other
suggestions?

I have an OrderDate date field on my main form.  I have a subform linked to
it that has a column called TransactionDate.  I want to put the OrderDate
from the main form and place it into the TransactionDate field on the
subform.  I know how to populate data from the subform to ...

I have an Access 2000 database with a Customers-Order form scenario identical
with the Orders form in Access’s Northwind (NW) Database.  Whereas the NW
database has about 91 customers that are accessed from the “Bill To:” combo
box, I have several thousands of customers.  I find ...

I used the wizard to create a combo box "Find" a record (based on a field in
the table) on my form, which works fine. But, here is the strange part, I
added this into the "BeforeUpdate" of the form.
If Isnull(txtName) then

I have a form in which I need help calculating percentages.  I am trying to
get a percentage on the difference month over month.  August and July were
originally currency.
=([August]\[July])

I have a continuous form that has 2 linked combo boxes and I trying to
synchronizing them so that when you scroll through the records the 2 fields
in focus are exact.
Here is my table structure:

I have 8 tables created for my database: catalog numbers, countries,
FFR#,Part#, Rat_old, Return Authorization, Sales force, and Sales personnel
by name. Ive created a form for the Return Authorization Table with drop down
boxes.  My problem is the drop down box on the field ...

I created a form that will be used by about 25 people at the same time.
Is there a limit of users?   How can I make sure that it will be supported,
will not freeze and/or the users will not be kicked out?
Thanks

I have wondered about this for a long time.  I have a "Main" form with list
of customers, etc.  You can use different buttons etc to open other forms
update info and close those forms.
I have my "main" form set to maximize when it is opened onopen docmd.maximize.

I'm getting this problem with a secure Access 97 database.  It happen
when I first open the database.  
I've loaded previous versions of this (before some upgrades to som
reports that we made) and the problem doesn't exist.  If I import som

I'm trying to set-up a system to automatically display the proper menus to a
user depending on the user's department assignment.  I have set the start-up
form for the database to be "frmMain".  In the On Activate event for this
form I have placed the code to get the current user ...

On my form I have a control named Platform which contains the name of an
oilfield platform, i.e. High Island 376 A
If this platform shows a A or B, then I need to hide the A or B so my report
does not show it.