Search results

  1. MSAccessRookie

    Story

    Pixar Animation and
  2. MSAccessRookie

    Story

    newest DVD Sales
  3. MSAccessRookie

    Story

    and sweating with
  4. MSAccessRookie

    Story

    with the giant
  5. MSAccessRookie

    Story

    down by the
  6. MSAccessRookie

    Story

    to the guards
  7. MSAccessRookie

    Story

    you tried to
  8. MSAccessRookie

    Query Expiry

    This should be an excellent way to do what you want. Condiser also the possibility of not using a hard coded Date, and instead, having a Table to store the date (and others like it) in. Two distinct advantages to this approach include the fact that you do not need to edit Queries to update the...
  9. MSAccessRookie

    Refer to aggregate function in WHERE clause (AC2007)

    I am very glad that the Forum has been useful to you, but I noticed something in your response, and wanted to point out a very common misconception that many questioners have in here. Simply put, resolving a simple issue is often much different than resolving a complicated one, even if they...
  10. MSAccessRookie

    Compare Two Strings Problem

    Based on the Prefixes contained in Table2, I suspect that you could NEVER find Table1.[Tracking Number] in the list of Table2.[Tracking Number]s. I think that jhb was on the right track by suggesting use of the Right() Function to locate the entries in Table2.[Tracking Number] which contain...
  11. MSAccessRookie

    "Or" in a update query criteria

    Sue, I had a problem similar to this one (I think). The project used two Tables to store information related to Equipment that the company used. The first Table contained Standard Equipment Information that was similar for all Equipment, while the second one contained Equipment...
  12. MSAccessRookie

    Story

    five shot expressos
  13. MSAccessRookie

    Find/Replace code - line wrap problem

    I did some testing on my own and have come up with the following: The marker that I was thinking of was ^p, not <p>, and before anyone goes off to try it, it does not work either. I am no longer sure that you will be able to do what you want. I am going to have to leave the next step to...
  14. MSAccessRookie

    Find/Replace code - line wrap problem

    Somehow I got the rules for Word mixed up with the rules for Access. Try using the vba Equivalent vbCrLf instead. -- Rookie
  15. MSAccessRookie

    Story

    forty second street
  16. MSAccessRookie

    Find/Replace code - line wrap problem

    It looks possible, but you might need two <p>. Testing is the only way to see what it will really look like. Good luck -- Rookie
  17. MSAccessRookie

    Story

    down to the
  18. MSAccessRookie

    Access 2010 query help needed

    If this is the exact SQL Code, then you have an invalid Syntax in your WHERE Clause. The WHERE Clause must have a specific value to compare to, and yours does not. Two possibilities occur to me: Postings.Customers is a String, and should be compared to "?", not ?. You want to accept any value...
  19. MSAccessRookie

    Find/Replace code - line wrap problem

    While is it possible to do what you want by adding a NewLine Insert Character <p> to the replacement string, it might not be practical, since the Replace All Feature is not completely intelligent and will replace any matches that it thinks it finds. Another approach would be to replace one at a...
  20. MSAccessRookie

    Story

    the other side
Back
Top Bottom