Search results

Maybe I'm looking too hard but I can't find a way of changing the format of the data labels in a graph. They default to black but I have a dark background so want to change that. Does anyone know how to change this value, please?

I compared my nav form with yours and couldn't see any difference then, suddenly, mine worked. Strange. Thanks for your help.

Hi, sorry but I don't understand. Was I supposed to simply copy and paste your code or did it need changing for my circumstances? Also, when you say 'Double-check the name for the subform control' check it where? Apologies if I sound dumb.

Hi. Tried it but it returns #Name? error.

Hi Is there anyway to show the name of the active subform in the nav form header? I've tried something along the lines of the below but this doesn't work: [Forms]![NavigationForm]![NavigationSubform].[Form]

I kept getting errors but, long story short, I had spaces in the references which I've resolved now and your code works a treat. Thanks for your help :)

What did you set the rowsource to? May be this is why I can't get it to work. I'm not sure how I could hard code it in the form.

I just tried your code in an expression in the before update event for combo2 but it didn't work. I haven't tried it via vba as I was under the impression it wasn't good practice to use Select queries in vba.

I've just taken another look at this and, I'm guessing it is somewhere along the lines of what I'm looking for. However, I need to check the values in Dept field to each query linked to each report. As there are many I created a TempVar. So, the report would be selected in combo1 and the...

Thanks. I've had a quick look and I'll have a go at implementing it shortly and let you know.

This may be a bit ambitious but I'm hoping it's something that can be achieved. On a form I have two combo boxes. In the first the user can select a report. In the second they can select a Department to filter the report by. What I would like is for the list of departments in that combo box...

Hi arnel I tried adding acHidden as you suggested but this also seems to hide the save dialog box. As there is no default "save to" filepath this needs to be selected by the user.

Hi I have the below code to save a report to pdf. However, I don't want the report to open so could someone suggest what I need to change in the code, please: Private Sub CreateReportBtn_Click() On Error GoTo cmdPrintMapArea1_Click_Err DoCmd.OpenReport Me.RepNameBox, acViewReport, ...

That worked, eventually. I couldn't change it initially because the property sheet was locked up. But that seems to have resolved it. Strange because it worked perfectly in the On Open event before. At least it's working now. Thank you for your help.

No, I don't know.

Hi. It won't open manually. I've attached a screenshot of the error message.

I'm getting a 2501 Open Form action cancelled error when I click the login button on my login form. On selecting debug the highlighted code is: DoCmd.OpenForm "Navigation Form" The Navigation form has an On Open event which calls a tempvars macro: Private Sub Form_Open(Cancel As Integer) If...

Update: Now resolved my criteria issues and have managed to successfully update my records using the above method from arnel and DBGuy. Thank you.

Thanks, I'm working on it. I'm just having an issue with criteria which I'm trying to resolve. At least I know where to start now. Thank you

Thanks arnel. How, though, do I select the specific records by using an update query? Or is that part of the query process? I've never used an Update query before so apologies if that's a stupid question.