Please help me. with a Access project.

[VenomXt]

mods could you please del this thread.

thx

 

[VenomXt]

blank blank

 

[stephen81]

I've had a quick look and I've come up with a couple of things. I get a "Data Type Mismatch in Criteria Expression" when I open your form. I think it's to do with the subform as the main form opens but the subform doesn't.
Also, you have a different table for each type of product i.e. drinks, sides desserts etc. All these tables contain the same information though i.e. product description, product price etc. Is there a reason these need to be in separate tables? I think if I was doing this project I would put all the products in a products table. You can add a field to the table to hold which type of product it is. That way, in the event of a new type of product coming along (perhaps not so relevant for a restaurant menu but could be for a different situation) you can simply add the new products to an existing table, but with a different value in the product type field, as opposed to having to create a whole new table to hold your new products and all the associated work involved in that.

 

[neileg]

I would have put all the menu items in one table with a field to identify which category they belong to.
You don't need a quantity column in all your tables.
You have attempted to write a query, but you haven't defined a join between the tables, so it won't work.
Your transaction table needs to hold a transaction for each item chosen. You need a way of tying these transactions together into a sale, so I suggest you need a sales table and a transaction table. The primary key of the sales table will be held in the transaction table to identify which transactions relate to the sale.
The combo boxes in your form should be bound to the transaction table so that as you choose the items they are stored in the table.

That do for a start?

 

[VenomXt]

blank blank

 

[VenomXt]

anyone else want to take a look at this?

Another friend tried to do it this way but i think this way is flawed.

FTp access to anyone that acually helps me with this stuff. all i can offer as a reward other than thanks.

 

[stephen81]

The primary key of the sales table will be held in the transaction table to identify which transactions relate to the sale.

But im having issues with determing the Primary key (i may not have it in the table yet) in the transaction table. And the relationships.

Your primary key needs only be something like an autonumber field or any field in your table that will be unique for each record. You then relate records in another table to the first one with a foreign key. If you use an autonumber field as your primary key in the first table then you just need a number field as the foreign key in your second table.

 

[VenomXt]

Ok iv went alot of diffrent ways with this and i think this will work im just stuck.

when i go to the form its giving me a error i dont understand. Can anyone please take a look at this and see what im doing wrong.

Once again this is a Access 2003 .mdb in a zip file.

Read above to see what the project is..

If you feel like it make any changes you want and save them. Just add a cooment in the thread about what you changed.

 

[VenomXt]

Anyone have any ideas? time is running out.

I updated the .mdb file with a few corrections.

 

[seth_belgium]

I fixed your form, it works now.

 

[VenomXt]

thank you so so so much. What was wrong with it?

 

[seth_belgium]

Triggered events on your combo's resulted in errors and your calculations were faulty too.

I'll take a look at your tables too.

 

[VenomXt]

thank you so much if you have any questions im checking this regualry.

 

[seth_belgium]

This should do the trick... Messed around with the form some more

Also changed your table where you wanted to store your products. It isn't the most ideal approach to this ordering thing. What if a customer wanted to order two kinds of drinks? But that's the prof's problem, he's the one that gave the assignment!

Anyway, take a look at it and try to understand the things I've done. If you can't explain to him what the code means, he'll know someone else has done it...

Good luck!

Seth

 

[VenomXt]

thank you very very much

 

[seth_belgium]

No problem

 

[VenomXt]

mods can you please del this thread id apreciate it.

thnakyou everyone.,

 

[Vassago]

mods can you please del this thread id apreciate it.

thnakyou everyone.,

We don't give help to people, especially students, for you to come in here and delete the thread so other people can't benefit from the same answers.