I posted a message recently but no response.
I have two combo boxes which are cascading. The first chooses a customer
name and the second lists the valid first lines of address for that customer.
In this 2nd combo I also have the rest of the address of the contact info

I would like to automatically change the first letter to upper case and keep
the rest intact of each word on a control of a form.  Is there any functions
to do this job?
Thanks,

How to pass fromMSG to txtMSG of frmConfirm? Below is my code:
Private Sub cmdDayOneWinter_Click()
   Dim fromMSG As String
   fromMSG = "Add Winter to Day One"  'The msg I want to pass to control of

I have a situation where management wants a report that lists notes for
customers - but they only want the MOST RECENT note for each customer to
show...
Customers and Notes are in a one-many relationship linked by field

have developed a serious ACCESS Aplication for restaurant managament.
(accounting + touch screen POS). Now I need to develop a remote ordering
restaurant system using some kind of PDA devices ( IPAQ for exemple). My idea
was to make Wireless LAN between PDA devices and my server ...

In opening an Access2000 .mdb - - that I brought over to my own desktop using
my flash drive -  I am receiving the error message:
An error occured while loading Form_FrmXYZ.  Do you want to continue loading
the Project?

I've created a database with tables, forms and macros that will connect to
computers in our network and pull the add/remove programs list so we can get
a list of installed software on our PCs.
Everything works fine, except if I want to cancel the scan while it's in

I'm trying to Open a report based on a range.
The following works for one GROUP:
Left(rstemp!GROUP, 9) = "99999-pbd"
But I need to set it to a range like: BETWEEN "99995-002" and "99995-099"

Hi again Svetlana (and anyone else who can help!),
I've put my form with the edit button as a subform in my database. When I
click the edit button and enter my password a run-time error message (2465)
appears saying that Access can't find the field 'Combo20' referred to in my

I want to use the Call method to run a Sub Statement on form when it opens.  
The problem is if I use the Load form or Open form method then the Sub
Statement starts running before the form is even opened.  I want the form to
open and maximize first.  Then I would like the Sub ...

I have two forms, Form A and Form B.  When I click on a control on Form A, I
have code to open Form B (Form B takes up only a portion of the screen, while
Form A has been maximized).  When I click on Form A while Form B is open, I
would like for Form B to close.  I have tried DoCmd ...

This is very odd. I can open this form yesterday but today I got this error.
I didn't change anyt coding regarding the openform statement. The only thing
I changed is adding more code about DAO recordset processing. Any suggestion?
--

I have a db that holds many SQL statements in a memo feild. These SQL
statements can have STARTDATE and ENDDATE parameters, however they are
currently stored as plain SQL with the dates written in.
How should I save the code with the STARTDATE and ENDDATE parameters so I

I created a form with at subform using the wizard.  It worked fine -
including the ability to add new records to the subform.
I could not display a "Total" text box on the footer using the datasheet
view of the subform.  When I changed it to a continuous or single form - I

I have a problem with recordset/SQL statement.  The following is the code.
Private Sub Command1_Click()
Dim SqlQuery As String
Dim RcdSet As Recordset