Ahh i need help!
Pretty much I have 5 or so query tables.
What I need to do is go in under design view, find yesterdays date and update it with todays date.
Heres what I have so far written under a module.
Code:
Sub findandreplace()
Dim sFind As String
Dim sReplace As String
DoCmd.OpenQuery "Aborts Step 1", acViewDesign
'this opens my query table in the design view
sFind = InputBox("Find what?", "Find and Replace sequence")
sReplace = InputBox("Replace with:", "Find and Replace sequence")
'this is for the user to enter what to find and replace with
End Sub
This is obviously just for the first query table.
I cant figure out how to find and replace it now.
Any help would be greatly appreciate!