Search results

Anada Q, how do i mark a thread closed i've searched but can't seem to get anythin bout dat...

I got it... here's ma code ElseIf IsNull(Me.PHONE_NO) Then If IsNull(Me.CELL_NO) Then MsgBox ("Please enter the Telephone or Cell Number") Cancel = True Me.PHONE_NO.SetFocus Exit Sub End If End If Thanks Bob 4 everything

Thanks Bob 4 everythin. I found out that it skipped ma save command and went straight to the close command Here's another problem I modified ma original code so that it can let the user know specifically what's required and not entered... I want the application to allow the user the option of...

K i've tried this but am not getting anywhere. Can u kindly let me know how to set up the flag?

Unfortunately it still get's closed afta complainin :-(

Hi guys I'm trying to force the user to enter the Customername, Contact person and (tel or cell nbr). Everything's fine for the customer and contact person as i hav made the required fields on the table. The problem is i the user doesn't enter the customername or contact person it complains...

i'll try this and update u 2moro. Thanks

Wow thank u. Now i want multiple users to use the same application but it's it doesn't allow them to make changes. it's complainin dat it's already opened elsewhere & in order 4 some1 2 make any changes they need 2 have exclusive access. I've made it shared application under tools but it's...

Hi guys Is it possible to make a link or somthin in some1's desktop (user) so that they can jut click on it and get connected to my Ms Access application. Is it also possible 2 just display d form (i don't want the user 2 b able 2 see nor access my tables, queries and code) Thanks

lagbolt thanks 4 responding. i used this code On Error GoTo Err_cmdGo_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form namr" stLinkCriteria = "field name =" & Me![text name] DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_cmdGo_Click...

Hi guys, am new in developing with Ms Access I use Access 2003. I've got a search screen which is working perfectly fine. now i wanna load the data that's = to the search criteria but i want it in another (seperate) screen Can u please kindly help as to how can i do that 1st screen (Search...