On one of my forms, I want to verify that a combo box actually has data
populated by the user. In psudo code I need to do something like;
if combo box.text = ""l then
msgbox "you have to enter something"

In a time sheet database, I have a drop down combo box that filters
out only Active Employees when assigning times.  It works fine.
But when an employee is no longer active, the drop down filters the
names not to show that person anymore (that's good) - but it also

I have imported files from an excel spreedsheet into a new database in an
attempt merge some fields. In previous years this data was provided to me
with patient data being on "one" row with certain fields that have different
dates being denoted with the test perfomed and the ...

I build an input form in which there are a number of fields using combo box
to enter the data, i.e., names, suppliers, etc.  The combo boxes are linked
with a query before on a table.  I have learnt this way to avoid storing
repeated data in a database but I notice that the ...

Problem:  I have a subform with 3 fields & want to sum dollars in 1st based
on text value of 2nd and store in 3rd.
Main form named F_DepositSlip & Record source is table M_DepositSlip;  sub
form named fsC_PayFundsAllocationSelForDeposit & Source Object FS_DepositSel.

I'm using a form to track a QA process for a large number of records.  These
records have both an id number and record name.  I'm need to have the record
name display based on inputing the id number.
I've tried using DLookUp as an expression and VB code after reading other

Hi ya'll...
I am dire need of some clear thinking. Here is the situation....
I am running split databases... the timesheets are entities that are
controlled by the employee. I have control of the project information. I need

Hey everyone,
I am about to go crazy.  I am setting up a CRM system and thought it was a
pretty cut and dry project.  Here is the db layout.  I have set up
relationships between a master client table and several detail tables

I have created an access page and stored it on a network server. I can access
and display the database remotley but when anyone else tries, they recieve
the following error:
Microsoft Office Web Components could not open the database 'K:\PMO

I am trying to create a form to easily enter and update family information.  
The main form comes from the family table (last name).  The main form has a
working list box.
The subform brings the family members from the familyMembers table.  I want

I would like to know if it is possible to create skip pattern on a MS Access
data entry form and how does that works.
Thank you

This is a terribly basic question, with an answer probably staring me in the
face: but I have not yet figured it out:
I created two simple forms, one that sits within the other.
The main one (Form A) lists a topic, a date, and a comment field for an

access 2000, windows xp
i have two tables say, customers and orders with a one to many link of
invoice number
i wish to delete from customers all records with no orders.

I am trying to use Dcount in a text box on an unbound form to count the
number of records that match criteria for a given date like this:
=DCount("[Field]","This Table","[Field] = 'This String' and [Start
Date] ># 23/3/2001#")

I am getting an error that procedure SP_Getpayments expects paramter
@studentid
What I am trying to do with this is execute the stores procedure that
is just this....