Search results

I've already solved this by adding a command button that looks like a check box to assign a DateReturned to each copy when it is returned. Works perfectly!

I don't really know how to address this new question, so pardon me for adding to this thread. As you can see in my rentals database posted earlier, DateReturned is part of tblCopyRental (not tblRental) as copies of the same rental can be returned at different dates. Since that would happen...

I'm the original author totally aware of the fact NewRec did nothing and was just a lousy try that ought to be deleted after giving no result. Thanks a lot Sergeant. I'm kind a newbie to Access, could you explain in a sentence or two why this code works and previous did not?

gromit What can I say? I admire you! I'm reluctant to post any further questions if/when they pop up as I don't want to put you into more trouble. You're the MAN! Many thanks!

I think I read lhooker's previous thread which was deleted I believe he has two tables like: Table1 Column1 Column2 Column3 A 2.1 (blank) A 2.2 (blank) etc. Table2 Column1 Column2 Column3 A (blank) 3.1 A (blank) 3.2 etc. He...

Wayne As for the DoCmd.GoToRecord , , acNewRec line you suggested removing, it actually did nothing in the first place. I added it in my "trial and error" approach to get it work but forgot to remove it afterwards. As a beginner I don't get your idea. Why a listbox on the main form, and why...

gromit take a look at part of my database - try frmRental and see for yourself it won't go to a new record when you double click CopyID and pick/add a copy. It goes if you manually enter a copyID tho. I did change the subform to continuous view but double click worked just as well in datasheet...

Okay this is mystery to me. I was so off track I was making a whole new database importing tables, queries and forms directly involved with the Rental form, renaming everything neccessary to English and trying to make it work so you could take a look at it. While searching using frmSearch in...

gromit I've been trying to get it work but as a novice it simply seems too much for me. I'm using the frmSearch pretty much the way it is in the example found in the link I posted in my previous message (just a few names changed) The whole code of that search looks like this...

gromit - it works perfectly. Thanks! I combined results using union query and now I have a list of all available movies in a query. I also started a simple Rental form, which uses a RentalCopy subform to add copies (of movies) to a particular rental (check attached jpg). Now if you would...

I have decided not to go with the Rented flag after reading some other threads and suggestions. I created a query qryMaxOfDateRented that looks like this: SELECT tblCopyRental.CopyID, Max(tblRental.DateRented) AS MaxOfDateRented FROM tblRental INNER JOIN tblCopyRental ON...

Hello! Since my video rental database is in Slovene I'm affraid I can't post an example so I'll try to translate the tables involved and post some questions. Hopefully I'll make sense, keep in mind I'm a beginner. tblMember: MemberID (PK) Fname Lname etc. tblRental: RentalID (PK) MemberID...

gromit - thanks for your response Actually in my case the number of videos directly affect the due date. If you rent 1 video, you must return it a day after, 2 videos in two days and so on. The TapeCount query I mentioned above calculates the number of tapes in a rental and that number should...

Still no idea Here is a query which calculates TAPECOUNT SELECT COUNT(Tape_Rental.TAPE_ID) AS TAPECOUNT FROM Tape_Rental, Rental WHERE Tape_Rental.RENTAL_ID=Rental.RENTAL_ID; Is it possible to replace number 5 in above example with this? I've tried it and it doesn't work, maybe I'm doing...

Hello I'm very new at this - just found out about the DateAdd function today trying to solve my problem, so that you know who you're dealing with. Let's say Im operating a video rental shop, and want to calculate a DateDue (=when videos need to be returned) based on DateRented and number of...