Search results

If that is the case then change your Shell statement to use the application that you are trying to open and the name of the file with complete path like you are already using and maybe it will come up faster. Shell "msaccess.exe " & Me.Text0, vbNormalFocus Shell "excel.exe " & Me.Text0...

Not as far as I know, I've tried it this morning three different workstations and different OS's and processors and they all pop right up, but I may depend on the server your path is pointing to and the speed of your intranet. Are you trying to open a File or just open a Folder some where on...

Try this; undo the hyperlink changes you've made to the text box on the form use the DoubleClick event that looks somthing like the following" Private Sub Text0_DblClick(Cancel As Integer) Shell "explorer " & Me.Text0, vbNormalFocus End Sub Change the Text0 to what ever the name of your...

Pat, Thanks for the tip it appears to be an advanced topic that not to many people know about. It looks promissing but a full review will have to wait for Monday. Have a nice weekend and thanks again :cool: . I'm sure I'll have another question by this time next week.

Bueller... Bueller...

Yes it does, I should of mentioned that earlier, so if your thinking what I'm thinking, I need to select the unique id field in code when the link to the view is refreshed and that should solve the problem. My problem is I havn't found any examples of selecting the unique id record.

Hay all, this is my first post so go easy on me. I've done several searches and have answered most of my questions over the last week or so of previous threads on creating DSN's through code and linking new tables and refreshing existing tables. Thank you Travis, the code you posted on...