Search results

We have people in the field collecting data about buildings into multi-tab spreadsheets. (between 10 and 20 tabs total). We then want to copy this data into Access. I might try to do this a bit differently if given a choice, but I have no option but to have data collected in Excel and for...

I need to append data from a spreadsheet (many spreadsheets over time) into an access table. There are several aspects of this I am not sure how to do. First is that the spreadsheets have many tabs and within each tab are “tables” that contain the data. Thus, I believe that I need to...

I need to do two things in VBA that I do not really have a clue how to do and am hoping for specific advice. Fist, I need to use the DIR function to loop through a number of Excel files, perform actions from them one by one, then end the process when each file has been processed...

I need to import data from spreadsheets into Access on an ongoing basis. I know how to set up the queries themselves. But there are 2 things I do not know how to do. 1. I would normally tell the query where to look for its data, that is the name and location of the spreadsheet. But I will...

I am trying to subtract one field from another. At the moment, there are values in one field, but not in the other. Thus, the result of the subtractions should equal the values in the field has entries. Both of these selected "tables" for the query are actually sub-queries that total invoice...

I have an application where I need to return all records from two tables (actually, predecessor queries). My goal is to see the difference between two different calculations of what should have been the same data. But in some cases, the data was not calculated in one or the other of the two...

I am building an app that at one point compares two versions of the same records. That is, the data in question is input at two different times in two different databases. I import the version on a mainframe into an Access application in which the other input has been performed. (Sadly, the...

I need to know how to use a table-field reference in the criteria for a query result. I want to see all records where field 1 is different than field 2 by a certain variance amount. I do NOT want to enter this amount as a number each time the query is run via a parameter query for reasons not...

I have an application where the salesperson enters sales orders into a local Access application, including all the normal details one would expect. They are nearly always new customers that are not yet in the corporate computers. These same orders are submitted to the company who enters the...

I need a form that looks essentially like the below (ther are more field, but the following should be enough to get the idea). I need a form, not a report, so that the user can check off one field to mark when entries are processed. I need it to be based on a query to pull enough fields The...