Two Databases Sites
Wed, 10 Dec 2008 16:04:06 -0800
I've have designed a database which I have Connected to Autocad, which I use
for Document control.
However I have two other sites using the DB, however from time to time I
need to copy sections of tables between my local DB & the External DB's,
which is causing problems.
The problem is that the Autocad ...
|
Trying to find the best way to structure this . . .
Wed, 10 Dec 2008 11:55:02 -0800
I'm creating a database that tracks customer information, brand information
and item information. Customers have brands and brands have items. Most of
the information is item specific. There is a unique customer identifier (call
it a customer number for the sake of argument). Brands are also unique and
items ...
|
History Table and Data
Wed, 10 Dec 2008 11:52:08 -0800
I have created one table holding a variety of date fields including original
and current date fields. But what I also need is a monthly history of those
dates either on the first of the month, end of the month or perhaps even a
command button letting the user copy the table information as of that date
over ...
|
OLE Object Makes Database to Large
Wed, 10 Dec 2008 11:37:01 -0800
Fire District has database for running cards -- directions from each
firehouse to each street in the district. My databse is split - front end
and back end. We want to add maps of each street. We have scanned the maps
and I created a table for the maps and linked it to the table with the
directions. I'm ...
|
How do I allow a leading zero in an Access number field?
Wed, 10 Dec 2008 07:27:01 -0800
I have a 5 digit number that may or may not have a leading zero. This is the
key field in the database. I need it to allow and display a leading zero. ...
|
dcount syntax help
Wed, 10 Dec 2008 04:05:01 -0800
I have a databse with a table called Expenses. In that table I have a field
calles Vendors which is a text field and a field called Cost which is a
currency field.
I need to count the number of times that for example something was purchaed
from Walmart so I used the syntax
=dcount("[Vendor]","Expenses","[Ve ...
|
Dcount syntax help
Wed, 10 Dec 2008 04:04:01 -0800
I have a databse with a table called Expenses. In that table I have a field
calles Vendors which is a text field and a field called Cost which is a
currency field.
I need to count the number of times that for example something was purchaed
from Walmart so I used the syntax
=dcount("[Vendor]","Expenses","[Ve ...
|
|
|
DCOUNT SYNTAX HELP
Wed, 10 Dec 2008 04:04:01 -0800
I have a databse with a table called Expenses. In that table I have a field
calles Vendors which is a text field and a field called Cost which is a
currency field.
I need to count the number of times that for example something was purchaed
from Walmart so I used the syntax
=dcount("[Vendor]","Expenses","[Ve ...
|
need help with a database
Tue, 9 Dec 2008 22:43:51 +0200
Hello, I'm trying to create a database to keep track of my
customers'transactions and don't know which table to choose. Here is the
business process. A person sends money to another either in Euro or Dollars.
If it's in euro, i use an exchange rate to convert it in dollars and for
each currency there is a co ...
|
linking tables
Tue, 09 Dec 2008 18:34:57 GMT
I have a table (tblMembers) with member info and an other table (tblFamily)
to link the member to a family. Each member has a MemberID and a multiple
members have the same FamilyID. I've created an additional table
(tblRelation) to store the the type of relation for/to each member to the
other (ie. a single mem ...
|
