Search results

Hey guyz, my above problem is solved. This is a fresh query but am continuing in the same thread as the problem is relating to the same but here there is a little twist. Problem :- In my above case my form was linked with a table where i had all the required field and against which the...

Please ignore my above scrap. I got where i was wrong. Thanks again.

Hi Camron / Brian, Thanks for your efford. This was an ultimate solution to my problem. I was pasting these codes to my original mdb, however, i got stuck in one of the form. There was no problem when the code was pasted when the field was named [Value Date], but when i changed the field...

yes english is indeed not my first language.. and apologize for the confusion. the code provided above is not working in normal scenario too as its showing compile error. To clarify... The form is for entering new record only. So when any one goes into the form, it will be for entering new...

Hi Cameron Your further coding is not working, especially when its false. I had tested with true and its working, but with just the option button event. Private Sub Option65_Click() If IsNull(Me.[Value Date]) Then Me.[Soonest Value Date] = "SVD" Me.[Value Date].Locked = True Else End If End...

OOPS!!! Looks like Cameron has provided me with some detail coding at the same time when i scrapped my text... I will check and get back to you... Looks like you gave what i want, thanks for ur effort!!

yes..thanks for appreciating... its alwayz the interest which drive you to get things what u want.... and what would i have done with you guyz!!:confused:... thanks you'll have made this worked..... this is my code which worked.. Private Sub Option65_Click() If IsNull(Me.[Value Date]) Then...

Perfect!! It worked.. thats what i was looking for... I had deleted one line of the code after, Else, as i do not want soonest value date = value date. If IsNull(Me.[Value Date]) Then Me.[Soonest Value Date] = "SVD" Else End If However, i would like to add further to this code, saying...

Apologies the code should be this way... but still not working ------- Private Sub Soonest V/D_Click() If IsNull(Me.Value_Date) Then Me.Value_Date = "SVD" Else Me.Value_Date = Me.Value_Date End If End Sub

Am just trying to put following code for my option button to work based on the above, please advise what would be wrong here as am getting Run time error when clicked "The value you entered isn't valid for this field" ------- Private Sub Soonest V/D_Click() If IsNull(Me.Value_Date) Then...

Hi Brian, That was a great piece of information for me. Since am new to access and not aware of this segment, so i just created a label of Soonest Value date on the Form as Option button, but actually there was no direct effect of that option effect on table and was just for a display...

Hi Brian, Am looking the way to update the query under the column "Soonest Value Date" In Post 1, i achieved because that was an independant field not linked to the table. I would like to achieve the result by applying the same parameters or any other, but to the one which is linked to...

ok, so it looks like IIf indeed never works on criteria, but i had seen somewhere IIf working on the criteria. What would be the ways you suggest on getting the text "Soonest Value" on the query? I had revised the file in the attachment and adding Forms in it. Hope it might work with...

Thanks for your input camron, but this is not what i required. I require the IIf expression to be linked to the table wherein Soonest Value Date is written. I would like to to scrap the column where i have the parameter written and would like to get those into criteria row under the table...

Here is the attachment to the query to give more insight view to the question. I had linked the query 'Form3' to the 'Table'. If you will see, there are two fields i had added, 'Soonest Value Date' and other 'Soonest Value'(which is not linked to the table and contains the expression). The...