Recent content by barrysprout

Thanks Remou but I've solved it. For the record, the syntax is as follows: Me.SubForm.LinkMasterFields = "Field" Me.SubForm.LinkChildFields = "Field

Does anyone know how to programmatically set the LinkChildFields and MasterFields properties on a Report/subreport? The help file doesn't provide any examples and I can't seem to get the syntax right. Thanks

I was missing something. I needed to include another row heading with the year while using Jan to Dec as the column headings. Thanks for your help, everyone.

Not quite. I need to show 3 year's data for each product like so: Product A Jan Feb Mar etc... 2007 2006 2005 Product B 2007 2006 2005 etc. The grouping is on the product.

That would work but would still be limited because you have to enter the years in the column headings otherwise the data from all years will be summed for each month. Maybe I'm just missing something ...

That would be fine if I was dealing with a finite dataset but I will be adding data each month which means I would have to keep modifying the report every time to include a field for the new month. I want to create a report that will give 3 years data whenever it is run. It seems to me a case of...

I would like to create a report in a crosstab format that shows sales per month for a range of products but for each product I want the current year row to be followed by the previous year row like so: Jan Feb Mar ….. etc Product A 2007 100 150 200 …..etc 2006 80 120 150 …..etc Product B...

Thanks CautionMP. For anyone else interested, the following link addresses this exact issue: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acproCodeContextObject.asp

Does anyone know if there is any way to obtain the name of an object that causes an ‘object exists (3012)’ or ‘can’t find object (7878)’ run time error? I want to create an error handling routine that requires me to know the name of the object that is causing the error. Thanks.

Only problem with this method is the default constants that Access provides are limited. I can't zoom to 90% for example which is the level I want. Any way round this?

Anyone know whether it is possible to programmatically set the level of zoom when a report opens. The default zoom in and out are either to big or too small. I want to set my own level but don't want to include any additional toolbars.

I logged on to both databases with my username (not admin) which I created and gave administrator rights in both. The databases are in separate directories with their own .mdw file. I assumed that as my username has administrator rights I am able to do anything to the database. I managed to get...

Yes. You can create a blank menu and assign this as the default in your startup options. All forms and reports that don't have a custom menu will then use this one. Maybe there's another way but this works fine for me

I have 2 databases, both of which I am the owner and administrator. When I try to copy or import objects from one database to the other, I get a message saying I don't have the necessary permission and to get the administrator or owner, i.e. me, to do it for me. Any ideas?

I have a database that seems to have got corrupted and is giving me a name conflict when I try to change the name of a report. It won't let me change the name from Proforma1Copy to Proforma1. There is no report visible in the database window called Proforma1. Anyone know how I can fix this...