Recent content by mlai08

What would happen when it goes to ErrCorrection? The problem is when the error occurs, the process stop and Excel worksheet does not show up.

Hi there, I got the subject runtime error on and off when I run the following module in Access. This error only appears when there is already a Excel worksheet opened on my computer but this is not a regular incidence, meaning that I don't always get this error even with the existence of another...

Finally, I figured out how to make the codes work by using the shortcut's Arguments properties. Public Sub test_Click() Dim WSHShell As Object Set WSHShell = CreateObject("WScript.Shell") Dim AccessPath As String Dim MyShortcut As Object Dim FEpath As String Dim ClientDirectory As String Dim...

Unfortunately, the code gives an error of "Invalid procedure call or arguement". :confused:

It creates a shortcut with invalid path - "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE\officeblrgrp2.office.adroot.bmogc.net\Int_Tech\Technology Resource Repository BE\Intake Test.mdb \cmd 2" In order to make it works, we need the path properties to show - "C:\Program Files...

Yes, I know that. My challenge is how to get rid of the last " on the Target path under the shortcut properties. The coding path has to always in the format of ("......") and must end with " to make the code works.

I got this shortcut target path under the Target properties "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE \officeblrgrp2.office.adroot.bmogc.net\Int_Tech\Technology Resource Repository BE\Intake Test.mdb\cmd 2" when using the following code: MyShortcut.TargetPath =...

I changed the codes and replace workfield with the actual path but it still does not work. No error but no shortcut is created on my Desktop. I could direct the shortcut to another folder once it works on my Desktop.:confused: Set MyShortcut = WSHShell.CreateShortcut(DesktopPath &...

The error applies to MyShortcut.TargetPath = WSHShell.ExpandEnvironmentStrings(Workfield) I manually ceated a shortcut on my desktop and it can open the form with specific record # 2 Shortcut properties: Target = "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"...

I have applied codes found in the internet to create a shortcut from the Intake request form as below, using a click event for testing purposes. However, I got an error "invalid procedure call or argument". Can you please advise what I have done wrong? The ClientDirectory path points to a...

Thank you for everyone's comments and suggestions. I might not have made my requirements clear enough. Under vbaInet's example, is the shortcut creation on User2's PC an automated process? There are numerous User2 who are managers in our organization. We would try to avoid their involvement in...

Yes, I can create a shortcut to pass the command line parameter to open a specfic form but it does not work in my case. The idea is for the user to receive an email with a hyperlink containing a variable, i.e. an ID to open a form with a specific record. As such setting the hyperlinik to the...

I am investigating on the possibility of setting up an approval process for our employee intake procedure by using MS Access and Outlook. The idea is for the requester to open an intake form in Access and fill in the new employee's information and send an Outlook email to the manager for...

I am considering the possibility of revamping the employee onboarding & off-boarding process for our organisation to make it more efficient. Current State: We use InfoPath forms in SharePoint Servers 2010 to handle onboarding/employee change/off-boarding requests submitted by the related...

That makes sense. Thank you again for your on-going help and advice.