Search results

  1. V

    External Name not defined

    Can you indicate which line causes the error.
  2. V

    Sequence Numbers

    What's the question?
  3. V

    Using a value on a report for a query

    I don't follow.
  4. V

    UNC Links

    There are comments inline. Copy the relevant parts from there and add it to yours. Then ask specific questions.
  5. V

    Attachment Datatype and viewing images in reports

    Is it only the spreadsheet that will be included in the report? Tell your boss that it's just not feasible. A spreadsheet spans much wider than an Access report. The spreadsheet can and should be opened in Excel.
  6. V

    Sum of field of a field in 2 different subform.

    When I say filter, I'm talking about the filter options that are available on the ribbon. Are these disabled? If they are not then there's nothing stopping the user from selecting the ID and filtering it down. Confirm this.
  7. V

    UNC Links

    Delete the links and recreate them. Here's some code that you can adapt: http://www.access-programmers.co.uk/forums/showpost.php?p=1437883&postcount=3
  8. V

    Image in output to Word Document

    Not quite darbid's code. An image control doesn't have a copy command like the chart example in Excel and a Shapes object in Word doesn't have a Picture property so you can't do: Word.Shapes(0).Picture = Access.Image.Picture You still need to save the image to disk (e.g. the temp folder) and add...
  9. V

    Query "And" on same field

    Ok, I understand your requirement now: SELECT Table1.ID FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID WHERE Table2.[Location] = "Home" OR Table2.[Location] = "Office" GROUP BY Table1.ID HAVING Count(Table1.ID) > 1;
  10. V

    Max Function

    Two queries with a join... remember I mentioned joining...
  11. V

    Max Function

    Not quite. Have a go again, but re-read my post and try to digest it. There are two queries involved there.
  12. V

    Max Function

    And what does the above mean? Can you please back up your posts with some explanation.
  13. V

    Query "And" on same field

    My last comment was in reference to the fact that plog was still around, but I think this time he's gone to sleep ;) so... What was already given could have been used by including the Table1, joining it to Table2 and swapping the ID field for the Table1's ID field. plog already mentioned this...
  14. V

    Error messages on unbound text

    That's right!
  15. V

    Max Function

    Add/drop the above query to a SELECT query that includes all the player fields, then join the table and the above query via the [MaxOfYear Drafted] and the [Year Drafted] fields.
  16. V

    Run time error 3075 - Can't get it to go thru

    Good job! :) If you don't want that warning message, you can use the DAO Execute method: CurrentDb.Execute SQL, dbFailOnError
  17. V

    Error messages on unbound text

    @GinaWhipp, I'm aware that it causes issues sometimes and it's not sensible including it in the deployed front end, but the VBE, VBProject, VBComponent etc which are all members of the this type library are still only accessible via the VBIDE object library. I'm currently on an Access 2007 on...
  18. V

    Max Function

    You want just the max value so: SELECT Max(Players.[Year Drafted]) AS [MaxOfYear Drafted] FROM Players;
  19. V

    Max Function

    Let me see the SQL of the query you tried. And a bit of advice, in a forum such as this, when you're presented with solutions/suggestions, give it a try and if you're having difficulty show us what you've tried and we'll advice.
  20. V

    Query "And" on same field

    I take that back :o
Back
Top Bottom