Search results

I also do realize that this isn't 'intended' use of combo boxes, but I'm hoping to find a way to make it work. My initial problem was users did not like typing into a text box on a single form, into a table that was akin to a fact table like orders - that had a comment field, and if the text...

Hello AWF, I have a combobox that is reverting back to the old value when I edit it and I can not figure out why. I have a Not In List event that adds the record if it does not exist, but it is inconsistent with keeping the new value that was just edited, or reverting back to the original value...

I just meant moving clickable labels/cmd buttons and also the informational labels to be on a header somewhat similar to below.

That makes two of us.. I think my biggest hurdle is color schemes and finding something that all users will like, and consider an upgrade.. In my honest opinion there isn't much that i think wouldn't be able to be considered an upgrade.

I have a modified version of Jamie's ResizeForm module that handles it okay somehow, but yes.. On 72 inch displays it fills up the full screen just as it would any other size screen.. I tried to update my existing resize module with IslaDogs updated version, but it doesn't produce the same...

Thank you for the feedback! I think every point you gave input on has some work to be done. I'm kind of 'caught up' in a sense of learning every database application that I inherited, and now it is time to let my users reap a few of those celebratory benefits with me.. For the 4M and PDCA - In...

Hey AWF, Any takes on suggesting how you would modify this form to be more visually appealing? This is a full screen display form - maximized, resized to whatever 15 inch laptop to 72 inch tv is being used as the display. I'm getting ready to at least turn all of the underlined blue texts into...

@MajP this is perfect! Wow. Thank you for taking the time to set this up and explain it to me. This is really helpful to see how you got this working with my form/subform setup. What led me to your FAYT solution was the fact that access doesn't seem to have the search box on the filter...

Hey @MajP got it! Thanks! Ultimately - the reason that I am implementing this is because the db users want to be able to search/filter/find things easier. The subforms on this form have the same recordsource, but it is an assembly line with a left and right side, so they like to view the work...

Understood.. I wasn't expecting it to work, as it needs to look at +2 forms (subforms) recordsources instead of the 1 main recordsource.. But I was thinking there must be some way to modify it to make it work instead of just hardcoding a form sub/function solution. As I would have liked to be...

Right now it does only default to task as that is how it is initialized, and I keep getting object variable not set with the way that sample db is with the after update events on the main form for the option controls. I'm struggling to reference the subform/form between code in main form and...

Hello AWF, I've been trying to implement @MajP 's FAYT continuous form class to filter two subforms from my main form, but I can only get it filter 1 subform and not both at the same time. I'd like to figure this out so that I can reuse this concept. I've tried initializing the class from each...

Maybe I need to try passing the main form text box into the initialize call from each subform then. I tried a public sub on each subform that was called from the main form, but still only one would filter. I need to make a sample db and post, need to remove a lot though.

Impressive! This has to be the top Access/VBA forum that I have come across. Thanks for keeping the lights on around here for us Jon.

Can you point me in the right direction of modifying the FindAsYouTypeForm class to filter two subforms from the main form? On the main form load I was calling the class initialize sub but passing in the subform names, yet it would only filter the first subform passed in. So I made a 2nd class...

Anyone care to share some songs or contribute to a music thread? Currently listening to this gem - not endorsing, but somehow came across it tonight, and I was introduced to it by a fellow coworker at my first job.. Out on the lumberyard mud field with a chainsaw and putting together all of the...

Hmm.. I was expecting to see a bit more. I'm not sure what else I could suggest then. Here is mine for 16.0 I thought yours would maybe display some show/hide object or default settings, etc..

No - Only need to see settings - click on the settings folder on the left and take a screenshot of that. Or take everything after 'settings' out of the path.

That is Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Settings\CommandBars if you look in the file path address bar up top. How about just: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Settings And also ------...

Not suggesting you change anything just curious of the registry values if you want to share a screenshot of them. How does this registry path look: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Settings?