Search results

Create a footer to put your subreport into by going into View>Sorting and Grouping. In the Sorting and Grouping box... In a new line under the "Field/expression" column select Customer ID. Select Yes in Group Footer from the properties box. A Customer ID Footer will appear. Pop your subreport...

I have a report set up with various subforms with 2 pages. When I publish it in word, it pops the occassional word down in the middle of the first page. It isn't consistent with the records each time I produce it and there's definatley no field or hidden field down there.

I have a report with 4 subreports in. The page is set to legal and has a margin at the bottom of 0.5cm. When I publish the report into Word pushes records onto another page approx 1/3 of the way down! It's driving me mad!

The first time each machine uses the report, you need to change the page setup and save.

It's probably that you have a field in the report which does not appear in your query behind it.

I seem to be unable to write If statements which looks in a field for a empty entries and entries which aren't empty. I know how to do this in macros, but I'm trying in subforms therefore need to do it in VB code. Also I need to find fields which contain certain things but can't use the...

I've set up coding to recognise a date. What I need to do is alert the user if the date is older than 35 days or more. It then asks the user to input another date (input box with a declared variable), if this is stil 35 days or more then it won't let them go any further. The problem I've...

I've set up a case statement to perform various tasks. The only thing is I can only get it to perform record by record. When I open the report I need it to run the code through all of the records. Any ideas?

Has anyone any ideas how to display a number field as words ie 123 one two three 0123 zero one two three

I have a field containing numbers. I need to display the field in reverse order. Any ideas how to perform this?

I am trying to produce automated printed cheques which require each unit of money to be listed in a separate box. The field it comes from is a calculated field. ie £120 the 0 goes in 1 box, 2 in another and so on. I have a formatted number field which is 7 numbers long. So all number are of...

I have a formatted number field which is 7 numbers long I need to extract each single number into separate fields on a report. Any ideas how to do this?

Thanks for the quick response Any idea how I do that, sorry not up on this bit of VBA!

I'm trying to display a number field as a set amount of numbers I have numbers ie 10, 120, 4000 and would like them to display as 0010 0120 4000 Is this possible?