Search results

barry, if you was to check my first post,im pretty sure it wudnt be hard finding a 'please' in there!!!! anyway away from the playground, emma thanks for ur info....... emma do u have (please) any example i can look at? or can u expand on the 'undo method'??

the following code is used for adding new users: Private Sub addrec_Click() On Error GoTo Err_addrec_Click If Me.NewRecord Then DoCmd.Undo Exit_addrec_Click: Exit Sub Err_addrec_Click: MsgBox Err.Description Resume Exit_addrec_Click End Sub and i am using the following code...

Seth ive tried your way but it doesnt work.............. ive got a clear button that clears the form but after clearing the form and clicking 'x' it only shows one validation 'date issued'. i have many more validations, but why does it only show the one 'date_issued'. It shouldnt show...

sorry barry, you must have fell out the wrong side of your bed today :) :) ok the code i have: clear button: Private Sub Command25_Click() Dim intResponse As Integer intResponse = MsgBox("Are you sure you want to clear all entries?", vbYesNo, Change) If intResponse = 6 Then...

Hi fellas, thanks for all ur help in my previous posts....... ive got this problem, ive got a form that provides mobile details. on the same form theres an add button and clear button. all the validations work....... if the forms incomplete then validations do occur. but the problem...

thanxs peep

BOb ur idea worked, thanks just a quick question, i get one message now stating all the missing fields. In the message how do i space out the text and put spaces between field names: for example: instead of: These item(s) were not filled out and are required...

Hi, i have a form that requires validation. i am using the following code: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.number) Then MsgBox "number is required", vbOKOnly Cancel = True Me.number.SetFocus End If i have repeated the above code for other fields......... The...

got it........ thank you

its a field for the date................ the date must be like the following : "17 November 2006". I DONT UNDERSTAND, why the cursor is on the right side?

Hi ive got a form that has several textboxes. The cursor in all textboxes appears on the left hand side (which is good), but one field shows the cursor on the right side??!!! how do i change this, i want the cursor to be on the left hand side like the rest? cheers

i need help!!!!!!! Has any1 got examples of the following that i can view: 1) simple form field Validations 2) Adding to a database using a form with a adding button ?????? i just need a few examples so i can work from them. Ur responses will be appreciated.

Alright peeps, Im trying to add details to a database called "tab_main". I wana add details such as phone number, name, imei no, PUK code, tariff etc etc for a mobile phone user. Ive created an empty form with all the neccesary text fields and also a seperate form for just the New User button...

thank you buddies........ it works now!

i have a form that allows to add details to the table "tab_main". ive got a clear button, it clears all textboxes apart from the textbox "date_issued". i get the following error message: 'Run-time error '2113': The value you entered isn't valid for this field.' Why am i getting this? ive...