Search results

sure, i understand. I am about to head off to buy some books...I hope I find the good ones, even if I have to spend hundreds!

Right..sorry. no more questions..

Hi again, I'm still checking out that stuff....great :) but i'm still at uni. I want to know, how did that relationship with the customernumber from the customerdetails appear in the order form with customernumber in it? I need to create a set of relationships and hoping for some help -...

I am doing so right now :) THANK-YOU :) Last quick question, U made a form for the producpurchased, i think u made it in design view from scratch? Do u think i should do the same for the customer details section in the order form? if so, how did u go about doing the productpurchased? (did u...

TY very much SIR!! ARE THE GREATEST! I couldn't sleep over this! I agree, I have to do all the things myself but the reason I didn't do it was because 1) I have not much knowledge of MS Access 2) The uni didn't teach us this at all, we only got as far as subforms and queries and that's it...

hehe, i ain't like all the other students :) it's for uni...and they haven't really taught much on this subject :( it's not due in until March 7th (or further than that) so there is time but need to get it done and out the way! :) OK, this is WHAT I actually want: in the orders form, a...

sorry for all these msgs, i do apologise. i was looking at the northwind db, is there a way to get the datasheet view and the drop down lists like the one in the orders section? that would be great...

I mean, I could delete it and simply make a subform or something, or tell it to use the appropriate tables/fields as the control source but we wouldn't be able to get the info put in there from the combo box, if we select a customer/product number why so hard?

ty i'm going to fail this course :cry: urgh right, what should I do? I mean, look at my table, all muddled up :( What I WANT, in my order form is that, a customer number and a product number is chosen from the drop down box and all appropriate info is shown - great (thanks bj) but, IF i...

thank-you :) can someone please attach the northwind database, it's not on my PC for some reason and cannot b bothered to put in the CD cause it's late here and i am sooo tired at this database!

tyvm :) it's complicated for a beginner like me! :(

Hi, i hope this is the right place to post this I am wanting to know, I am making an order type database and it has stock control, if we have a table with product information, containing the stock, and we have an order form, how can I make it so that, once the order has been placed, after...

Hi there. I am new to relationships. and again, I need help, and hope that you can help :) I have a database with different forms/tables etc... take a look, keep downloading regularly as I update it: ftp://temp:temp@techftpserver.co.uk/mdffc.zip Right, There, I think, must be a relationship...

ur a genius :) It works, many many thanks :) I have the other problem - lol, sorry. it's when, if you create a record, then add a new one, whatever the last records customer details/product orders were, it is still kept and moved on to the next record! and if u change it, and go back to the...

thank-you, I DO Appreciate ALL OF THIS SIIRRR!!!! :) thank-you.... I hope i can get this to work..

I hope that link works.... :)

it's too big for it, even after zipping! after zip, it's 154KB..i will upload on my server: ftp://temp:temp@techftpserver.co.uk/mdffc.zip

i need ur email addy

The Other problem I am facing is that, if we enter a new record, whatever the customer number was chosen last, will be in all the records :( is there a way to stop this happening? I give up! :mad: The problems are this: 1) For the rest of the text boxes, it does not show the details of the...

lol...here i come again! It won't work for any other field :( I mean, if we select a Customer number, only the Customer name will appear on the text box, but on the rest of them, the appropriate information does not show, just blank it only works for the name (=CustNum.column(1))...