Recent content by rmccafferty

They actually ran one of their ads in a way that makes it look like it was part of my post? Come on, folks. How about a little integrity here. I understand the need for revenue, but that is over the line when you make an ad look like part of a post.

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

In short, I want to run append queries in Access that will get data from an ongoing string of excel spreadsheets. By ongoing, I mean that they will continue to arrive over a period of time. In time order, here is what I foresee happening: 1. On day 1 there will be a number of spreadsheets...

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 guess I have the same question regarding putting the subform in the footer. With I see first client 1 and its subform (line item details), then client 2 and its subform, etc? Or will the user have to keeping pushing something for next record to see successive clients that are returned by the...

Maybe I do not understand continuous forms. I thought I needed a continuous form to show multiple sets of records. That is, my query is going to respond with line items for maybe 10 clients. So if I set it up the body of the form with something like: Client1 (sitting on a line by itself)...

I first put in the subform and then tried to make the primary form Continuous and I got an error message specifically telling me that you cannot make a for continuous if it has subforms. Then I tried looking it up (I forget if it was in one of my books or on line) and seemed to find...

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