Advanced Search

Return to Snippet

Revision: 24432
at March 1, 2010 16:03 by CaptainProton
Initial Code 
Private Sub createQuery(name As String, sql As String)
  Call deleteQuery(name)
  
  Dim queryDef As DAO.queryDef
  Set queryDef = CurrentDb.CreateQueryDef(name, sql)
End Sub
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This method creates a query with a given name and given SQL.
Note: Requires the deleteQuery(String) method.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
createQuery(String, String)

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, query

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
Visual Basic