I have an unbound combo box that populates correctly but I have another field
[ID_No] that is populated after the combo selection but it does not work for
any values beginning with 9.  The field [ID_No] is a  text field.
Private Sub cboIDNo_Click()

I have a query which works and use the SQL for my VBA coding using
currentdb.execute strSQL, dbFailOnError, but I got too few parameters,
expect 4.
There is no parameter in required in the query.

If anyone can help, I would really appreciate it.
I have a main form with a handful of subforms that all share the same SQL
statement as a recordsource.  I also developed a system to synchronize these
subforms so that any time a record is selected or sort order changes, etc,

Good Morning,
    I am trying to set up a form that will allow me to enter hours worked
for a list of active employees. I have 2 tables tblEmployees and tblHours.
tblEmployees includes Employee Name, Start Date, Term Date(if any), tblHours

How can I make a combo box show some values on a form. They do not have to
be stored anywhere, they are just for show. They will be from a cost list
table that has descriptions. I want it to show the descriptions in the empty
text boxes when I select a name of the cost from the ...

Hi i want to make a command button which scrolls through several pictures in
a folder. The Folder address will be made up of several fields in the form.
txtCoreAddress - will contain "C:\Documents\Pictures\"
txtSubFolder - will contain the next folder name "00001-00001"

Hi, there!
I have a subform in datasheet view. Its record source is a "many"
table that's in a "one" relationship. I need to assure that [Use] in a
given recordset can never contain more than one "CS", "UN" or "PT".

I have a query that needs to pull data from 3 tables (1 table holds
the vendor (technician's) name and skill set, 1 table holds all the
vendor contact data, and 1 table that holds a list of zip codes that
the vendor covers.  All tables are linked by the vendorID.  Since

I have five string values - strFrame3, strFrame13, strFrame26,
strTitle and StrTotal
I'm trying to create a strTotal that reflects the preceding four
string values depending on what is clicked in the frames, etc.   I

I need some help. I need to match order details to our inventory and
determine what order can be filled based on our current stock.
Example:
OrderDetail

I have variables A1, A2, A3, A4, A5
I want to use them in the following way
For i = 1 to 5    "A" & i = Valor    Next
In other words, to use all the variables with the next for

I have an Access database for processing credit cards.  There is a choice of
using .com(.dll) or Control (.ocx).  Is here an upside or a downside in
using one or another?  Is one more stable?  Is one more vanilla than the
other?  Also to take it a step further will Winhttp ...

I'm making a database where I would like some design ideas. I'm making
a item component database where I have an item # i.e. 123456 and it
breaks down into component pieces i.e.
flour 40%

I am trying to use case to check for several conditions with an on_exit
event.  2 of the 3 work, the problem won is the Case IsNull.  When the code
is called, it just passes it right by even though DRNo is null.  Can anyone
tell me what I'm missing to get the isnull to work?

I have a textbox with a control source of:
=DLookUp("MileDate","tblProjectMilestones","ProjectID=forms!frm_Projects.ProjectID AND MilestoneID= " & 5)
This returns the correct information, however, I have a double click open a
new form to update this since I can't edit it directly ...