Recent content by dajabo

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...

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...

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...

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

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...

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...

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 =...

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...

Of course! Thanks VM ...

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...

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...

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!!

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

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...

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...