Search results

  1. K

    trying to set form size

    Bob, I have been doing a bit of form & control sizing over the last few days and was wondering about twips. I have a failry large monitor and reasonable eyesight (when I bother to wear my glasses). The moitor resolution is set to maximun with large icons. My problem is that the first...
  2. K

    Can moderators purge spam and block spam posters?

    RV / Mrs. Gorilla, Well, some people obviously take notice of the 'jello' (jelly to our British readers). I am very happy to be an 'unknown quantity' and regard that as a significant step on the path to forum forgiveness. From minus 10 to +4 in a couple of weeks - somebody must be...
  3. K

    Can moderators purge spam and block spam posters?

    Hi Colin, You're right that you can decline to open spam. The problem is that if the posters are encouraged in any way, they may flood the site to the point that it becomes unusable for the intended purpose. Whoever 'Dowel' is posted some half a dozen adverts. If he/she wasn't discouraged by...
  4. K

    Can moderators purge spam and block spam posters?

    Thanks SJ. Can I ask, is there any merit in using the warning triangle to report spam postings etc? Or does it just make me feel better?
  5. K

    Can moderators purge spam and block spam posters?

    I know the spam pushers could create new accounts to post more crap, but htat would be an effort and they may give up if quickly deleted and blocked? Dowel has flooded the forum with spam this am so he/she could be purged with out much concern for their feelings I would say.
  6. K

    Useless Facts

    Vassago, I recall reading somewhere that Tokyo had concreted over so much of the area that the reduction in green plants and exposed soil had caused a considerable drying of the local climate. This was to the point where low humidity was a problem. Obviously your experience contradicts that...
  7. K

    Useless Facts

    Mrs. Gorilla, Thank you for setting me straight. I'm glad I put in the caveat or I'd be feeling a fool (again). :)
  8. K

    Useless Facts

    Pa3329, Wow. Big house. Not to doubt you, but I couldn't resist trying a Google search on this. There were a number of hits, all of the "useless Facts" listings such as this thread. The first 6 hits were word perfect to your quote. That really is a useless fact :D The seventh, copied...
  9. K

    Build Excel Pivot table in Access (Columns)

    Hi, I'm not sure that this is what you are talking about, but when I did something similar, my Access Pivot Table rows ended up as columns in the Excel version. Off the top of my head I can't recall where it is, but there is a toggle to show results (details area) as columns or rows which...
  10. K

    Help with + and &

    Dave, I'm glad you got your problem sorted although I confess the answer doesn't mean much to me. Out of interest, does the "URLEncode = %26" configure the ampersand to be treated as text or change it to a '+'? Regards.
  11. K

    Useless Facts

    "40,000 ton brick house" :confused: :eek: Could you possibly mean a house made of 40,000 bricks? A 40,000 ton house would be pretty big, even for America. Not may mailboxes could cope with the wear and tear! :)
  12. K

    Subtract one table from another?

    hi Ya, Use an Find Unmatched Items query. Select queries in the database objects panel, New/Find Unmatched Items. The wizard is fairly straightforward. You need to create 2 queries, 1 for unmatched items in table A from table B and another the other way round. I think the subtract one...
  13. K

    Problem with a crosstab query

    I'm very green in this (and other) areas but I can offer this which may be relevant. Sorry in advance if it isn't. :) In Pivot Tables, which I believe are functionally the same as cross tabs, only with more flexibility, you can right click row and column headings and select to show empty...
  14. K

    Adobe PDF?

    Mr. Smith, I'm not entirely clear what you want to do here. I think what you want is a report that shows only the current record and you then want to make a .pdf file from it? The sample database on this thread should sort you out for the single record report...
  15. K

    Filtering data before report

    Try this thread. If the sample DB doesn't do what you need, post back. :) http://www.access-programmers.co.uk/forums/showthread.php?t=85822
  16. K

    Recommended Reading List

    Sorry, forgot to say welcome! :)
  17. K

    Recommended Reading List

    Microsoft Press Access 2003 Inside Track and Inside Out are both advanced books. To be honest, some of the content was over my head as a novice when I read them and now I have had some exposure to Access it would pay me dividends to go through them again. Neither of these books are out an out...
  18. K

    Adding a "Tip of the Day" feature to a database

    Hi, The db fell over at the Dim MyDB as database line copied below. I'm using A2k on my home PC. I saw your response to MSLady, but don't know where/how to reference a DAO library. If that is my problem, could you give me a little guidance? Private Sub Form_Open(Cancel As Integer)...
  19. K

    Useless Facts

    Elephants Elephants are the only beast on the planet to have 4 knees. All other 4 legged beasts have knees in the back pair and the leg equivalent of elbows in the front pair (I wouldn't swear to the second statement, but 4 knees and elephants is definite!) Elephants are believed to be able...
  20. K

    [UserID] is on a distinguished road? huh...

    Bob, It's easy to get a blind spot when working on your own. I sometimes feel like the pantomime dame with everyone shouting "He's behind you!" when I'm missing something obvious. I'm glad your curiosity has been satisfied. :)
Back
Top Bottom