Search results

Ok this code works great however i have noticed something. I have the code on a close button however there are alot of ways to get around entering the data e.g. they can move to a different record etc. Is there a better place to enter the code so that if they try and close the form or move...

Ok got it to work using: If Not IsNull(Me.DATE1) And IsNull(Me.QTY1) Then MsgBox "Please enter a Qty" Me.QTY1.BackColor = 8454143 Else Me.QTY1.BackColor = 16777215 DoCmd.Close End If If anyone thinks of a better way please let me know Thanks for your help

Hi I want the date field checked, if there is a date entered I need there to be a qty in the qty field if not I want a txt box to say please enter a qty, the qty field to go yellow and the form to stay open. If there is a date and there is a qty I just want the form to close and if there is...

Thanks for the quick reply. I have demand info on my DB and I am trying to add code in the close form event so that if the user has entered a date but no Qty (believe me it happens, lol) a msgbox appears telling them to enter a Qty and the form will not close.

Hi I am just wondering if you want to say in code that the field is empty you use "Nul" however what if you want to say that the field has text in it, is it just Nul=false or is there a better way? thanks

Yeah hopefully that should work Thanks

Hi I am trying to create a txt box to display the current user, I tried Environ("username") but this displays the user logged into windows. I really need the user logged into the database ( a username and password is required to log in) as they may not always be the same Any ideas?? Thanks

So that I am not just copying codes etc can anyone explain why the code works e.g. what the Nz( ) means and how it works with the on current and then after update events e.g what happens with call form_current? Thanks

That works great thank you I would never have figured that out Thanks

Hi again On my form I have a "last updated by" field which works fine, I have added a label to this field so it reads "this data was last updated by" then the "changed by" field I want this to be where if the field is blank in the changed by the label is invisible I have used the code: If...

Yeah knew it would be a simple thing Thanks

Hi I'm just wondering why sometimes when I try and write new code does it go red straight away and wont let me use space (when I press the space bar it moves forward then jumps straight back) Any ideas thanks

Hi I have really confussed my self but I am sure that I am nearly there! I have a form which will show personal detail which the user will update. These updates are shown using a subform and are entered by using a pop up data entry form. This all worked ok until I added more than one user now...

Hi When my DB is opened a txtbox macro opens telling the user that they need to set a password and how. This come up each time the user opens the DB, is there any way that I can get the macro to open only if the user doesnt have a password set? Thanks

On my form I always get a grey box that I cant get rid of. Does anyone know what it is and how to change it?

Just comes up with #Name? again

Yeah I have ot it to work but like you said both forms have to be open which isnt good for my design. Is there a way to get around this

Hi I am trying to do a calculation using 2 fields in 2 different tables I want the result to be displayed in a field so I have put this expression in the control source of that field: =[test2]+Forms!table1!test But all I get is #Name? Any ideas what is wrong

Hi i am wondering if it is possible to password protect a form? I am building a DB which will hold personal information, all this info will be held in a table and displayed on a form, but I would like it so that the user has to enter their user name and password and only the form which relates...

Yeah I think that that did it. Will have a good look later thanks