Search results

Okay, I can create a new DB and import things, but if I import only the problematic forms, nothing will work - they are heavily reliant on things that do work. And what purpose would that new DB serve? I'm not trying to be obtuse, but I don't understand what you're proposing as a fix, or even a...

Customer has removed 2019 and re-installed 2007. Same problem. Now I don't know what to think. Something screwy in Win 11? But it works on my Win11 notebook with O365.

I have not yet tried copying the failing file back to a working machine. I will try that today, and and get the two version numbers. There are no OLE fields in the tables that feeds any of these failing forms. There is one OLE field in one table, which provides some images to the ribbon...

I have a database that is throwing that extremely unhelpful error about "A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control". It is a single-file DB – not split. All tables and queries open normally and correctly. I've tried all the usual...

I don't know who peed in your cornflakes this morning, but if you have only snark to offer, go bother someone else.

Here is some of the junk between angle brackets in those texts, if anyone is curious about what I'm dealing with. </a> </div> </em> </font> </strong> <0.0001). The comparison of yearly totals within the 37 yearsof coincident monitoring showed a significant correlation of fluctuation in numbers...

True, but again, this has no provision for leaving useful information. If I manually select a color, for instance, I want that color. Access does that by setting a color at the beginning and clearing it at the end. I would like to do THAT, and not have the color pointlessly set to black every...

Thank you, but it appears that this will simply change all tags of one font to another font. I'm not just trying to change the appearance of the text to be uniform - I'm trying the get rid of the font tags entirely, while leaving any other formatting tags.

Yes, that looks promising. RunCommand acCmdFont opens the dialog box for all those things, but I don't want to pester the user with it, I just want to apply it. I suppose I could use SendKeys as a last resort, but that's icky. I wonder if there is a way to directly call something with the same...

I have a memo field into which the user pastes text from various online sources. I made it an RTF field, because some of the formatting is useful - mostly italics for species names, and occasionally bold. Unfortunately, pasting web text often brings in a huge amount of superfluous formatting...

Words matter, but actions matter a lot more. But it's a wash anyway - Biden fails miserably in both categories.. This will be one of the few times that people will be able to compare two presidential candidates on their actual performance in office, instead of the record of one against the...

Bravo - a perfect demonstration of TDS. What other anti-Trump hoaxes have you fallen for?

I find it incredulous that so many people rage against one of the best presidents we've had for a long time. All you see is the stage show, and you say that is offensive, as if your being offended meant something. He is not stupid - far from it. The stupid ones are the ones who swallow the...

Independents are far more likely to look at results and vote according to those, rather than faithfully sticking to a party. In most elections, people must balance real results, which always have flaws, against promises from the new guy, which always sound better. The upcoming election is one of...

How about making your source query dynamic? Something like {aircode): Select Iif(Col(1)="", Col(2),Col(1)) As ColA, Iif(Col(1)="",Col(3),Col(2)) As ColB, Iif(Col(1)="",Col(4),Col(3)) As ColC, etc. This would allow you to use the stuff starting from column 1 if column 1 contains data, or start...

Thanks, I'll take a look.

Thanks, lots of stuff to look through there. I'll get to work.

I meant that he just quit working on it. He wrote that himself, that he was going to do other things and would no longer respond to any communication regarding Access. He left the website up, but as far as I know, it has remained a completely static site. And he left no docs on where he got the...

I have several apps in the field using Stephen Lebans' PictureBox class to draw various thing on the screen, generally a map with some selected information from the database shown on that map. All has worked well for many years, but one of my users now has a 64-bit machine, and the class no...

One thing I've not seen anyone else mention - Excel makes it VERY easy to trash your data. Sorting only some columns and subsequently saving and closing the workbook will mix your data to the point where you are very unlikely to be able to recover it. This simply can't happen in Access. I would...