Search results

Awesome, it's working perfectly now! Thanks heaps. =) Stef

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

David, I'm trying to do something similar; I have a combo box which displays the descriptive names of the files and when the user clicks on them the file will open. I have the full file path, file name in a separate table from my main table, and a field: "Well name". In the main table there...

All solved, thanks! I followed your advice for the second part, but i used DLookup to get the sum of specific records (related to one main record in the main form). =) Stef

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

Hey, need just a bit more help to finish this thing up. Everything is working except that I want to display files for a particular record only. Now, when I click the combo box, it displays all the files in my table called Well Files. I have the fields: AutoID, Well name, Field name, and Field...

Thanks heaps. My problem was that the bound property was set to the wrong column AND of course the wrong code for the followhyperlink method. Thank you very much! Stef

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

Thank you ajetrumpet for your reply. I'll give that a go, but it'd be great to have just a bit more direction where to start, namely to get a different pdf opening for different records. I know the code to follow a single file path looks like this: Application.FollowHyperlink "C:\blah.pdf"...

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

Thank you very much all for your replies. Based on your advice, I think I might not try this auto archive move after all. However, do you have any good suggestions as to how I can go about updating the status of the pump without losing the previous data? I know I can query to find out which...

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