Recent content by aman909

running it form a macro. How do i stop the warnings from the macro then

From a macro

I have created a delete query and it works fine. When the query is run a message box appears asking if you wanna delete the records etc....? Is there a way to stop this message box from appearing?

I have a form which contains a subform. This subform is in datasheet format. The subform contains a yes/no field. This is a tick box. What i would like to do is just to be able to delete the records which are ticked. For example if i have 10records in my subform but only 4 are ticked, then i...

The information is bound to a table

I have two tables, one called customers and the other called products. I would like to create a form called orders. On here what i would like to do, is a drop down list for the customer ID. When the customer ID is selected the rest of the fields get filled in with the correct details. So their...

Hello, I have a unbound text box on a form. This gives a total from a calculation. I would like this total from the unbound text box to appear on another form. I just need the total on the other form, not the calculation. How do i do this?

I would like it so when a form is opened, it opens in the maximised size that is possible. How do i do this?

Im not sure you know what im trying to do. Style is a textbox and will contain letters. Quantity is a numeric field as well as sum. What i need to do is, when a certain style entered such as crew, then do a calculation and display the result in the sum field. What i have tried to use is: If...

Hello, In a form im trying to use an If statement to do calculations. What im trying to do is this, i have 3 text boxes. One called style, quantity and sum. What i would like is when a certain style is entered, then in the some field it displays an answer from a sum. The statement i have...

Hello, What im trying to do is to create a report from a form. I have made a template for the report i would like to use. What i have is a form which contains details of a customer. What i would like to do is when on a certain customer to be able to view their details that are shown on the...

Hi, I would like to calculate the total on a form. But the problem is that i need it to calculate from 5 text boxes on a form, but not all this text boxes are filled out depending on a client. E.g. one client will have 3 out of the 5 text boxes filled out while another will only have 1 out the...

Hello, I have a stock control system for fabric that is produced. The stock control has contains details of every colour of fabric that is produced. We have about 40 to 50 different colours. Im now adding a ordering processing system to it as well. In this order system we have certain clients...

I have now changed that from ! to . But now everytime i run the query it is asking me to enter a parameter value

I have tried what you said to put in the critera. i put in: [Forms]![Stock]![Supplier Colour] It didn't work