Search results

Thanks It worked fine. Robert

Hi all I have a button CmdPrevious and another button CmdNext. CmdPrevious is Not Visible. I want CmdPrevious to become Visible when I click CmdNext. I also want to move to the next record when I click CmdNext. I can do the Next Record part using a macro, and I can do the Visible part using...

Thanks again. I did manage to get my database working, using a Volume-Book-Author form-subform-subsubform structure. It looks OK as far as data entry is concerned, but the crunch will probably come when I try to produce the reports. I will look closely at what you have sent, and will probably...

Still having trouble. The help from jzwp22 has been wonderful (thanks again) but after several days of reading about relationships, forms and subforms and lots of trial and error (mostly error!!) I still can't get it to work. My preference is to start with a form based on Volume information...

I thought I had this sorted, but not so! I am happy with the project so far, but now want to extend it. As well as the Books, Authors, and Books_Authors tables, I now want to include a Volumes table. This is to allow for physical books which contain more than one title. These would include...

Thanks I understand that, but the Wizard seems to regard subforms and linked forms as something different. That's where I am having trouble. Robert

Sorry, still not clear enough. My tables are A, B and C, with junction tables (AB and BC) in between. I have A linked to AB in a one-to-many, and B linked to AB in a one-to-many, thereby creating a many-to-many relationship between A and B. Similarly with B and C. My main information is in A...

Hi all When I try to create a form with a subform the wizard gives me the option of a "form with a subform" or "linked forms". I can't find any explanation about linked forms in the Help files. What are they and when should they be used, please? Robert

Thanks to you both. My original post was, I now see, not clear. I know that the nesting notion is OK if the tables on which the forms are based are each pairwise linked by a one-to-many relationship. However in my case the relationships are each many-to-many. Does this make a difference? Robert

Hi all With Access 2007 is it possible to have a form which contains a subform, which itself also contains a subform? In other words, if I have a form (B) with a subform (C), can I insert that into another form (A), creating a set of "nested" forms? Thanks Robert

Thanks Dayna and Rabbie The Sorting and Grouping option worked well. Thanks again. Robert

Hi all. I am a beginner using Access 2007 to try to develop a small home library application to store details of my book collection. I originally had trouble with my data entry forms but those problems have now been resolved thanks to help from this forum. My difficulty now is that my report...

jzwp22 Thanks for the quick reply. I have just tried it and I managed to make it work. At last, after so much frustration!!! Thanks again. Robert.

Hi all. I am a beginner using Access 2007 to try to develop a small home library application to store details of my book collection. So far I have three tables as follows: Table 1 Books has fields Book_ID (AutoNumber, Primary Key) and Title. Table 2 Authors has fields Author_ID (AutoNumber...