Search results

I read the article that is for a query

I tried that already. says it is not available. I wish it were that easy. How do I overcome the threshold.

I have this working great however there are too many rows which exceeds the output in xls format. I would like to export them to xlsx 2010 format as well. What other options are available to get these unless using transferspreadsheet Private Sub cmdOpenReport_Click() On Error GoTo...

I need it automated so will be hands off it once Im done. Im going to try and have the original table indexed. Seems like the easiest and best approach. Otherwise I would have to write vba to auto import the table and index it daily. They do not have outlook for tasks.

Thanks Ill take a look.

I just dont want the report preview just the export excel. Report running sometimes 100,000 records will cause db to crash. I'll try to manipulate it to do it.

That works great. Thanks. What if the report is too large too many records that you dont want to open it or preview it cause the db will just crash. Too many records but perfect for export it too excel.

You were very right. I ran a test imported the data and indexed one of the signifigant fields and ran the same queries, forms, and vba and it ran so much faster. Now I just need to find out how to auto import the table daily in the morning without having outlook. Thanks so much!

duplicate records

Does anyone know how to delete the duplicates in one column once opening the data query in excel? Here is my code: Private Sub Command56_Click() Dim strFile As String Dim objXL As Object Dim objWB As Object strFile = CurrentProject.Path & "\Test.xlsx" If Len(Dir(strFile)) > 0 Then...

So your saying instead of linking to the table directly, import the table daily into the database and create indexes on the table daily?

I found this and think it is likely the method to run a query through a multi select combo box on a form and would like to know how to get it to expoert out with the docmd transferspreadsheet. Private Sub cmdPrintLabels_Click() Dim strSelected As String Dim strWhere As String Dim varSelected...

Ive done everything I could to fix this issue. Is there any way to hide the Not Responding message?

How should I handle it and I index it? I dont have control of table as it is linked. It is one table with about 20 fields. Queries are run from the one table. I only have oroblem when running queried through forms

The report method I got to work but Im dealing with bulk data. I found this on a query. I suppose this would work if I configure it. Private Sub cmdOpenQuery_Click() On Error GoTo Err_cmdOpenQuery_Click Dim MyDB As DAO.Database Dim qdef As DAO.QueryDef Dim i As...

I have to run it off of queries with this. DoCmd.TransferSpreadsheet acExport, 10, _ "qryPlanTypes&EffDate", CurrentProject.Path & "\Test.xlsx", True MsgBox "Data export completed", vbInformation, "Completed" Do you know what parts I change from this? Private Sub cmdOpenReport_Click() On...

At first I didn't see the file but looked at it so the vb makes more sense. I saw a couple methods so wanted to see it straight forward.

I saw that. Thanks

Here is the SQL SELECT All_Cars.[Sub #], All_Cars.[Name], All_Cars.City, All_Cars.State, All_Cars.Zip, All_Cars.[Term Date], All_Cars.Plan, All_Cars.[Plan Name], All_Cars.[ Eff], All_Cars.MFORM, All_Cars.LMAT FROM All_Cars WHERE (((All_Cars.[T Date]) Is Null) AND ((All_Cars.[Category...

I have to create a report with a list box which a user can select multiple fields which will run on the query. The field is called Category. Category A, B, C, and so on. It is pretty straight forward with a combo box with just one choice. Any one done this before?