Search results for query: *

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

I have a report that contains an item description and other fields that are numeric. I have set the CanGrow properties of all fields and the section to yes but when the item description grows, the other fields don't grow with it unless they need to. I am using the field border property so the...

I am implementing security in a database but when the user clicks on a command that uses visual basic to open an object they don’t have rights to, the resulting message box alarmingly contains a button that opens the Visual Basic editor. Is there a way of preventing this? I thought of using...

The sql string is part of the OnOpen event. It's just a simple query and there isn't any other code associated with the report. The report is opened from a form with a date criterion and the form remains open until you quit the report. I've managed to get round the problem by printing the...

I have a report whose control source is set with the OnOpen event like so: me.RecordSource = sqlstr The report previews fine but doesn't print. Strangely, if I try to print it from the database window using the right click print command, it prints. Anyone know what's happening here and how to...

Totally stumped on this one, hence the re-post. I have a combo box on a form whose results are filtered by a parameter that is supplied by the value in another combo box like so: Combo1 = country Combo2 = customers of country entered in combo1 Nothing fancy about this and it works fine but...