Search:

Type: Posts; User: alifrog; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    499

    File Open and Favourites in Word 2013

    I have only had one brief encounter with Word 2013, which was enough to make me run screaming back to 2010. But, alas, I can only stave off the inevitable for so long.

    Perhaps I'm missing...
  2. Passing a variable from an Access form back to the calling subroutine

    I am always reading that Global Variables, like GoTo, are programming pariahs requiring the digital equivalent of a string of garlic and a wooden stake to keep at bay under all circumstances.
    ...
  3. Replies
    1
    Views
    420

    Where would the hyperlink be? If it's in a form,...

    Where would the hyperlink be? If it's in a form, does it need to be a hyperlink, or would a button do the job?
  4. Duh! I've got the RecordsetClone solution...

    Duh! I've got the RecordsetClone solution working by turning the filter off at the start of the routine, and back on again at the end. So, in summary:

    - The OnOpen event of the form sets the...
  5. Replies
    4
    Views
    1,215

    Hi Trevor - Yes, I'm pretty sure it will be...

    Hi Trevor -

    Yes, I'm pretty sure it will be the chart that is causing the problem. It sounds like an issue I've had with Outlook - after creating an e-mail from Access, I would try to leave...
  6. WendellB - Yes, you're right, and I wondered if...

    WendellB - Yes, you're right, and I wondered if it had something to do with all the records being in the same block as the record in use, and therefore locked as a group.

    Patt - Separating out the...
  7. Did you try the compact anyway? I generally...

    Did you try the compact anyway?

    I generally find I don't use autonumbers in a field that is going to be seen by users, because you always get the problem of missing numbers sooner or later. There...
  8. Using one record in a form to trigger updates to other records

    I have a table that poses a series of questions (one record for each) with Yes/No answers (stored in the [tautological?] field ysnYesNo). The questions fall into various categories. For each...
  9. Alternatively, you might have the New Values...

    Alternatively, you might have the New Values property for the AutoNumber field set to Random instead of Increment.

    Cheers

    AliC
  10. This suggests that data have been entered in this...

    This suggests that data have been entered in this table and then records deleted - perhaps in testing? The used and discarded autonumbers won't be re-issued. However, if you clear the table and...
  11. Replies
    4
    Views
    1,215

    I have had difficulty replicating your report, as...

    I have had difficulty replicating your report, as I get an error message when I try to activate it. I checked your previous post, and have set all my properties in the same way as you, except that I...
  12. Replies
    6
    Views
    1,732

    Hi Wendell - I'm sorry - I feel as though my...

    Hi Wendell -

    I'm sorry - I feel as though my stupidity level is going through the roof here, but I'm still having trouble getting a handle on what you are suggesting regarding OnCurrent.

    I can...
  13. You could use Domain functions, although the...

    You could use Domain functions, although the larger your dataset the slower this could become.

    Using a very simple table (Table1) with three fields (ID, strText, dblNumber), I created a query...
  14. Replies
    6
    Views
    1,732

    Hi Wendell - I'm using Access 2010, although...

    Hi Wendell -

    I'm using Access 2010, although with the 2007 file format for backward compatibility.

    Yes, Auto-Expand is turned on, and deliberately so.

    I do understand why I might want the...
  15. Replies
    6
    Views
    1,732

    Collapsing a combo box in VBA

    As always, unsure whether to post this under Access or VBA, but here goes.

    The VBA code I have attached to the NotInList event of a combo box does all the right things except collapse the combo...
  16. Not familiar with Soundex, but it looks worth a...

    Not familiar with Soundex, but it looks worth a try. Last one in the office so heading home before the lights go out, but will check it out tomorrow and see if it provides a better way of doing...
  17. Clearly, the next thing I need to tackle is how...

    Clearly, the next thing I need to tackle is how to split a message into multiple quotes - thought it might have something to do with "Multi-quote this message" but if it does, I'm too tired at the...
  18. OK! I've got it - at least, I know why it's...

    OK! I've got it - at least, I know why it's throwing up the apparent error. There is somebody else with the same surname, but different first name; because there is no duplicate First/Last...
  19. Aaarrrggghhh! Deficient testing on my part - I...

    Aaarrrggghhh! Deficient testing on my part - I tested with neither records' fields checked and one record's field checked, but for some reason completely omitted to test with both records' fields...
  20. Hi Tom - I was beginning to think it might be...

    Hi Tom -

    I was beginning to think it might be a good idea to create some dummy data, but Ruirib's response seems to have done what I need.

    However, I really appreciate your comments about...
  21. Progress!

    Hi Ruirib -

    That last solution seems to give me what I want, and faster than the VBA function I had written.

    I need to apply this in a couple of other contexts (checking Last/DoB and First/DoB...
  22. Thanks - that doesn't give any errors, but only...

    Thanks - that doesn't give any errors, but only calls up records that are unchecked, which isn't quite what I'm after.

    What I'm trying to do is identify if there are any unchecked records and, if...
  23. Yes, here it is - sorry if it would have helped...

    Yes, here it is - sorry if it would have helped to include it in the original post. The problem for me is knowing what I need to add to the SQL!

    SELECT
    itblLGAClaimantsUnique.strLast,
    ...
  24. Query for duplicate names where at least one record's YesNo field is False

    I have a Find Duplicates query that identifies people with duplicate names in a table. When the initial set of data are imported to the table, this enables the user to check whether the same person...
  25. Replies
    1
    Views
    767

    Microsoft Knowledgebase

    I really don't know where I should be posting this question, but can anybody tell me WFT has happened to the Microsoft Knowlegebase? I can go for months without needing outside help, apart from a...
Results 1 to 25 of 146
Page 1 of 6 1 2 3 4