Recent content by PHJ

Thanks Bob. You have saved me and Google many, many hours of grief. Hope I can return the favour one day, even if its just for someone else. By the way, this is a shareware membership system for (mainly) 3rd world unions that I'm building. Not sure if that matters a fig to you, but I reckon its...

Shortcut menus Thanks. Yes, this is what I'd done. What I need is some way to open this sortcut menu (ie as per your tutorial) when the application window is closed. ie the right click only works if one restores the app windom. Would there be some way of adding the shortcut window to the form...

Ahhh - worked it out. The only loose end is the shortcut menu, which won't run if the database window is minimised. Any idea what macro script I could add to a button in order to run the shotcutmenubar (ie the equivalent of a left click)?

Thanks Thanks for this Bob. I suspect you've nailed it, and so I bow in advance. But I'm not quite sure what I do to implement. Do I include this line of code in a macro called Autoexec? If so, what Action do I give? Or do I have to use VBScript somehow?

Hi I've designed a form which opens when the database opens. It contains 4 buttons linking to other forms, and a shortcut menu offering all the other options necessary. I've also hidden the database window. My question (and I've looked hard for an answer elsewhere) is whether or not it is also...

YESSSSS!!!!! You rock!!!! And again, and again, cos that's a perfect little snippet of code I'll be able to use all over the place. Thanks very much indeed.

Thanks MStef. I did as you suggested, editing the script to this: Private Sub Younionize_Rep_Click() DoCmd.OpenForm "Communications", acNormal, , "ID = Forms!Unions!Younionize ID", acFormEdit, acWindowNormal End Sub and got the error message: "Syntax error (missing operator) in query...

Hi folks I wonder if anyone can help me (a newbie) with a question. I've got a form and it has a button on it next to a field called Younionize_ID. The idea is that when you click the button it takes you to another form (called Communications), and then to the particular record where the value...