|
Link one field to many categories
I am trying to set up a database for library books. We would like to be able
to link each book to one or more categories. e.g. one book might relate to
children and to poetry or another book might relate to children and finances.
I cannot figure out how to set up the tables so multiple categories can be
chosen....
|
4 |
4/19/2007 8:23:48 PM |
|
|
Table Relationships
What is the benefit of setting up table relationships in the relationships
window? OR...what is at risk if this is not done?
Is it not essentially the same thing to assign the necessary relationships
within queries, etc?
...
|
3 |
4/19/2007 7:47:17 PM |
|
|
Command Button
How can I make a command button send keystrokes... in other words... make a
command button do the same thing as the F11 key on the keyboard?
Any help would be greatly appreciated.
Thanks,
Mark...
|
3 |
4/19/2007 3:38:00 PM |
|
|
Calendar database advice needed
Hi guys,
I'm tasked with building a database for scheduling dates that all parties on
case (civil or criminal) are available. Parties consist of:
Judges
Attorneys
Public Defenders
Victim advocates
Circuit Attorneys
and meybe few others that I can't remember at this moment.
Here is the situation;
There will be one clerk for civil and one for criminal parties(cases) and
they will enter...
|
1 |
4/19/2007 2:38:05 PM |
|
|
Getting Data X based on variables
I have two tables, one is a list of transactions that have taken place over a
wide group of offices and the other is a list of offices and the locations
them that the transactions refer to.
In the transactions table I have among other data [Office] (6 digit number
where 1st 3 digits are the area and the next 3 digits are the office), [CA]
(text), ), Pr (integer).
In the Offices Table ...
|
1 |
4/19/2007 11:56:01 AM |
|
|
design question before I get started
Hi all, as I continue on my awesome journey of Access I am making efforts to
improve my design.
My question is this. I am adding a new element to my database which is Tugs
and Barges. What my desired outcome is to have a query where somone enters a
BARGE NUMBER and it will return the TUG COMPANY, Phone Number, webiste and
Comments.
Now, I have down this before and it's pretty easy b...
|
9 |
4/19/2007 1:59:39 AM |
|
|
Update Form
I have a form [frmMeasures] where the user inputs a record to a table
[tblUtilization_Measures]. Once they tab out of that form I don't want them
to be able to scroll around in the records, but sometimes they do need to go
back to an established record and edit it.
I have created another form with all the fields [frmUpdate_Measures]. A
query that searches the main table is the recor...
|
4 |
4/18/2007 3:52:05 PM |
|
|
wherecondition - works in one instance, not the next....UGGH!!!
I have a form with a few drop dows and a command button. Each command button
has an on-click event, as below:
Button_A: this works
DoCmd.OpenReport "rpt_Cable_info_01", acViewPreview, _
WhereCondition:="RF_Cable_Ident = '" & Me.Combo0 & "'"
....so I copied the above and edited it for Button_B as:
Button_B:
DoCmd.OpenReport "rpt_Test_results_AC_drop_down", acViewPreview, _
Wh...
|
3 |
4/18/2007 10:38:02 AM |
|
|
Display a calendar of Access database dates
Could anyone help? I'd like to have our Employee database (when it's set up)
to display a given date range (say 1 month) with when any employees are on
leave (for instance to print or show for the month of December, or January,
with the employee name on the row [record] and 'columns' for each work day).
I'm currently using Excel with rows for employees, columns for days of the
week (incl...
|
3 |
4/18/2007 3:40:03 AM |
|
|
student absence database in Access
How do I set up a one teacher use, multiple class, 3 lessons of different
durations per week for 10 weeks database? ...
|
4 |
4/18/2007 3:28:02 AM |
|
|
Deleting a table in access 2007
One I run the make query table I was being asked to click YES, YES, YES. I
was able to eliminate the last 2 YES questions but can not get past the " The
existing table "name" will be deleted before you run the query.
Is there a way to set it so I do not have to answer this question?...
|
6 |
4/18/2007 2:22:00 AM |
|
|
Sample db needed
hi,
i need help in designing a hotel management system, i have
designed 6 tables yet i.e. Customers, Vehicals, Room, Hall, Employees,
Tables...
now im confused about keeping record of extra services, so kindly
can anyone here give me a sample database for hotel management system
so that i can use it for refference/help.
thanking you for your cooperation
WaC
smart.bug@gmail.com
...
|
2 |
4/18/2007 12:46:00 AM |
|
|
Design for Raffle Ticket Database
Hi, I'm am trying to creat a database for a raffle our school has every year.
I made one last year, but I wasn't happy with it, so I'm trying to start
over this year. I need some help, so I'm going to tell you what I need, what
what I think I need to do, and any responses would be very appreciated. I am
a beginner, and don't do this often enough to remember what I did last time.
I wa...
|
2 |
4/17/2007 9:06:50 PM |
|
|
Table design question
I have a question on the best way to design a database I want to
create.
My database will be keeping records of historic League tables for a
certain sport.
For a given team, who may have been in several different leagues in
their personal history (for example Southern League, Elite League etc)
Ultimately, I want to produce reports that show 1 or all of these
Leagues in the way you might...
|
3 |
4/17/2007 9:05:09 PM |
|
|
Small business needs database design help
My company is a small but growing retailer who needs to create a database
that will track the potential retail sites we are evaluating. There are
anumber of fields of data in each record that we want to be able to input and
track as well as a log in reverse chronological order that will track what
has been done and what needs to be done with this site. We use Acess 2007 and
we would like...
|
5 |
4/17/2007 8:54:01 PM |
|
|
Raffle Ticket Database
...
|
1 |
4/17/2007 7:58:01 PM |
|
|
AutoNumber is displayed instead of the name
I have created a look up from another table in a database that I am
redesigning. I made a few changes and then went back to the original table
and found that all of the values I had chosen from the lookup in that field
had converted themselves to showing the primary key, rather than the name
that I need. I also noticed that the data type of the field is now Number
rather than Text. I hav...
|
11 |
4/17/2007 7:24:48 PM |
|
|
Work Schedule database (coming from Excel)
I'm trying to convert an overgrown and overly complex Excel file to Access
but I'm stumped on the best way to set things up. I'm scheduling monthly
work hours for four positions on each of about 200 projects. I'll always be
looking at about 24 months at a time, beginning with the current month.
My excel file looks basically like this
Month1 ...
|
2 |
4/17/2007 6:02:05 PM |
|
|
Designing for Warehouse
In my archive database I have to have the physical location of storage boxes.
These will be identified as Section A, B, C, etc. Row 1, 2, 3, etc and Unit
a, b, c. When I start this database should I have Section, Row and Unit as
separate fields, or should I have one field for example A2b. The ultimate
result is to know what is in each space but also to identify which spaces are
empty ...
|
7 |
4/17/2007 2:52:06 PM |
|
|
Yes/No Data Types
I have defined a Yes/No data type field with a Default Value of nothing
(neither Yes nor No). However, when records are created without indicating
Yes or No for that field and I query the Yes/No field, they act as if they
are a No, when in fact I thought they would be a null. What's the trick
with Yes/No fields?
Peter Marshall
Manager Information Services
Ohio Coatings Company
(740...
|
3 |
4/17/2007 2:16:35 PM |
|
|
Data entry connected to daily date (over multiple months)
Hi. I'm trying to design an access database. I want to have a given lot
name in one table connect to a daily measurement number in another table.
Setup would look like this:
LOT# date1, date2, date3, date4, date5, date6, date7, date8
07DDLL 40 39 37 30 22 20 7 1
Question is, do I need to make a separate date for every single entr...
|
2 |
4/17/2007 3:02:05 AM |
|
|
Database Creation
Anyone created a Krewe database - need to have member plus guest - names,
addresses, etc. very large, more info near time of Ball....
|
4 |
4/16/2007 10:06:15 PM |
|
|
Introductory table building question
I have a fairly basic question about table design. I'm building a
database that has 1 main table which is a list of client names. The
clients can get 3 different services and then they are discharged from
the program. My client table is my main table but I have 3 different
tables for the 3 types of services.
So currently the main client table has client names and general
information and...
|
2 |
4/16/2007 6:20:33 PM |
|
|
Running Balance
How to calculate a running balance in a MS Access Form or report.
Thanks...
|
6 |
4/16/2007 6:16:01 PM |
|
|
Search For Related Files
Hello,
I have an access database for our credit requests that come through. I need
a way to click on a button or something to that effect and be able to search
for an email from my form in Access. Basically I want a box to pop up and ask
for a WO# that will search Outlook (or a file that I can save the emails to)
for that WO#. I hope this makes sense! Thank you for your help in advance....
|
1 |
4/16/2007 6:14:01 PM |