Search results

No. Lets suppose Client ID = 1001 Matter ID is = 1

Dear All Double click on list box I am trying to open a form for particular record. Although form gets open but without any data (blank). I am using the following code: Private Sub lstMatter_DblClick(Cancel As Integer) DoCmd.OpenForm "frmClientMatter", , , "[ClientID]=" & Me.lstMatter & " and...

Thank you so much it works fine.

Hi All I am trying to open a form with following code: DoCmd.OpenForm "frmClientMatter" ,,,"[ClientID]=" & Me. ClientID &"'"& and "[MatterID]=" & Me.MatterID But code does not work. Any help suggestion will be much appreciated. A Munir Please note both (ClientID and MatterID) are numeric...

Many hanks

Many thanks

Thank you for your reply. Can you please point where exactly closing is missing?

Thank you for your reply. Format requirement is dd/mm/yyyy.

Hi All I am trying the following line of code: strCriteria = "[MatterDate] Between " & Format(Me.txtDateFrom, "\#dd\/mm\/yyyy\#) & " And " & Format(Me.txtDateTo, "\#dd\/mm\/yyyy\#") But getting Syntax error message. Will much appreciate if someone can help to to sort it out. Many thanks

Thank you very much for your suggestion.

Thank you very much that is exactly what I want. You are great

Hi All I am trying to display/show records on my continuous form based on the value selected from combo box. However, when I run the form and click on combo box first it asks me for parameter value and then shows that value in combo box instead of showing Customer Type. When I select each value...

You are absolutely spot on “ laptop without a login”

I am getting current date 17/11/2020

No using my laptop at home

Just tried it and getting this error (#Name?)

Hi All I have a users table in access which holds user’s login name, password, and user type like(Administrator, data entry etc...). What I want to achieve is to display current ms access user’s login name and user type on my main. I tried (=get current user()) but it returns widow login user...

I did exactly what you said and it is working fine now. Many thanks

Thank you so much. I did what you told and it is working fine now, once again thank you for your help I learned a lot with your help.

I am thankful to both of you and @Gasman for your help. Although I can use the list box form you have amended/corrected for me, however for the sake of my own knowledge and learning I made changes in my original form based on your recommendations and correction. Unfortunately, I am not getting...