Search results

Form "IAR_Entry" with multiple fields is being used to enter data into "IAR" Table. I am trying to a way to enter a field value (ID) on a form and base the report on the specific field value in the form, i.e. only show the records for that ID. I am able to do the above in the form using a combo...

For future googler, if you want a text box (in this case "ID") to change color based on another text box (in this case "Status") use: Select Case Me.[Status] Case "Closed" Me.ID.BackColor = 12632256 Case Else Me.ID.BackColor = 16777215 End Select

Holy S:eek:T .... That was it! Thank you!

p.s. I know you do not have access to access ;) right now. I checked the code in debug mode. Not sure what I was looking for. Was it about the backcolor?

Paul, I have attached a sample database, would you be able to review it please?

Issue resolved. Had to drag and drop the "attachment" from field list into report .. just like the form. Thanks guys

Me.Status.BackColor. The code I have now is: If Me.Status = "Open" Then Me.Status.BackColor = 16777215 End If If Me.Status = "Closed" Then Me.Status.BackColor = 12632256 End If Report print preview does not show any change in background color. :confused: Everything else seems to work ok in the...

Forgot to attach pictures

Followed the instructions to add code to Detail properties (see pic "Detail"). The code was giving me syntax errors (see pic "error"). Made a slight change to the code: If Me.Status = "Open" Then Me.Status.BackColor = 16777215 End If If Me.Status = "Closed" Then Me.Status.BackColor = 12632256...

Hi everyone. Database tracking various issues. Using a form to enter the data, which is recorded in a table. Table has a Field data type as "Attachment", Form has the option to attach a pic which was created by dragging and dropping the attachment field from the field list (add existing fields...

Sorry guys - I still cannot find where to insert the provided code. Please see the two pictures attached. "Con-for" is how the conditional formatting is set as (when print previewing report BG colour does not change) Other picture (Status) is of the property sheet tabs - Can you please direct...

Thanks man, I have used conditional formatting before in excel and am familiar with it. The report does not display the background color and i could not figure out why. Could you expand a bit more on "format event of the section containing the controls"?

Getting expression errors when trying the code provided. I went to report property sheet > on open > code builder > and the following code was addded: Private Sub Report_Open(Cancel As Integer) If Me.Status = "Open" Then me.Status.backgroundcolor = #FFFFFF End If If Me.Status = "closed" Then...

Hi everyone. Created a subreport from a query and I am trying to change the background colour of a text box in a report based on a simple criteria. If the text box displays "open" no background color or #FFFFFF and if the text box is closed then back ground color is to be #A5A5A5. Currently the...

Thanks SOS - that seems to have worked, however the TOTAL displayed in the report for some reason is ignoring the date criteria. It is giving me a total in the table - regardless of the date specified. I have attached a template that I am working on. Thank you.

thanks - tried that and no go. :( Still the error. Just wanted to let you know, that DATES is a date field in the "tracking" table.

Hi guys. I did a search in the forums and on almighty google, but could not find any solutions to my specific issue. The following code is used to display the "sum" of a field from a table. =DSum("[Front]","Tracking","[Front] DATES Between #" & [Forms]![Search]![Text0] & "# And #" &...

No resolution found yet. I temporarily added a text box which is filled in the form to say "No issues".

I checked for spaces, seems like access removes any extra spacing on its own. I have also checked the controls (to the bst of my ability) and don't seem to be the same as the two fields. I have attached another database. The issue seems to be with fields A, B, C and Dates. Where there is some...

SELECT Main_Query.field_a, Main_Query.field_b, Main_Query.field_c, Main_Query.dates, [P1 testing].DRV, [P2 testing].PASS FROM (Main_Query LEFT JOIN [P1 testing] ON Main_Query.dates = [P1 testing].Dates) LEFT JOIN [P2 testing] ON Main_Query.dates = [P2 testing].Dates;