Recent content by dajabo

  1. D

    Maximized form coming 'unstuck'

    thanks shaneman and allan57. Yes I could use Maximize again or Restore. I guess I don't see why I should and I'm wondering why Access is un-Maximising a window that should be Maximised. I was under the impression that if one non-pop-up/modal window is maximised inside the application window...
  2. D

    Simple Dlookup probem

    You need to take the reference to the form control out of the double quotes, so something like: =DLookUp("[Title Name]","Titles","[Code]='" & forms!Order_Details![Product Code] & "') Notice I put single quotes after the second = and before the last bracket. If the variable is an integer you...
  3. D

    Maximized form coming 'unstuck'

    Thanks if anyone can offer a suggestion, I cannot find a similar problem described on the forum. I have a form which runs at startup maximised. Pop-up and Modal are set to 'NO', Auto Resize and Center are also set to 'NO', Border style has been set to various settings, and Moveable has also...
  4. D

    For Each Next & ItemsSelected - strange behaviour

    Thanks very much Banana for your suggestions ... I'll try what you said in the next couple of days and post back. I think there is an error in the code somewhere too. I ought to tidy this section up. D
  5. D

    For Each Next & ItemsSelected - strange behaviour

    Thanks for the tutorial. Knowing that you can make variables last beyond the function they are in would have been very handy writing this series of code, I'll look into it. It doesn't change the issue here, though, which is that the FOR EACH NEXT loop above cycles through ctl.ItemsSelected...
  6. D

    For Each Next & ItemsSelected - strange behaviour

    While troubleshooting I just wanted to make absolutely sure this variable was null. I use the same variable in other procedures and this procedure is in the middle of a nest (or jungle) of them. I'm not very informed about the life-span of variables and just wanted to make sure while I got the...
  7. D

    For Each Next & ItemsSelected - strange behaviour

    I usually find an answer to problems on this forum in a matter of minutes searching, but this one I can't. Can anyone shed light on why the For-Next loop in the following code cycles through twice? For Each lstitem In ctl.ItemsSelected Debug.Print ctl.ListIndex MsgPresentCheck =...
  8. D

    MailMerge and FormFields command - no documentation ANYWHERE

    Greetings ... Now I cannot for the life of me find references to the below on this forum, in Access or Word VBA help, or even searching Google for that matter ... I don't understand ... I am trying to call a Word .dot template from Access for a MailMerge function. I have gleaned from a few...
  9. D

    filter query wildcards won't work-pls hlp

    Of course! Thanks VM ...
  10. D

    filter query wildcards won't work-pls hlp

    I'd be grateful if someone could offer some help with this to a frustrated Access novice : ) I have a query that filters records according to the value of an unbound text box in my form (basically search on last name) I want to introduce wildcards into the filtering process but cannot get it...
  11. D

    Audit Trail

    yes I worked it out eventually, thankyou, and for the script which is brilliant!! Can anyone suggest why I am now getting: error:2472 - you have entered an expression which has no value everytime I modify a field?? I assume it refers to an expression in dAuditTrail as nothing else has...
  12. D

    Audit Trail

    how do I get this working?? Er, excuse my stupidity, but I don't know how to get AuditTrail to work in my DB! I have imported the module dAuditTrail, but how what do I do now? I haven't a clue!!
  13. D

    filter query returns same value every time!!

    Brilliant! I knew it was something quite simple. Thanks.
  14. D

    filter query returns same value every time!!

    I'm sure there is a simple problem in my query but I can't find it. I am trying to do a simply filter query, that filters my LastName field on the contents of an unbound text box afterupdate. The query works fine the first time I run it (when I first open the db), but when I remove the filter...
  15. D

    fixing Mailing Label height w/ many fields & 'can shrink'

    Hi Trucktime, I know how to avoid printing null fields ... I am using the 'can shrink' option in text box properties in the report. My problem is that the number of fields in which potential data may be increases the label size in design mode. I have 38mm high labels and including 11 lines of...
Back
Top Bottom