Search results for query: *

Hi John, The field only seems to be adding a single field i moved the text box into the detail area and it seems to be displaying each total again. Cheers Mark

Hi everyone. I have created a virtual money box for my son and when i generate the report it gives me the list of who gave him what how would i put a single field to add the whole column up so it gives me a total paid all together. Cheers Mark

Hello again apologies for asking 2 questions straight after one another. I am trying to run a report that will only display data in specific boxes and if the box has no data in ignore it. I am using code for a single box but my problem i have 10 fields on the form qty 1 - qty 10 now when i...

Hi guys I have a database that I am looking at making specific records stand out when I scroll through the form. I am trying to make a text box or something similar stand out when I click a command button. Can someone help? Kind Regards Mark Swansborough

Good afternoon forum users and MVP's. I have created a form that stores orders, i have just created a second form for the use of quotes. I use this so i know at the end of ever month what outstanding order and quotes there are. I first of all place a customer in my database as a quote, when...

Thank you very much Zameer. It works better than expected. I have a command button that prints my report. Makes life easy, is it possible to have a form popup that lets you specify the date range you want displaying on the report? Thanks very much Mark

Apologies if I sound a little slow, When you say code window, is that it the top left corner of the report? If so under which option within the window? Apologies Kind regards Mark

Thank you for you reply ZmrAbdulla Where would I attach the code? Kind Regards Mark

Hi everyone. Is it possible when using reports to only display data that contain information? My report has 7 fields 1 field will always have information in but the others are blank when i print my report i only want it to print the lines with data in the fields so blank ones are not. Is this...

Apologies for posting in the incorrect forum, i did look but couldn't find the report forum. Anyhows i'm relativly new to reports and i don't understand your response could you elaborate a little or could you place a link so i can search the reports forum. Mark

I've looked on the forum and i think my problem lies with the use of filters. I have many records on my database 212 on the one table to be exact I have 2 departments when an order is placed it is given a department number. The 2 I use are WFBG and WFJB, following these department numbers is...

Thanks for your replys guys. I have linked a few test fields together to try and solve my problem. I can now add the fields to my new form from the 2 diferent pages but only the information from the 1 table is showing. I have tried using a query and running the form from that but it does the...

I've not used any relationships before as i know nothing about them i have tried putting all my information on one table but have run out of columns. If i have 2 identical tables saved under different names and i'm looking at putting product1 and product2 from both tables on a form what...

Thanks again Trevil. I'll have a play and see what i can come up with. Mark

Thanks for your reply Trevil. I originally looked into having a basic form with multiple forms attached for many different orders but I’ve already created my order form and don't fancy remaking it unless I really have to. The comment about "..press the same command button and input the...

Good Afternoon everyone. Please bear with me as this is a very complicated problem. I have a database that i hold customer information both personal and product. The problem i have is i want my customers ID number to stay the same no matter how many times they purchase things from me. I have...

Hi guys i am using 2 forms both need to be able to print the same data the one form works fine now i've added 2 command buttons with the following code attached to the onclick event could someone please tell me where i'm going wrong as i keep getting the debugger appear Private Sub...

Thanks Zameer. I have rewritten the code within the report to take the total from there as opposed to the form. Thank you very much for you help. Mark

Thank Zameer. It's gone past the error now but it's still not filling the field with the total it's just blank. Many Thanks Mark

Thanks for your reply ZmrAbdulla I have just tried your solution and it's telling me The expression you have entered contains invalid syntax You may have entered an operand without an operator. The code i have used is =Sum[text106] I'm sorry to be a pain. Kind Regards Mark