Recent content by Craig6

I put the code (Me.WebBrowser282.Object.Navigate Me.text285) on a form timer along with a cancel code after 2 seconds so it now displays the contents when it's loaded and they stay visible. A bit Heath Robinson but it works!

If I select the webbrowser control field and select View, I can change the view from large icon to details but when I go back a folder this resets. I cannot see anyway for this to default to details view.

Just an update; I am now using your code above (thank you) but I have had to put it in a command button because for the life of me I cannot get it to execute on anything else other than by clicking the webbrowser field (onclick) or a cmd button. So, this is the best I can get it so thanks for...

That worked just the same as the other code. So still no ability to go back to the folder I just left.

I'm not sure what it's called but I got it from the standard design toolbar in Access 2016 as shown in the picture below. I tried what you suggested and it worked. Thank you! However, it's created another problem that I thought I had overcome before. So, when this text box is updated the...

Just to add: Can you also tell me why is it that when I close the form and then open it again it works perfectly? What happens in that process that I can't replicate whilst staying in the form? The picture below shows my Control Source for the WebBrowser. As these fields aren't populated when I...

Thank you for your replies. I tried both (which are very similar if not the same) and I get a compile error: method or data member not found with the .Navigate section highlighted.

Hello, I have inserted a field on my form using the 'web Browser Control' tool. In there I have linked it to a file path on my server. The idea is that when I select a record this field displays the folders that are in that file path. This allows me to get quick access to those folders and the...

Right, I found this piece of code for the DLookup and inserted it before my original code to check if the record exists; If DLookup("Me.SupportType.Column(3).SupportID", "tblRemedials", "SupportID = " & SupportID) > 0 Then MsgBox "This card already exists" Else DoCmd.OpenForm...

I've found a piece of code for DLookup so i'll have a tweak of it and see if it works. Thanks

I can see this growing and growing then. I suppose a contact will have more than one number but I could just create fields in the table called, Phone, Mobile, Home etc?

Hi Cronk, Since that picture of my relationships I've removed the redundant Customer field and added ID to the SupportType in the tblSupport. I'm in the process of adding the name to the ID for the PK in the other tables. However, I haven't got on to omitting the multivalue field in...

Yes, my customer table will have many contacts in the contact table and will be related. I've now created a contacts table and linked it to the customer table. Thanks

I'm googling it now! and will probably be back haha

Wonderful!! I really appreciate it. With this I can now open a form based on the combobox selection and create a new form with the auto populated SupportID in there. :) I just now need to build in an error message for when the form already exists with that SupportID or else i'll get multiple...