Recent content by exRP12Nuke

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!