Recent content by papic1972

Hi Remou, Thanks.

Hi All, I store PDF copies of all invoices that are printed from an access form in a folder 'C:\Invoices'. I have had a look at & used the method (of creating a form that lists files in a folder) devised by Allen Browne called 'Listbox recursive list files' which is found here...

Thanks Remou!

Not to worry, i've figured out the problem with the Public Function, it works now.

Hi all, I use the following DLookup statement as a control source in a text box: =(DLookUp("[SumofPaymentReceived]","[qryDlookupDebtPrelimTOTAL]","[ID]= " & [id])) If the Dlookup returns no records from qryDlookupDebtPrelimTOTAL, how can make my textbox show a "0" value. I tried using a Public...

Hi mhartman1, No, that is always one of the first & most obvious things i check. Since i have the report printing records based on an OrderID field & have an OrderID Header & Footer, could this be causing the problem?

Thanks Remou, you are an absolute gem!

I have one other question if i may! If i have a product description that doesn't have brackets after it, i get an "Error". How do i overcome this?

I have an invoice style report that i'm working on. I have a problem where an extra page is being printed, even if there is only one record in the detail section. I have a header & footer, (of which i removed to see whether the problem still happens) & it does. I did the obvious & checked the...

THANK YOU THANK YOU!!!! You are a legend! That worked beautifully!

Thanks Remou, The bit i wish to exclude is always bracketed at the end of the description. I'm not very good when it comes to using strings. I tried the following in the 'On Format' event of the 'Detail' section of my report without success: Dim strDescription As String, strShortDesc As...

Hi all, Does anyone know of a way to exclude part of a description in a field on a report. E.g If i have a description such as: Bricks (Commons), I want to exlude the description in brackets so that the description only displays as: Bricks Can anyone help?!

Geez i'm dumb, i've worked out the page break!

Hi dhookom, OK. Excuse my ignorance, but how do i add a page break control?

Hi dhookom, Thanks for that. I understand what you are saying, however it doesn't entirely answer my question. I want to be able to force a new page after 10 records. I also have some information in the page footer that needs to be shown on each page, hence the necessity to force a new page. Is...