|
Guest/Room Allocation Database
Hi all,
I am an Access novice and need to create a database which will help me
assign rooms, with host families, to international exchange students. I also
need to be able to check availability of rooms etc. at any given date.
At the moment I have a table with Family ID, Name, Address, Number of Rooms
(typically 1,2 or 3 rooms per family).
When a student arrives I need to be able to...
|
3 |
6/10/2007 10:49:00 AM |
|
|
Tracking multiple man #'s with one work order #
I designed a database to track quality control inspections for a vehicle
maintenance shop and I have a problem. Several mechanics may put time on one
work order. How can I track several man numbers to one work order number?
Here is how I have it set up:
shopcodetbl:
[shop code] <-- primary key
[shop name]
Employee Man No tbl:
[man no] <-- primary key
[last name]
[first name]...
|
7 |
6/10/2007 12:45:41 AM |
|
|
Access-friendly spreadsheet data
I have an excel spreadsheet that I need to be able to translate into
something Access can use. The problem I have is that there are both row and
column headings (like a pivot table) and the spreadsheet field is a non
calculated answer. The data is static and used in other calculations. Please
tell me there is an answer besides if/then statements for every possible
outcome!...
|
4 |
6/9/2007 3:37:49 PM |
|
|
Questionnaire data onto table
I wish to create a questionnaire and have Access automatically record the
responses on a table. I want staff to be able to use the same questionnaire
(i.e. it is refreshed for the next user) not to have to create new forms
for new users.
can anyone help with this - much appreciated...
|
4 |
6/9/2007 12:06:00 PM |
|
|
Switchboard creation
I have 12 sections in my office and Im trying to setup a switchboard
with a page for each of the sections but im finding myself limited to
8.
How can I change this so i can use as many as neccesary?
Please email me christopher.belczyk@mcguire.af.mil
...
|
4 |
6/8/2007 7:12:40 PM |
|
|
Table Problem
I have a database with two tables. (Access 2003)
In table1, there is a lookup field that uses table2 (table2 contains
employee names).
For some reason, Access is assigning the data type of that field to NUMBER.
When I try
to do a query on that field based on a persons name (Smith, John), I get a
data type mismatch.
But Access won't allow me to set the data type..it does it on it's own.
...
|
5 |
6/8/2007 5:44:26 PM |
|
|
How do I expand the length of an OLE object in a form for viewing
I have an OLE object embedded in an Access Table. That table is linked to an
Access form. The OLE object consists of about 3 pages of text in a Word
Document, however when the Form is displayed, only the first page is
displayed. When the OLE object is printed, the entire text is printed, it is
only when you view the object on screen that only the first page is
displayed. I am using this ...
|
1 |
6/8/2007 1:52:00 PM |
|
|
Custom error messages
Is there a way of overriding certain Access error messages with my own? I
know you can do it at the form level, but is there a way of just
saying..."anytime this error ever comes up, bring up my custom error
message." The reason is b/c I have a lot of forms and buttons and everytime I
want to alter one of my custom error messages or add a new one, I have to go
into all of my forms and al...
|
3 |
6/8/2007 1:20:00 PM |
|
|
ACCESS TEMPLATE FOR ISSUES
We downloaded th etemplate for issues and have added several fields to the
form. They are also fields in the dtatabase. When entering data via the
form, it does not fill in the added fields in the database table. Help
please? ...
|
2 |
6/8/2007 11:16:00 AM |
|
|
Multiple values into one cell with each on a new line
I am trying to concatenate [Street 1], [Street 2], City, State, and Zip
fields into one field called Address in a separate table. Is it possible to
create a query that would use INSERT INTO and add the next field as a new
line below the previous one? I tried using VB but all I got was the little
white and not a new line. I used vbKeyReturn. Please any help would be
greatly appreciated. T...
|
4 |
6/8/2007 7:52:22 AM |
|
|
Awesome
Check it out: www.BrandonsMansion.com
...
|
1 |
6/8/2007 2:09:18 AM |
|
|
Q: Exel vs. Access, email notification's, calculations
I am setting up a database and have a few questions. I am setting up a road
database for the Village that I work in to track the maitenance of the roads,
as well that the time lines for reconstruction.
1. First off I am not sure if I should be using Access or Excel for a
database like this. Currently we have information stored in a single Excel
worksheet fine, but it is hard to naviga...
|
3 |
6/7/2007 11:10:24 PM |
|
|
Replica Database in Briefcase
I have an Access database which is on the main office server and updated by
my office staff. I have recently dragged a copy of this file into the
"Briefcase" on my Laptop so that I can have a "more or Less" up to date
version with me when I am out of the office. When I did this I got a message
saying that it would need to create a "Replica".
I do not try to merge the databases, I merely t...
|
2 |
6/7/2007 3:16:03 PM |
|
|
Making a value span multiple rows
I am trying to concatenate [Street 1], [Street 2], City, State, and Zip
fields into one field called Address in a separate table. Is it possible to
create a query that would use INSERT INTO and add the next field as a new
line below the previous one? I tried using VB but all I got was the little
white and not a new line. I used vbKeyReturn. Please any help would be
greatly appreciated. T...
|
2 |
6/7/2007 3:14:24 PM |
|
|
SQL Server 2005
I am planning on rewriting an Access database using an Access front/back ends
into one that uses an Access front-end and SQL Server 2005 back end. When I
designed the db originally, the database was stored on the G:\ drive and the
front end was on each computer. On my development computer, my G:\ drive
pointed to a different location, so I was always using a duplicate set of
data for d...
|
2 |
6/7/2007 1:19:15 PM |
|
|
Users only Work with Their Data
In MS Access 2003 What are some methods of restricting users to only
see their data in a shared database? Or if in SQL Server 2000 (or
2005) is this functionality available?
What I am doing now: I have a login form that has a dropdown for the
users. In the code behind the form is a case statement with hard-
coded passwords. If the password fails, it tells the user that the
authenticat...
|
3 |
6/7/2007 1:06:55 PM |
|
|
Temporary Loan Register
i don't have a lot of knowledge about access, but what i'm trying to do is
create a database that holds the information on all tools and equipment in my
workshop, and a means for other people to loan these items from the front
screen. the front screen would have a section for them to enter their name,
and the unique tool id number, then when you press tab, or search, the
corrisponding to...
|
1 |
6/7/2007 11:58:01 AM |
|
|
Access Database Issues
I downloaded an access database from Microsoft and added some fields.
I've also added the tables but when going back to the form the additional
fields do not show up. Please help...
|
3 |
6/7/2007 12:20:03 AM |
|
|
Doing my head in
Hi,
Am self-taught through tutorials about Microsoft Access. Just today got my
head about multi-table relationships and subforms.
In an example on the tutorial, in a Form, you could select a value from a
drop down box and the other boxes would automatically fill with the details
related to that value.
ie: Select: Chicken from drop down box and $2.00 appears in the 'Price' field.
...
|
2 |
6/6/2007 11:55:50 AM |
|
|
To .Close or not to .Close
Is it a requirement or just good form to clos a recordset before setting the
instance to nothing (or both)?
E.g. if I "set rs=db.openrecordset(sSQL)", do I need to "rs.close" it when
I'm done with it before I "set rs=nothing", or does the latter pretty much
take care of the former?
Obviously I'm not doing any updates in this example, just accessing some data....
|
6 |
6/6/2007 11:14:14 AM |
|
|
Database for Project Stages
A Project has 3 stages:
1. Prospect
2. Estimate
3. Detail
I am building a database where the user opens a project, and sees a tab
control with 3 tabs, one for each stage.
I have a tblProjects, tblProspects, tblEstimates, and tblDetails. These
tables are linked by ProjectID.
Should I build a subform for each stage, and place them on the tab control?
The Child/Parent link ...
|
2 |
6/6/2007 9:10:13 AM |
|
|
Too many fields?
In my databse I was try to add a field, and it said that I have too many
fields. But when I went and deleted one that I never use, it still says I
have too many. Even if I go to one and change the name and properties of an
existing field, it wont let me save.
Can anyone help with this?...
|
8 |
6/5/2007 9:39:59 PM |
|
|
Dependant's Table
I have a dependant's table with the fields for spouse, children, and
additional (if you care for your parent's or other).
Should these three categories have their own table?
When I view the data in the table, one record may have multiple rows, for
example, one spouse, five children, and 1 other dependant will have 6 rows of
data, but there is mostly empty fields as only one of the six ...
|
16 |
6/5/2007 11:00:01 AM |
|
|
Autofill using form to populate data
I'm trying to develop a database to log inventory that is has unique serial
number but incremented in numbers of 25.
I what a form that allows the user to input the starting number, the number
of items and have access populate that data based on the users entry.
For example: starting number = 100
number of items= 5
autofill table with 100, 125...
|
7 |
6/5/2007 4:37:32 AM |
|
|
Autofilling a field with equal data if a previous field is >9999
I use a subform to enter transaction information. If the field,
[GrossAmount], is greater than 9999, I would like a subsequent field on the
same subform, [CashIn], to autofill the same amount as the [GrossAmount]
field so the user doesn't have to enter the data twice in the event the
figure is over 9999. Any help would be greatly appreciated.
--
DMainland...
|
2 |
6/5/2007 3:37:58 AM |