Recent content by Othello911

Try this: Dim strAnswer as string strAnswer = inputBox("Enter Password Here") If strAnswer = "customer" then docmd.OpenForm "NewForm" end if 'What cha think?" "Is it green?"

Well, what I need to happen is to have some custom code run that will open a table and return all the records in that table that are related to a certian customerid number. THis works fine. except I have the code set to run on the exit event of subform 1. The code executes fine, but it does not...

Greetings, I have a form with a subform(sub1) that contains records. Also on the parent form is a subform that contains subtotals of the records on the (sub1) subform. When I add a record to the (sub1) form, I can't get the code to update on the subtotal subform unless I go to another...

Try this, Dim MyPracticeName, MyPracticeCode, MyPracticeLocation, MyVisionEmis Dim PracticeNameFalse, PracticeCodeFalse, PracticeLocationFalse, VisionEmisFalse dim falseColor, trueColor MyPracticeName = Me.txtPracticeName & "" MyPracticeCode = Me.txtPracticeCode & "" MyPracticeLocation =...

If I may chime in here, I think you are having problems because of your "IF" function at the bottom. You are basically saying that if "ALL" the fields have invalid data, then do the canel event. I think you mean to use OR between your objects. Like my example below. Private Sub...

Sorry, but I don't know what either of those things are. Could you go into some detail? Thanks!

Greetings All, I have a database that I have given to a customer that I would like to make some changes to. The problem is that the user is not computer savvy and I have turned off the database window, so he can not "accidently" destory something, but I need to make updates to the database...