I have got the following data in a report which I have created (just to show
you clearly what my main report and data looks like)
In my next report, I would have to show, how many minutes was spent on Slag,
how many on basket, and how many delay and so on.

i have one unboudn checkbox and dtpicker control..
i had put code to disable or enable dtpicker control when checkbox turn on
or off accordingly...
but strange thins is when check box is turn on, dtpicker control moves its

=DLookUp("[PCC]","Location","[TXUsite] = Forms![Transactions]![TXUsite]")
This is returning nothing to my PCC field in my form. Where do I need to
place this funtion and is this correct?

Thanks for taking the time to read my question.
I have a form that has a text box (Name) and a list box (List of all Names).
The rowsource for the Listbox is a query of the tblTest described below.  
The form that these are on is based on tblTest.

Can someone tell me if the IF statement will accept something like this:
IF (testnum = 202, 203, 204, 205, 265, 266, 268) Then
  DO THIS
ELSE

Help me with my combo box filter please,
I have read all of the posts within this group and I cannot figure this one
out.  I know it's a simple fix.
Private Sub cmbfilter_AfterUpdate()

I have an existing app running well on many machines.
One particular machine is giving an error that it cannot find a library.
I am using the advapi32.dll to get the user NT login name when they open my
main form, and that is where the program halts.

I have some code (see following) that will lookup to a table with Form name
and a number assigned to that form to open the 'next' form in a series via a
Command Button:
Private Sub Form_Current()

In a Macro how do you phrase the condition to equal on #Error in a
certain field?
Thanks
DS

i m using unbound checkbox in my form..
i want to check on and off run time...
i tried using
chk_enddate.value = true

I have a subform displayed in continuous forms that I need to refresh from
the parent form.
I can refresh controls on a subform as:
   Me.f_Note_sub.Form![cboNationID].Requery

I have an After Update event that dumps the user completely out of Access.  
The best part is it only happenes intermittently and for some users more than
others.  Also if I break the code and step through it it works fine.

Hi Experts,
Got puzzled with this one and would appreciate any pointers.
A form with an inputbox under OnOpen opens as it should when called from the
custom menubar created but refuses to when the relevant button is clicked on

To All,
 My company wants me to create an invoice form that we can use for billing
for out products. How do I set up a form that I can have more than one
product for one invoice?

To explain further....
I have 1 PO# with 5 items. I only want to save the record after entering all
5 items. Maybe by Using a Button control.
After confirming the PO i wish to clear the field for another PO.