Tree viewing records or data
Sat, 4 Oct 2008 05:15:00 -0700
Dear all,
I wanna show an organizational structure which is kept in some tables that
have a 1 to many relation, in a form like a tree view .how is it possible?
I appreciate any help. ...
|
Proper using of Combobox
Sat, 4 Oct 2008 04:11:00 -0700
I have frmClientDetails based on tblClientDetails, where the field
cboClientName in the form is a ComboBox, based on the fldClientName in the
table. E.g. I want to be able to either look or update the details by picking
the already existing ClientName, or to add a new ClientName and all his
details.
In orde ...
|
Referencing from a combo box
Sat, 4 Oct 2008 01:39:03 -0700
I have a form (frmmain) and a subform (subform1). On the subform is a combo
box (cmbname) based on table tblindividual. This shows two fields txtsurname
and txtfirstname (in that order). I have another control on the subform
txtmemnbr. I want this to be a lookup where its value is the same as a field
in tbli ...
|
Limiting text data type to numeric input
Fri, 3 Oct 2008 19:40:01 -0700
Can a text box control with a text data type source be limited so as to only
allow the user to input numeric characters (no alpha or special characters)?
I have need to allow the user to input up to a 14 digit number which is
larger than a long integer data type can handle, so I'm using a text data
type.
...
|
Print one at a time
Fri, 3 Oct 2008 17:06:08 -0700
In my db I have a form that assigns task to employees, I made a report with
the same info in it and it works OK but when I print the report I get 2 and
sometimes 3 employees to a page depending on their days task. How do I get
the report to print each employee on it's own page. I'm using 2003 ...
|
Combo box Blank
Fri, 3 Oct 2008 15:37:52 -0700
Hi and TIA! I have a combobox on a form that is populated by concatinating
to fields. When I open the query that I am using for the the recordsource,
all the records are there. When I click the combo, none of the values show
up in the combo, however if I select a blank area in the combo, the
afterupdate w ...
|
Modifying the default find tool
Fri, 3 Oct 2008 14:49:01 -0700
I am looking for a suggestion to modify the default find tool for my form.
In order to search a specific field, you must give that field the focus on
the form to run the search. I would like to add code to the default tool so
that you can pick which field you want to search using the LookIn combo box.
I w ...
|
|
|
Tracking Classes and Totaling Sizes
Fri, 3 Oct 2008 14:32:01 -0700
Iâ??m struggling with what would be the best method to accomplish the following:
I have an application that can have up to 8 different types of land classes
for each record (types 1-8). If a record has a specific class, it will also
have a field for the size of that particular class in square feet
For ex ...
|
creating subform from table
Fri, 3 Oct 2008 14:28:01 -0700
I somehow lost my original subform entered into my main form one day and have
been trying to figure out how to get it back. I have three years worth of
information in two tables that I need to put in this subform. What I need in
this subform is a vendor's booth space location, date paid, amt, ck or cash,
a ...
|
Finding most recent date worked without code.
Fri, 3 Oct 2008 14:01:00 -0700
Does anyone know if there is some type of expression that I can type into one
of the controls in my form (â??Volunteer Database Formâ?) that will return the
â??most recentâ? date from the â??Date Workedâ? column in a â??Volunteer Hours
Tracking Tableâ?? I donâ??t know enough about Access 2003 to understan ...
|
