Search results

FINALLY SUCCESS I CAN'T THANK ALL YOU FOR YOUR HELP ON THIS PROBLEM. WHEN I GOT TO IMMEDIATE WINDOW I TYPED. CommandBars("Property Sheet").Enabled = True CommandBars("Property Sheet").Top = 0 CommandBars("Property Sheet").Left = 0 AND IT WORKED!! MY PROPERTY SHEET IS BACK THANKS AGAIN JIM

Thanks to all. I see in view the immediate window, but when I click on it nothing seems to happen I want to get to the immediate window to enter CommandBars("Property Sheet").Enable = True hit enter key CommandBars("Property Sheet").Top = 0 hit enter CommandBars("Property Sheet").Left...

RG, Thanks for the reply, but I'm still doing something wrong. 1. load access 2010 project 2. click on database tools 3. click on visual basic It loads VBA I try control ^G and do not get the immediate window Any help is very much appreciated.

I don't know what I did, but somehow when I click on the tab nothing happens. I checked the internet for a solution but they tell me to open any form in design mode. Go to the immediate window in VBA. How do I get to the immediate window in VBA? I then need to enter CommandBars("Property...

Paul, Thank you for your help on this problem. With your help we are able to feed over 500 people each week. Thank you so much. Jim PS I don't see where I can thank you to add to the many people that you help.

Paul, I think it works ok. Now when I type in the name it retrieves the record, but the combo box is immediately blanked out and the data for that client is available for updates. This is good for me. Ideally it would be nice if the typed name in the combo box went away after the record...

Paul, Thank you for your response. This is what I tried to do: I have a menu called Homepage. Client Visits is a tab on this menu. I went to the form property on the form called Client Visit. on the line "On Current" I typed Me.Combo69="" and saved the result. access could not find the...

Has anyone been able to figure out a work around to the following issue. Access 2010 leaves the last name that a user typed in after he has done and update. All of the other fields on the form are blanked except the dropdown box . This seems to confuse my users and they would prefer that the...

Yes I was not able to make it work. I have now found out that what is actually stored in [Gender] is a 1 if its Male and a 2 if it is a Female. So I wasn't getting the correct result because I was testing for "Male" and not a "1" Given that knowledge I am still trying to get the syntax correct...

Sorry for being a pest, but I do want this feature to work. My users are not very computer savy. The code below does work for a particular ClientId!!! I am having problems when I want to add another criteria to count the Males for that Clientid. Specifically I want to say for this ClientId...

I keep getting an error 13 type mismatch in the statement where I use DCOUNT I am simply trying to get the number of records for a specific [ClientId] and [Gender] is equal to Male I have implemented the suggestion of my previous post done on yesterday and am still stuck. I tried to change Answ...

Thank you all for your thoughts. I guess I need to think about problem some more. I appreciate your input will eventually get it to work Jim

I am attempting to have two string criteria connected with and for example [ClientId]=clientid on form AND [Gender]=Male when the syntax is correct the answer is wrong ???????

This is my latest attempt which results in a compile error Private Sub Form_AfterUpdate() Dim malesx As Integer MsgBox "[ClientId]= '" & Forms!HomePage!NavigationSubform.Form!ClientID & "'" malesx = Nz(DCount("[Gender]", "Household Information", "[ClientId]= '" &...

jdraw Male=male was an attempt to force a conversion from text to integer and visa versa. the type mismatch occurs in the comparison of "[Gender]='Male'" also tried "[Gender]=Male" both did not work. Galaxiom [ClientId] is defined text see original problem definition I did not know about the...

I really messed up and am looking for your thoughts to solve problem I designed a table called FAMILIES ClientID text This field is the ID for the entire family composition Lname text Fname text Gender Integer (Which should have been text) (This field is linked to a drop down box table where...

Fields: FoodStamps This is a YES/NO field (printed in the first or second columns) FSAmount This is a numeric field(always printed in the third column) I have a preprint form with three columns The first column is for a YES answer and I want to print YES if FoodStamps is TRUE The second...

I tested and sure enough the record was updated like you said. What this is telling me is that my users are simply not entering the change for the person. I will probably leave the save button on the form because the slightest change throws my users into a panic. Thank you so much for taking...

I have a simple application where a user clicks on the name of the person he wants to update from a drop down box. The record is then retrieved and the fields are filled on the form. The user will then enter a value in the # in household field. The user is then required to click on the save...

Thank you, thank you, thank you. I have been pulling my hair out over this problem. Sometimes you just need another pair of eyes to see your error. How can I thank you enough, you are the best. Very grateful, Jim