Search results

Thanks Gemma and Minty I am indeed trying allow a student name to be replaced if erroneously entered, or for the offending record to be deleted. The student ID is stored in the [BookTitleTbl], until the book is returned. Upon its return, it is then updated to null to make way for the next...

Many thanks Mole The main form is based on a table containing all the Book Details. Each book is displayed in the continuous form and here is a combo box for selecting the student. After update of the combo box the underlying table [BookTitleTbl]![StudentID] is populated by StudentID...

Many thanks Static. Perhaps I wasn't clear about my processes. Here's what happens: 1. The librarian checks the book out by selecting the student from a list. This is applied to [BookTitleTbl] 2. The book record is then flagged as 'On Loan' in the book title table. 3. The Date out is set to...

Hello folks, I have a question for the boffins on here. I have a school library system set up and one of its functions is to record each student's library activity (for awards at the end of the year). The function works well, however I've thought of a scenario which could well occur at some...

Hi JD, I did as you suggested, but the contents of the box are still well short. I reckon with the spaces, it is only allowing about 250 characters, about the same as a text field rather than a memo field. I will continue to play around to see if I can come up with a solution. With regards to...

JD you are quite correct. I had changed the format of the original field to Rich Text in order to experiment. I forgot to change it back. I have done so now and the code is gone. I agree that there is too much white space, however this is down to the user. Often they will create lists or...

Once again JD, an amazing piece of work. I have tried to alter it to suit my database, bearing in mind my limited understanding of code. So far so good. However I have come across a problem. In the uppoer box, where the contents of the original comments are shown, it displays only part of...

Many thanks John, I'll certainly investigate.

Wow, that's amazing JD. You clearly put a lot of thought into that and I thank you for it. The thing that worries me is its complexity. I don't know if I could troubleshoot it is needed. But an amazing tool nevertheless. I am definitely going to investigate this further and implement it when I...

Hello folks I wonder if someone can advise me? I have a form containing a memo field, and, when populated with text, I would like to highlight certain words, if they appear in the field. The underlying query looks at the gender assigned to each record and compares this to the pronouns...

Hello JD, you may remember we had a discussion a while ago regarding finding gender pronoun disagreement. Well, I have managed to solve the problem with a query. Now the user clicks a button and a list of all the reports that appear to have a problem appears. It works quite well, although...

Hi David, you are correct of course. I t should read >date(). I suppose though that since it happens the next day then it makes no difference. I do take your point however. I'll look at this. Thanks Rob

Dear David and Mr B, many thanks for your prompt replies. I now feel much more confident about this action. David, Forms!Switchboard![Date of Reg] gets it's value from an underlying table which is populated by an append query. It is set to default date(), so when the records are appended...

Good morning folks I have a database project that is held on an internal network. There are multiple users. Since the design is now finished, I would like to split the database. When the database opens for the first time each day, a module runs, appending the contents of one table to an...

Many thanks JD, I will study what you've done and have a go at integrating it into my dbase. I think it will be beyond my limited cpabilities, but certainly worth trying. Rob

Hi JD I'm not sure what happened to my attachments. I'll have another look. Many thanks for your sample dbase. All I can say is wow! Actually, it's way above and beyond what I was aiming for, in fact, it might even be too good. What I was hoping to achieve was a module that would run after...

JD, I have attached three files. One is the slimmed down version of the dbase, one is the spreadsheet list of effected records from the dbase and the Word document is a description of the procedure for opening the screen in which the reports are created. Your code looks even more complicated...

Many thanks JD. I'll trim it down and post to you. Rob

Dear JD I understand the new table set up and each record entered, but I don't understand the code behind the search. My knowledge of code is very basic unfortunately, but can I assume that the code where the records are looped and parsed is activated by the After Update event? A example of...