Search results

Is it as simple as adding - Dim strSQL As QueryDef Where do I add this and how do I then use the .recordcount? Thanks

In a rostering database, I am using the following to list "Stewards" who are available to work (in a venue for a performance). These are displayed in an unbound text box called lstSteward. Private Sub cmbPerformance_AfterUpdate() If IsNull(cmbPerformance) Then lstSteward.RowSource...

This is just what I was looking for. Thanks.

I have some queries which I would like to export (analyze) in Excel. At the moment I do this by highlighting the query and clicking on the "Analyze it with Excel" button which then opens the data in Excel. However, I wish to let other people use the database and so wish to hide the database...

I have a form which has "Start_Date", "End_Date" and "TableName" text fields and I am trying to create a new table using these parameters. I have a command button with the following code - Dim strSQL As String strSQL = "SELECT StewardDetails.First_Name, StewardDetails.Last_Name...