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...

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", _...

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...

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...

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...

Hello, I am trying to write some code that closes out of Excel when a button is pushed. What I am trying to accomplish is to close the activeworkbook while leaving other workbooks open if there are additional workbooks open at the time that the code is ran; otherwise if the only workbook that...

Hello, I am building an Access program, and when I try to sort one of my final select queries using the drop down menu, it tells me "Invalid scale for decimal data type." I have looked around Access websites for some help, but most of what I was able to find was about setting the data type in...

Hello, I am building an Access program, and when I try to sort one of my final select queries using the drop down menu, it tells me "Invalid scale for decimal data type." I have looked around Access websites for some help, but most of what I was able to find was about setting the data type in...

Good Afternoon, This problem would seem to be a simple calculation, but I am finding that it is proving most difficult. I have an access table that I need to find the total hours on a component by subtracting two different values in two different rows. If this was only going to be a one time...

Good Morning, I have a quick question on how to streamline some VBA for excel. This is a long repetitve chunk of code that I would like to minimize and I have had no luck with my knowledge. I pull data off of our local intranet at work and it does not come off in the order that I need it to...

Good afternoon, I am trying to find and select rows that are less than a particular date. Here is my code so far T1 is the date that I am trying to find. Sub MoveData() x = Range("T1") Dim LRS As Long Dim Dx As String Range("H:H").Select If...

I have been placed in a job that requires a strong working knowlege of VBA, mainly for Access, but also at times for Excel...the only problem is that my working knowledge is not as strong as I need it to be at times. I am working on putting together an Excel spreadsheet that automatically...

I have been placed in a job that requires a strong working knowlege of VBA, mainly for Access, but also at times for Excel...the only problem is that my working knowledge is not as strong as I need it to be at times. I am working on putting together an Excel spreadsheet that automatically...