Search results

  1. E

    word index creator code would be good: possible?

    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...
  2. E

    create text box showing how many characters remain during input to form's text box

    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)...
  3. E

    Rich text field in form - bulleted list icons look has changed (bad)

    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...
  4. E

    Put what, where, to eliminate blank spaces in sub-report

    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...
  5. E

    Audit Trail VBA fine tuning: before/after list of changes

    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...
  6. E

    Database engine does not recognize 'payment' as a valid field name or expression

    Hi all -- I've tried various searches for my probably simple problem but no success. I have a small database for producing various financial reports, by date period (from/to). It works perfectly except when there are either no payment records or no receipt records for the chosen period...
  7. E

    Forced page break(s) in Access 2007 report

    Hi everyone I am writing a book, using MS Access 2007 (seemed like a good idea at the time I started, and the report that creates the formatted book content works quite well). The book content is "per paragraph" which gives me total flexibility to move content to whatever spot in the book...
  8. E

    Can't find & format section of text within a RTF Memo field

    Hi! OK, I am writing a book, based on a large database with the key fields being named "what" and "how". Because I had the need every so often to quickly find all instances of any (particular) word within the database, without going to the bother of thinking about where that word/subject...
Top Bottom