Hey Guys
After doing countless hours of design for an access image database for
roughly 5000 images and climbing. I wanted to include a thumbnail of each in
the database so that anyone could view each record and see a thumbnail of the

I work for a Mental Health Agency and have been asked to develop an
assessemnt form for "Early Psychosis" patients. I have created the tables --
the main table being the "MPI" number (unique to each patient) and a visit
number, as the patient may have one MPI #, but several ...

I am trying to flag important items in access and don't know how to go about
it. Please help!!
Thanks

I am having problems with a form for which i am using to create invoices
The problem i am having is once i have entered the items sold in the subform
and click a command button to print the invoice via a report, for some weird
reason the items entered are re-arranged in a completely ...

I am designing a system for entering tickets.  I want it to be auto number.  
Problem is the company is at ticket  # 3516, and I wish to start the
autonumber field at that point.

I have to develop a program to track sales commissions. I have a standard
Sales Order Header/Detail table design already setup to track the sales.
The issue I am having is that the sales commission % changes as the salesman
get more and more sales for the month.For instance, it ...

I have a small bussiness, and print my own online checks,merchants will not
except them due to the fact that they look plain and computer generated, I
would like info on how to put a background on my check paper.

I need help with something that is probably very easy, but it has been
eluding me none the less.  I have a main order form with an order details
subform and a parts list in a separate subform with tabs (both subforms are
on the same form).  I would like to be able to select a ...

I've been trying to figure out a properly normalized and efficient way
to implement a system wherein:
-default values are looked up based on one or more fields.  These
should be queried dynamically as they will change.

I'm trying to format a number field to except partial hours for a time sheet.
How do I format that to stop rounding up to the next whole hour?
Thanks!

I have designed a query with 2 tables called "Customers" and "Tanks".  The
query has all the fields from tanks which our company rents to customer and
the customer ID [accountnumber] and ship name from customers.  Can this query
be used for data entry if a form is made from the ...

Hi,
I'm building an access database mdb file and there will be several (up to
15) users reading and writing to it at the same time over a wireless network.
Tables will hold information about patiens, wisits, payments and so forth. We

I need to format a field in Access to accept a leading zero in a two digit
number?
This is posing a big problem for me.  I know it's an easy fix.  Please help
me??

Created a value list and use edit list to add data. After 150 entries, it
won't allow me to add any more. Please help

I have a relational database design question that I cannot seem to
solve in an aesthatically pleasingly way; I was hoping someone could
help me with.
I am trying to create a recipe database, in which I would like to