Search results

It's actually one click: "Your threads" is the default when clicking on "Find threads". Agree it's a very useful feature. For #2, the Search threads feature allows you to enter the user name and the forum to narrow it down.

Please don't set text color to black - I can not see it using the dark theme. @Jon is there anything that can be done about that? Disable black and white text colors from the picker?

I've been wondering: is there a functional difference between that and DoCmd.ApplyFilter , "[ClinicName] <> 'In Office' OR [ClinicName] <> 'No Provided'" ?

Can you show us a picture of your form? I can't imagine how Excel would interpret a form. How does it know where to place the data? The answer is you're going to need to make a template in Excel that Access will export the record to. It is going to be tabular data and you can have conditional...

That's another thing that MS has since fixed (at least it seems). That feature saves me time and I haven't seen any of the bugs that Allen Browne wrote about.

Hmm. I know from testing that opening the table takes longer than opening the form based on the query that uses the table. And, we're only talking about a table with ~1k records at this point. It's noticeably slower to open the table with subdatasheets enabled than it is without. I can't say...

Hmm, I haven't had that issue. Turning them on and off has no effect on my datasheet split forms. They only appear when opening tables directly, which are hidden. For the record (ha!), my forms are based on queries.

Well if the records aren't in my recordset, they shouldn't load.

I thought subdatasheets only load when a table is opened directly?

You may run into issues if you ever export this data to a spreadsheet and plan to work with it there. In my experience, the Format function results in numbers formatted as text. Therefore, you won't be able to perform any calculations on the data until you use the =VALUE function to convert...

End users should never see the tables... As a developer, I have found scenarios where turning them on to inspect data relationships between tables was a huge help. Pretty sure that's why they're there. Otherwise it really doesn't matter once your app is up and running.

I don't use union queries (or at least I haven't had a need for them) but my Select query results are fine. I don't see lookup fields in tables as having anything to do with the queries and joins I use throughout. They are not mutually exclusive.

Oops, forgot that important part. Edited.

Here's mine, using a tweaked version of CJ's method. Subform footer has an unbound invisible text box named txtPK On Current event of subform contains the following: Me.txtPK = Nz(Me.[yourprimarykeyID], 0) Conditional formatting is applied per attachment Field will highlight as you move...

I like the idea that you can create an HTML email. EMailDatabaseObject works but is plain text only. Also, it has a bad habit of leaving a dead Outlook instance running that you have to kill with Task Manager. The Outlook email window also takes over like a dialog form while it is open...

CJ, do you mean Work Folders? Work Folders is how it's being done now. You run your files from your hard disk, and there is a background process that is basically online backup to the domain server. That way, there are no performance issues. If you move to a different computer and log in for...

Our IT department does disable installation of software except by Admins. So, you can try this. Create a new macro and in the blank macro designer, paste this: <?xml version="1.0" encoding="UTF-16" standalone="no"?> <UserInterfaceMacros...

Sorry. High-res phone screen.

Hwat in the hell. Up is down and Christianity isn't a religion.

You will be in good company. I think it's silly that such lists exist, but here's a small sampling of the club: https://en.wikipedia.org/wiki/List_of_atheists_in_science_and_technology