|
How to find Size of tables in Database
In an Access 2000 database how can you find the size of each table in
the database without having to export every table to a new file?
...
|
3 |
4/24/2007 5:46:19 PM |
|
|
How to find Size of tables in Database
In an Access 2000 database how can you find the size of each table in
the database without having to export every table to a new file?
...
|
2 |
4/24/2007 5:13:31 PM |
|
|
Secondary Key
I am in the begining stages of designing a DB which would track the expenses
of 40 customers . Each customer has a unique five digit ID and the expenses
would go against their location cost center number which is a unique six
digit number. The customers are billed monthly and each invoice can only have
one expense account billed for the services provided(One to One
Relationship). In the ...
|
5 |
4/24/2007 5:06:39 PM |
|
|
Ranking of Topics in Access
Hi
I have a database design with three tables:
1. Student Table
2. Student/Topic table
3. Topic Table
The purpose of these tables is to allow students to pick their preferred
topics for a student project.
I need to make sure that each student only picks ten topics ranked 1 through
10 and each topic the student picks must be unique with a unique preference
(i.e they cannot ...
|
2 |
4/24/2007 3:40:36 PM |
|
|
Multi user in Access 2000
I have a database Access 2000 file format, and stored in a shared folder so
several users can access it at the same time. Most of the time it works fine,
but sometimes it shows a message that prevents them to work with it. It says
that the database is locked by another user and it can't be open. The users
that are already in can work without problem, but it doesn't allow new users
to com...
|
3 |
4/24/2007 12:32:01 PM |
|
|
Relationship and forms
I have a new database that has tblRentalAgreement, tblCorpBusiness and
tblMajesticExpressRenters. All have primary keys that are autonumbers.
TblCorpBusiness and tblMajesticExpressCustomer have one-to-many relationships
with the tblRentalAgreement.
When I am setting up my frmRentalAgreement that is based on
qryRentalAgreement (which incorporated all three tables)... I can't add a new
...
|
4 |
4/23/2007 11:59:21 PM |
|
|
Split Database Difficulties
This question must have been asked before, but I cannot see anything of
relevence in the present posts so forgive me if I am duplicating an earlier
query.
If a table in a back-end database is renamed then it is no longer visible to
the front-end. Presumably, the same will also be true if a new table is
added to the back-end. Is there a way of relinking the databases after such
chang...
|
5 |
4/23/2007 6:34:16 PM |
|
|
AutoNumber Using Duplicate ID
I have a back end database that contains a number of tables linked to one by
an ID field. The ID field ("MainID") is the primary key in tblMain. The
field properties are as follows:
Data Type: AutoNumber
Field Size: Long Integer
New Values: Increment
Indexed: Yes (No Duplicates)
When a user added a new record through a form in the front end, it would not
allow the add. When I wen...
|
4 |
4/23/2007 3:11:32 PM |
|
|
Set Focus to specific combo box
I am trying to set focus to a list box. The listbox is accepting bar code
font data. I am trying to only allow parts in the list box when the operator
scans them. If they scan an incorrect number not found in the list box I
would like an error message stating they scanned an incorrect part number and
rescan. How do I complete this task? thanks...
|
1 |
4/23/2007 2:18:01 PM |
|
|
Error "Unrecognized Database Format"
Dear All,
Newbie Access .mdb
I am trying to create a database (Table1) with Access 2003 Professional on
my XP PC.
The Table1 includes 80 fields and one row. I need to read and write 'Texts"
to the Table1. I have set the maximim length of the record cells to 250
characters. There are 2 problems:
1) I can open Table1 directly with MS Access, but when I try to access the
Table1 through ...
|
3 |
4/23/2007 6:50:00 AM |
|
|
Date last used
Hello:
I have a simple Access 2000 database with 2 tables; tblSites and
tblLandspreading. I need to look up the date a site was last used from the
landspreading table and place that value in a field in the tblSites table.
Any help would be greatly appreciated.
--
Brian...
|
8 |
4/23/2007 1:51:35 AM |
|
|
Database Design
Hi all,
I need some advice with a database I’m trying to design. Its main purpose is
to asset track PC’s and other related items within several different project
areas i.e. the item e.g. a monitor may move from one project into another
(the monitor itself has its own unique reference number). The project is
“owned†by an individual which subsequently each item has a current owner
...
|
5 |
4/22/2007 11:12:01 PM |
|
|
Cost vs quote design question
Hi,
I seem to be having some problems designing these days, mental block or
something.
I have the following scenario for a small painting/building business;
Each Job can have many Quotes.
Quotes are based on prices from a number of suppliers and each quote can
include many products.
I have got the following table relationships:
1 Job => Many Quote
1 Quote => Many For 1 <= Produ...
|
5 |
4/22/2007 6:44:04 PM |
|
|
Company and multiple addresses DB design
At the moment I have simple Access DB with 3 tables Companies,
Contacts and Activities.
In the Company table we have stored the address fields
Address
Street
Suburb
City
Code
Company ---> Contacts ---> Activities (1 ---> many relationships)
This works fine for 97% of contacts on the database.
A problem happens when a contact has a different address from the one
in the Co...
|
2 |
4/22/2007 2:18:51 PM |
|
|
create an application to copy tables
Hello , I am trying to build an application where I have a weekly spreadsheet
of data that is averaged and sorted prior to me getting it. the data in the
spreadsheet is 42 thousand rows each week and a dozen or so fields , the key
is the field Element as this is what all the data is relevent to . I have to
due comparisons each week and create averages and reconcile which elements
have b...
|
2 |
4/22/2007 8:57:58 AM |
|
|
Weird relationship window problem
This is odd.
I clicked "Show All Relationships" and one table showed up off-screen above
the upper edge of the window.
I know it's there because the relationship line still goes up there, but I
can't modify it, because I can't actually see the table, and if I add the
table again, it shows up as "tbl_notes 1", and then "Show All..." shows
relationships to both "tbl_notes" and "tbl_n...
|
10 |
4/21/2007 2:08:47 PM |
|
|
importing external tables by code
hi,
i need to import external dbf tables into an access database in CODE. i can
do it easily by hand by going to File/Get External Data/Import.
but i need to automate it. how can i do it in vba or as an access
application within visual basic.
my access database is Names.mdb. the external table is Names.dbf, both are
in d:\Names.
i'm not familiar with the access object model, an...
|
2 |
4/21/2007 2:54:10 AM |
|
|
can not send email with 2 attachments
When I try to send a email with 2 or more attachments (pictures) I receive
message The TCP/IT CONNECTION WAS UNEXPECTEDLY TERMENATED BY SERVER
-- ANY HELP
larry...
|
3 |
4/20/2007 10:09:07 PM |
|
|
One to One relationship
I am developing a database to monitor the expense's of five differnt company
locations which have a ubique 3 digit identifier number. The invoices
genereated from each location have a unique invoice number so that will be
the one to many relationship. The invoices can only have one expense account
per invoice but i am unsure if this should be a one to one relationshsip or
one to many. T...
|
4 |
4/20/2007 8:04:23 PM |
|
|
Null as Default Value
I have been using Access for some number of years but I just noticed that
when I create a new text field and set the Default Value to Null (with no
quotes) and the enter a new record the field has the characters Null
entered. When I do the same with a number field the value Null is entered.
When I set the text field Default Value to =Null then the value Null is
entered as expected for new rec...
|
5 |
4/20/2007 8:02:53 PM |
|
|
negative Autonumbers
From some websites i've looked at I understand that negative Autonumbers may
be a problem. I'm doomed to support about 30 remote databases, so I set
Autonumber to Random to avoid confilicts when combining the remote datasets
into a single database.
My questions are
What are the problems, how serious are they, and how likely are they to occur?
Given the situation I sketched above, are...
|
6 |
4/20/2007 6:38:02 PM |
|
|
Question on Automation
I am designing an Expense DB and in my Accounts table i have 20 unique
account numbers. There is also a decription for each account number in which
i would like to associate with the respective account number since in my
Forms design i would have a list box selection in which a user can pick a
description and the account would fill in the field. Is this done with a
Macro?...
|
4 |
4/20/2007 6:28:00 PM |
|
|
Do I need code for this?
Dear Collegue:
I need to be able to do the following:
What I have: I have a table with 1658 records. Basically it is a list of
every instructor of the college that has taught in a period of 7 years. Each
year has 3 semesters.
For each semester that the instructor worked, the table records a $ amount
(Rate of pay)
Now, not all instructors taught every semester over those 7 years, so
b...
|
3 |
4/20/2007 2:38:01 PM |
|
|
Multi Line text fields
From Access '97 through to 2002, it was possible to enter a multi line entry
into a table field. This I could do with a Control - Enter (NewLine Char).
With 2003 this does not appear to be possible any more. This flows through
to form fields.
This was very handy to store addresses where the number of address lines was
variable.
It is now not possible for me to maintain any address data...
|
4 |
4/20/2007 2:40:45 AM |
|
|
Email and Distribution Lists to send Reports thru email
Hi
I have an App where a user can design a email message and add Attachments
and send to a list of email addresses they manually enter
into a grid- no problem all is working
I have to add functionality of Distribution list
so I need to maintain
1)list of emails
2)Groups that contain multiple emails addressses
I have a table design there I have 1 table which contains distribution lis...
|
2 |
4/20/2007 2:11:34 AM |