Recent content by Sodslaw

I didnt get back to you guys but I ended up by formatting the cells with a red background that are duplicated in Column A. It's good enough for my needs. thanks again.

No problem, thanks Bob.

Thanks Minty, How would i do that?

Guys I have on column A a combo box (drop down box) that gets it data from a column on another sheet. I did this via Data>Data validation> criteria List and entering the Source Data. This is all fine, the issue I’m having is that I don’t want any duplicates in column A >> How can i achieve this?

then use this in the report =[Page]-1 page 1 there will be no Page x of xx and on 2nd page will display "Page 1"

i think you have miss read the original post. this is to hide the page text ie "Page 1 of 2" in the footer, not a complete page from a report. Start a new thread please.

try adding code to the format footer or header event (or wherever you have the page count displayed) If Me.Page = 1 Then Me.PageNumber.Visible = False Else Me.PageNumber.Visible =True End If

is there a VBA command to preview a report and open the print window? ... My current code is ... If Me.OrderType.Value = "Quotation" Then DoCmd.OpenReport "SalesQuotation", acPreview, , "OrderID = " & Me.OrderID End If > Pleasde note that ribbons and QAT are both hidded in my project...

so it appears that the filter in the propery plane, is overwritten by the SQL ( i've never come accorss it before) and after moving within the where statement of the SQL, It seems to have been solved. This seems to work... WHERE (((TblPARTS.PART_NO)<>"-" And (TblPARTS.PART_NO) Not Like "AC*")...

@arnelgp So in the where statement of the SQL, is.... WHERE (((TblPARTS.PART_NO)<>"-" And (TblPARTS.PART_NO) Not Like "AC*")); So having this in the SQL and this code in the filter IIF(DCount("*","QSalesQuotationItemAcc","OrderID = " & OrderID)=0,POSITION>0,POSITION <...

ive made a nother video showing the same issue it may be a clearer. no removal or deletion of this code by me. @Uncle Gizmo, will check out your video

Hi @CJ_London Watch the video 1-2 seconds in, it shows the property sheet with the filter populated, after changing the SQL query its gone. im not sure why you beleive the video doesnt show anything. sorry. but never the less after editing the report the code in the filter dissapears. BTW the...

I have made a video of my issue. I dont know why but after making changes in design view (Navigation plane>right click the report>Select Design View) the Filter is blank please see video... Before Editing... After Editing... Video... Is it an Access Bug? Can it be fixed? is there a better...

As its a dropdown wont something like this work ... if Me.TXTBOX.value = "RED" then Me.TXTBOX.BackColor = RGB(237, 28, 36)

@isladogs its based on @arnelgp's solution if it on page 2, display page 1 (-1) if total Pages =100 display 99 (-1), thats right isnt it... i hope so LOL