Search results

I fave an sql string that takes it's input from a couple of tempvars. The input for one of the tempvars is Sp. 'Yarawah' from a table field, so the tempvars.value presented to the sql string is "Sp. 'Yarawah'" The single inverted commas are part of the scientific name. db.execute crashes with...

That's exactly why it's in there.

I wondered how long that question would take. I am scanning about 14000 jpg files and the same number of nef files. I recover the file name and the full path to each file using a recursive search. If I search an external drive, that has a full copy, it takes about 30 seconds but connected by...

Removing the docmd from the load event and placing it after the loop statement looks a bit tidier. Private Sub CloseMe() Do DoEvents Loop While Not bOut DoCmd.Close acForm, Me.Name End Sub

I don't think that will work. there is nothing to keep the form open That doesn't work. There is nothing to stop the code running past the end sub of the load event. Calling the loop from the load event effectively halts the flow. John

A simple work around. The form is now popup on modal off and opened with Public Function Messenger() As Boolean DoCmd.OpenForm "messenger" Messenger = bYN End Function I have modified the form's code to become Option Compare Database Option Explicit Private bOut As Boolean Private...

As a matter of interest, I've just created a blank form and set modal on is blocking program flow. I will rebuild the form and see what happens. I will also try Arnelgp"new code. I offer my thanks and gratitude to all. Watch this space. John

I think I'm stuck with the form the way it is. I might have to write a loop around the buttons, or the form, that goes nowhere until a button is clicked. I have implemented Arnelgp"s code, with the module and without. The form is accepting "modal on" but is still not stopping program flow. Can...

I didn't fully answer you. The form is a standard single form, albeit resizable in width depending in the length of the strings.

I didn't "achieve" that, it's just the way it is.

Thank you. It's bedtime, I'll have a look in the morning. John

Contrary to what this say's, setting the form's "Modal" property to on is having no effect on the form's behaviour

As you can see, the form requires the "Yes" or "No" button to be clicked to direct program flow. Without acdialog and with popup and modal on, this does not happen.

If I don't specify acdialog then the form does not stop program flow, it just sits behind the next form that opens.

Maybe I should clarify. I am not talking about a textbox or combobox label. There are none on the form and they are easily controlled with code or in properties. I am talking about the "label", "caption" on the form that say's "Messenger" and the green bar on top of the form. That is what I want...

Sorry Arnelgp, you've lost me. If I open with acdialog, why would I need to check what I already know, and how does that make a difference to the form? This is the function that opens the form. "bYN" is a global boolean variable. Public Function Messenger() As Boolean DoCmd.OpenForm...

If you look at the second screen shot you will see control box is no, close button is no and there is no caption! Not much left to do there.

All my forms borders are set to none. This label and bar only appears on forms that are set to acdialog.

The small form pictured below, requires an input before the program can continue. If I set it as popup and modal it does not stop the program unless I also set "acdialog" in the docmd.openform statement. Acdialog puts the form on top and stops the program regardless of the popup and modal...

I'm running Access 2016 and currently running an update. I am writing the sql in the vba editor. OK. I've run this after the update and it seems to be working properly now. Apparently some sort of bug in my setup. My apologies for wasting your time and my thanks to all for your efforts. You are...