Search results

  1. A

    Dependent query

    That looks as it it might do the trick. I will try it in the morning - meantime, thanks!
  2. A

    Dependent query

    Ah..! Can I use that syntax with a value input by the user, something like: select * from ScoreTable where ScoreYear =[Enter Year] (SQL has been a bit of a closed book up till now, but I think I can see the logic)
  3. A

    Dependent query

    Do you mean something like "ScoreYearPrevious:[ScoreYear]-1"? That returns the actual previous year, but not the other data (ie, the score).
  4. A

    Dependent query

    This is an attempt to overcome a mental block! I am trying to extract 2 sets of Scores from 2 sequential years, from a single table. The result will display side by side in a report (or a word document), showing this year's results and last year's results. The user will be asked to input a...
  5. A

    Query "holding" values

    I did, thank you. For information, the problem was not in the code, but in the underlying query which fed the data to the Word document. However, the very fact of posting here forced me to go back and review the whole process thoroughly - and I found an error in the query which was causing the...
  6. A

    Query "holding" values

    Thanks JHB - it is a fairly complex(long) piece of code - so you may be onto the solution. How would I use a DoEvents in this? A snippet of the code is here - there is about 90 lines! WordObj.Selection.GoTo what:=wdGoToBookmark, Name:="VisitsSCCurrent" WordObj.Selection.TypeText...
  7. A

    Query "holding" values

    LOL! No, it has not. However, this is the first time I have run this system over a fairly dispersed LAN (Server in London accessed by team members all over the UK and Europe via a VPN).
  8. A

    Query "holding" values

    I'm hoping someone here can give me a pointer in the right direction. I have a database which runs a (fairly complex (60 + fields)) query to output an annual report to a Word document. The procedure is called from a button on a form, which then opens a Word template and populates the...
  9. A

    Standard(?) outlook import/export macro

    Spike, Thank you for your post. Firstly let me apologise for my churlishness in posting such an asinine comment - it is perhaps evidence of my frustration with my own lack of knowledge, and my inability to make such a potentially useful (to me) feature work. You are, of course, entirely...
  10. A

    Standard(?) outlook import/export macro

    OK, call me stupid. If over 150 people read this post, and can't be a**d to reply, to something which MUST be an integral problem with Access, why should I bother asking the question? Thanks and goodbye.
  11. A

    Standard(?) outlook import/export macro

    No takers? Surely someone must have come across a similar problem? Or is this a well-known glitch among the cognescenti? :D
  12. A

    Standard(?) outlook import/export macro

    I am using A13 on W8.1 alongside Outlook 2013. I am trying to build a project which will automate my home business. Like many, I use Outlook for my contact tracking. I want to be able to export and import contacts from my Database, and A13 provides 2 built-in Macros to do this. Problem is, in...
  13. A

    Hello from scotland

    Morning fellow forum-ites. I have joined this forum because I have come back to using Access in a homeworking context - previously I had used it for other people, now I am doing it myself, for myself! A lot has changed since most of my learning (done with A97 and A2003) so I expect to ask some...
Back
Top Bottom