Filtering a query
Wed, 29 Oct 2008 03:46:01 -0700
I have a query of drilling data with fields BoreholeID, From, To and
Rocktype. Bear in mind each borehole can have any amount of records and the
same rocktype can appear more than once. Lets say 50% of the holes have their
first Rocktype as SAND and these have STONE as their second entry. The other
50% the f ...
|
Listbox-multiple selections
Wed, 29 Oct 2008 03:31:00 -0700
Hi all,
I am creating a table at the moment with the field name "what is the weather
like today?" I am creating a list box with the options: Warm, cold, wet, dry,
windy, icy, snowing..... How can I allow the user to select more than one
option, or restrict them to selecting only one option? Am not even sure ...
|
relational data base design
Tue, 28 Oct 2008 13:21:02 -0700
i HAVE CREATED 4 TABLES WITH NUMBERS UNIQUE IN THE FIRST COLUMN
NOW SOMEHOW THE TABLES ARE NOT RELATIONAL SO THAT QUERY FOR A REPORT DOES
NOT SEARCH ALL THE TABLES.
I CAN SEARCH EACH TABLE SEPARATELY FOR ALL CLIENTS WITH WHOM WE HAVE DONE
SPECIFIC WORK AS CODED ON A SPECIFIC FIELD ENTITLED "MATTER", BUT IT ...
|
Simple Memo Field Question
Tue, 28 Oct 2008 12:26:01 -0700
We have an associatewho uses an Access 2003 database, several tables. One of
the tables have five text fields and a memo field. The memo field has right
alignment of text and she would like to have it left aligned, and I can not
seem to be able to figure out how to do that.
Please help
Paul ...
|
How do I write a calculated field to apply only to certain records
Tue, 28 Oct 2008 09:04:34 -0700
I am trying to create a simple calculated field in a query it is: Freight:
[Price]*0.04.
But I only want it to apply to all records without "RS1000" in an [Item#]
field. For those, I want the amount to be $0. And I want it Formatted for
Currency.
What is the syntax for this?
--
Tyler at Creme
New Acces ...
|
Query selection
Tue, 28 Oct 2008 07:25:34 -0700
I have a table similar to the customer servie database teplate available for
download from MS site. There is a status field that has the lookup set to
Combo Box / Value List and then the row source has a list of values.
Is it possible to force that list of values in a query? Or do I need to
depend on the ...
|
what to do when combobox is too full
Tue, 28 Oct 2008 05:51:21 -0700 (PDT)
what can i use instead of a combobox when it can't contain all of the
rows required by the user/client. my client needs a way to enter a
count for inventory items when they are found in an undocumented
location. so they need to ensure the item numbers are real and the
want to pull the description along as well ...
|
|
|
Expiry Date for Data Base
Mon, 27 Oct 2008 21:24:00 -0700
I have a Data Base that I wish to distribute and set a Date for expiry.
Any help would be appreciated.
Thanks ...
|
Highlight a record
Mon, 27 Oct 2008 20:50:01 -0700
Is it possible to highlight non-contiguous records in VB? If so, how is it
done?
After examining a recordset with code, I want to highlight those records
that I want to bring to the users attention. The whole record doesn't
necessarily have to be highlighted/selected but I just want some way of
visually ...
|
How to save to a specific record?
Mon, 27 Oct 2008 21:22:40 -0500
tblSavedSettings
field1 SettingID (Autonumber)
field2 ControlName (text)
field3 Setting (Numeric Long Int)
cboSection, let's say, has a value of 10
tblSavedSettings field 2 has a value of "cboSection" in one record (could be
any record)
1) How do I read the "10" in the combo box and put it into the row ...
|
