Search results

Never mind, I figured it out, it turns out that after doing conditional formatting in the form, I tried to do the same in the report, but this time with vba, but at the end i did it with conditional formatting. I forgot to delete the code and for some weird reason every time i go to print...

Yes, those are the same I have

Because from the tables there's more than two categories, I have standard, non standard, not needed, different dimensions. It was the way I was asked to do, but you right. Either way that shouldn't be the reason for the behavior.

Hi, I have a report where I have three different fields called Dimension A,B, and C , and two other fields(Yes/No fields) called standard and non standard. I implemented conditional formatting for the 3 dimension fields so the cell turns red if the standard check box is selected. When I open my...

What you mean with more than one table. I created a query that would display the repeated records, but won't allow me to edit them. Thanks

Seems easy that way, could you try it and attach a working code. Remember that once it's checked the condition is true and won't allow edits including unchecking, as far as i know and tried.

Thanks I got it. I used a button to unlock the desired record with Me.AllowEdits = True, either way if someone knows how to lock/unlock by checking/unchecking the check box I would like to know. I imagined with VBA you can maybe count the amount of clicks on the check box and assign AllowEdits...

I have some components that have few characteristics, including three dimensions, part number, and quantity. I have them in a form bound to a table. Is it possible somehow to within the form to input data if I have more than one for the same part number, and where dimensions differ? Thanks

Actually hiding the record is a bad idea as it might happen by accident. I have managed to lock it, the only issue is unlocking it within the form. As far as I have researched I don't think you can lock/unlock by checking/unchecking the text box, hopefully I'm wrong. Is it possible then to...

Hi, i have a form bound to a table. the form has 3 yes/no checkbox and I'm trying to hide certain record if the checkbox is checked. I know that I can query the records, but was wondering whether you can hide unnecessary records(these are records I don't want users to edit, so lock them is also...

I got it thanks, here it is: [Forms]![MainUtas]![NavigationSubform]![NavigationSubform].[Form]![Text5]

I have a main navigation form which name is MainUtas, one of his tabs or navigation buttons is NavigationButton9 which Caption is Quality and opens the QualityNav form (which I think becomes a subform). In QualityNav I have more navigation buttons, one is NavigationButton7 which caption is...