Search results for query: *

Hello, I am using Access 2010, and I have a table that contains over 2 million records in it. I need to break that table down into a more manageable size. What I am looking to do is to have a query that returns 24999 records, another query that returns the next 24999 records, so on and so forth...

PHV, that worked perfectly! Thank you!

Hello, I am trying to export a table to a specific spot on a server in *.csv format, and I am not having any luck with my VBA. Here is my line of VBA for the export routine. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tblImportUsageReading", _...

Maddonac, Thank you for helping out with that. One last question though...in order for the routine to run when the email button is pushed on the quick access toolbar, Sub SendEmail() does not seem to work unless I go and manually run the macro. What do I need to title the routine as for it to...

Good Afternoon, In Excel 2010 there is a function to send the spreadsheet you are working with to an Outlook mail message as an attachment, which works perfectly. However, when the mail message appears it does not contain my signature as it normally would if I were to create a new mail message...

Hey guys, I have a query that I would like to automatically update the criteria in it to equal values from another table. Here is the SQL for my current query. SELECT LIBE49H_MSPHDRS0.CUNO, LIBE49H_MSPHDRS0.EQMFM1, tblCntFleet.SN, LIBE49H_MSPHDRS0.SVMTHR, LIBE49H_MSPHDRS0.WONO...

Oh I agree, I was just trying to make the point that I like having the most recent versions of office documents. I rarely, if ever, put Access data into a .docx or .pptx unless I am giving a static presentation or generating instructions on how to utilze some of the databases that we manage...

I will try that approach, I have never queried out of Excel into Access before, but it never hurts to learn something new. Overall, if it does not work, it is not that big of a deal, I just like to have everything as .xlsx, .docx, .pptx, etc... Thanks again!

Nope, I only have one version of Access, I wish that I could put a screen print in here, but I have not figured out how to do that. Is there another command besides TransferSpreadsheet that I would be able to use? Thanks!

Yes, I have Microsoft Office Professional Plus which includes MS Access 2010.

I have MS Office 2010.

dhookom, acSpreadSheetTypeExcel12 does not work either, looking at the help file the highest that will go is acSpreadSheetTypeExcel9 (Excel 2000 format). Even with that I cannot get the .xlsx Any other ideas? Thanks!

Good Afternoon, I have a bit of code that exports a table in my database to an Excel Spreadsheet, but I cannot get it to save in .xlsx format, only in .xls format. What am I doing wrong? I assume that it is the Excel type that is the issue, but I cannot figure out which one I need to use. Here...

Hello, I have an append query that runs each time my VBA code is ran. This append query takes values from one table and stores it in another table for a historical record. However, if the values that it pulls have not changed from the last time the program ran, it creates a duplicate entry...

Thanks guys, the unmatched query with a few tweeks works great!

Andrzejek, For Select WONO From qryWarrWO, it returns 79 records. For Select * From tblHist, it returns 5897 records. For Select * From tblHist Where Not In (Select WONO from qryWarrWO), it returns 5689 records. There can be multiple CompCode and CPMTD3 for each WONO which is why the last...

This is the SQL that I came up with, but it does not return any results. SELECT tblHist.WONO, tblHist.CompCode, tblHist.CPTMD3, * FROM tblHist WHERE (((tblHist.WONO) Not In (Select WONO from qryWarrWo)) AND ((tblHist.CompCode) Not In (Select CompCode from qryWarrWO)) AND ((tblHist.CPTMD3) Not...

Andrzejek, Thank you for your response, unfortunatly my SQL is rather weak so a little more assistance would be greatly appreciated. The two tables that I am working with are tblHist and qryWarrWO. The records in tblHist is the complete list of records that I am working with, while the records...

Good Morning, I have two tables, table 1 and table 2. The records that are in table 1 are extensive and are the records that I need to use further in my database. The records in table 2 are the records that I want to exclude from table 1. I would be joining the two tables on the WorkOrder...

Thank you everyone, this works perfectly! Sub Exit_Click() If Workbooks.Count > 1 Then ThisWorkbook.Close savechanges:=True Else Application.Quit End If End Sub Thanks again for all of the help!