Recent content by govuser1

can you modify this code at all to set the access window size but allow the window to open up in the position it was last opened in?

I am already using the code above to resize the window but I don't want to set position. i.e. let it reload the access window wherever it was the last time it was closed. What can I change in the code above to ensure that the position of the window is not adjusted.

Resolved. Thank you

ssanfu from accessforums.net was able to answer this question in no time at all and understood exactly what i wanted from my original post. I knew it couldn't be that hard Here is the code in case anyone else can use for ideas. Blue was what i was asking for Private Sub cmdApplyFilter_Click()...

Bump...can anyone help with the code needed to Filter a report based on 3 check box values where any or all can be true. The report has these same 3 check box values. Thank you,

The filter will look at the checkbox value the user entered? ... take the value the user input (i.e. checked or unchecked? yes/no true/false?) and pass it to the end filter string so that when the report populates it is filtered by one, two or all 3 of the checked values which match my checked...

what can i add to the code below that will also filter the report by 3 unbound check boxes. My employees have 3 required items to obtain before they are certified and i want to be able to filter my report based on any 1, 2 or all 3 and mix and match the requirements. The code below works...

Private Sub Command131_Click() On Error GoTo Err_Command131_Click Dim stDocName As String stDocName = "TRAVEL" DoCmd.OpenReport stDocName, acPreview, "TRAVEL" Exit_Command131_Click: Exit Sub Err_Command131_Click: MsgBox Err.Description Resume Exit_Command131_Click...

Hmm ok i thought it was very specific. Just shows my limited knowledge i guess Here is the WHERE statement i am using for the 3 check boxes. WHERE (((IIf(forms!Report_Menu!Data1,[Data1]=True,True))=True) And ((IIf(forms!Report_Menu!Data2,[Data2]=True,True))=True) And...

I would like to create a query that uses 3 check boxes and 2 Option groups to filter the data. I am not sure what code to use. I have got the 3 check boxes working but i can not figure out how to add the option groups to the same query. 3 Check boxes Data1 (yes/no field) Data2...

I am trying to filter a query based on 3 check box selections and 2 seperate option groups I am using SELECT tblNames.LAST, tblNames.FIRST, tblNames.PORT, tblNames.OFFICER, tblNames.SUPV, tblNames.PERMIT, tblNames.DFO_ECC, tblNames.PASSPORT, tblNames.PASSPORT_EXP FROM tblNames WHERE...