urgent help needed. reward if necessary

[AJ IT Student]

urgent help needed.

Hello all!!

I have a project in for Tuesday - simple as that!
I need some help with a few bits and pieces..

I need to get the actual database finished by tomorrow.. (well today when i'm writing this!)

Its shaping up quite well, but I'm not at all experienced in Access, and trying to juggle a full time job aswell!

REWARD offered if necessary for some serious help!!!! But it will probably be a piece of cake job for someone on this boarD!

PLEASE ADD ME TO MSN. I should be online all day.

ALEXANDEROCONNELL@hotmail.com

Many thanks.

AJ

 

[raskew]

Why not post the problem so we may take a look.

 

[AJ IT Student]

Thx for the reply.

Its not one specific thing, so I can't really ask for help on a particular point!

I need someone to guide me through/implement a few things over MSN.

Urgent help needed and reward is negociable. Just desperately need help, fast!

ADD me. Thanks.

AJ

 

[Rich]

Have you asked Jeeves?

 

[AJ IT Student]

Nooo..

Jeeves is a loser.

 

[ColinEssex]

How long have you had to finish this project?

Why not zip a copy here and tell us what you want help with.

Col

 

[AJ IT Student]

Thx guys.

Ok.. well i've actually only had 3 weeks!

I just missed getting into Manchester Uni last year, as I didn't actually hand in my second year ICT coursework. Completely stupid - i got 100% in the first year...

So this got my grade down to a C!!!!

Should boost it to an A this year.

I'm working full time on my gap year for IBM, so haven't got much time to do it - especially as the college messed up my re-entry, so i've only ended up with 3 weeks to do the coursework, which is worth about 50%. I've even been away for a week on business during the 3 weeks - so i'm in a bit of trouble.

I'm just doing some more now.. I'll post it this afternoon with notes of what i need doing. Its all ok really, i think :S, just i can't get a whole load of bits to quite fit together..

ie. a combo box select a specific record and display it in the subform - will get the right data in the combo box, but can't get it to change the record in the sub form.

Thx for your interest.

aj

 

[AJ IT Student]

ok..
i'm not gonna upload it for a variety of reasons.

£100 offered for a nights work (cheque/do it over ebay/paypal..)! please get in contacT!

i'm online
alexanderoconnell@hotmail.com

thx!!!
aj

 

[neileg]

I think you misunderstand the nature of this forum. There's plenty of people here who will help for free. They're just not going to get involved in priavate consultancy.

 

[AJ IT Student]

I know. i'm sure you're right.
Just getting desperate.

Sorry!

 

[raskew]

Dearest Neurosing Student,

If this is so urgent, you're spinning your wheels. It should be somewhat clear by now that offering the big bribe probably isn't going to cut it in this forum (although, I suppose that everyone has their price--do I hear £2000).

If you want assistance, post your database, preferably in Access 97, so we can all take a look.

Bob

 

[AJ IT Student]

yes I don't think I've done myself any favours..
but whats done is done, eh?

ok.. well here is my database.
Don't laugh

I've converted to 97 format.

Ok, now if anyone takes a look, it may be self explanatory what I can't figure out.. but anyway!

There are several forms. I have managed to get the 'Review Managers' form to work..

However, the main thing i can't do which really holds me back on this database, is that I can't seem to get a drop down list (say with a primary key in it) to select a different value, and then update the rest of the fields in the form accordingly..

For example - on the 'EditManagers' form, the select box at the top should be used to select a manager by name, and below you can then edit all the details of this person. I can't get this to work..

I'm sure you'll also notice MANY bits and bobs that aren't working!!!!

Another problem is with the switchboard. The first 3 or so options work, but the others don't.. despite looking fine in the Switchboard manager.

I really hope someone can understand what I mean!
All help graciously appreciated.

Many thanks

aj

 

[AJ IT Student]

anyone?!!!

thx

 

[Vassago]

You can see the database has been downloaded. Give people some time okay? It's only been an hour or two. You shouldn't push the people that are helping you.

 

[AJ IT Student]

Ok.

Thx Vassago.

I don't mean to badger, but its my own fault that alot rests on this.

aj

 

[chewy]

Instead of using the switchboard. Try using just a "regular" Form" your not really doing anything special with it other than opening up a form and thats it.

 

[AJ IT Student]

yeah you might be right.

just would look good in the project.. thats all

 

[Autoeng]

What chewy is suggesting is that you make your own switchboard. Create a form and use the toolbar wizard to place buttons on it, use the buttons to open the appropriate form. The wizard will walk you through it.

 

[AJ IT Student]

loads of the wizards don't work on my access

i can't find the disk to put them on...

I really need some help just linking the forms together..

i mean with say a combo box (with the primary key ManagerID) in the form header, and when a value is selected it updates all the fields below (all the manager details).

something like this would make alot more work!!!

thanks
aj

 

[chewy]

Why do you make the combo box on the main form and the listing on a sub form? Why not just make them both on the same form? Anyway...I think you will have to make a recordset clone to display the record that correspons to the record selected. But I cant help you on that though