Search results

Okay, this one is driving me nuts. I want to combine two fields in a query to create a unique ref which i already have created in another table. The format is this: AdviserCode&ReviewMonth&ReviewYear This gives a ref of i.e. CJW082010 However, i also have a query above which needs this...

Apologies for this but it still dosent seem to work. Here is the Visual Basic code i have on the detail sections ON FORMAT. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Label30.Visible = Not IsNull(Text21.Value) Label31.Visible = Not IsNull(Text21.Value) End...

I have used that code and replaced it with the names of the 'labels' which i need to make invisible. Sorry for the confusion in my topic post. I currently have this: Label30.Visible = Not IsNull(Text21.Value) Does this look right to you? Label30 needs to dissapear if Text21 is null. Also...

Is it possible to set a text box on a report to only appear if another text box is not null? I have a hunch that this is something to do with setvalue or similar in a macro? or even in the basic query the report is based on. Any ideas? Thanks!

Here is an interesting one for all of you amazing experts out there. I have a report which has a front sheet and back sheet. The above are both in the detail section of the report with a page break between them. When you print this report, depending on the amount of clients it picks up, you...

Done and dusted. Thank you so much!!!

Close, however i only want the box to show a "" empty string when both the clientID and the Joint Owner ID are null.

Is have a two fields which take thier value from a table. The first is [ClientID] The second is [Joint Owner ID] Basically, on my report i want to do the following. If [Joint Owner ID] has a value then i want it to show "Joint" If [Joint Owner ID] doesnt have a value then i want it to...

Again, thanks. Helped a treat. :)

Next question, I have another field in the report which is called RegularPremiumFrequency and this pulls its value from a table i have with all of the main policy data. I want the value to always be what is in the table against that policy i.e. Monthly or Annually. However, if there is no...

Thank you so very much! Worked an absoloute treat! THANKS!

Um, none of them. Its a report. Just checked to make sure i posted this in the report section and i did. So no, not a form, just a report taking its fields from a query.

Hi everyone, I have two fields. The first is RegularPremiumAmount and the second is SinglePremiumAmount. Basically i want the report to default display the RegularPremiumAmount but if this is blank (or null?) then it will display the SinglePremiumAmount automatically. Can someone help a...

Thank you to all the above who have helped me, especially Trevor. This is now working an i appreciate the assistance!

Hi, not sure wether this the right place to post this but here goes. I have one table which has two columns, Adviser Code and Adviser. Each code is an abbreviated version of the full advisers name. I currently have a form which has two combo boxes. The first combo box looks up the table and...