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 <...
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...
@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
"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...
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?