Recent content by dominicdunmow

Thanks for your response, I've done many a search for the anser to this and I notice your name appears nearly everytime. I've been to your website already but couldn't work out how the report worked. The code I used seemed simpler so I took the easy way out. I'll study your examples cloesely...

Hi there, I've used the code below to assign control sources to the fields, I have similar code to assign labels, but when I run the report, only the first records appears, the source query has at least 10 records. Can anyone tell me what I'm doing incorrectly? Thanks Private Sub...

Hi there, I have a print button on a form that I'd like to use to print out the linked subform after "filteredbyselection" has been used. I can print the whole form using:- DoCmd.SelectObject acForm, [frm], True I assume I have to make the filtered form the SelectObject, but cannot work out...

Hi there, Thanks for you response, it's great and has me on my way works, but I have one further wish. The code works if FilterBySelection is used once...if I want to further filter the mainform using the FilterBySelection button a second time, the subform recordset resets, then filters by...

Hi there, I have a main form linked to a subform by a Unique ID field. I have a command button on the main form that uses "acCmdFilterBySelection" to filter by the selected field. When this button is clicked I'd like the subform to be filtered by this same field. Does anyone know how I can...

If I add this line to the criteria of both the geography and Product Cat. fields in the query, the subform will always filter by both of fields wil it not? The problem there is that I won't get the full Product Cat. recordset for example, I'll get the Product Cat. set filtered by what ever the...

Thanks for coming back. I think I understand, but both the Geography and Product Cat. fields will always be populated so I don't think this would work. I guess what would be the perfect answer would be if I could add to the criteria line of the the query something along the lines of:-...

I have a form with fields named "Product Category" and "Geography" amongst others. There is a FiletrBySelection command button sot he form can filter by either of these 2 fields. I also have a subform which is linked parent/child by the "Geography" field - this essentially filters the subform...

Thanks, it would have been helpful if "Help" had mentioned it...perhaps it did and I missed it!

Hi there, I'm trying to find a list of the commands available under DoCmnd.Domenuitems. Help gives a few but not the full list. It says for the full list look at the command arguement list in previous versions of Access. I'm using Access 2002. Can anyone help? Thanks

Thanks for the response, I've managed to solve the problem using ... Forms![frminstallationoutlook]![sfrmPartnerCost].Requery Which is a little strange as I thought I'd tried this at least once already! (All's well that ends well)

Hi there, I'm pulling my hair out...I have a parent form with 2 child subforms (bound to different tables. I have a cmd button on the parent form that copies specific records from one subform to the other using a DoCmd.RunSQL "INSERT INTO line. this works well the values are inserted into the...

Thanks for your responses. The database is a temporary solution so in theory year doesn't matter but for best practice's sake I've included - thanks for the nudge. DoCmd.Rename "tblArchiveOSP_" & Format(DateAdd("m", -2, Date), "MMM") & Format(Date, " yyyy"), acTable, "tblOSPPrevious" Dominic

Hi there, I have a table that I'd like to archive, in order to do so I'm renaming it and adding appending the month in which it applies to. The code below adds the current month, but I'd like to add 2 months previous, e.g Format(Date, "MMM" - 2) but I can't work out the code. DoCmd.Rename...

Hi there...this is a little longwinded but please bear with me. I have created a Revenue Forecasting database. Functionality should allow users to input new customer order details and secondly to be able to leaf through records to find particular orders. A main form contains generic customer...