I have designed a form that will display a main form & subform in response to
a parameter entered by the user. I've designed a parameter query for that
purpose, and it works! (Thanks be to God!)
Now I'd like to tinker with it a bit more to get the following result: I'd

I have a question about a table and relationship design.  I am
building a Task management system for my current workplace (well an
upgrade of an older version). I think that I have the tables well
developed and they seem to be working well for the actual task

I have designed some forms that use a combo box to pull from a table. The
table has a list of ~ 50 choices, and despite alphebetizing the source table,
I cannot get the list in the combo box to populate alphabetically. Even if I
blow up the forms & start from scratch, I can't get ...

We have a large database of graphic files.  The file names match the barcodes
we will be scanning with the exception of a pdf extension.  We are using
simple usb scanners to read the barcodes.  I am wanting to be able to scan
the barcode on the object and get notified (or at ...

I created a database and it works great as a stand alone application. When I
put it on our company LAN only one person at a time can have it open, how can
I fix it so multiple people can open the program?
Thanks - George Williams

I have a query and need to exclude some'SKU" items.  If I enter just one
exclusion it wil work but when trying to enter more than one it doesn't.  I
know I have done this before but this time I'm stumped.  I want to do this in
the SKU field:  

I have a query that is calculating royalty for book and cd sales.  My royalty
field is currently =Sales*.2.  This gives me the dollar value for the royalty
on sales.  I need the royalty field to also do this:  IIF 'SKU' =B* then
Sales*.2 or IIF 'SKU =C then Sales*.1.

I have created a database to manage the process of recruitment for a project.
Currently all the details of the applications are recorded in one very large
table and I'm using autonumbers for the primary key.
The personal and contact details of the applicant are displayed on one ...

I have an invoice DB and the primary key field is for  the invoice number
which is unique and should not be duplicated. I have just received duplicate
invoices from differnt vendors so how does one work around this scenario?
invoiceID field=primary key unique

I import a Foxpro DBF table APCHK from our accounting system.    Table APCHK
has a text field for CheckNumber.   Field is 8 characters in length and is
any combination of Alpha and numeric.
The values appear to have leading blank spaces ---- meaning if the value has

I have an Access database that is linked to another (with all of my
information).  I copied my databases onto a colleagues computer and had her
use the linked table manager to link her copied database to her copied
information database.  Most items work just fine on her version.  ...

My question is for you veteran Access users. I’ve never made an Access
database—I was just given this assignment last week and I’ve been teaching
myself how to use the program the past couple of days. I thought I’d run this
by you all to see if my plan sounds like the way to go.  ...

I have the BE and FE of a 2003 database on a network drive. Users copy the FE
to their My Documents folder and then put a shortcut to it on their desktop.
So far, that has worked fine. The network drive is not read only and everyone
has rights to it. Another user just copied it ...

I've spent a significant period of my Access learning adventures sifting
through threads on this site. I must say "THANK YOU!" to all who share your
vast knowledge! So now, I'll pose my current conundrum:
I have a database of contractual correspondence.  There are many tables, it’s

I need to build a database for a non-profit organization that my Dad's taking
collections for.  I need to be able to input data on a monthly basis of:
- How much was collected per month,
- Who the contributors were,