Search results

It should work but I don't get the message box unless I exit the record and then go back into it!! So more help please!!

I have put it on the Forms Properties on Current!!

This is virtually the same problem I was having before.. I want a message box to appear if a quantity entered is lower than a specified value. I am using....... If textbox = ????? Then If textbox2 < 10 Then MsgBox(????????[,vbOKOnly]) End If End If Someone please tell me what I'm doing wrong...

Your suggestion sounds good in theory, but the quantities of my minimum order fields are all different depending on the product it is referenced to. i.e. not all '10'. So how would I do this now?

Yes the maximize worked thanks very much!! I will try this validation thing.

I want to know if it is possible to set a validation rule to pick up values from a differnt table. For example I have a table of minimum order quantities and I am setting up a new table with the same field, but if a lower quantity is entered I want a message box to appear asking for a higher...

I am trying to set my form to open to full screen size, but every time I try it won't work. I think i'm missing something simple, but it is driving me mad..

I have no idea why this has happened, but I was working on a form, the screen crashed and now all of my VBA codes for command buttons etc have disappeared and everytime I try to redo them I get a message box saying Module not found. PLEASE HELP!!!

I don't mind cheating a little Rich....... All I am trying to do is like a summary form, where when an action is carried out the box is ticked - like on a to do list. I have set up a table originally with the fields set as yes/no. and set up a relationship with another table, so as to link...

I don't know a lot about this, how & why do they need to be bound to a control source?

I have set up a form with check boxes in when I select them and close the form, they are not still selected the next time I open the same form. Why?????

This is probably quite easy but it is driving me mad!!! How do I set the properties of an option group to allow me to select more than one check box??? I don't want to store the info anywhere else only to view it on screen or run a report from it. Please Help!!!!!!!!!

I have set up a subform with a command button to open a 'notes' form. I want it to only pick up data which is linked to the main forms record. I have set up a relationship between 2 matching fields but it still shows all records rather than just 1 specific one. Help!!

I have tried using a save code on the command button and on the form itself, but it still will not save the text. I have also tried deleting the command button and starting again bt for some reason it just will not save the text!!

I have set up a command button to open a form showing specific data to display. After typing in text and returning to the previous form the text is not saved. WHY???

I have set up a database with a subform, on the subform I have put on a cmdbutton to open another form - which is fine. But after I have entered text into the opened form & gone back to the main screen the text I have just entered is lost. WHY???? Also on the same forms I have asked the...

I mean the properties of the main form i.e not the subform are set to allow no addition/deletions, the data on the main form does appear, but the fields on the subform itself do not appear at all. The properties of the subform in design view are set to allow additions and deletions, I thought...

I Haven't got data entry set to yes, my main form shows the record, but it is the subform which does not show any fields!!

I have set my form properties 'allow no deletions/additions' But my subform now will not show any data (the fields do not appear at all!) WHY??

I have set the properties on a form to 'yes' on the data entry option, but I want to be able to edit other records in the same form.