Search results

Thank you, I tried, it says arguments not optional..

Thank you for the reply. The message box was blank. No message.

Thank you everyone for your replies. Still I am not able to open the subfolders. Here is my code I tried. Shell "explorer.exe /" & """ & txtLink & """"", vbNormalFocus The text box txtLink has the path (C:\Users\Joel\MyDocuments\Cases\2020). It opens only the MyDocument folder. Thanks...

Please let me know how to open subfolder from access form. I am able to open MyDocument but not able to open MyDocument /Cases/2020 Thanks for your help

Thanking you all for the help extended

Thank you very much. Thank you for your patience. As Cheekybuddha said, I added a backslash, which was missing. It works now. Thank you all for your time and help.

Very sorry, text0 is wrong. It should be txtFolderName. I copied before changed.

Thank you. I am getting error: Run time error: 75 Path/File access error. I tried even in the local folder: Private Sub Command2_Click() If Len(Text0 & vbNullString) Then MkDir "C:\Users\Joel\Documents" & Me.txtFolderName End If End Sub

Please let me know how to create a folder in Windows Explorer from access form command button if possible. My folder name will be in a text box named txtFolderName. The path will be: s:\\cases\2020 Thanks for your help. Let me take this moment to thank all the genius in this forum who are...

Thank you very much. The code works. I will also look into Cascading combo box. Thanks you both for the replies.

Please let me know how to populate one combo box with the field from a table based on the value selected in another combo box. I have two combo boxes, one for States and another for counties ( which is a field in a table) Please let me know how to populate the county combo box based on the...

I am getting type mismatch error for the following syntax. Kindly let me know what I am missing. When I remove the and City Like "" * " & Text49 & " * """ there is no error message. Thanks. Dim dbs As Database Dim rst As Recordset Dim myString As String On Error GoTo errorhandler Set dbs =...

All documents are required. Yes, each combo box has data field attached to the underlying table. And also correct me if my table structure is wrong and how it has to be designed. Thanks.

Thank you. It is for a law firm. The firm receives a set of documents from the client. I have a document checklist form which is used to check whether a specific document ( say, marriage certificate), is received or not. The checklist is for around 25 documents to be received from the client. An...

It looks like a generic email stating the pending actions to be completed. If it is incomplete, an email is sent to the client, fetching the email from the email field in the underlying table. Thanks. I would appreciate if I can get the complete code. Thanks.

I have 6 combo boxes (Combo1, combo2 etc.,) in my form. Some have value "Completed" and others have "Incomplete" I wish to loop through these combo boxes and trigger an email for the Incomplete ones. Please let me know how to do this. Thanks.

Thank you so much.

Is it possible to get populate access combo box with the data from an excel column? Please let me know how to do that if possible. Thanks for your help.

Thank you very much to all. I will try this one. I do not know how to do what pbaldy said. Please let me know when time permits. Have a good weekend to you all.

Thank you. It can be 16:00:30 or even 16:01:30 ?. Yes I will sending an attachment. A query.