Search results

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?

i don't want to type in a value at all, i just want the text box to display the Mini ID with the highest value at all times which isn't 'activated', as such, but just is... i realise my posts contradict themselves but this is only because i've got so desperate i've considered all options open to...

i have got a form based on one table, called tblcar, and in in is a field called Mini ID. I'll call this Mini ID2. It is a number. I have another table which is not bound to any form with another field called Mini ID which is an autonumber. i'll all this Mini ID1. what i need is a way of...

hi i've got a table called tblcar and a field in it called Mini ID which is an autonumber. i have also got a form attached to a different table with a text box on it that i want Mini ID to be displayed in. i have entered the DMax code: DMax=("[Mini ID]","tblcar") - or whatever was shon to do...

hi...and thanks. i think DMax is the route to follow, but although i have decided that this is what i need by getting the text box to display the Mini ID with the highest value in order to enter it into a seperate table, i'm not sure if i've got the syntax right. i've entered the syntax...

hello and thank you. i haven't made any alterations yet, but i'll let you know how they go when i do. in reply to you IanC, the textbox is unbounded and you saying i don't need a module is great news. however, is what you're saying this: in control source i should type the DLookup expression...