Search results

The above is not quite true! If you use a accDB (non complied) application then YES the above is true. However, if you use a compiled accDE, then the above is NOT the case. In fact, any un-handled error will NEVER re-set local or global vars. Hence, we always deploy a accDE. Thus, even...

Yes, it is differrent. Keep in mind, that you suggesting benefits arise that the form now does not have that binding information. However, all you done is move that developer workload to another location - you STILL have to do that work! Remember, I do a LOT of web development work now, so I...

So, how about another example? Well, again, software industry was maturing - but then the smartphone came along!!! And again, huge doors opened up, as many business now wanted and could use some app software (for building inspections, for delivery, for taking on site pictures with quoting...

Actually, no! If you building desktop software, then Access STILL remains a great choice!!! Access is not really fading in terms of what it can do for a given business. The simple matter is that area of the industry has matured, and thus it means LESS investments are going into desktop...

To be fair, in a lot of cases, at least coming from Access land? Often, the issue is not "general" web content, and often the issue is not SEO (search optimizing so Google can find the site). Now, the topic here WAS in regards to building sites with content. As noted, there are a good many...

Well stated.... I only pointed out the above approach (sub forms) as one great approach to building and reusing controls. And as I stated, I have in the past built a form that was driven by a table in which the colluns, their data source etc was defined. So, I've done this in the past. However...

Actually, you can use ADO or DAO. And you can as noted, created the 2 recordsets in code, start a transaction, and then bind 2 recordsets to the the form + sub forms. This "can" be done, and it' been years since I attempted this. And to be fair, I think if you only have one main form, and one...

How amazing - ah, the days of FoxPro, dbase and a few more from those exciting early days of the desktop revolution. So many of us share similar roots as yours in regards to our early beginnings. Really remarkable we talking about something about 25 years old now? (1/4 of a century!!!!). Good...

I think the issue to garner interest is you have to make a really great case as to why this approach is going to benefit the typical Access developer. So, as always, there should be a tangible benefit here, and one that developers see this, and go, gee, I want to do this! I mean, right around...

For any separate processing, since I have really great setup and ability to call vb.net code from vba? Well vb.net supports multiple threads - hence that's the approach I use. Nice, clean, easy, no shell() code, and no .dll registration required..... R Albert

Hum, I not found a issue with simply tossing the form reference out of scope. So, assuming a collection used to hold the multiple instances? Then this should suffice (assuming we use caption). So, then this: Private Sub Form_Close() Call RemoveForm(Me.Caption) End Sub And the...

Actually, if you note many times here? I just use screentogif for my posts. It's quick and simple. As I pointed out, the issue REALLY comes down to HOW you going to know when the user is finished typing. So, for example, in this dropdown, I type in the letter K - and auto complete will match...

Yes, if you going to have users type in place of selecting a value, then what I suggest? You need more code. So, you will require additional code to check if what they typed in matches a value in the list - and then you move focus. Really no other way to have some focus change if they not...

I can't add more to Geroge's wonderful post above. After all these years, 9 out of 10 times, when you try to change or fight the default behavior(s) of Access? It tends to be a bad idea..... Simply use the Change event. This one: and then the code in that on changed event: Private Sub...

You are 100% correct. As noted, with my older computer, I "really" noticed the speed difference. With a newer (and not really a high end) laptop, then that daily speed difference was not like "oh wow", was the server oh so nice. So, that server is still fast, but as noted, standard hardware has...

It is just the way it is. Now, of course we could as, what is the maxium type of hardware setup to get max performance here? Well, every day, at one clients location, I remote into a sever. How amazing and fast is this server? Well, it cost over $100,000 dollars - in fact quite a bit more...

Actually they do. And why is that? Because 99% of professional Access developers will give you the same answer I did - that's why it releavnt... The same goes if you walk into a room full of doctors, and 99% of those doctors will and should give also the same answer for a given medical...

No worries. Keep in mind that while you cannot pass parameters to a view? (unless you create a Stored procedure, and it thus can use parameters "against" the view which is perfectly fine and legal)? Well, you don't need parameters anyway (at least in most cases - some you do!!!). So, it...

For any public exposure - a VPN is a must have. I remember many years ago - in fact it was 2004. Just before going to the MVP summit in Redmond, I want to show my fellow Access developers how cool it is that you can have a Access front end connect to a database with any valid internet...

To an extent that one needs a good ER diagram for documentation, sure, Access (or SSMS) not all that great for such a diagram tool. But, it's better then nothing! And I remember when Access came out - having a diagram tool was REALLY amazing, and previous systems that had such a feature were...