Search results

What is the difference between the three Set lines below? Dim db As DAO.Database Set db = OpenDatabase("C:\Northwind.accdb") Set db = DBEngine(0).OpenDatabase("C:\Northwind.accdb") Set db = DBEngine.WorkSpaces(0).OpenDatabase("C:\Northwind.accdb") And should either/both of these lines be at...

Back again with more notes to add. I wanted this powerful form filter to be even more powerful for my forms so I made some changes to make the button pictures show that a field is sorted as well as being filtered. Four more pictures are needed for a total of six. I'm using these images and...

Another note to add: If a field name contains the name of another field then the button picture will change unexpectedly. For example, if you have a field named Spool and another field named SpoolSize, whenever SpoolSize is filtered, the picture for both SpoolSize and Spool will change to show...

I see now that your class version uses the Form_Current event to check if the filter is on and update button pictures accordingly. This must be what you meant in a previous post about fixing a bug in the original. I prefer the simplicity of MajP's original because I understand (mostly) how it...

I asked this question because there seems to be some unexpected behavior in Access but I couldn't find the cause. I located the source of this behavior and now have a solution. To see the command button pictures update correctly when either of the Toggle Filter buttons are used, I would expect...

I'm trying to understand how this code works. When using the code provided in the first post, why do the button pictures not update correctly when the toggle filter button is clicked in the ribbon (or next to the record selectors)? This problem is corrected in the Class version but I can't...

I don't see the "enable content" banner but I do get the "security risk - microsoft has blocked macros..." banner and the autoexec macro is prevented from running. (I get this banner in the unlocked version as well.) I read through the article again and I don't see that the trusted...

No idea. I can't figure it out. I added it two hours ago and it was great. Now the ribbon shows every time. Maybe caused by a setting I changed somewhere because it won't work in my backup files either.

The custom ribbon approach provided by Microsoft seems like a better solution (when it works) but I'm still curious how people are using code to secure the database when the code won't run until the user allows it to run...

I keep seeing this as an easy way to hide the ribbon. But if a user copies the database file to a new location, VBA code is disabled until the user clicks "enable content" under the security warning. The hide ribbon code won't run and the user will have full access to the ribbon. How do you...

I think I've figured out how the save system works. But it's so confusing I might be posting more incorrect information... The save button in the VBA editor window generates a prompt to select which object and module you want to save if you have made changes to an object and module. The save...

Yes I get that too (never mind what I said about "all or nothing"). What I want to do is discard VBA changes without having to close Access. Also, sometimes I want to click the save icon to save changes to an object. But this will save VBA changes as well, even if the VBA editor window is...

Sometimes I like to make changes to a VBA module for testing then want to discard those changes. The only way I have found to do this is to close Access and select "no" when prompted to save changes. The problem with this method is if I make changes to Access objects while I'm editing a VBA...

Thanks, I'll check it out

Sorry, "active" is the wrong word. I was trying to simplify. I have a list of construction projects and sometimes they get split or combined. When split, I'll have two or more new project numbers. These new project numbers may be added to my list or not (I'm only tracking certain projects...

3 months later.... I created a second table with a field for projects linked to the main table projects field and another field displaying related projects (similar to an orders/products many to many relationship). The second table is added as a subform so now I can enter and view related...

Yes, I want to show parent/child relationships due to split and combined projects. How would this look on a form? If there was only one child project that would be a simple text box to manually type in a number but how do I handle multiple entries?

Hello, I have a table of projects and I am trying to link some of the projects together. For example, if I am viewing project 1 on a form, I want to see projects 1a, 1b, and 1c listed as related projects. 1a, 1b, and 1c are in the same table as project 1. I also want to see 1a, 1b, and 1c...