Search results

Many thanks for your help.

Thank you so much for your help.

Hi All I m trying to filter the records "Alphabetically" based on Tab Selection/Change. However it does not work at all, can someone look at attached file and suggest a solution? Your help will be much appreciated.

Hi All I m trying to to sort the records "Ascending & Descending" based on click of a button on listbox. However it does not work at all, can someone look at attached file and suggest a solution. Please note that "ClientID field" in tblClient is autonumber I am not sure whether that is causing...

Thank you so much it's working fine now, it was me who unchecked the ClientID in row source that is why it was not working. Many thanks again

Data entry is set to No but still not showing the record.

Thank you for your reply it opens up the form but shows no record at all.

Thank you for your reply it opens up the form but shows no record at all.

Hi All, I have a little issue. I am trying to open a form, showing a specific record based on the selection in a list box. I am using the following code and getting "mismatch" error: DoCmd.OpenForm "frmClients", , , _ "[tblClient.ClientID]=" & "'" & Me.lstSearch.Column(0) & "'" The...

Thank you so much for your reply. Your sample is spot on, however is there any easiest/simple way to get the same result by creating a query?

Thank you for your reply. I have created another table which is a copy of the original table, in this table I have created additional field "TitleNo1" which is being used for second title no if exist, this seems to be a one of the way to get it resolved. However, I want to stick to original...

A table in my database has following fields: ClientID, MatterID, TitleNo all three fields are compound key. Some time the same MatterID can have more than one TitleNo in which case they need to be displayed in a row on a report rather than as a two different records. I am trying to work it...

Thank you so much it works fine.

Thank you for your reply. Since my last post I have been trying different things and came up with something what I want to achieve. However, not sure whether it is a correct approach are not. Anyway I am going to attach the file for your review and suggestion. Thank you in advance

I have three tables in my database with following details: ClientMain ClientMatter AdditionalClient PK ClientID PK MatterID PK. ClientID FirstName PK ClientID...

Hi All, How can I capture the user name, date modified and time stamp in other tables from userlogin table which as users log in details?

Thank you so very much Pat you are genius, you are great much appreciated.

Thank you for your reply. I can't get my head around it would be great full if you can view the attached file and make necessary/missing changes. Objective is when I click on "Add Matter" button it should open up "Matter Form" populated with current "ClientID" and based on "ClientID" generate...

Thank you for your reply. Sorry I think I missed something to explain. I have a 'Add Matter' button on Client form. The event procedure to open the form is as follows: Private Sub Add_Matter_Click() On Error GoTo Err_Add_Matter_Click Dim stDocName As String Dim stLinkCriteria As String...

Let me try it, many thanks in advance