I have a customer table setup in the fashion of a contact list.  Most of my
forms need to access the information in it via a list box.  I want to set
these list boxes to generate a new record in my customer table if the name
that is entered is not currently in that list.  By ...

I have many payments some with po#, some without it, I need to add up the
previous payment on the same po with the current one, what is the formula or
expression?

I have employees hours scheduled for work centers in a work week. I would
like to be able to copy week 32 schedule of emlpoyees and the work centers
assigned to, then paste it for a future week 51.
Whatcha think?

I have a form where I have set "None" in the "Min Max Buttons" property.
In the "On Open" event I run: DoCmd.Maximize
Then I have a "Restore Window" button on my form. When I click this "resore
window" I only have the close button showing.

I have a form with 2 combo boxes (A and B) used to pass searched information
from a query to a common report. ComboA searches for Customer_Name or ComboB
for licence plate#. For ComboA I've Command1 to trigger the report while I
use Command2 for ComboB (both combos use Customer_ID ...

Greetings!  I have a nifty form for entering Contacts and their addresses.  
My form is adaptable for primary and secondary addresses, by chosing the
appropriate flag.
Now I need to modify my setup to include Canada.  I've included my mailing

If I got rid of all my saved Queries and just used SQL would there be
any benifit to to this?
Thanks
DS

Question:  Is there a way to define a different default switchboard
depending on which user is logged in?  Our company has multiple departments,
and we want each department to have their own menu available at startup.
Does anyone know of a way to do this?

I have been trying to figure this out for literally a week, and I'
going bonkers!
I have a form in which records are entered, and each record needs to b
assigned an ID according to the Salesman, Month, Year and Record Number

Wanting to use the calendar from Calendar Control 9.0 to select the date for
the date field in my form.  I am using MS Access 2000.  

Anyone,
I have a unbound form (frmlookup) that contains a text box (Mysearch) and a
subform (sfrmlookup).  The text box is mentioned in the subform underlying
query Criteria for MatrialName: Like "*" & [Mysearch] & "*".  When you type

I am working on a check and balance program and I have an issue on one of my
forms. I have a main form (name "Account") with three subforms ("Data",
"MonthsYear", and "Total"). All three subforms are conected to the main form
by the account number. The subform "Data" is a ...

I am trying to use the dSum function with 3 criteria, and it doesn't seem to
be working.  
Here is my formula that I use: =dsum("[Student Grade]","Student","[Grade
Type]='FINAL' AND FORMS!FORMNAME.[STUDENTID]=[STUDENTID] AND

Hi Friends,
I would be very grateful if you could give any solution for my following
problem.
I have created a form based on customer table. On this form I have created

I have a main form which pulls info from a Master Emp Query.  I have created
a Badge subform for users to input infor and it is based on a Table.  When I
type the emp# and the emp infor populates the top of my form, I can enter
infor into the Badge subform, but I don't know how ...