Search results for query: *

This has worked perfectly, thank you very much!!

thanks dhookom, I'm afraid I'm not an expert in writing vba codes, what would the code look like and where would I place it??

Thank you for your reply. I have page breaks in between every subreport, so that two subreports don't end up printing on the same page. I have set all the "Grp Keep Together" Properties for each subreport to "Per Page" I'm using access 2003 and I'm still getting the same problem.

PHV this is now working perfectly thank you very much for your help.

Hi I have a main report which is filtered for each customer, the report contains about 7 or 8 subreports (Address Book, Feedback, Opportunities, Meeting Details etc) all relating to the chosen customer. For some customers, there may not be data in the meetings subreport for example. In this...

I was mistaken and this has not solved the problem. If anyone is able to help me that would be greatly appreciated.

I've solved the problem now. I put an IF function around it. If Me.Parent.Name = "Frm_Main" Then Me![Cmd_Add_Action].Visible = Not CurrentProject.AllForms("Frm_Main").IsLoaded End If Thank you for your help, been struggling with this all day!!

That's what I tried and it removed the button from the subform regardless of how I navigate to it.

I have done this and am now getting the following message "The expression you entered refers to an object that is closed or doesn't exist." The Main form is open when it runs. Is this because I have replaced it with MAIN? Because the name of the form is Frm_Main

I put this in the Load event and it still erased the button from the whole subform, regardless of where you access it. Private Sub Form_Load() Chk_Due_Actions.Value = DLookup("Default_Value", "SysTbl_Settings", "Control = ""Chk_Due_Actions""") Chk_My_Actions.Value = DLookup("Default_Value"...

I've been trying that but that hides the button from the whole subform, I only want to hide it when it is accessed via the Main Form.

Hi, I'm fairly new to access but I'll try to explain my problem as best I can. I have a main form, which includes a switchable subform (When a button is pressed on the main form, a different subform will appear) one subform is called "SubFrm_My_Actions" It brings up a list of all the actions...