Search results

Hello, sorry for the vague title. I didn't know how else to word it. So lets say for example I have a continuous form with 1 text box and 1 image. By default the image's visible property is set to 'False'. Is there a way using VBA or otherwise to basically say 'If the text box text = 'Yes' then...

I have to create a report that replicates another created in excel. The problem is I have no idea how to do this in my current situation. The design is in such a way that I don't think it allows for traditional record generation. The only option I have found is tedious and even that has been...

As the title suggests, I am looking for a way to hide or filter out the records in my reports if all of the values are 0. My problem is that all of my reports have their filters set on the event that opens the report. I use an If statement to decide which report to open, which means that...

I have a form that that contains a button that opens a report. The code I use to open said report is: DoCmd.OpenReport "Comp and NB Targets Q4", acViewPreview, , strWhere The issue is that occasionally when the user prints from that preview, it can instead print out the form in the background...

I have a report that is filtered like Year_ = "2014/15". Say for example on this report it contains two text boxes: Text box 1 has a control source of "March_T" Text box 2 has a control source of "Aprril_T" How can I make text box 1 be filtered by Year_ = "2014/15" and text box 2 be filtered...

Is it possible to only display a specific number of records with multiple filters of the same field. So say I have a table with 2 Columns: Name Address Can a user basically search for multiple records based off of their names? Maybe by using a form where they can input those names like this...

For the report in question all data is taken from one table named "Completions £". The fields I will be using are as follows: [Surname] [Firstname] [Branch] [Quarter1_A] [Quarter1_T] When the records are added, the Branch is added using a combo box. There can be several rows of data with the...

I have a single expression that seems to be causing this error. At it's current state this is what it looks like: IIf([Year_Total_T]=0,0,Sum(([Year_Total_A]-[Year_Total_T])/([Year_Total_T]))) This isn't the first time I have gotten this error. I initially had this expression...

So I have a report with the following text box controls: [Surname] & ", " & [Firstname] =Sum([Quarter1_A]) - Named "Quarter_Total" =Sum([Quarter1_T]) - Named "Quarter_Target" =Val([Quarter_Total])/Val([Quarter_Target]) - Named "%Target" (Percent Format) The report is grouped by the expression...

I have 5 tables that I would like to input data in. It can only be done with a single form. The fields I want to input in have the same names in all 5 tables, for example: Table 1: Name Age DOB Table 2: Name Age DOB Table 3: Name Age DOB Table 4: Name Age DOB Table 5: Name Age DOB Is it...

Hello! I am an Access novice and new to VBA. Looking for general help whenever I am in need of it :) Kind Regards, Simon