|
Primary Key w/Two Means of Data Input
Here is a brief description of what I'm doing before asking the question.
I'm building a CRM type solution for tracking customer information -
contacts, quotes, etc. We have existing customer information that I can
download from our old, still in use, DOS system into an excel file that I can
import/link into our Access 2003 CRM Database. These customers have a unique
customer number...
|
3 |
12/14/2008 7:36:27 PM |
|
|
dcount syntax help
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","[Vendor]='Walmart'") and that works
my problem is with multiple conditions
I need ...
|
7 |
12/14/2008 7:26:07 PM |
|
|
someone to design my database
how can i find someone that i can give my required info to and have them
design my database for me?
--
Dragonfly...
|
13 |
12/14/2008 1:22:57 AM |
|
|
update number field automatically?
I have an existing table that has a number field as the primary key. I want
it to replicate the autonumber feature by adding the next number in sequence
when a new record is added, but I can't change it to an autonumber field and
keep the existing data. Can it be done? Thanks! Pat...
|
6 |
12/13/2008 12:10:05 PM |
|
|
Visibility 2
Maybe I'm not expessing myself adequately. My form has many "Tabs". I want
to only have one "Visible" based on the information contained in a
"Department" field on the main section of the form. Several different
departments, each with a related tab for data.
Example, Engineering in department field, only engineering tab shows.......
|
8 |
12/12/2008 11:14:00 PM |
|
|
relationship
Hello everyone this is my first post here.
I always run across post from people asking questions but they don’t have
enough detail in them, I will try my best to put as much detail and explain
my self to minimize confusion . Excuse me if I over explain my situation to
the point of been annoying.
Reason for been here:
I am trying to help my parents build a database. they own a smal...
|
6 |
12/12/2008 10:36:01 PM |
|
|
Visibility
Working in Access 2007. I have a form that contains several tabbed subforms.
I would like to only show one tab based on the data in a field on the main
part of the form...
Any thoughts. Not the sharpest pencil esp in 2007 but can follow directions
fairly well...
Regards
Tom...
|
3 |
12/12/2008 9:22:16 PM |
|
|
DTB Design Question
Hello all, I've been struggling trying to design this particular database but
have been unsuccessful. I want to build a databse of medical groups data.
Every medical groups has the same list of contacts (MD, Admin, Case Manager,
etc.) but the contact information for each of these title are usually
different. I want to build a database so whenever a person enter in a new
medical group, a ...
|
2 |
12/12/2008 8:35:24 PM |
|
|
Linking between tables
I want to create a link / relationship that associates a People Table record
with a Company Table record. I.e., if a record in the People Table says that
Joe Smith works for Company ABC, I want that record to be linked to the
Company ABC record in the Company Table (and vice versa).
Ultimately, I want to be able to see the Company Table details of the
corresponding employer when I clic...
|
4 |
12/12/2008 4:25:01 PM |
|
|
OLE Object Makes Database to Large
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 pulling the maps in as a ole object. The problem is the
database is too large wi...
|
12 |
12/12/2008 2:06:16 PM |
|
|
HELP! DB Design to later query multiple keywords
I am an Access novice, using v 2007.
I need to design a database to store our company's project information in
for later reference for marketing, etc. Each project needs to have multiple
associated keywords from several different categories. The goal is to be able
to run a query specifying certain keywords, and a list of associated projects
will return.
Some of the categories are Sec...
|
6 |
12/12/2008 9:11:35 AM |
|
|
Access Crashes When Deleting From Subforms Or From Related Tables in Table View
I have witnessed this problem in my own database and in Northwind with
Access 2000 and Access 2003. I have a main form with three nested
subforms. The following sequence either dumps me unceremoniously from
the database or it displays the an error, "Microsoft Access has
encountered a problem and needs to close." :
1. Click the plus sign on the first subform to open the second
subform...
|
1 |
12/11/2008 9:41:17 PM |
|
|
need help with a database
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 commission rate in dollars ( 8% for euros and 10%
for dollars).After that the dolla...
|
6 |
12/11/2008 8:15:01 PM |
|
|
How to manage images (jpg or png small photos)?
Hi all.
Access 2003. I'm designing a DB for personnel management procedures. I need
to store a little photo of each individual. In your opinion is better to
store directly the image file as BLOB or only its path and manage the view of
the photo programatically?
Photos will don't change frquently.
Thank you in advance for advices, tricks and solutions.
Nicola M. ...
|
3 |
12/11/2008 4:48:02 PM |
|
|
Trying to find the best way to structure this . . .
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 are unique based on SKU#.
I want to be able to relate a one to many relationship...
|
3 |
12/11/2008 4:38:43 PM |
|
|
History Table and Data
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 to the history table. I can then have monthly record of what each date
field con...
|
2 |
12/11/2008 4:19:00 PM |
|
|
How do I allow a leading zero in an Access number field?
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....
|
5 |
12/10/2008 6:49:25 PM |
|
|
DCOUNT SYNTAX HELP
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","[Vendor]='Walmart'") and that works
my problem is with multiple conditions
I need ...
|
2 |
12/10/2008 12:22:46 PM |
|
|
Dcount syntax help
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","[Vendor]='Walmart'") and that works
my problem is with multiple conditions
I need ...
|
2 |
12/10/2008 12:22:35 PM |
|
|
Updating table
I need guidance on my database design:
I have a table that lists out several tasks in field 1, and includes about 7
other fields of information on the task.
Some of these tasks are "Critical". If a task is critical, I need about 10
more fields with data on the task.
Am I better off storing this info in 2 tables, or one? It is possible for a
task that is currently not critical, t...
|
4 |
12/10/2008 3:36:57 AM |
|
|
linking tables
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 member can be wife, sister, mother etc.) I'm having
trouble finding an easy way to en...
|
2 |
12/9/2008 11:02:01 PM |
|
|
multiple tables into one table
We currently track carrier effectiveness with an Excel worksheet. I’m
attempting to somewhat automate the process with Access. There are three
tables that I would need to be able to ‘pull’ data from to populate a fourth
table tracking carrier effectiveness. Each record in each of the three
existing tables has four columns of data would need to be imported. They
are: Carrier, Da...
|
6 |
12/9/2008 7:34:03 PM |
|
|
Field Size
Hi! As I am entering data, a message pops up "The field is too small to
accept the amount of data you attempted to add. Try inserting or pasting
less data". The text I'm tyring to select is American Indian/Alaska Native,
Non-Hispanic or Latino. In the table that was designed; the field size is
set to 65. I don't understand why am I not able to select this, when I can
see it in the f...
|
10 |
12/9/2008 6:23:07 PM |
|
|
Second Sales Tax Field
I would like to use the "Service Call Management Database" template but it
only has a single sales tax field. I need one with two sales tax fields
(local and Federal) or at least some help in making the changes to the
template to add the additional field. I am using Office Access 2003. Please
help
...
|
5 |
12/9/2008 10:50:42 AM |
|
|
be/fe or secure first?
Do I split and then secure or secure and then split?
thanks!...
|
2 |
12/9/2008 8:41:38 AM |