Search results

Thank you!!! Please see attached. The first thing i need to do is generate an order by pressing the button "Generate Order" from the criteria entered into the "Orders" tab. I want this to be displayed in frmNewOrders.

Help desperately needed Hi all Are there any developers in the Manchester area that would be willing to help me this week with my final year project for my degree. I am really struglling and Ive tried everything that has been suggested and got nowhere. If you could meet up with me and help me...

Hi, thanks for you help! Im sooooo stuck with this :( Please see attached RD. Im not sure how to go about doing this at all, Im not even sure if I have the right structure. I need to be able to select a group of books from the given criteria, then store this information in past orders (or...

Thanks, and yes you're right, I do want to suggest book titles from limited information. The client places a loan order for 10 French/ fiction/ junior books - it is then up to the system to select a list of books that the client has not had before. The clients being schools who loan for their...

Book database query hello I am building a book rental database. A typical order is: 10 French/ junior/ fiction books and 4 German/ adult/ non-fiction books. When the order is entered I want to be able generate a list that consists of 14 appropriate book titles with all the details. How can...

Thank you for your comments. Although this is my Uni projetc it is also for a real live company that loans foreign books to schools with a set rental period of 4 months, which can be extended for 4 mths at a time. The borrower is the establishment (should change this to contact name). I have a...

Hi all This is a database for my final year at Uni. Ive been trying to build this database and am not getting very far as I know very little about Access. I have put the tables together and created the relationships. My thoughts are that before I go any further i ought to check with you guys...

The main form has no data attached to it. I have set up a tab control on the main form so that each set of data can be displayed on each page.

To create an ID rather than try to auto-generate one. I have now managed to do this.

Sorry, thought Id attached a file (huh) I have 2 tables: tblBooks and tblLanguage tblBooks: BookID - autonumber BookCode - (this is the field i want to fill) LanguageID - (look-up field from tblLanguage which returns the full language) tblLanguage: LanguageID - autonumber LanguageCode -...

How do i auto fill a field with the first three letters of another field in the same table?

Thank you, I have tried this but am getting nowhere fast. Please could you explain exactly how to do this?

Yes I have the form setup. Please see attached file.

Ok, sounds quite straight forward, however i cant get my language id to generate from the input, any clues?

Hi and thanks, I have listed the table structures below. At the moment the relationships for the orderline table are connected to other tables; language, type, and readership .... is this the right way to do this? Table: Borrowers BorrowerID BorrowerName Company Table: Orders OrderID...

Hi I need to create an order form with info from several tables. The first table being the customer info, the second table is orders and the third table is orderlines. I want to be able to select the customer then enter an order with several orderlines from combo/list box but am getting error...

auto id Thank you ... and yes, I am completely baffled with your reply. I have a table called Books and a table called Language, are you saying create a field in the book table called language then create a form for the books?

unique id Thank you!! The second sample: FRE00001 FRE00002 ENG00001 ENG00002 ENG00003

Hi all I need help!!! This is only my second database, but its a big one!!!! Im building a book loan database and need some help ... Problem 1 I have a table for languages and would like the id to be auto-generated from the first three letters of the language, ie FRE for French. Problem 2...

Hi all Hope someone can help this extrememly novice with a massive project .... all help very much appreciated!!! Have had a look around and not found the answer. Problem 1 .... I want to generate a unique ID for a table named language, from the first 3 letters of an entered record, ie...