Search results for query: *

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

Hi all, I have an 'invoice' style report that i'm designing at the moment. Therefore, for each record or 'invoice number' there will be a list of product items shown that the customer will be invoiced for. Does anyone know how i can limit the number of items shown on a page before a new page is...

Hi Guys, Sorry about the delay in response. Each user has their own frontend, they are not sharing. 'Slow Building of Forms' means that the form is 'slow in painting' itself. The data retrieval is quick however.

Hi all, I have 5 users that are connected remotely to my server & are connected to my SQL Server db using an Access frontend. The problem they are having is that when they are opening forms it takes a long time to build the form on the screen. Does anyone know of a way to improve this...

Hi All, Is it possible to shade alternate rows in a report that uses a CrossTab query as its record source. I have tried: 'Michael Red. 2/13/2002. To 'Toggle the backolor, which 'Provides alternate line shading Const XorToggle = 4144959 Me.Detail.BackColor =...

I have the following code in the Unload event of a form: If Me.NewRecord And IsNull(Me.PackSize) Then MsgBox "Check Pack Sizing on " & Me.ProductDescription & "." & vbCrLf & "If unsure enter '0'.", vbCritical, "Missing Data Message from ZP" Me.PackSize.SetFocus Cancel = True...