Search results for query: *

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

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

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

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

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

Hi everyone. I have created a form that prints all relevant boxes into an invoice. I have assigned a command button to my form to print report but instead of printing that specific record it prints them all is there some code i could add to the onclick that stops this thus helping my problem...

I have numerous combo boxes on my form when i select the relevant item it displays in my table as a number not as the text selected is there any code that will enable me to see the text as opposed to the position number. Kind Regards Mark

Good Afternoon everyone. I have a small but basic question. Is it possible within access to have a command button that once pressed can copy the contents of 2 text boxes into 2 other text boxs? Kind Regards Mark

Hi everyone. I have a pretty basic problem which has bugged me for a little while. I have a database that has numerous pages lets say i'm on record number 10 when I open a page from my form it automatically defaults to the first record in the database. is it possible to automatically open the...

Good Evening all. I have a table that uses 2 columns one for descripion and the other for cost. This is linked to a bombo box on my form that automatically updates the price using this table. My problem is this, i am trying to create a second form that allows me to change the price of each...

I have taken a look on the forum and have found some information but it's a little confusing does anyone know where i can get or could someone provide a walkthrough on how to create your own Search box to be used on a form. Thank You Mark

Hi everyone. I have created a form that pulls data from column 1 in a combo box and places it in a different text box. The information is used as the price of the product. The information is taken from a second table called ProductID, my problem is when I need to change my prices within the...

I've searched in the forum but i'm unsure what to look for regarding this problem. It's an easy one i think. I have a button on my form which when i press it takes me to a second page where i can change the details on the first as the first page is view only. If i'm on record 6 on the first...

Hi all I have a problem at the moment that i need a little help with. I have created a form with a little help from some folks on here. I have a listbox with 15 different products in i am looking to be able to select the relevant product press a key or button that will transfer the information...

Hello again folks Thank you for all your help with my last problem i now have another question this time it's a lot less technical. I have 8 boxes on a form once a product is selected the price automatically is displayed in the box next to it. What i am trying to do is get the totals box at...

This question has been asked but i need a little more information as i'm still struggling to answer it. I have a combo box that i select one of two different products from. I have two columns within this combo box the first has the product description in the second has the price. When i select...