CC22

I am doing AS Level Computing and i am doing something called Terry's Turkeys, you maye of heard of it, well it is in Access, but VBA is useful for it (although i don't know it and my coursework at the moment has no VBA in it)I have done everything i need pretty basicly, but the order form is a bit tatty and compicated at the moment, but it works,

The most troubling thing is when you add a orderline (turkey) when adding an order, you need to fill in all the data at once in the right order (right to left) for it to work, if not then a jet error comes up

any help would be brilliant, cheers, Please PM me as i can give you more details about it via PM in a more private discussion.

EDIT: sorry about this, when i signed up i did not see the project bit at the bottom (is hidden for guests you see) so i posted this in the wrong place, i'm sure a mod/admin can move it for me

Ooble

My advice would be to not use Access - it's a piece of crap (as Andrew, a friend of mine can tell you - he rewrote his entire coursework in PHP and MySQL in less than 10 hours a couple of days ago).

__________________
Me :: You :: Them

Infinite Recursion

is access required?

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

Ooble

It's not - I'm doing the same thing in C#, using a text file to store the data.

__________________
Me :: You :: Them

Rory

I recently got banned from the Student Room for having a big rant about Access which I won't repeat (though I continue under a pseudonym...)
Basically Ooble's right. Use an open source and standards compliant SQL database (none of the wierd Microsoft things). Jet, ODBC, ADO are all outdated and were designed for Windows 98: despite bits being patched on they are still fundamentally crap, so much so that they've almost been dropped in .NET.
Hell, use a binary file rather than access: at least you don't get random errors with negative IDs and irrational limits!

Infinite Recursion

Yeah, I know Access isn't technically needed to do this... I was curious as to if it was part of his Assignment's requirements... you guys know how professors can be.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

CC22

Ye It needs to be in Access, i don't know why, we were going to do it C++ but then he changed his mins (the teacher that is)

Rory

Tell him to go someplace unpleasant, if you object that is!

The actual assignment makes absolutely no mention of the tainted Redmond word - you could run it from a punch card reader with Fortran code, so long as it works.

It's a symptom of the fast rate that technologies, especially programming advance - technologies such as VB and Access are simply out of date and outmoded. Many teachers just don't to have seemed to have been reconciled with the potential of open source for the simple reason that it basically was nonexistent for all intents and purposes when they did their qualifications.

What annoys me though is a few narrow minded instructors and teachers who impose there ingrained ways of using Access, often due to lack of expertise elsewhere purely because the course they attended had a lucrative software licensing deal.

Sadly, and to a large extent, education in the UK is still geared towards Microsoft - allegedly the Edexcel board won't touch anything not done in VB.NET. Thank God for AQA!

Maybe there'll be LCPs on offer soon in this country?
I'd be interested to know what you all think.

princess

hiya im also doin terrys turkeys, well im quite finshed...do u still need ne help?

bl00dninja

it is somewhat unfortunate that microsoft has dominated the computer market with it's notoriously unpredictable software. they have gotten better though. i have no complaints about windows XP.

__________________
i put on my robe and wizard hat...

Have you ever heard of Plato, Aristotle, Socrates?...Morons.