Search results

I am trying to import an excel worksheet into a new Access Table using the following code: Private Sub ImportXLSheets() Dim WrksheetName As String Dim i As Integer Dim xl As Object Set xl = CreateObject("Excel.Application") xl.Visible = True xl.Workbooks.Open "T:\FINANCE\Man_Acc\Month...

Not sure what Sub you mean. I've shown the code that is run when you click the button.

Yes, the code is called on the click event of the button on the form. I'll try your suggestion. Thanks

Here is the VBA code to run a stored query called 'qry Divisional Analysis Month End Rate' Sub GetMErateData() 'Displays all ME rate data DoCmd.OpenQuery "qry Divisional Analysis Month End Rate" End Sub I don't understand your suggestion regarding creating a form and setting a datasheet...

Hi, the query works fine if opened from the normal query window. When prompted for a date, I click cancel and I don't get an error message.

Yes, its a select query based on a date (which it prompts the user to enter). Thanks

I have a query which prompts the user to enter a date. Using the following VBA code, which is assigned to a button: Sub GetMErateData() 'Displays all ME rate data DoCmd.OpenQuery "qry Divisional Analysis Month End Rate" End Sub When the prompt appears and I click cancel rather then...