Search results

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

=[Page]-1 & " of " & [Pages]-1

"http://admin:jTZ27imOh2@192.168.90.24/command.htm?number=12345678&outgoing_uri=URI" "....192.168.90.24..." is a local network addreass so it wouldnt for for anyone unless they are logged in via a vpn or on the local network. do you get the same reults with ... Application.FollowHyperlink...

i feel ya! thanks for the reply!

Not having done it myself or perhaps not the best way of doing things but as a general question to you gurus :) , is it possible in access to use 2 or more back end files and separating the tables?

Nice!

I think you've cracked it! ;) Sub report 1 = SalesQuotationItem Sub report 2 =QSalesQuotationItemAcc Sub report 3 =SalesQuotationItem2 In report 1, Form filter ... IIF(DCount("*","QSalesQuotationItemAcc","OrderID = " & OrderID)=0,POSITION>0,POSITION <...

If no order ID don’t apply filter. This will fix the issue

I get the same results as before. If QSalesQuotationItemAcc doesn’t have matching orderID record due to no accessories for that order ID then the sub reports won’t generate in the main

Example not all Order IDs have Accessories. Accesssories are cought in query "QSalesQuotationItemAcc" So if order id 128 has no accessories then OrderID 128 wont exist in query "QSalesQuotationItemAcc" When this happens the report fails to generate if order id exists in...