Search results

jdraw, That's what I'm saying. If you delete record 722, it's recording record 723. At the bottom of Martin Green's tutorial are two samples in zip files. I'm interested in the AccessAuditTrail_Detailed version. It seems that the AfterDelConfirm triggers the Sub AuditChanges but by then...

Arnel, I love the changes you made to this code to make it more comprehensive. I implemented the same code from http://www.fontstuff.com/access/acctut21.htm only to discover that it's recording the incorrect ID of deleted records. When you delete a record, it records the RecordID of the next...

Thanks for your response Ranman256 You can disregard. I found the solution on another site. Listed below. Me.NameOfSubform.SetFocus Me.NameOfSubforml.Form!NameOfControl.SetFocus Boy that was a pain. I didn't realize it needed one line of code to set the focus to the subform and then...

There is a tab control that you can add pages to (I have four pages) and then each page has a subform on it. It seems that no matter what code I use, it still tab stops on the Tab Control so you have to tab twice to get to the first page. When I use the Builder to identify the name of the...

Hello all, I have exhausted my searches for help on this matter. I have a main form, a tab control with four subforms on the tab control. I would like the focus to move from the last field on the main form to the first field on the first page of the tab control. I have tried using the...

That was the issue. The FileServer field wasn't included is the search queries. All is good now. Thanks again.

Oops, I did discover a glitch. The main form has an OnCurrent event (code below) that is displaying an error on the first line of code when I perform a search by clicking a cmd button (second set of code below). Private Sub Form_Current() If Dir([FileServer] & Format([ID], "\00000") & ".pdf")...

I saw how to mark it as SOLVED.

sneuberg, SHAZAM! It worked perfectly. I can't thank you enough. Now, I need to review your code and learn from it. I'm new to the board. Is there something I should do to mark this thread as SOLVED or is there some way to give you credit? I may be posting another issue after I do some...

arnelgp I played with conditional formatting but couldn't get that to work either. What would the expression be to check if a file exists for conditional formatting? Putting the command button is not an option since some records will have multiple records in the subform. Margaret

sneuberg, For some reason it's not picking up the second to the last segment of the path; the ADNo. ADNo is a field in the table and the query. C:\Users\muggs\Dropbox\Project Support Solutions\Tools\Agreements Database\Agreements\00001-.pdf

Thank you for your response sneuberg, I have created a module and entered the code below. I changed it a bit because I'd like a ? to display if the file doesn't exist and a PDF if the file does exist. Not sure I changed it correctly though. Also, I think I confused the matter by including...

Thanks arnelgp. The code I displayed was an example and works fine but the same code with different command buttons doesn't work on a continuous subform. My question is really about how to implement similar code on a continuous form and if that won't work, how can I implement the same idea in...

Hello all, I am in need of assistance. I'm updating an old database. Each record in the database has a corresponding .pdf document that is saved in a folder outside of the database on a file server. A separate table in the database contains the location of the storage folder for all of the...