Search results

Dear all, I have a problem that I've been trying to solve for some time. :( I have a combo box on my main form [PCP Database] which is linked to a secondary table [Well files] which contains 3 fields: a foreign key, file name and file path. The primary key on the main form "Well name" is...

Dear all, I'm sure there's a really easy solution to this, but I can't seem to find it and am getting more confused after looking through the forum. I'm trying to run a query that returns: [Pump Models], Sumof[Run time to Failure], Count[Run time to failure], and then perform a calculation...

Dear all, I'm getting really confused about how I should go about this. I have a main form and a subform. For each record in the main form, there are several records displayed in the subform. On the subform, I have a field [Cost]. I want to calculate the sum of this field for all the...

Hi, I have a main form where I would like to put a combo box that displays the file names for a particular record, and when the user clicks on a file name, that file will open. Based on suggestions on the net, I've created another table with a primary key, the file name, and the file path...

Dear all, I know there are heaps of stuff on PDFs in Access, but after much reading and experimenting, I still can't seem to find what I need. I need to have a combo box that displays a few PDFs for each record in a form, and when the user clicks on one of them, it will open up. Also, I...

Dear all, I'm not sure if this is possible or not, but I'd like to make a form which allows automatic archiving of old data when I update the form field. I've thus far created a simple Access database to keep track of all the pumps my (mining) company uses. For example, I have a pump that is...