Activity Stream

I understand having multiple instances of a form. My point was that no matter how many forms you have open you are only running code in one of them...

Here is an example, if we're talking about the same thing, of P1 (MyForm2_3) running two instances at the same time.

DP - but this might link might help: https://www.reddit.com/r/vba/comment.../async_in_vba/

what does the error message tell you? edit - a simple google will tell you all about listbox properties...

Hi CJ How am I supposed to Declare itm? Tried this Private Sub cmdInsert_Click() Dim db As Database Dim RS As Recordset Dim Itm As...

why do you think that when you said itm was highlighted? as far as lngitem is concerned, you are not using it, so doesn't need to be declared. But...

If you reset the code anywhere it will destroy any global variables. Access is (as far as I am aware) completely synchronous within it's own...

Hi CJ This is where my lack of VB knowledge lets me down I thought that the Variable Item is the BookingID Do I need to Dim lngItm at all ? as...

While poking around to see if there is a way to do it with VBA extensibility, I noted a post from Chip Pearson basically saying he has tried...

Okey, this is my third attempt to write something legible to your post. I'm with you, up to a point. Trying to figure out if Access isn't...

Suggest you add Option Explicit at the top of your module as a standard practice. Then, Access will point to your error. As CJ said you have...

look again

Hi CJ I tried this but it gives the same error? Private Sub cmdInsert_Click() Dim db As Database Dim rs As Recordset Dim lngItm As...

error message is telling you the problem - you have not declared itm

Okay, so after hours of revisiting this ancient problem, I decided to make a hand-drawing (my apologies, I'm not a graphic artist nor great with...

Colin, I just downloaded the 32bit version and tried to run it and AVG reported as below?

Personally, I avoid any solution based on SendKeys as these are notoriously unreliable, particularly after version changes. As well as the...

In my opinion if more than one process can set the same Global and have different consequences, it's no longer suitable for use as a Global, it...

If you have MZ-tools there is a command button for that. Very useful.

Hi June I am trying to help Sam in resolving this issue and in the On Click Event he has the following Code but when he runs it he gets the...

If someone else is in the same boat someday, this video might help: https://youtu.be/qc-7uYr7kHE

I'll have to try that again, if I recall correctly, it left the cursor way down there, so then we need a trick to get it back to the top. There...

I never use send keys so couldn't tell ya. Since the immediate window is limited to a couple hundred lines Dim i As Integer For i = 0...

That did it, I knew it was probably something simple. I just couldn't find anything telling me that.

I think you'll need to provide a bit more specific info on where this desired dropdown is to be used; in a combo box control (which is what is...

Already done :).... Cheers,