Search results

Keep in mind that to get the next recordset, you MUST use the current recordset!!! (this explains why you only get the 2nd one). So, WRONG: Set rs2 = rsMaster.NextRecordset Set rs3 = rsMaster.NextRecordset ' WRONG CORRECT: Set rs1 = rsMaster Set rs2 = rs1.NextRecordset Set rs3 =...

Sorry - been very busy this week. How old of a DC reader did you try installing? VERY unfortunate that the link I provided? Well, even FileGozzilion and a few other sites providing "older" Adobe readers? They been scrubbed, and NOW when you hit the Adobe site, they have removed those older...

So, in summary: Access web control NEVER could display a pdf - regardless of browser installed. Access web control STILL requires the AcroPDF.dll, and you thus MUST install a version of Reader DC 2021.x, or previous....... My sincere apologies for having provided the WRONG Adobe link to...

bump my post - see edit that first link was WRONG WRONG -- my bad....... Must be 2021.x, or older -- 2022 Adobe will not work.....

Above is correct, but still in ALL cases, the browser control in Access ALWAYS did require the Adobe plug in.... Did you try installing the older legacy Adobe reader? Has to be a older legacy version that includes AcroPDF...... I'm just going for coffee, and I have that win 11 vm. It has no...

This MUCH sounds like a issue that would/could be fixed with a persistant conneciton. I mean, the poser ALREADY has shared and stated the application runs speedy and fine with one user. But, with MORE then one user, then it runs slow. This time and time again is thus fixed by a persistent...

Ah, very well. Of course the legacy IE access browser control actually does not have PDF ability built in. It relies on AcroPDF.dll, and that's been removed from newer installs of windows 11........ So, if you install a older version of Adobe reader, then Access IE should then start to render...

I have a new win 11 VM, and the Edge browser does show the pdf, but i not (yet) tested Access or say runtime, and how the web brower control works. More "troubling" of course is that SOME use the Adobe pdf viewer in their browser, and now that Adobe has both a x32 bit version, and a x65 bit...

Ok, a few things that “jump” out here? You using different database connection objects here, and multiple "different" instances. You also don’t show how IsObjectOpen() works – but, let’s leave that for now. And I see that you have some “testing/trying” idea code here with this: ' If...

I missed above -- sorry for not following up. What I was stating is that oleDB can use a ODBC connection. https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-ole-db-provider-for-odbc from above: So, for example, in Access when we use a...

Thanks for sharing. I will consider using this on one of my web sites. Not quite sure how I'll add sanitization, but the pages using this HTML editor are ONLY used by site admins to create messages and some content - not end users. Sanitization is often required if such pages that "allow" HTML...

Sure, but any old form in Access as "general" rule is able to add new records. I Guess we could call this a append, but we tend to think of this that the form is on a new record, user edits the data, and when you leave that new record is automatic saved/updated to the table. So, even the most...

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...