Recent content by Albert D. Kallal

Actually, I been looking for a nice HTML editor - might consider using ckedit. From our web based software, we have a email template system. So, this allows us to create a e-mail template, and even ms-access (with outlook) can (and does) also use these templates. Since it's a email system...

Well, as a FYI? I think what matters most, and what will affect most developers? Why of course the properties that Access generates WHILE in form design mode, and you change the form's record source. This "effect" and "design time" creating of properties is critical to most developers. Why...

Actually, you can create a public VBA function, and thus have that return the global VBA variable, or anything else. As a result, such expressions are in fact NOT fixed, and can change, and you CAN pass values to that function from SQL. eg: select id, FirstName, LastName...

No, it can still trip up things. To be fair, in NEAR ALL cases, this is going to trigger that really slow flip into design mode (for any form, or any report -- not just the bad one). So, to be fair, I am suggesting to check this, but in near all cases, such slowdowns are not a accDE or...

Excellent follow up. 5 stars for you!! Appreciate the concise, but fantastic information you provided so far (well done!!!) Ah indeed, again your follow-up clears this up – (so, over time is you having to deal with this issue, and seeing the issue crop up – again excellent clarification)...

You MUCH have to distinguish between the concept of sharpness vs softness, and that of something out of focus. Lots of software can say add softness to a video, thus making a video look more like film. And the reverse of making a softness picture look more sharp by increasing contrast...

Ah, very good then, as this means the DDE registry settings ARE ok. Ok, then I guess a big hammer try would then be a un-install and then re-install. (really hate having to give this kind of advice - a nice "fix" would be better, but you gone through the most "obvious" solutions, so about the...

We probably could/should have started a new thread on this issue. And, not knowing what been attempted so far? Well, the "hammer" and chew up your time? Well, one could re-install, or even attempt a "repair". I most certainly noticed during the install, at one point in time one is asked if you...

Well, not my intention to be rude, if as such, then my apologies. And really, this should be great news. And the reason? Well, if everyone not having this issue, then that bodes well here - really, it does. Since, if the issue not all that widespread? It suggests that a fix is possible, right...

Your "use" case is actually quite common. So, on program startup, you check if re-linking is required. But, how do you change what location, so correct linking is to occur? Well, you have several choices. One choice I used in the past was having a local table in the front end. It had several...

First up: >>there is a SQL server over LAN Ok so file sharing, locking etc. not going to be the issue here, then right? >>I pinpointed an issue to the 24h2 update Really? Well, if this was a wide spread issue due to that update, then would not the internet light up like a Christmas tree...

I'm not seeing this issue. If I have SSMS open, and click on a .sql file (from windows explore), then it opens up with current SSMS instance - not a whole new version. And if I have a sql query window open to a given database connection? Then double clicking on a .sql file not only opens the...

What's that saying about the juice is not worth the efforts to squeeze the fruit or some such? Typing in "exec" not going to wear out your keyboard is it? ;) I don't recommend leaving it out.... R Albert

Actaully, in both SSMS, or even a PT query from Access? You don't need the EXEC in front in most cases. So, from SSMS, then these will all work: EXEC dbo.GetHotels EXEC GetHotels; dbo.GetHotels GetHotels And thus, even from a PT in Access, then this works: So, the "exec" is actually...

Ok, for sure then, start out using SSMS to create, manage, change, add, modify the tables. You find SSMS not a whole lot different then ms-access. The table designer is VERY much like the Access one. Only trick part is to setup your PK takes 2 steps, and not one like in Access. However, above...