I have a form where I want to browse for the directory path and display in a text box.I have done something similar to browse for file and display, but this time round I need only the directory path to be displayed .Need help on this.
I have a statemtn like this
DoCmd.OpenQuery("UPD_RECEIPT_IMP")
When I run the above, it pops up the input box for user to key in the argument.
How can I stop this and pass the argument to the query in macro
Need help on this.Thanks...
I have a script as below :
Public Sub DoSQL()
Dim SQL123 As String
Dim TEST As String
TEST = "23/01/2003"
SQL123 = "UPDATE AR_Invoice " & _
"SET AR_Invoice.IMPORT = 'Y' " & _
"WHERE AR_Invoice.InvoiceDate = '23/01/2003'"
DoCmd.RunSQL...