Recent content by markswan20

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...