Search results

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...

It seems to work fine. in the example data in post #6... there are 2 records for the accessories position = 4 and 5 i manually wrote in report1 "Position < 4 " as the 1st accesory, the position value is 4. And filter only those with position less than 4, in report 1. Then in the 3rd sub report...

Thanks Guys seems i am much closer now thanks to you both. This has now presented a new issue, now that i am filtering reports, in that if no accessories have been selected then none of the sub reports print. (Im expect its because it cant find results to the filter crirtera) this is the filter...

@LarryE its not solved mate i need to find a way to to filter the First and last report...

if it helps this is the vba Qry for Report 2, the accessory report. SELECT TblOrderOption.OrderOptionID, TblOrderOption.OrderMainLink, TblPARTS.PART_NO, TblOrderOption.POSITION FROM TblPARTS INNER JOIN (TblOrder INNER JOIN TblOrderOption ON TblOrder.OrderID = TblOrderOption.OrderMainLink) ON...

Thanks for the reply. I Had tried this apoproch (creating a seperate report for Accessoried. ie i had successfully been able to run this in 2 reports. 1. One report for Part numbers (filtering out accessories.) 2. A report to include only the accessories. This worked fine and solves all of the...

how can this be done only to records where Me.PART_NO = Like "AC*"

I would add new unbound Colunm and make it Hyperlink. make it visible IN THE FORMS ON CURRENT OR ON LOAD EVENT ETC... if me.originalcolumn = x then me.NewURLColumn = "Open Link" else: me.NewURLColumn ="" END IF ONCLICK EVENT OF THE NEW COLUMN... If Me.NewURLColumn = "Open Link" Then...

@Wysy have you solved this?

im havimng an issue where my Boss has asked be to do something left feild and i need to know how best to go about it. i have created a report that displays technical specifications for products for all product groups. Basically if a product group = Accesory, PartNo starts with "AC", then i need...

are you sure? in design view in the text box property scroll to the bottom and look for Is hyperlink = yes/no selection. set it to yes try and give it a go

will something like this help to solve your issue? the action on click event of your toggle button if me.tglbtn = true then me.cboYesNo = "Yes" me.textboxes.visible = true else me.cboYesNo = "No" me.textboxes.visible = False end if

just wanted to put my 2 cents into this long chain. :( and late for this party as i understand it you are having issues since you split the back end and others accessing the BE are experiencing similar issues? look at the server and check the folder permissions of the BE file. make sure users...

starting point... try this to create the pdf.. strReport='your report strWhere='the record to print TCRAID? strFolder='folder path to save strSubject = #Date(yyyy)# & "-" & Me.TCRA & Me.Level & Me.Block & ".pdf" ' Something like that assuming this will be a unique name, ideally the TCRA ID...

Personally for mobiles I would use php/html. Some providers use My SQL and usually its free with client packages, others Sqlserver. If they use My SQL then you should be able to connect to their database via a ODBC connection and import the data stored in that table, into your main access suite...

@arnelgp BTW if i remove the stacked function, then it doesnt work again. So, without knowing to implement the stacked function i wouldnt have solved it ..... many thanks mate, great Job!

Same result. intresingly if i remove the label and add another txtbox and give it a value then it works. ie Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Lbltxt.value = "NOTES:" Me.Lbltxt.Height = Me.Notes.Height End Sub i think that will do. but its...