Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create and execute view using VBA
Thanks for your reply. I've enought rights to create the view. In fact the view was created correctly but is not visible until I refresh the Views Window. I think is a problem about the refresh of the database schema. I've tried calling the Application.RefreshDatabaseWindow method but it...- lradael
- Post #3
- Forum: Microsoft: Access Project (ADP)
-
Create and execute view using VBA
Hi I've a problem creating and executing a view using VBA. This is my code: Dim cmd As New ADODB.Command cmd.ActiveConnection = CurrentProject.Connection cmd.CommandText = "CREATE VIEW TEST AS SELECT * FROM MYTABLE" cmd.Execute Set cmd = Nothing DoCmd.OpenView "TEST", acNormal, acEdit When I...- lradael
- Thread
- Replies: 2
- Forum: Microsoft: Access Project (ADP)
