I have a combox box referencing a Select Query (see blow), which is part of a
Quiz form, where the user picks an Address in the combo which he thinks
matches the correct address in a hidden field box on the form, the problem is
that my Combo lists the possible address answers in ...

Is there a way to make the switchboard show items depending on the access  
level of the person logged in?

I have this on a command button on the PadNumber form
I want this to happen on the Employees Form but I can't get the syntax.
Dim Ctl as Controls
For Each Ctl In Forms!Employees!Controls

I have 'timing' problems with a database converted from Access97 to 2003.
Features which have worked happily (in 97) now give variable performance,
sometimes with errors. I have tracked the problem to [probably] using
SendKeys. I have read several posts which warn about the use ...

I'm getting this error on my form when the user changes a record and before
moving to another control, clicks on a combobox used to filter the records.
Error number  -2147352567 Cancel Update without AddNew or Edit
Can someone tell me what I can do to fix this?

I'm trying to create a Form in Access that, when the identifying number of a
specific data set is chosen, will autopopulate with the rest of the
previously entered data.  When I select the form that I've built from the
Database menu it works perfectly; when I select it from the ...

does anyone know how - using a tabular form - i can display sub totals at the
bottom of a screen - eg after 20 records. then have the user press a button
to display the next 20. the records are not grouped and the user does not
want a main and subform.

I know how to send emails directly from a form but is it possible to send
meeting requests from outlook directly from a form?
Russ

Hello and thanks in advance for your nice precious help.
I have a Form with just one subForm with a classic one to many relationship,
I am trying to filter the data of the whole Form from two text boxes.  I
have seen ways of filtering via combobox but that is not what I want.  I

Is there any way by which i insert 0 before the value by query or any
other way. I have a table contains 10,000 records and because of some
reason i need to move 0 before number of field Tech_ID. Type of field
is Text.

I added a command button to a form to open a report.  
The form has:
modal=yes, pop-up=yes, and maximized when opened.
I added this line to the command button's open procedure:

I've worked with access before, but it was a long time ago and I've
forgotten most of whatever I knew.  I'm trying to build a form to help a
friend updtate our retireee database.  We have about 3600 lines of data in
the database and each month he has to add new members and make ...

Sorry, if you find my request kinda stupid, but I'm really stuck, I'm
reading books and help, but I can't find an answer. What I'm trying to do is
to bring 3 tables into one form and to be able to edit them. On of the tables
is a lookup table. Something like this:

I want to create a button in a form that when I click it, the field
«actual_date» assumes the actual date and time.
How should I do it?
Thanks in advance.

I USED TO WORK WITH DLOOKUP WITH ONE CONDITION TO SHOW SOME DATA BUT I DO NOT
HAVE PROBLEM FOR THIS BUT I WANT TO SHOW SOME DATA WITH USING DLOOKUP WITH
THRE CONDITIONS FOR EXAMPLE:
Dim Show As Boolean