For some reason, my code below for DoCmd.RunCommand acCmdCopy is not only copying the text box contents into the clipboard but also opening a folder on my network (where I can then Ctrl-Paste into the Search box in the opened folder). I am now trying to change the folder location (new year) but cannot remember how the original folder got opened (so I can change folder name).
My code:
' Copy to clipboard provided by KingsSolution.Org.UK
Me.Source_Ref.SetFocus
Me.Source_Ref.SelStart = 0
Me.Source_Ref.SelLength = Len(Me.Source_Ref)
DoCmd.RunCommand acCmdCopy
'End code from KingsSolution, above.
Now that I am trying to answer this question, why does this DoCmd.RunCommand acCmdCopy even open a folder ??
Thanks for any help on this. I have googled and searched Tek-Tips with no helpful results.
Jeff
My code:
' Copy to clipboard provided by KingsSolution.Org.UK
Me.Source_Ref.SetFocus
Me.Source_Ref.SelStart = 0
Me.Source_Ref.SelLength = Len(Me.Source_Ref)
DoCmd.RunCommand acCmdCopy
'End code from KingsSolution, above.
Now that I am trying to answer this question, why does this DoCmd.RunCommand acCmdCopy even open a folder ??
Thanks for any help on this. I have googled and searched Tek-Tips with no helpful results.
Jeff