I try to get the value in a real time. There are two subforms inside a
mainform. First user enters value into mainform. Than comes to
subform1. And after that on the basis of a choice in subform1, the 2nd
subform is open. In 2nd subform i create a listbox with that query.

 i have problem inreport when i use dlookup
  As Example:
Table1
 Id                                 TranDate             FieldA

I maintain a database used by a lot of people.
I want to be able to record who's signing in and what time they log off.
I have set up a table to record this info....but I can not make it work.
Any reference regarding the issue.

Hi: Can any one please tell me how do i convert data from (1,2) to
("1","2","3") before i save it into table. I mean when user enters
value in a textbox like 1,2 i want to change it into above format
before i save it.

I want to put a 'cancel' button in a data entry form so that if a user
enters some data and then cancels it discards the data entered, if I do
a delete record:
   DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

I have a form with the property popup defined as 'yes'.
However, after I did that, my toolbar attached to the form (where I have the
navigation buttons), appears disabled.
Can anyone tell me if it's possible to enable the toolbar keeping the form

I have three forms:
frmCustomers; frmOrders; sfrmOrder Details
frmCustomers is opened and it has several tabs one of which is for orders
where I have the frmOrders with the subform sfrmOrder Details. On the

I have the following in the criteria field in a query of mine to filter
records from a table:
Switch([Forms]![frmMapEx]![Combo11]=">=",>10000,[Forms]![frmMapEx]![Combo11]="<=",>100000,True,>0).
Why doesn't it work?

I am working on a Access application to track nurse educational  
requirements.  I am using a number of combo boxes in the app.  All of a
sudden when I open my form in design mode, the combo box and navigation
buttons tools are greyed out.

Can any one please help me how to i join both tables so that i get
value from FieldC. Table A of val(left(FieldA,5))=Table B
of FieldA
Table A

We have a service request database that we want to use a single form to
enter new requests. We have it set to close out of the database when
the close / submit the request, but I'd LOVE to have it open with JUST
the form and not the remainder of the database windows. Is there any

How do to block my scroll of mouse not to alter the record current of
form?
Thanks,
Michel Ank

My criteria in query is:
where outlet in [tbl_events].[PPV_Outlet]
Outlet type is text and [tbl_events].[PPV_Outlet] type is number is
there any way by which i can match the values.

I need to update a display in a listbox because of other user activity in
form.
How do I look through a controls list to find the proper row to display?
My textbox control that I want to base off of as this is correct, is called

i wan use may web cam but can't i don't knw way