Search results

Yeah: the code needs to be run in the Current event of the subform. I don't believe a requery or refresh is needed for enable/disable of controls.

Don't use DLookup in queries.

Thanks for pushing me to test my solution (y):coffee:

This should work.

Hmm, well I'm getting Macro Single Step Error 2001. So I guess you're right. Best policy may be to ensure the location is trusted. In my case, my .bat file copies the front end from the server to a local folder on C:, and we don't see the yellow bar. This code is really just a back up policy...

So you need an Access Report with its recordsource set to a query that contains the Files table and the Users table. Add the repeating (many side of one-to-many relationship) fields to the detail section Format the fields as Hyperlinks Put the User name or User ID in the Report Header Open...

It hides no matter what. First line of AutoExec macro is RunCode, HideRibbon() <- public function Second line is to check if the DB is trusted, then either load one form if trusted, or load another if not. So by the time it's checking, the DB window is already streamlined with no ribbon...

If you do not need to retain the original table, you could just delete the table and let Access create a new one with the import. It's decent at picking data types, in my experience, if your Excel file was set up correctly (no numbers formatted as text, please!)

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.