Recent content by nj2la96

Sorry Doc, we are not doubting you. We were just saying that it didn't work as you described. Granted, I am using Access 2016 so maybe things may have changed since, but I have tried putting the same code in the OnPrint and OnFormat and alternating the display when parameter and none of those...

I concur with sneuberg.

Thank you for your response. Your sample database looks a lot better. Thank you, I will try this out now. Thanks for all your help.

Hmm....seems a bit messy. I can't believe something so simple could cause so much difficulty. I'll try and see if I can get other ideas. Thanks.

sneuberg, Thank you. I tried your idea but the invoice still shows, ever so slightly, the fields we don't want. Bob, I haven't tried your idea yet but the last suggestion of changing the formula in text117 seems like it would be a problem if the quantity is 1, wouldn't it?? Because from your...

Thanks for the reply. On the OnFormat event of the detail section, I have added the following code: If Me!Quantity = 1 Then Me!Quantity.Visible = False Me!UnitPrice.Visible = False End If I have attached a portion of the db, as you can see from the report, the 2nd line has quantity of...

I am creating a report that has command buttons (i.e Save to PDF, Print, Email etc) on the report header section, but these buttons can only be viewed when the report is shown on Report View and not Print Preview. However, on the same report, I have a couple of fields in the detail section...

Oh wow. Thanks a lot. It worked!!! You've someone very happy ty

Thanks for your response. I tried that but no luck, I still get #Error. I'm in UK so the format for me would be dd/mm/yyyy. It's really weird that it works on certain fields and it doesn't on others. I've looked up the table and the data looks right to me Any other ideas?

Hi guys, I am trying to do a simple query to get the running total from a field. I have ClientID, InvoiceDate, and InvoiceBalance fields and I am simply trying to get the running total of the InvoiceBalance field for each ClientID by InvoiceDate. Now I've used the formula But this seems to...

that did the trick. Thanks a million. *thumbs up*

oh no you misunderstood. It was a main form containing a drop down for clients, then in this form is a subform containing the properties. Within the subform properties is a button which OPENS (not a subform) a new window containing the third subform for the jobs. My issue was that entering...

thanks I will try this out now. The easy fix I found was using nested subforms so at least there is an option. Thanks I will keep you posted.

I apologise, I don't think I follow you completely. 1. have an unbound hidden control (we'll call it lnkProperty)...do you mean like have a disabled text field with these properties? 2. property subform recordsource=tblProperties - link child and master on clientID..if the recordsource is...

Hi Guys, New to the forum. I need help on some vba coding for a db I'm developing. The Setup: There is a clients table, a property table and a jobs table. Each client can have multiple properties and there can be multiple jobs done on each property. The form: I created a form that uses a...