Search results

Thanks for the explanation. For this database, there is no need for a users to be able to delete more than one record at a time.

No, I think I went back to the version in Message #29. While I was curious why the audit log didn't include records deleted by selecting the record selector and then pressing the delete key, I want as little code as possible to accomplish a task and knew I wouldn't be leaving any record...

jdraw, How are you? Just wanted to give you an update and ask a few questions. I'm nearing completion of my project and have implemented the audit trail code with your updates. It works perfectly. I would like to slim down the code that is not needed on some forms. If a form doesn't have...

Well, setting the detail section autoheight to yes helped but did not solve the issue completely. If there are many records in the subform the mouse wheel works fine but if there are only a few records and the last record is partially visible in the subform, the mouse wheel won't scroll down to...

The solution was to set the autoheight property of the detail section to YES.

Thank you for all of your efforts.

If I change the properties of the textbox to False, it still is not showing the whole path and file name. It's not just occurring when "Is Hyperlink" = True. I tried the new code with no change; the entire file name is still not showing. Also, the toggle button didn't change anything when...

First pop up message states . . . "Loc:C:\Users\muggs\Documents\Test File\Test Document #1.docx" I click OK Second pop up message states . . . IsLInk: True I click ok But the file name is still inserted into the text box Location truncated.

Yes, still get the Microsoft Security Warning Notice. To change the registry on ~70 machines so they don't get a warning notice doesn't sound feasible but that's a different issue. Got to resolve this issue first.

When the subform is opened standalone, it's a continuous form so there is no limit to it's length and it scrolls with no issues.

I don't understand why I would have to declare my own hard drive as a Trusted Location, however, I went ahead and added my C:\ drive and C:\Users\Muggs\Documents\ and then tried your simplified code and it did the same thing truncating everything after the "#" symbol. This data will be used...

Here are two examples of the file paths and names with a "#" and what occurs when each is clicked. C:\Users\muggs\Documents\Test File\Test Document #1 When the textbox with the above is clicked, you first receive a Microsoft Security Warning Notice, which is another hurdle to overcome. The...

Funny! At least something made me laugh today. Been dealing with one issue after another. Thanks.

No, I've never heard the song :)

If I'm understanding you correctly, you're saying that I only need the code shortened code you responded with, correct? Also, changing the "Is Hyperlink" property for the Location textbox did not fix the issue. I still cannot insert a file name if there is a "#" in the folder path or the file...

Sorry, I posted the wrong code. File textbox name is Me.Location below. Private Sub cmdAddLink_Click() Dim f As Object Dim strFile As String Dim strFolder As String Dim varItem As Variant Set f = Application.FileDialog(3) f.AllowMultiSelect = False If f.Show...

I found the below code at http://stackoverflow.com/questions/14915179/ms-access-browse-for-file-and-get-file-name-and-path. and it works except if a folder or file name has an "#" in the name it won't enter the full path and file name in the textbox. Any idea how to alter this so it enters the...

I have a main form with a subform and have set AllowAdditions and AllowEdits on the main form to No. If the height of the subform is greater than 3.1" while AllowAdditions and AllowEdits is set to No on the main form, the mouse wheel will not work in the subform and scroll through the records...

It's funny what annoys people. I will show them both ways and let them pick. I wanted to understand how to start an action from the main form to the subform. Good stuff.

That's exactly what I was looking for. I think it will be intuitive to the User that they would have to select a record in the subform prior to clicking the Edit Record button. Thank you very much.