Search results

tried this....didn't work. Private Sub lblUPSINVNAFTASTMT() If Me.FUELTYPE = "Diesel" Then Me.lblUPSINVNAFTASTMT.Visible = True Else Me.lblUPSINVNAFTASTMT.Visible = False End If End Sub I only want to print the Label if the Fuel Type is Diesel

crap. weird...worked in layout view and then not in PRint preview...will try yours now Paul

While I was waiting I kept looking and found one that did work...so happy I want to cry!!! Thanks for your reply Paul

:banghead: I've tried 3 different codes and can't get my VBA to work... I have a report...on this report I have a label. I have the visibility property set to NO. BUT....IF the "FUELTYPE" combo box on the report is "DIESEL" then I want the visibility to change to YES Eyes are bugging out....

Thank you so much!

My tech is on my computer right now so I can't get to my database at the moment but I will as soon as I can.

I have a report that I inserted a background image and when I try to insert a field it goes to the top of the report page, extends the width of the page and won't move.:banghead: What's going on?

Remember, once you download them, you will have to relink to the new location from the front end.

this is the front end, the above is the back end. https://www.dropbox.com/sh/agkeanovmfadrw2/IdWycLypl8/Dealers2011_FE%20-%20Copy%20%282%29.accdb

https://www.dropbox.com/sh/agkeanovmfadrw2/h54Ursd9si/Dealers2011_be%20-%20Copy%20%282%29.accdb

the back end is in there too.

the forms and queries are the only ones there. to produce the report rptPWMSO go to the dealer tab in the form and click PWMSO button. PURST is the problem

does this work? https://www.dropbox.com/sh/agkeanovmfadrw2/0dCF58NTrn

I've taken out all the information, reports, forms & queries that I possibly can and it's too big to attach. I tried Zip and that won't accept for upload either.

Hi, I have a report that works great! I added a new model to my table "tblModels" today. It is set up EXACTLY like all the other models. When I run the report with the new model I get #Type in the Model and no results anywhere else...if I use the SAME vehicle but change it to a previous...

I'm looking for suggestions to speed up my report. So far I have 4 subreports in my report and 3 out of 4 of them have images that I have fields overlaying the image. I still have 4 more pages to add...and that is just for one report. I still have 2 more reports that will be 3 and 6 more...

Ha! Got it! So happy!!!

UPDATE! It originally wasn't generating because it didn't like the way the query was set up. Got that fixed...BUT...now it generates for SOME records and not others. I can't seem to find any correlation to the records. It isn't a certain customer, isn't a certain model. Any suggestions?

When i delete the two text boxes that are coming up in the first attachment as Error and Type, it still comes up blank. The one that comes up Error is =[enter sticker weight] the one that comes up Type is =Trim([MODEL] & "-" & [SERIES])

here is what it looks like when I double click the report and it comes up with all 9500 records.