I need to truncate, not round, a Double number to 1 decimal place.
e.g.
Funct(4.67) = 4.6
Funct(4.61) = 4.6

I have a ComboBox search in my form where you type in the Last Name and the
comboBox generates a list based on what the user types.  I'd like the search
to return a list of all the items that contain the text entered, so that the
user can search by last name or by first name, and ...

I am building a from that has a text box, and a button. When the button is
clicked, I am wanting it to take the value from the text box, and insert it
into the URL.
I saw some examples, but I am unable to get it to work.  

I have tried using the other posts dealing with what seems like similar
issues to what I am having but I don't seem to be getting any results.  
Here's what I have.
I have a parent form with a subform within a subform on it.  Thanks to all

I want to put in someones name then the address field auto fills with the
address held in the table.

According to the help files, a Textbox can have a ControlSource of an SQL
statement.
I have created my SQL query and inserted it into the textboxes control source:
=(SELECT Count(MPR) FROM zSYS_tblMPR_Tracker WHERE

Hello & thank you in advance.
Is there a way that you can filter the combo box?  I want combo box value to
be filtered from the provious screen where user enter the value.  if User
enter the value "X" then display only those "X" or if user leave the it blank

I have cmbState and cmbCounty on a form that corresponds to a table.  I
want the Counties shown in the cmbCounty to be limited by the State
chosen in cmbState.  I have tried the code from the Access sample forms
and The Access Web with no success.  I am pulling data from one table

Thank in advance.
I have a main form bound via a query containing equipement to dispatch. On
the form I have an Combobox via a contacts query looking for a contact by
bringing up 4 fields (contact, company, telno & Pcode), user selects correct

Need procedure / function to manually advance customer numbers in Access when
user adds new record. Procedure would have to find highest existing number,
than add 1, then return new number to field in DB. (Customer number field
type is text, though all data consists of numbers, ...

We have an access database which needs some of the coding changed. However
the person who set the database up password protected the code and the have
since left the company.
I urgently need to get into this.

How would I call the following command line from within my Form?
"C:\Program Files\ABC Amber Advantage Converter\abcadv.exe" "C:\demo.adt"
"C:\demo.dbf" 1
Thanks!

How can I programmatically change the size of a field in a table from 50 to
255?
reidarT

I have a form collecting data on patients' operations in my hospital. I want
to be able to error check the date of operation entered for any inaccurate
data entry. If the date entered is in the future a message box alerts the
user to this. When they click OK they are taken to the ...

I have a Tree View (ActiveX control version 6.0 SP6) control on a form.
(Environment: MS Access Project (2002, SP3).
During the Form_Load event the treeview is populated successfully.
What bothers me is that when the form is displayed, the first node in