Search results

Right now 7,000 unique SI that are being shared among the 150,000 task records. Of the 150,000 tasks - 10% have no SI, 89% reuse SI, and >1% (639) of tasks have a SI unique. That >1% (639 tasks) is the user editing the special instruction text. Most SI is automatically handled by the db through...

I'm checking this out now @MajP, thanks! I like the concept, and I hear and nod my head at the points being made. The task screen looks like this currently. Users aren't searching much for [special instructions] but it was made a combo so that the text could be reused and referred to by its...

Thanks Tom 1st point comments - the spec_inst stands for special instruction for the task. In the actual db there is also a task_text field. So it is more like Task = Fix Engine, Task_Text = Do these 20 steps, Spec_Inst = (sometimes no spec_inst for the task) but verify/confirm 'x' Made up...

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...

Maybe if you were still in your younger years you could rub Biden's legs for him. In all seriousness - I don't want another 4 years of Biden teetering around and falling over his next thought.. Give me Hubbard dammit.

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...