Search results

I am trying to set the back color of a rectangle (called SignalBox) on a report. The color depends on the value of another field, ItemStatus, which will have a value of a,b, or c. Can someone look at this code and tell me why I get this error? The report is based on a query. ItemStatus is a...

I have a MainQuery with the following fields: ID-(the patient's ID) Score ItemID I am trying to get the highest score for each patient and be able to identify which item was their high score, so basically I want to end up with the following query results: ID (Patient'sMax)Score ItemID To do...

I have searched all over on this and I can't find anything, though I am sure it must be a simple problem. When I print my report it appears shrunken in the upper left corner of the paper (I mean tiny!). On print preview there is no problem--it appears full-size and accurate. Does anyone know...

I have a form with a test list. Each test is a record with a yes/no checkbox, and controls for testdate and examiner. I don't want the user to be able to exit a record if the yes box is checked and either the testdate or examiner fields are blank. The code I am using is: If...

I have a table with a multi-field unique index: PatientID TestId TestDate Examiner The problem is, date and/or examiner can be blank until that information is updated. I want those null values to be understood as actual values so that multiple instances of that "waiting to be updated" record...

I have several tables of test scores(Test1, Test2, etc.). I want the report to contain these scores as well as their percentile ranks and descriptions. I have created a table of all the possible scores and their corresponding percentiles and descriptions(NormsTable). I have been having...

I have a report with two subreports. The first one is ok, but the second subreport's source object changes to that of the first subreport when I save the main report. I change it and it changes back. My report is rejecting this source object like an organ of the wrong blood type. I must be...

Does anyone know how to change a field FORMAT default? I am creating lots of tables with lots of number format fields. I don't, however, want a zero default value (or any default value for that matter) for all of these fields. I can go in and delete them manually, but that seems like a...

I seem to be stuck in a tricky situation... I have a subform where records can be added or edited. There are two fields: firstname and lastname. I want a message box to appear when a first or last name is edited. I do not want that message box to appear when a new name is being added. I use...

Can anyone point me in the right direction on this... I have a field on a form where data can be added or edited. I would like to have a message box appear when the data in the field has been changed. I do not want the message box to appear when a new record is added. I tried using the On...

I am looking for some advice... I am making a database for school programs that will receive lots of data every day. They will use one copy of the database for each classroom. I am worried that they will become too large very quickly because of the large amounts of data being entered daily...

I am trying to avoid having my form or report names visible in that top blue bar of the database. When I set the form's pop-up property to yes I was having trouble with forms being maximized. Is there another way to have them not show, or is there a better way to use the pop-up function...

I found a great example by ghudson for disabling the close button on the database window and it works great. I have searched high and low for a similar way of disabling (or even hiding) the restore and maximize options (though I am ok with minimize). Does anyone know how to do this? (I don't...

I have used ghudson's code in the Open event of my main form: Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i To hide all menus and toolbars. I would like to show a single, custom toolbar when reports are opened so they can be printed and then closed...

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

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

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

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 & "' ")...