Recent content by lakattack

The message box is fine coming up when I want but it needs to check the status in my tabular sumform. If it does say 'Despatched' then it should close but if not the message box with the yes and option (which I have done) Subform tabular name: TabCtl78 tab name: StatusHistoryPage entity (that...

Hey, I would like to know how I would go about putting a message box with a yes and no option on it. On my database form I have a subform inside it in which has a tabular form on it and basically on one of the tabs if it does not have say despatched then on exit a message box should say 'There...

Yes it is in the main form. The coding is in the close form button. It is not on the On Close event. Does this help?

I want the code to be in the part where if the Name field has no text and the user wants to close the form then the message box will pop up and it will not close the form until the Name field has been filled in. Is that possible? Thanks

I tried using this in my main form and subform and stil it does not work. Do you have that database that you can send me? I do not want the form to close but it closes even if there is no text in the textbox but the message box still pops up. Thanks

No this does not work! What should I do now? I was thinking of using setfocus but did not know if this would work! What should I type into my coding?

Where would I add that to this code: If Me!frmEquipmentSubform.Form!Name > "" Then DoCmd.Close acForm, "frmEquipmentSubform" Else MsgBox ("Enter Name") End If Thanks!!

This kind of works... My code is now: If Me!frmEquipmentSubform.Form!Name > "" Then DoCmd.Close acForm, "frmEquipmentSubform" Else MsgBox ("Enter Name") End If If I click the exit button on the form and nothing is typed in the textbox then the message box comes up and closes If I click...

I typed in what you said and the message box still comes up as: 'Microsoft Access can't find the form 'frmEquipmentSub' refered to in a macro expression or Visual Basic code' Any more ideas please!!!???

I just typed in: If [frmEquipment]![frmEquipmentSub]![Name] > "" Then DoCmd.Close acForm, "frmEquipmentSub" Else MsgBox ("Enter Name") And I just got an error message saying: 'Microsoft Access can'e find the field '|' refered to your expression' What should I do? frmEquipment = main...

Hello. I need to know some validation coding for my database. In my subform of my form I have a text box in which you can enter data but you must enter data in that textbox before closing it. What would the coding be for this? Thanks

Hello! I need some serious help with my database, I am struggling badly with my database in doing my validation, error messages and queries. What I need help with is this, • Set up a form to allow the input and display of details of a Show. For example the user should not have to remember...

I am trying to connect it to my web server at home. I just want to know that it works thats all. I just want to show the names of the CDs in Aoefa's (the person) collection over the internet. • Aoefa would like to be able to view details of her collection of CDs via the web. Using ASP create a...

Hello! I was wondering if someone could try and connect my database to the web. I would like to view the names of the CDs in her collection over the Internet. My database is attached! Thanks

Hello! Can someone tell me how to do a validation. The one I am trying to do is check Track No is not duplicated. I have added my database if you may need it. Can someone help me please! Thanks