Hey Everyone.
I have a complicated situation.  Lets say that I have 2 rows in my list
box:
[ID].[2006-145]             [Category].[1]

I have an Access combo box (text) field, where folks type in a shoft
date using
an input mask <or> they select a text value from a value list.  The
drop down selection remains in the field.  This is what we want -

I have a combo box where the "Row Source Type" is set to "Table/Query" from
another form in the same database.  Although the source data is sorted and
displayed in A-Z format, the combo box is displaying the data in the order it
was originally entered (that is, the order in which ...

I know I should be posting this to ...activexcontrols but I posted on the
8th
and haven't received a reply (must be busy) so I'll try my luck here if the
community don't mind.

I'm a novice who had to quickly build a large database with forms to
demonstrate some ideas. The database works well, but now I need to neaten it
up.
I put some lookups on the table. I knew it wasn't the thing to do, but it

I am facing a problem with ms access 2000. I have an unbound form name
"Employees"  with a listbox showing 5 columns of information:
EmployeeID, FirstName, Last Name, Date of birth, Country of origin. The
listbox is based on the table "tblEmployees". On that form there is also a

I have a database that I've just took over.  It has timer code to shut down
the database if when on the main form , it is idle for 5 minutes.
The problem that I'm having is that this is a network database, and everytime
the database shuts down this way while other people are in it, ...

I have a form with two combo boxes ([NmF] and [NmL]) and a calculated text
box ([NmFL]) that is a concatenated value of [NmL] & [NmF]. [NmL] is limited
to a query with [NmF] value as criteria.
I have a command box to reset the values in [NmF] and [NmL] if the user

I'm using some custom navigation buttons I created, and have added a Delete
button to the form.
I am currently using code that identifes which record I am on
(currentrecord), then deletes the applicable record, requeries the form (it

I have a main form that has two subforms.  I am trying to change the record
source of Subform2 on the OnCurrent Event of Subform1 .
I get a run-time error 2455 - You entered an expression that has an invalid
reference to the property Form/Report.

i've spent my own time creating a database front end (forms, reports, mail
merges, coding & custom functions, etc) for use by staff for my benefit
only - it's wrapped up 80% of my paperwork
i quite happy to leave back end (data tables) wide open for the company to

I have an SQL UPDATE statement that runs so the user can update certain
information in the table. The problem is, when I click on the update button
Access throws up a warning message saying that you are about to change x
amount of rows and once it's done it can't be undone, do ...

I get an Expected end expression error with the following code at point of
"mmdd". What is missing here?
 qdf.SQL = _
       "SELECT Table1.Yearof, Table1.Dateof, " & _

I have a listbox and want to update a field in my table, here is the code
that I am using:
Dim varvalue As Variant
Dim strList946 As String

I have two questions about writing more efficient code:
1. Whenever I have combo boxes on a form, I almost always add
Me.<FieldName>.Dropdown to the On Enter event for each. This can get tedious
if I have many combo boxes. Is there a more efficient way to handle this?