Search results

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

How do i make the criteria of the colour to be the value selected in the list box

What i have is a stock control system. What i would like is to be able to display all the colours we have in a list. Then from this list be able to select a colour and then show all the stock levels for this. How do you suggest the best way to do this?

What would go in the conditional formatting?

Im trying to use some vb code in a form which simply changes font colours. It is for a stock control system. The stock control system includes three items: colour, stock and minimum stock. The code is: Private Sub Form_Current() If Me.Colour = "Red" And Me.Minimum_Stock > Me.Stock Then...

I have tried to use this: Private Sub Form_Current() If Me.Colour = "Red" And Me.Minimum_Stock > Me.Stock Then Me.Minimum_Stock.ForeColor = vbRed ElseIf Me.Colour = "Green" And Me.Minimum_Stock > Me.Stock Then Me.Minimum_Stock.ForeColor = vbGreen ElseIf Me.Colour = "Blue" And Me.Minimum_Stock >...