Recent content by empyrean

yeah my bad... i didnot see it properly. It worked the way i wanted. Thank you so much pbaldy. have a nice day

At .itemsdata(0,inty) i am getting that error. Thanks for helping me.. Private Sub CommandResult_Click() Dim intY As Long '~~> Loop through List For intY = 0 To ListAliasInformation.ListCount - 1 '~~> Check if Combo Value exists in list If...

I am getting the same error saying wrong number of arguments assigned.

Do i need to keep X value in loop? i declared x to 0 but its giving error saying "wrong number of arguments or invalid property assignment"

List box column check.. In my code when i use itemdata (int Y) its checking my second column where my alias information is there but i wanted it to check with first column. If i change the way it adds to columns i.e entering alias in first column. it checks and give me duplicate message but i...

I tried this but still not working Private Sub CommandResult_Click() Dim varItm As Variant Dim duplicate As Boolean Dim intY As Long '~~> Loop through List For intY = 0 To ListAliasInformation.ListCount - 1 '~~> Check if Combo Value exists in list If...

Hi I have a combo box with some values, when i select the data in the box it should check with the data present in the list box if it did not find its duplicate then the list box should take this value and if it finds the value if should pop up a msg box saying duplicate value found. The list...

hellooo some one help me please...

I would like to use check box in my form and when you click i need one command to happen and if you dont click it i need another command to happen. i tried using checkbox.value but i am getting error saying Method or data member not found. please help me with right syntax. Colored code is where...

can someone help me to solve this?

ok i got wht you are asking... i am sending my code... i am really sorry about the confusion Private Sub btnRefine_Click() Dim i As Int Dim strTemp As String Dim strFil As String Dim strM As String Dim str As String strM = Me.txtMoiLevel.Value str =...

sorry i am unable to tell u and i couldnot get about what you are asking.. can you frame it another way? i believe the event is click. after clicking the check box and when user clicks generate report this event should happen like checking whether check box is marked or not, if marked open this...

so bob, how to tackle this? i dont have me.checkped.value coming up and even i entered its giving error Method or data member not found.

sorry i am new to access programming and learning now.. i have access form. i created a checkbox on it if user clicks the check box and i need one command to execute which opens one report and if he didnot do anything i wanted to open another report. here is my actual code If...

This is what i tried. i am getting error Method or data member not found. If Me.Checkbox.Value = True Then DoCmd.OpenReport xxxxxxxx Else DoCmd.OpenReport yyyyyyyy End If