Search results

I was putting the code in the Open event for a report. I want there to be no toolbars generally. Then, when someone opens a report, the "Print Report" toolbar will show (so they can print it and close the preview page). I also plan to hide the toolbar in the Close event of the report, but I...

No error message, but no toolbar either... Thank you so much Andy. The code you gave me does not produce the error message anymore, but by toolbar is nowhere to be seen either... Any ideas as to why? When I try to follow the suggestions of the code editor, it prompts me for an =. I guess I...

I do not know anything about writing code, but code builder sometimes helps. I am trying to follow what it suggests, but it keeps telling me it is expecting an = somewhere. I used ghudson's code to hide all toolbars and I want to add a custom toolbar to my report previews. The custom toolbar...

I found the way to fix this problem on the chart as well. View the properties of the chart and click on the ... in row source. Select a sort order for the field you want to sort by in the chart's underlying query.

I am trying to keep my charts from being color-dependent for people to read them. I have a bar graph, for example, with seven different colors being compared in a bar graph. In the design view the chart shows only four of the seven "data series." I have been able to format them one by one...

Great-Thanks again Wayne!

Does anyone know a trick to have reports and charts order weekdays the way the calendar does and not alphabetically? It looks really silly to read my graph with Friday coming first.

I have a chart in a group footer of a report. The data is displayed correctly for all but one group of records. Why should this be? When I mess with the links of the report to the chart or with keeping together or not keeping together the group it changes which group of records has wrong...

Yes, that is it! Thank you both so much!

Invalid syntax??? I am getting an invalid syntax message with that... Too many or too few quotes???

Can someone take a look at this and hopefully spot my error? =DLookUp("[BxName]","TargetBxLabeledTable",'Tables!TargetBxLabeledTable!StudentFullName =' & [StudentFullName] And 'Tables!TargetBxLabeledTable!BxLabel =' & [Bx1Label]) Right now the field in my report is looking up the first value...

Nevermind! I got it working with: =DLookUp("[ObjectiveSummarized]","ObjectiveSummarizedTable","ObjectiveSummarizedTable!ObjectiveNumber = " & [Ax1Label]) For anyone having a similar problem I hope this helps. I guess because Ax1Label is a number field my quotes were the problem. Thanks for...

I think I didn't explain that well... I have ObjectiveNumber stored as data on a daily data entry basis. When I print an annual report I would like the report to lookup the actual summary of that objective in the ObjectivesSummarized table. ObjectiveSummarizedTable is like this...

Paul, Thank you so much for your reply. That prompts me for a parameter value. The issue is that Ax1Label is the field in the report. ObjectiveNumber is in the table whose values I am looking up. Does that make sense? Carly

Hello, I am trying to use Dlookup in an unbound text box on a report and I am having trouble specifying criteria. I have the following in the control source: =DLookUp("[ObjectiveSummarized]","ObjectiveSummarizedTable","[Ax1Label] = '" & Tables!ObjectiveSummarizedTable!ObjectiveNumber & "' ")...

Thank you so much Wayne! What a silly mistake. I thought the problem was in the date field and totally overlooked that I made a change to the name field. Thank you so much for catching that!

Ok, here it is. Thank you so much for taking a look at it! The query pulls data if you just try to preview the data in datasheet view and manually enter the criteria. When you try to use the form it pulls nothing. See what you think...

I am trying to do something that should be quite simple and I cannot find what is going wrong. I have a report based on a parameter query. There are two fields that prompt for parameters, NameField and DateField. When prompted for criteria it worked, but you had to enter the criteria as...

Andy, Thank you so much for all your help and patience with my questions! Carly

I guess I was just worried about someone deleting or renaming the dll file. I was hoping someone might know a code that could be in the database that would disable the mouse. There are some nice solutions I've read about in the forum, but they seem to give options to turn the mouse wheel back...