StevenSkub
New member
- Local time
- Today, 06:48
- Joined
- Sep 17, 2020
- Messages
- 8
I've been trying to edit an old query that I did not design but Access stops responding when I right click it and select "design view." SQL view is not listed as an option.
I have seen some people say to retrieve the SQL code using something like this in a standard module:
Function qSQL() As String
Dim qdf As QueryDef
Set qdf = CurrentDb.QueryDefs("NameOfYourQuery")
qSQL = qdf.SQL
End Function
but I am new to Access and am not sure how to do this.
Any help would be very much appreciated!
I have seen some people say to retrieve the SQL code using something like this in a standard module:
Function qSQL() As String
Dim qdf As QueryDef
Set qdf = CurrentDb.QueryDefs("NameOfYourQuery")
qSQL = qdf.SQL
End Function
but I am new to Access and am not sure how to do this.
Any help would be very much appreciated!