Search results

  1. reclusivemonkey

    Why does AND filter also filter NULL

    OK, Thanks Brian. I've added And Is Null to the end of the filter and it does indeed pick up the Null values. Seems an odd way of doing things I don't know why I haven't noticed that before.
  2. reclusivemonkey

    Why does AND filter also filter NULL

    Sorry; I didn't explain fully. There is more than this one field; when I don't enter any filter, I get the records with NULL values in this field.
  3. reclusivemonkey

    Why does AND filter also filter NULL

    Hello Everyone, Been a while since I needed to post on this forum, but I found something rather disturbing today; either that or I have missed something obvious. I have a large query of financial data, and I filter out certain codes which I don't want to include. The filter is; <>"BL01" And...
  4. reclusivemonkey

    Retain memo format - Require WYSIWYG

    Try strolbody = strolbody & "<tr> <td>Ticket Text</td><td><pre>" & me.notes & "</pre></td>" The <pre> tags should preserve formatting, although whether or not it will work through access I am not sure. Here's a link to PRE on w3schools; http://www.w3schools.com/tags/tag_pre.asp
  5. reclusivemonkey

    Windows login form

    I've just tested this at work, and it found my domain with no problems. If you need any more details, just let me know.
  6. reclusivemonkey

    access and ecommerce

    mySQL, which would be ideal for this purpose and is indeed used in thousands if not millions of shopping carts on the interent is free, both as in "speech" and "beer".
  7. reclusivemonkey

    Email different report results to a list

    I have something fairly familiar; I'll let you look at the code and see what sense you can make of it, and then ask questions later ;-) Sub TabProduction() ' For the first three months of the year we need to produce a regular report, and then a _ & report for the same month ' in last year...
  8. reclusivemonkey

    Export query to xml

    Why would you want to do this? What is the end result that you want? You can group on the province simply using keys in XSLT, or if you really to put the province name in the XML, you should use an attibute, like; <dataroot> <Province Attribute="Flevoland"> <City>Woonplaats</City>...
  9. reclusivemonkey

    Export query to xml

    I'm not sure what you are asking here. The XML you have will give you all you need to make any other XML file, you can use XSLT to take an XML file and change the format easily. However, in the example you give you are losing the Province name, which I am sure you don't want to do? Top XML...
  10. reclusivemonkey

    Pick List

    Try "Data --> Validation".
  11. reclusivemonkey

    Toolbars and Menus have gone

    Hold down the SHIFT key as you open the database.
  12. reclusivemonkey

    Email Code correction

    OK firstly you should sort out a couple of other things. You should never use "Date" as a field name, which it looks as if you have in here; Forms!DispatchDay!Date.Value Also, remove daSubject = "" and the same line in daBody, they serve no useful purpose. Then, to get a long formatted date...
  13. reclusivemonkey

    Email Code correction

    Remove the vbCrlLf; you can't use a line field in a Subject line AFAIK.
  14. reclusivemonkey

    HTML <table>

    Do you need to use a table? You can use a div to do this just as effectively. Use the "background image" property and you can specify the exact percentage of where you want the image to appear. In your <head> section use; <style type="text/css"> div#graphic{ background-image...
  15. reclusivemonkey

    Variable Values Not Showing

    In your VBA Editor, in the "Tools --> Options", "Auto Data Tips" should be checked. If its stopped working for no reason, then this may not help but its worth a try. If that doesn't work, you may have to try reinstalling. You might be able to just reinstall the VBA Editor, I am not sure.
  16. reclusivemonkey

    Hanging up my mouse

    Congratulations Brian, more time to spend at the Philamonic now? (I was at Uni in Liverpool ;-) )
  17. reclusivemonkey

    Calendar Software?

    Hmm, threads freaking out a bit I already replied but I think it got lost. Like you I have only used it personally, but it seems it can do everything you want. However, you may want a more "tried and tested" solution. Here are some links which should help you...
  18. reclusivemonkey

    Calendar Software?

    You could try this; its still in development but pretty usable. A good free option to try before you spend any money ;-) http://www.mozilla.org/projects/calendar/sunbird.html
  19. reclusivemonkey

    office 12

    Not tried it, but I have seen the new tool bars and they looked "sucky" :-) I should imagine though that there will probably be an option to revert to previous toolbar behaviour? Working for local government it will be a _long_ time before Office 12 reaches my desk thankfully.
  20. reclusivemonkey

    Variable Range

    Use a range name, rather than a specific reference to cells.
Top Bottom