I have a private medical practice and need two things.  The first is a simple
patient accounting program.  I do not need to bill electronically or fill out
HCFA's.  I am looking for what would amount to a more complex ledger format
than I could create with Excel, with some drop ...

I created one table named 'Fields' expressly for the purpose of
housing commonly used values for drop-downs in my main table called
'Main'.
One of the fields in 'Fields' is a list of last names.

I  have table #1, which lists a series of titles and their corresponding
product numbers. In another table I want the same info, but I do not want to
have to manually input the product number.  I want to be able to chose a
title name from a drop down list (which I already set up, ...

Does anyone know if it's possible to have a barcode on a form that when
scanned, adds the current record? This would allow the user not to have to
used the mouse.
Thanks,

Using A2003. I discovered a glitch in my database today that I traced
back to a text file import.
I already have a table in place to receive the text. One of the table
fields "CLM" is a 20 character text field, zero-length OK, not required.

I have a form that contains many sub forms within it. I'm trying to setup VB
code to send information within these forms to MS Outlook. My email code is
working and I can select fields from the master form (The Form that opens)
but I cannot get data from the sub forms. I believe ...

I have a split database which I have put together locally (i.e. both front
and back end reside in the same directory on the same PC).
Now I've finished it I want to transfer the front and back ends to another
PC.  How to do this is simple enough but something strange seems to ...

I have a lot of queries that are based on other queries, which are based on
some other queries, etc... Quite a mess!
I would like to simplify SQL of the top queries so that they are based only
on tables, not other queries. It would be too complicated and time-consuming

I have a data base to inventory and track repack boxes (fireworks that have
been broken down for sell the previous season).
Each box is assigned to a specific tent # and each tent may have many boxes
and each box may have many products.  Each box is given a uniqure bar code

greetings. access 97/2k. about 10% of my users are running 2k and the
rest 97. approx. 60 users currently, access FE and sql 2005 BE.
the issue is that right now i have to support 97 and 2k. i run both
and test on both on my machine. now IT is upgrading from 97 to 2007!

I may not have said that correctly.  Here goes...
User inputs time into a field by entering or using KeyPress event to
increase/decrease time in 15 minute increments.
******* code for keypress event

The name of the query that I am trying to run is called
"qryRegionalAdmitSummary_Mark".  The error message that I get says:
"The Microsoft Jet database engine does not recognize
'qryRegionalAdmitSummary_Mark' as a valid field name or expression"

Are there MS Access 2007 templates available for Web applications?

I have the current Sub Procedure in a VBA Module.
-----------------------------------------------------------------------------------------------------------------------------
Sub openForm(formName As String, Optional varToSend As Object)
   If varToSend Is Missing Then

is it possible to add additional field to the list of fields coming
from a table inside of list control,
i see that inside of a row source you can get an sql sentence if you
choose table\query but how i can add additionaly an item that doesnt