Can Anyone do me this acess project with in 48 hours

DevastatioN said:
We could have made the database for him. Make the database uneditable, and put the name of this website and our names on it. So he can't edit it... he can't pass it in... but at least he could visualize it ;)
Click to expand...

but why take the time? i couldve drawn him a picture in paint, (mind you im not artist) so he could have visualized it. but its more of a do your own damn homework type of thing. i was a TA for an online class and all they had to do was ask for help and it was offered. putting it off doesnt mean they can have someone else do it
 
I agree with you completely that it's wrong to ask anyone to do your homework for you. Was just stating the amusement and adding insult to injury when something you need is right at your fingertips and you can't use it :)
 
Amusement with Access? That's a great concept...I keep hoping one of the gurus will post an example db with a form that contains something like 'space invaders' on it ;)
 
CraigDolphin said:
Amusement with Access? That's a great concept...I keep hoping one of the gurus will post an example db with a form that contains something like 'space invaders' on it ;)
Click to expand...

get on it! id like soemthign to keep me busy! (besides my problems:confused::confused:)!!
 
All rite i get it..i guess i became the joke of the week..hehe..u guys must having a blast laughing at me...well yea i should do my work on my own then get help..

however i managed to do the tables but now i am stuck....only have few hours left..

Any idea why i can't do the relationship to none of the table...
it gives me error

"Invalid field definition 'id' in definition of index or relationship." for all the table

Enforce Referential Integrity is enabled, Cascade Update and Cascade Delete is enabled




http://rapidshare.com/files/76611880/reservation.mdb.html


How do i implant the followings ... i jsut don't get it how to ue it in acess

BUSINESS RULES
• Structural Constraints
• Derived Facts:
• Hotel total = hotel rate/night * # of nights reserved.
• Vehicle total = rental rate/day * # of days rented.
• Reservation total = hotel total + vehicle total + cruise rate +
flight rate
• Operational Constraints
• A person may make a reservation only if he/she is over 18.
• A person may make a car reservation only if he/she is over 21 and
holds a valid driver’s license.
• A person making a flight reservation to certain Island, can only pick up
a car, or book a hotel, etc, to that certain Island
 
Romeo, sorry to say but a reservations db is not a trivial application to develop. And to learn enough to do one from scratch in just a few hours is a HUGE ask (actually, I would say impossible) if you aren't even up to speed on how to make tables and create relationships between the tables.

However, in addressing the problem you have, you should consider the following rules.

1. There are some names that you cannot use as a field heading in your tables. http://support.microsoft.com/kb/286335

2. Never use spaces or special characters in your field names (although underscores "_" are ok)

3. Field names should be meaningful and descriptive. CustomerFirstName is good, CFN is bad, CustFN is bad, etc. CustomerID is ok but ID is bad.

4. When you have key fields that you intend to use to join tables with (ie. make a relationship with) the name of the field should be the same in both tables. Also, the data type of the fields in both tables must be the same e.g., text must be joined to text. (Special case: when a field in the primary key of a table and is set to autonumber, the field in the related table must be long integer).

5. When forming relationship between tables the database needs to be able to determine whether the relationship is one-to-many (USUAL), or one-to-one (VERY rare). The database can only tell this if the field on the 'one' side of the relationship has some kind of no duplicates index (like a primary key).

6. If you ever have a many to many relationship you need three tables. One for each of the entities and a third table that acts as an intermediate between them (Called a junction table). The junction table typically stores the foreign keys (ie the values of the primary key field in the the entity tables).
 
the relationship works fine when
its

Enforce Referential Integrity is enabled, Cascade Delete Enabled

when
Cascade Update is also enabled then i get

"Invalid field definition 'Itemnumberid' in definition of index or relationship." for all the table
 
Last edited:
CraigDolphin said:
I'm guessing you either haven't set a primary key for some of the tables involved or you are trying to join two autonumber datatype fields.
Others have had similar issues before: (eg., http://www.access-programmers.co.uk/forums/showthread.php?t=123122) have you searched google or the forum using the error description and/or number?
Click to expand...

well i guess yes i am joining one primey key to another one isn't?

isn't like chose the CATID to ISLAND ID??? which is both primary key and both autonumber? isn't that what i am suposed to do
 
Just a hint - In the first link to the document that you provided it has the answer to what the relationships are supposed to look like:
rel.png
 
yeah that i know ..the slides pdf contain clear version of relasionship image...

my problem is i am doing something wrong.. because i am unable to apply Cascade Update enable

it give me the following error..


"Invalid field definition 'id' in definition of index or relationship." for all the table

this error comes for my reservation project or... any tables for my testing purpose.. which is mean i am doing something wrong while creating the tables...

please help me out


boblarson said:
Just a hint - In the first link to the document that you provided it has the answer to what the relationships are supposed to look like:
rel.png
Click to expand...
 
If you notice, all of the ID fields in the tables, are linked to the same field in other tables. The DIFFERENCE is that in the table where it is BOLD TYPE it is an Autonumber Primary Key. But in the table it is linked to it is a LONG INTEGER - FOREIGN KEY (Foreign keys are just that, a primary key from another table. You don't set it as a key in the second table).
 
but what i possibly can do wrong... acess is not letting me do the relashionship..... its perfectly fine when its only
Enforce Referential Integrity is enabled, Cascade Delete Enabled
 
I looked at the database you posted and you did not do what the sample showed. You need to do what I said and, looking very carefully at the sample, have the fields like that. You need to create the Primary Key field (shown as BOLD type on the sample) as an AUTONUMBER datatype. Then in the table it links with, the field with the same name as the bold type one, but not bold, it should be LONG INTEGER (nothing else will do) and if you do that, then the relationships will fit together.
 
Here - I used the Hotel and Hotel Details as a sample:


1.png



2.png



3.png
 
i am confuse ...but

isn't when i create a table it input a field called "ID" automatically ..that is the primary key field? then i just renamed it as CustomerID... and so on for the other table...

so then i try to link CustomerID to ReservationID?

what am i missing

any way to fix the data to make the relationship to work.... like i really don't get it..
 
Oh... so each time i conect something i have to create that ID also?
i thought it would add it automatically since i am adding it while doing the relationship....

thanks for the graphics.....

does the order matter of the field... since i am gonna add new field such as "HID" which will be at the end of the table?
 
Last edited:
CraigDolphin said:
Amusement with Access? That's a great concept...I keep hoping one of the gurus will post an example db with a form that contains something like 'space invaders' on it ;)
Click to expand...

You haven't played Access Vaders?????
My goodness, I thought everyone around here was an Access Junkie. ;)
http://www.happy2-island.com/e/access.shtml

Pick up a copy of Block Destroyer while you're there as well.

I am not responsible for your subsequent decrease in work productivity.
:)

Have you seen my Matching Game?
http://www.accessmvp.com/JConrad/accessjunkie/matchinggames.html

I made that for my kids.

--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 
You must log in or register to reply here.

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom