Search results

Nope it's for this thread. The OP's issue was that the hide ribbon code from other discussions runs after the DB is trusted. So, the solution is you move the code to be the very first thing that happens when the DB is opened - before its trusted status is checked.

If I'm understanding your need correctly, you can do what I do for a search form. Pick something that you know will result in 0 records. For example, if you have a Type or a Status field, you can set a filter on the form for Type or Status 0. Since there is no such thing, it will load up blank...

I just moved my hide ribbon code to a public function and call it from my AutoExec macro. It used to be on the load event of my Login form - but as you say, if the DB is not trusted, the ribbon won't hide. Now: AutoExec runs. First step is: RunCode: HideRibbon() Then, it checks if trusted and...

What if brackets help you spot field names in VBA and SQL admidst all the code and table, query, and control names? It works well as a visual identifier.

I'm pretty sure it's just a branding thing.

If each client can have many accounts and Each account can have many creditors and You don't have a direct relationship between clients and creditors, That isn't a M:M, it's just two 1:M relationships.

I do not believe MS Access has the sophistication to build control charts like the ones used in Six Sigma organizations, but I would love to be proven wrong on that.

I use .png files in 64x64 or 96x96 resolution for best results. Set images to clip so there is no zooming.

No go here.

Right, you still have to edit your VBA Autocorrect's biggest help is with updating queries when renaming things.

I recall when I set up our Mailchimp lists I needed to register a domain (you've got that) and enter certain settings in order for email clients like Gmail, Hotmail, etc to not reject them under newer, stricter rules. I can't tell you what those settings were but I could dig for them. Can you...

Thinking we may have to "opt in" at first. I just went in and unsubscribed, saved, left the forum, came back, and subscribed - we'll see if anything happens.

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.