Search results

Thanks but that is not really practical for a working application. Really need the 'frame' to act like an explorer window. In other words, if I use an Image Control, it only works for images. That is not what my client wants.

Yes. A continuous form of linked files and images. The path is the image control source of the path. I guess I need something like an explorer control.

I am using the Image Control to show a thumbnail of an jpg file. This works fine. Is there any way to show the file tiles or thumbnail for (say) a Word document, .pdf or Excel file? I cannot find anything on the web. Many thanks :)

Love it arnelgp That is elegant!

Very helpful. This is what I have used. Private Sub Form_Load() On Error GoTo Err_Parent Dim str As String str = Me.Parent.Name ' It will error at this point if No Parent exists cmdClose.Visible = False Exit_Parent: Exit Sub Err_Parent: If Err.Number = 2427 Then cmdClose.Visible =...

I have a form that I use both as a continuous Form and a continuous SubForm. There is a Close button on this form except that I hide this button when the form is being loaded as a Sub-Form. The way I do this is to use the cmdClose.Visible code is put in the Load event of the form a check to...

Thanks: - put a Me.Requery into the Close button code on the main from and that seems to have fixed it.

I have a continuous form of Quotations (as a summary) where d/c one of the controls opens a particular Quotation as a main form. The Quotation mainform has a sub form for all the quotation components including Totals in the footer section of the subform. The total is brought back to the main...

In Ridders post above, DevHut suggests that MS will distribute a fix in Sept17. I have not seen it yet. Does anyone have anything further on this? Thanks

Re: Continuous Form not Scrolling since Windows Update Thank you for your reply. I was aware of the several posts on the forums on this subject. I have also seen the code workaround. However, I and my clients have been using Windows 10 and Office 365 for quite a while and up until last week...

I believe there is a problem with a recent Windows Update. On or around last weekend (19-Aug-17), I noticed that my Continuous Forms no longer scrolled using the Mouse Wheel or by Sliding the Vertical Scroll Bar. Since then this same problem has been noticed by 2 of my Clients using my...

Microsoft logic never fails to surprise me. Apparently the code above is a Toggle so if the ribbon is already minimized, then the same code CommandBars.ExecuteMso "MinimizeRibbon" maximizes the Ribbon. :banghead: So I now use the following code in the Switchboard Load event on applications...

I have an application where I need to Minimize the Ribbon to load a rather large form using as much of the screen as possible; but I do not want to hide it. As such I use the fooloiwng code in the switchboard load event. CommandBars.ExecuteMso "MinimizeRibbon" The problem is when this...

I have a form with about 30 combo boxes and I am wondering whether putting them into a Collection will allow me to address each individual Combo's event property through the Collection rather having to code up each individual control? For example Private Sub Ctl1_1_KeyPress(KeyAscii As...

Can I reinstate this as we got side-tracked and I still do not have a solution - thanks.

Don't think so. I am running 2016 and have been using Environ for years.

You will have; it is a standard feature for Rich Text boxes in Access and Word too. Tyr typing some test in a Word doc and then highlight the text. The intelli-sense formatting box will pop up.

Environ("UserName")

It has been around since 2007, I think. You have a Rich Text box, just highlight some text and it pops up. Does the same in Word too. Surely you have seen this?

As it is a Rich Text box, a little formatting box pops up. That is my problem; the font name and size could be changed