I have a form that has a tab control in it. The first  tab is called Form
View and has many  text boxes so the user can input data. The second tab
called Datasheet view. I am using a subform inside the second tab to get the
datasheet view.  My problem is I want to some of my ...

Has anyone experienced any limits on the number of items in the combo box?  I
want to link the combo box to the part numbers table but want to make sure
it's ok because we have a list of about 2,000 parts.  Did anyone experience
system slowdown before?

I'm writing a record to a table. This record has, as its primary key, an
auto-number field. I then immediately re-read the record I just posted, in
order to fetch that number (I need it for a step further down in the code).
However, the RECORDCOUNT of the recordset is 0. When I ...

I have code which runs on several versions af Access with no problems
but crashes in Access 2003.  What I am doing is setting the RowSource
property of a list box to one of two different queries based on certain
criteria.  This is in the forms OnOpen event.  One of the queries

I have a drop down (lookup field) and when the user selects a record that is
currently locked, on the Before Update property I am displaying an error
message and then I set cancel = false and exit sub.  How do I set the drop
down field to empty again?  When the user tries to go ...

I have a pop up form in datasheet view.  I would like the users to be able to
close the pop up by pressing enter on the keyboard.  Since I can't place any
buttons on the form, I can't use the default property.  Is there another way
to do this?

If you're on the New, Dirty record and decide to drop it for some reason or
another, how do you programatically delete it? It appears as though if you
are on a NewRecord, dirty it, and clone the form's recordset, the new clone
does not contain the currently active record. Is that ...

I have a form with a field that uses the "Default Value" property to invoke
a function to get a default value.  When I open the form, this works fine and
the appropriate value is displayed in the field.  But under certain
conditions I want to force that field to be "refreshed" (i ...

I've foud out that on access 2003 as diffrent from access 2000 i can use
AddItem Method like VB to add new item to listbox or combobox.
It works fine when the the column count is 1 but it doesn't shows anything
when i'm using muli colums. (most of my comboboxes are like this)

In my continuous subform I want to hide a dropdown if the record exists and
allow it only for when the user wants to add a NEW record.  Is this doable,
or should I just make another method for the user to enter a new record?
Problem is, if the dropdown is active for the existing ...

I have a search Form using the following code:
___________________________________
Private Sub SearchClick_Click()
Dim strSql As String

I used the activeX calendar on my form.  I would like to use the same for for
several date records.  I would like for the caladar result to be place in
whichever text box I last exited.  Is this possible?

I know there are many subjects on this, but can't find the answer.
I have several text boxes with number values in it.  The names of these text
boxes have the current year in the name.
Example of all the text boxes on my form:

Is it possible to do not let the user see the Access objects?
I know that it is possible to hide with the menu 'Window, Hide' or by VBA
Code..
but the user can simply press F11 or go to the Menu 'Window, Unhide'

I have a form that has a button called Exit Form. When I click on that form,
it returns to my main form. There, I have a button called, Exit Database. I
am able to close the form with the doCMD, but the database still runs and I
can't close it unless I use task manager.