Search results

Well, at some fundamental level, actually it does matter. Since if it did not, then you would not be asking this question, would you? In other words, a big reason exists for this goal – and that goal is 100% centered on some data being changed. As I stated, if it did not matter, then you would...

I think the REAL question is what do you want to occur when that data changes? And who, and how and why did that data get changed? So, you could I suppose setup a database trigger, and if that change occurs, then "more" or additional data processing could occur, including that of say a email...

True, but you still free to make asynchronous calls - even with CreateObject(). I mean, if you want to call a long running SQL stored procedure? You can make that call as synchronous, and the VBA code will wait. Or you CAN make that call as asynchronous - the code will NOT wait!!! So, no...

Well, the MSXML object does not support "sunk" events in VBA, but you CAN STILL call the MSXML library code as "asynchronous" I suggest this code pattern for a 10 second timeout, and if it takes longer then 10 seconds, then you bail out - and do so without a freezing UI. Sub Test() Dim...

You are correct, but the REAL issue is in fact the data engine. So, think of a old 8 bit game, or even a PC game back in the DOS days. You had multiple things moving on the screen, you could use your arrow keys, and "everything" seems to continue updating. No UI lockup's, is there? Access has...

Well, first of all, if you do a lot of stuff, then the Access UI will lock up. There ARE some threads, and don't confuse that of "threading" models vs that of multiple processor tasks (often the term task and thread are mumbo jumbo up here). >So then in Access, how do you fork/exec a new...

I suppose it depends on the GUI + the process....... Linux land often is working with non GUI, and when the GUI "does" try to do something, then VERY often it's another separate process being kicked off. And Linux does not have a single GUI manager like windows. So, there's no real "nanny"...

Just re-set (re-apply) the path name to the control. Works for me. eg: Image1.Picture = Image1.Picture R Albert

No doubt - you had well noted this was a external type of drive....(and still VERY fast!). All in all? Well, over the years I always seemed to have hardware that was lagging behind the software. And by the time I would get a new computer, then all of the software bloated so much, I was back to...

NVe drives are even faster. Even on my laptop, without a raid drive? I often see this: And windows is "ready" for the future, since as you hit about 990 mb per seconds? Then it jumps over to gb/s, such as this: Imagine that - 1 gb per second!!!!..... And my setup is by no means a fast...

Well, how cool is that! I did not realize that both the client and server were Access here. I had "guessed" that you were communicating with some type of machine (photo copier, press machine, or whatever). The fact that both ends are Access? Well, then that would/should facilitate some testing...

Ok, I wish I had some example for you! It's not hard to build the .net class (use vb.net - code is much like VBA). So, in theory, you would use the .net sockets (System.Net.Sockets) So, not clear if you using TcpClient, networkSteam, or Socket? So, you can/could create a .net class, and...

Well, we have two goals: First goal, find some kind of code or "thing" to replace the OCX. 2nd goal: eliminate current polling that you have???? So, we have to keep both of these things somewhat "separate" for our goals here. So, you may well not need some kind of "polling", but if you looking...

I would suggest using the vb.net sockets, and then call that code from VBA. It's not clear if you using the ActiveX controll (dropped into a Access form), or using the TCP library direct from VBA? Over the years, going back to VB5, VB6 days, and even now in .net? I never had to use TCP library...

Really do appreciate that article - thanks for sharing that. Only a few minutes to read - but over a 1/4 of a century! Sends some chills down my back.... Like opening a old high school yearbook! Have to think that a97, a2003, and a2010 where those "really great release" years. Again, thanks...

Golly, version 1.1? I remember "trying" 2.0, but it was Access 97 was when I jumped in! Regards, Albert Kallal Edmonton Alberta, Canada

Yes, you are correct!!! (happy to be corrected on this issue == thanks for the follow up). So, ignore my "narrative" on needing some extra textbox or control to receive the focus - not required. So, good = don't try to use the UI for this - use recordset data processing. So, bad = my bad is...

As a general rule, no, if there are no other controls on that form, then hitting tab will not fire the after update event. However, in this case, we MOST certainly have another control on the form - that's the sub form control! And that means that focus is now moving from main form to sub...

Excellent! And the UI will be smooth as butter for this operation...... And like everyone else here? Just adding my 2 cents worth here..... As noted, if there is only one control on the main form, and when that "scanner keyboard" hits tab for you? Make sure there is another control on the main...

A few things - but just a quick look here at what we have so far? First, don't use on-current - avoid if possible. Next up, a goToControl is placed/moved to the sub form. I suggest to NOT do this. So, keep/write ALL of the code in the main form - don't use the "UI" to set focus in sub form...