|
|
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 |
221 |
|
|
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 |
115 |
|
|
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 |
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 |
99 |
|
|
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 |
|
|
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 |
111 |
|
|
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 |
144 |
|
|
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 |
|
|
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 |
|
|
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 |
104 |
|
|
|
July 29th, 2004 01:50 AM
by gen
|
0 |
140 |
|
|
Excel Linking Problem by
LGC
Hello all,
I am having trouble linking to an excel worksheet. One column is
predominately numerical but must be linked as text. It is formatted as text
in...
|
|
1 |
135 |
|
|
Number Data Type Field and Leading Zeros by
Carlos
I have a table that has one field set to a number data
type. As part of the values input process, I need to enter
values leading with a zero as the first...
|
|
4 |
540 |
|
|
"Property Value is Too Large"????? by
Zoe
I am creating a new table for 225 fields. I have ~140
entered, but when I try to enter any more fields a
warning pops up and says that the "property value is...
|
|
4 |
583 |
|
|
Table Design by
Rod Bayron
Greetings,
We have an Access database that was originally designed
back in Access 2.0 days. It's since been added to and
convert numerous times; today it's an...
|
|
1 |
247 |
|
|
Validating Email Address by
Bill Johnson
I've seen in some websites where you enter your email
address, it validates that the address you've entered is
in a proper format : or (in...
|
|
2 |
112 |
|
|
Design Roadblock - Input Forms by
Rob
I’ve got a design problem (at least I think it is) that I’m hoping someone can give me some guidance on. Say I’ve got a database I’m using to tracking...
|
July 28th, 2004 03:27 PM
by Rob
|
4 |
154 |
|
|
Creating an order and storing it by
chang
Creating an order and storing it
I want to create an order, so the person picks name from one table,
cutomer
from second table, and
then products from...
|
July 28th, 2004 12:48 AM
by chang
|
3 |
144 |
|
|
|
|
1 |
96 |
|
|
decimal places by
andrew
Hello all!
I'm trying to get my table to show decimal values.
In the table design view, I set "Field Size" to decimal,
and Decimal Places to "4". However,...
|
|
1 |
207 |