This has been puzzling me. I frequently use the same code over and over again
on various combo boxes stored within my database on their notinlist event.
Heres what I use
Private Sub cmbType_NotInList(NewData As String, Response As Integer)

I have been struggling with this code and trying to learn from other threads.
I am trying to check three fields on a form for duplicates...specifically
LastName, FirstName and DOB (date of birth) and if there are any records
already in the table that match ALL three, then a ...

I have a main form that displays detail on a client.  I have a subform
(unlinked) that displays the entire client list.  Using Access 2000
I want to set the main form to display the client detail filtered based upon
selecting a record in the subform.  I am trying to filter based ...

Hello, I posted a question on 7/30.  Several of my combo boxes that were
populated suddenly were not showing the data.  The answer I got was that it
was a "ac2003 SP3 bug" and that if I would remove any entry in the format
property of the table for that field, it would start ...

Really perplexing problem at the moment. A colleage interstate has developed
a database and corresponding data access page which works fine for them.
We've been sent it locally and I've been asked to set it up here. The problem
is, it only works if I open the HTA file from a ...

I need to set a control source of an unbound textbox on an unbound form.
I'm first setting  the recordsource and then i want to set the unbound
textbox from that recorsource.
I tried this but it neither one  works.

I have 2 forms: Frm_FireytechCustomers and DataEntry_Fireytech
The Fireytech Customers form holds all the customer data (phone,
address, name, etc.) There is an auto generate unique customer ID
number for each customer as the primary ID.

I have this code for one of my text boxes:
If Not IsNull(Me.txtfirstname) Then
       strWhere = strWhere & "([First Name] Like ""*" & Me.txtfirstname &
"*"") AND "

Hello Experts,
I am having an issue with a form that is bound to a table.  There is a list
box at the bottom of the form that users can select a record they would like
to work with, and the bound text boxes automatically show the values for that

I'm storing telephone numbers as text.
I want to display that telephone number on an unbound form in an unbound
textbox.
So in the format of the textbox I put (000) 000-0000

I know I am going to be asked why this is happening, but I have not been able
to find an answer on the discussion board.
I have a data entry form with several drop down combo boxes. The combo box
has a list of towns and their associated town/county codes from a lookup

I've been dealing with this problem for over a month and still have not
resolved.  I thought my database was corrupted and went thru Allen Browne's
sequence of steps to repair.  But I created a new database with the same
situation and it also crashes.  The goal is to print a pdf ...

I have an Access2000 form with a listbox and use the AfterUpdate event to
pass values to a TextBox using the .column property.
Me.txtIDInvoicing = Me.MyListBox.Column(20)
In Access2000 it works great, in Access2007 (compatibilty mode) the listbox

I would like to use the control tool tip for providing definitions to the
users.  I type in the information and it stays as a 1 liner.  My main
question is can the tool tip be more then 1 line?  If so what sets its that
way?

Hi, I have all of my queries listed in a drop down box. Is it possible
that when I select a query from the list to have the description (in
the Properties menu) show up automatically on the form?
Example- when I select Houses from the drop down menu, a designated