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

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

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

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 #" &...

Hello good people. I'm working with a report that pulls data (text) from a query and it works fine. What I would like to do is: >>> IF a text box (text71) in the report is blank (no data found in the query) then show "No Issues" I currently have =[P1.DRV] & Chr(13) & Chr(10) & [P2.PASS] in...

Hello. I've created a DAILY report to show data (text) entered into a table and I need help with it. I tried searching the forum and could not find any answers. I want the text box in the report to get data from 3 queries which have a date() criteria. P1 and P2 are queries of the original table...