Search results

can you please give me the code to try using openArgs that will pass the filter that in the specific record on another continuous form ?

that's the continues form, with the "Edit" Button so, when this button clicked i need it to open this form and filter this subform, with the same year i clicked on the button on the continues form

We got that part. I am trying to understand why you said the OpenArgs approach won't work. So, I am trying to clarify if you click the button on the first record that then opens the edit form, this edit form has a subform, and the data i wanna edit on the subform there's only one button here...

I've a continuous form, with a button on every row record, to edit this record this button opens another form"mainform" that has a subform, and I need this form opened filtered with same value on the continues form record and the continues form will close

thanks, @Ranman256 again, i need to filter the subform inside the main form, your code will be applied to the mainform !

thanks @theDBguy for your reply i can't do it that way because the button is in continuous form, so i need to use the where condition on the button to get the value from a control on this continuous form

Hello I've a main form with subform inside it main form have only a combobox to filter the subfrm and i wanna open this main form from a button on another form using vba code: DoCmd.OpenForm "mainform", acNormal, , "xYear= "& me.txtYear but i wanna use where condition too to filter the...

Well, thanks @Pat Hartman and @mike60smart, and thanks @theDBguy too I've used @mike60smart way in the example file he attached, and regarding Concatenate records, I'm using this function

Ok, I've heard you all and convinced to not use MVF I'll use a junction table but what is the best practice to do it? i've this lookup table named: conentions and another lookup table named: countries so the junction table that it will be a data entry using a form with these fields so...

Well, i can do it using one value field but i have data entry forms with combo box to choose between 20 values and the best way to do it is using a combo box with multivalue field, since nothing else was required and i have already built the whole system With the forms and reports with MVF...

Thanks for the suggestion but i need mvf because theres alot of reports depends and i need to see it the way mvf displays it.

that's a great solution u provided like always, thanks a lot but it's conflicting with my PS since we used append query, every time when we open the form, it will append the new records is there another way to get this new table without using an append query?

Hello I've a table with a multivalue field and i wanna extract it into one value fields because there's other fields related to specific value on this multivalue field to show you what i mean i've this primary table with data and multivalue field So, for example: Pop have English , French and...

it's attendance time !!! I get the time from Attendance Software with update query to attendance table, so in form time is not editable.

employee time is not changeable or editable at all!

i got your point. But in my situation, I only calculate Late time form ClockIn, and clock-in is not editable in form, it got the value from update query that gets the clock-in from another DB storing attendance time from attendance machine . so i'm not afraid of change/update the clockin .

I'm storing em in the table and I'm quoting ur words " especially if there are financial consequences for using them " At the end of the month, there's a report that calculates total hours of lates per employee !! that's why I'm storing em !! Please tell me your concerns in details

Yeah Thank you for the tip 🌷

It's for Late Hours so i need to store this value Thanks again

Hi I forget to make this post as " Solved " and for not allowed to attach, i meant for a not zipped file ".ACCDB" but after zipped its attached and i uploaded it in this post Thanks