|
|
Numeric field is rounding up by
Brook
I have a numeri field that is set for two decimal places.
However, when I enter a number 6.80, it rounds up to 7.00.
Does anyone have any ideas /...
|
|
2 |
103 |
|
|
entries are automatically duplicating by
Bud G
I have set up a database with a members table and a
payments table. I need to be able to apply payments to
an individual member... all goes well until members...
|
July 29th, 2004 02:48 AM
by Bud G
|
3 |
131 |
|
|
Database Design Advice by
Diana
Hi,
I am creating a database for server parts. My company has
8 servers onsite at one of our largest customers for the
sole purpose of using the parts in...
|
July 29th, 2004 06:01 AM
by tina
|
3 |
135 |
|
|
automatically date a field by
Rebecca
I have a field in table .
I need it to automatically enter the date anytime any of the fields in the
Memberfile table is changed. But I don't need or want it...
|
|
4 |
143 |
|
|
Time always set to 12:00:00 AM by
gavin
In Access create a date/time field with format dd/mm/yyy hh:mm:ss ampm
In VB.net update field with Now() function.
Date appears correctly but time is always...
|
|
1 |
110 |
|
|
Tracking Inventory by
Diana
Hi,
I am creating an inventory database that tracks server
parts. (Specifically I have 8 servers, the parts within
each server vary.) I want the quantity of...
|
|
1 |
115 |
|
|
Default Value Question by
Bill
I am trying to figure out how to set the default value of
a field called email. I want the default value to be
pulled from the inputed data in a field called...
|
|
1 |
98 |
|
|
Appending 2 tables by
Dennis H
I start with tables x and y. Link DIST and OBS1
I get query1 with a select query.
I want to get Query WANTED.
I've tried NOT linking.
TABLE...
|
July 29th, 2004 07:31 PM
by
|
1 |
114 |
|
|
Leading zeros by
Lynne
I am developing a database with 135 fields, many of which must output right-justified with leading zeros with the sum of the characters entered and the zeros...
|
|
2 |
114 |
|
|
Security-enabled database by
See
I am a student trying to convert a secured 97 access database to access 2003. I am having a few problems. First, I was sent a copy of the shared database and...
|
|
3 |
219 |
|
|
Indeterminate relationship by
Dennis Snelgrove
What would cause a relationship to be "Indeterminate" in Access XP? I've got
two tables, and I'm trying to set up a simple One-to-Many relationship. I've
done...
|
|
6 |
206 |
|
|
2 Column Combo Box by
Chris
I am trying to create a 2 column combo box using the lookup wizard. But I want whatever field I choose in a column to be saved in the record. If I choose a...
|
|
1 |
136 |
|
|
to link or not to link? by
Carlee
Hi There,
I use lookup tables to allow users a quick pick list. For example, tblLookupColor, tblLookupTestType etc. Typically i create these tables and use...
|
|
4 |
126 |
|
|
Is it possible.... by
Dan Myers
Hello,
I need to know, is it possible to do a find or a search in
multiple fields in a table. I've got 4 fields of serial
numbers in my table and I am having...
|
July 30th, 2004 12:05 AM
by RK
|
2 |
192 |
|
|
negative autonumber by
I have an ID field set to autonumber.
The table has a primary key combined of three other fields, ID is not one of
them
The table is being populated via a form...
|
|
2 |
570 |
|
|
tables with msys* by
John Stevenson
I have recently started using Access 2003 and notice that
when I make a new database it automatically will add
tables that begin with msys (as example...
|
|
2 |
155 |
|
|
Validation rule by
Ashley
I would like a field in my table to have 5 characters. If
the entry have less than 5, a Zero adds to the front of
data.
If enter 345D. It should correct to...
|
|
5 |
107 |
|
|
Excel field truncated on import...help? by
Steve Newton
Hi.
I am using Access 2000 to import data from an Excel spreadsheet with
the Get External Data command.
A couple of the columns in the Excel spreadsheet...
|
|
1 |
152 |
|
|
Need a design suggestion by
BobV
Hopefully this is the right newsgroup to ask this (and I apologize up
front--this is probably going to get kind of long).....it crosses so many
lines it's hard...
|
July 30th, 2004 06:37 PM
by rpw
|
5 |
445 |
|
|
|
|
0 |
132 |