Search results

Hi I have a form that uses 10 fileds for entry. The fields are Building descritption and building price (from 1 to 10). Not all 10 will be filled in, so in mt report I only want to show the fields that have prices in and I want them all together. Could someone advise how I acheive this...

Hi All I added this bit of code into the control source of a txtbox but I am getting #type1 in the report field instead of the correct text =[build1desc] & ([building price1]+(Chr(13) & Chr(10))) & [build2desc] & ([buildingprice2]+(Chr(13) & Chr(10))) the build1desc is the field name any...

Hi Thanks for the reply, I think looking at what I am doing I may have asked not quite the correct question. Sorry.... What I am now doing is creating a sub form based on build1desc and buildingprice1 build2desc and buldingprice2 etc...... all the waa up to 10. The I get a total...

Hi Just another question on this one, what if I needed to have headings next to each one This is my code =([sitename]+(Chr(13) & Chr(10))) & ([siteAddr1]+(Chr(13) & Chr(10))) & ([siteAddr2]+(Chr(13) & Chr(10))) & ([siteAddr3]+(Chr(13) & Chr(10))) & ([sitecounty]+(Chr(13) & Chr(10))) &...

Hi I have a similar code in the address field; =([sitename]+(Chr(13) & Chr(10))) & ([siteAddr1]+(Chr(13) & Chr(10))) & ([siteAddr2]+(Chr(13) & Chr(10))) & ([siteAddr3]+(Chr(13) & Chr(10))) & ([sitecounty]+(Chr(13) & Chr(10))) & ([sitepostcode]+(Chr(13) & Chr(10))) This is ok for the...

Hi I ahve a quote screen that as potentially 10 areas to add prices in and each one with free text descritption field. On the report for this quote I Only want to see the fields with a price >0 and not all 10 and I only want to see the description fields if it as a price so for example...

Hi Thanks for the reply. I added the fields again and adjusted manually, but i like you method ="Estimate Date: " & fieldname and will keep this for future reference. Many thanks

Hi I have a report with a log brought in as an unlinked object. However, I want the users to be able to add in another logo if possible without having to go into report desing etc....... Does anyone know of a way that this can be acheived, for example replace exisitng logo with new...

Or How can I get back the textbox lable. If you delete label for your txtbox is there a way to retrieve it. Thanks

Hi I have a lable called label93 which as a caption Estimate Date: I also have a txtbox called text93 with control source =Now() When ti shows on the report Estimate Date: 07/05/2011 How can I get them both so they are next to each other so it looks like Estimate Date...

Hi I have created quite a complex report built from over 20 sub reports (due to it having to be a document rather than a report). So I have some questions if someone could kindly advise or point me in the right direction.... 1. How many sub reports can 1 main report handle? 2. Is there a...

Hi Bob Again please ignore the last post, I have number 4 working now. Basically I forgot to put it in as code and also I needed to add the new field into the quote (which i can hide). I played with the code a little and amazingly for me it works pheww. Well many thanks for your patience...

Hi Bob Its ok on the last post, I managed to work it out and used 2 txt boxes and referrred to them in onclick as two lines and same on the report front page..... I am learning slowly ha ha Now to the last phase number 4.... The quote uses tablequote for record source and the reports...

Hi Bob Simple for the inivisble field, thanks... For the report to get this txtbox1 = Me.cbo_user.Column(5) txtbox2 = Me.cbo_user.Column(3) Do i put this in the On Click on the forms or on the control source txtboxes in the report. I tried this in the control source but get #name...

Hi Thanks guys perfect, I have that working well now. Next about invisibilty, if I dont want the txt boxes showing on the menu and quote screens etc.... (need it on the report of course), is there away for it just to hide this particular field. I know you mentioned Invisible forms bob but i...

Hi Bob I am plaing with the code and I am trying to get it to put the full name and position of the user. I have this which works Forms![main].Form.txtCurrentUser = Me.cbo_user.Column(5) & Me.cbo_user.Column(3) But I cant get a space in between the user name and the position. tried , "...

Hi Now I see the line in the code. If I use Close button on Quote or Print then I assume this code goes on the Click code there. My only worry with this is that a user may close it another way, but getting closer to them using it I suppose we can hide all other buttons to close, but the...

Hi Bob Ok I can see the name on the Menu form and also the quote screen, but I dont understand where it is getting the data into it from, please explain. Also I noticed if I close the quote form or Menu it loses the currentuser name, so I ahve to keep logging in (is this right). Of course...

That is sad to hear and I am also am so sorry for his family and friends. In the short time I have been a memeber on here David as helped me quite a few times with which I am very thankful....

Hi Thanks for the replies, it works well now.