Recent content by simeon_rose

thank you! that's perfect! i don't know how many times you've helped me now, but it's much appreciated, cheers!

hi...i don't mind everyone being able to see the button, in fact this would be preferable, and i don't mind having to put a bit of code behind the button - however, i've got no idea how to do this. in the current 'on-click' event is an 'open form' command...how can i state that the form should...

hi, could anybody tell me how i can set a password on a command button that opens a form that only administrators should be able to open? thank you in advance, simeon.

hi, i know how easy it is to create a command button that opens a table, but is it possible to create a button that opens the table in design view? i want it because i need an administrative side to my program that allows easy deletions of records etc...any ideas? i also need aministrators only...

sorry to keep on hassling you, but this problem just will not go away. i've tried your suggestions, but still i get the same annoying hitch. i liked the idea suggested by simongallop of simply making the Mini_ID textbo equa top the display of Text21, but the suggested syntax to carry out this...

the code behind the error message is: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.Text21) Or Me.Text21 <> Me.Mini_ID Then Cancel = True MsgBox "Incorrect Entry, You should enter " & Forms!frmaddadvertiser!Mini_ID, 0, "Error" Mini_ID.SetFocus End If the code behind the...

hi, i've got code that ensures that people enter data shown in a certain textbox into another textbox correctly by displaying an error message and then resetting the focus. the code i've got usually works fine...but then on adding another command button that closes the current form and then...

thank you, thank you, thank you.

thanks for the above suggestion...i no longer get that other run time error, however, i do now get run time error 2108 saying that i must save the field before executing the setfocus function. i don't kniw how to get around this, do any of you?

i've tried both your suggestions, unfortunately, neither of them work. when i try to enter the line of code suggested in the 'on enter' event, i get an error message telling me that the 'macro' isn't recognised (even though i didn't enter it as a macro) and when i try adjusting the actual code...

hi i've got a form with a textbox on it showing Dmax result from an unrelated table. i've also got another textbox on the same form into which i want the user to enter the output given in the Dmax textbox. when the user doesn't do this, i've set up an error message in the before update event...

hi. i've got a form and on it is a textbox with its control source set as DMax from another field. i have got another textbox with its control source set as one of my tables. i want the user to enter the digit displayed in my DMax textbox into the other textbox but need a validation rule that...

this doesn't seem to work. although the textbox is again bound to the correct field, the DMax function no longer generates the desired output. the box only ever has a 0 in it. is there somewhere else i can put the funtion that will make it work?

hi, i have a form and on it is a textbox that has its control source set to the Dmax function. it is the only textbox that i don't want the user to be able to use and so i have set it so that the user has no control over what is displayed in it. however, because its control source is now set...

THANK YOU...THANK YOU! it worked, at long last, it worked. there is still one problem however: why isn't the number generated in textbox added to the table that the form is linked together with the information from all the other textboxes?