Search results

I have a subreport in my main report. In design view the header contains label boxes, the detail contains the text boxes and the footer contains some other details. However in layout view and when i view the report normally it only shows the detail!? I need it to show the details in the header...

I have two boxes, one contains an order date and one contains a required date. I have code that compares these so if the required date is earlier than the order date an error message shows. If this occurs then i want some code to clear the two boxes ready for new dates to be entered. Here is my...

I have a form called F_Specify_period. It has two boxes on called 'Specify start date' and 'Specify end date'. The users can currently choose dates in this box using the calendar. What i want to happen next is that they hit a 'find order' button. This button will find all the orders that relate...

On my main form F_Orders i have two text box's. One contains and order date and one contains a required by date. I want to create a macro or something that will check the validation of these entries before the order is confirmed. In this case if the required date is earlier than the date...

How to stop duplicate records? I have a subform with a button that transfers the data to another subform. At present if i attempt to transfer the same data across it appears with the standard access message. I need to add functionality so that the button notices a duplicate record is being...

I have a bombo box that selects product details, once the details are selected a click button transfers the data from one form to another. The problem i have is that when it transfers the data it keeps copying over the same record. What i need is it to appear as a new record in the subform i...

I populate the fields of one subform by using a combo box, these fields contain product details. Once this data has been obtained i want it to be added to another subform, this is an order subform ready for the products to be ordered. i want to do this by using a button, therefore when a...

Hey guys, first of all i am a student. I have done some work on databases using Oracle but im completely new to Access so please bare with me. Also im nor sure if im in the right forum but here is my issue. I have a subform called product catalogue. It links to a form that is populated by a...