Search results

well, you r right , i've alot of records like 500 want to update them in one time so, the best solution will be an update query Thanks @isladogs @theDBguy

i've found this code Private Sub cmdTickAllBoxes_Click() Dim rs As DAO.Recordset Set rs = Me.RecordsetClone With rs .MoveFirst Do While Not rs.EOF .Edit !CheckboxFieldName = -1 .Update .MoveNext Loop End With rs.Close Set rs = Nothing Me.Requery End Sub and i tried with...

in the main form i'm using 3 combo boxes to filter subform records and my choices not the same everytime so i can't use update query as i'm using different criteria everytime

Can't do it in a simple update query as filters is not the same everytime so i've to do that on the fly on the showed records

it will be a button click so when i click it it will select all checkboxes in filtered records in subform and i don't want to deselect

yeah that's what i need , so do u have a code for it ?

Hello I've a main form Called "frm_Main" and i'm using it as Form Heading to filter records in subforms in Navigation form all subforms view as continuous form this subform is getting data from a query based on filters i use in main form so in this main form i wanna create checkbox field or...

in case of 2 subreports only it will show as i choose " cross and down " or " down and cross " but in case i have 10 subreports , and i wanna first 5 subreports to show in cross and down !! and the other 5 subreports the same way !!!

regarding subreports sortings can you please attach an example db ? and regarding force page break, i can't use it as some of this sub reports may not have data and will shrink to 0' , so the page will be half empty !

in design mode in report if is sort all subreports groups in column way it wont appear like what i want to be

that's good idea but it won't fit in my situation Using 2 columns will change the order of subreports i mean that i wanna see the first 4 subreports in "Formation 1" beside each other not in a column way ! and still not found any fix of the last subreport that only shows the header and the...

yeah that's #2 issue and i want to remove this padding !

Thanks Uncle Gizmo :)

it seems that's my only solutions for now Thanks @June7

well, it will work, and i said it's not possible because every report have about 15 dlookups and i'will have to merge em every 3 controls into 1 and i will need to add separators like &"/"& and it will take a huge time from me to edit every text box !! that's why i wanted a code to do that for...

why we are going away from my question to a side questions ? and a manipulation stuff ? why there's no answer about is there a Code for auto grow width? and i've searched and found this http://www.lebans.com/autosize_textbox.htm many thanks for your efforts trying to do that with the very...

that's not possible

:):):):):):):):):) i wanted a solution that will work on all cases my real report is Full NAME - Job Title - Country all in one row and the Full name text box Width = 2' Job Title Width = 2' Country Width = 2' it appears in not good look if the country name is small or job title is small...

Hello Fam, i know about format property ( Can grow / Can shrink ) and Can grow is good but it only grow vertically while i need to grow horizontally like i have 2 text boxes lets say First Name and Last Name and i put them in stacked layout horizontally Width for both boxes = 1" if we...

Hello, i've this main report named : "Formations" that have about 10 subreports all this subreports have the same query criteria, and there's no link between main report and all subreports on it, i'm only using this main form to preview all this sup reports in one report combined. here's a...