Search results

arnelgp, thank you for your helpful thoughtful comments. I need now to just see what word can do with my exported MS Word text file(s), in the light of whatever your suggested sites and people come up with. I also want to pursue understanding of MajP's very cool creation. I also need to study...

Wow, this is so logical and good. I agree with "fast" and "most of it done, do the rest via fine tuning, deleting, etc". You know it is a pleasure to see (my) vague and formless ideas come into fruition, via savant adaptation of "idea" -----------> "useful REALITY". I just can't believe...

MajP - I seriously don't know how to express my appreciation of what you've posted. My mind is genuinely blown away. Dumb is good, but it don't look dumb to me .... And as I haven't yet replied to Uncle gizmo re his post I won't go too overboard in my praise for you, in case his routines...

Hi CJ_London the way my bookwriter works, I don't ever identify a page number in the data base, but it does show when I produce an interim (or final) report. Yes, that's a problem for an index (clearly!). As I explained to arnelgp, the way around that is to export the report (= all & every...

arnelgp unfortunately, my MS Access book record(s) do not go by page, they go by (see my post to Uncle Gizmo, to see the database structure). But it's OK, I am investigating (as someone suggested here) the MS Word options, also a program called Sigil (which I use to make eBooks). From the...

MajP like minds, we are. I will have a look at your zip files in a while. I'd be happy with an 85% result and yes I know there's manual work needed to fine tune any/the list. I've posted a bit more detail of my Access book structure & reports, and that I can export text file to MS Word...

Uncle Gizmo - thanks for that suggestion, I now see (by fiddling) that my MS Access book reports (which I produce as pdf) can be exported beautifully from Access as MS Word text files and I note that MS Word does have a sort of index producing facility (which I knew anyway) which I could use...

Hi everyone I'm in MS Access 2007. I use RTF fields to create non-fiction books/stories. I would like ideas, and preferably also a whole VBA code to be able to create a routine (for each book/story I write) that creates a purpose built index, just like many books have as of course you would...

Thanks a million Arnelgp, you are a genius. I just love your routine, which I've "upped" from 100 to 255 characters, as is text field size limit. I will try and incorporate it into each of my input fields on that form, via "on change event ..... call .... your routine" (I think that is what...

Hi DBguy - sounds good. I think that's what I could use with the routine that Arnelgp has suggested in his post (which is sublime in its simplicity, and which is btw the essence of genius ....) EdK

Hi all, I have a form with various text fields to which I do input. I know the character limit is 254 and that's fine. But I would like during input to know how many characters are left that I can use for input to that field/record. Why? Because that would enable me to (as necessary)...

Thank you for your involvement. Unfortunately I can't even successfully do what you suggestabove, so it's nfa for now, thanks EdK

No, I don't think so - in design view, the property sheet for that RTF control says "Text format -- Rich Text". And I can do underlines, bolding, etc for any selected text. EdK

Hi all Some time back the drop down bullets I was using in a form's rich text memo field changed from to I have not idea why but would love to have it fixed as it looks terrible both on screen and when printed out in a report. It seems that MS Access 2007 has just the one option for its...

Hello again. Thank you to Sneuberg for your answer but unfortunately I haven’t been able to make that work. Doesn’t matter, let’s start again. This time I will give a bit more explanation/background. The sub-report is in a report footer which has a linking field called para1ref, all this...

Hello, all. I am looking for help with a certain report I have designed (without VBA knowledge). The report works OK but leaves a blank space in its sub-report, for each record found that does NOT have each of its five fields return positive (does that make sense?). I know about setting a...

Thanks to all for your responses, and my apologies - I didn't mean to stir the pot (so to speak). I will try out the two suggestions (using MS Word's tracking routine, which I didn't know about but should have; using some sort of utility, to be found by Googling as Spikepl suggests). I'll see...

Thank you, CJ! very interesting, those bits I could understand. I posted a bit more explanation of what I had in mind and how I might use a new routine. I can now cut to the chase, having thought a bit more about it. The only change to the VBA code that I posted earlier, I think (not being...

Thanks for your comments, Spike. Yes, I agree, that (of itself) wouldn't be very useful. But I should have said a couple more things about how the database/book text is designed and how I use it -- The three fields booktext1, booktext2, and booktext3 are in a table that is organised by ID...

Hi all I am writing a book using Access 2007. It includes a form/table which holds several memo fields. I have been keeping track of changes made to any/all of these memo fields. I have used the following VBA routine - Function AuditTrail() On Error GoTo Err_Handler Dim...