Search results

In oracle I can do it, however not good in ms access. in oracle usually issue this command: select max(matterid)+1 from matter where clientid=matterid; but don't know how to use this command in access???

Yes, for clientid I can use autonumber, however for Matterid it should always start from either 0 or 1 for every every client as one client can have many matters, before generating the matteid system should check for clientid and based on that clientid generate matterid, If I use matterid filed...

Both Numbers

Hello everyone Let me first explain what I want to achieve? I have two different forms based on tables 'Client' and 'Matters'. Client table has the following fields: 1-ClientID (primary key) 2-FirstName etc... Whereas the Matter table has the following fields: 1-MatterID 2-ClientID...

Hi John sorry to bother you is it possible, if I send you my db file you have a look and advise me what changes required to achive the required result.

Hi Everyone, I have two tables, Client and Matters. Based on those two table I have two Forms Client and Matters. There is a button on client form when I clik this button it open up the matter form with ClientID. What I want to achieve is when it open matter form like it copies clientID at the...

My apology, I missed to attached the file.

still unable to achieve the required result. Can someone check the attached db file and advise where I'm wrong.

Can someone check and advise why I'm getting this message. Thankx in advance Private Sub Form_BeforeInsert(Cancel As Integer) Dim db As Database Dim LSQL As String Dim Lrs As DAO.Recordset Set db = CurrentDb()...

Hi all! Can someone view the following qury and advse where I'm wrong cuz when I execute query I'm getting the above message. Private Sub Form_BeforeInsert(Cancel As Integer) Set DB = CurrentDb DB.Execute "SELECT max(tblClientMatter.MatterID) + 1 FROM [tblClientMatter] WHERE " _ & "...

Thank you very much K Afridi for your quick response. Can you give some example. thanks

Hi Everyone, I have two tables, Client and Matters. Based on those two table I have two Forms Client and Matters. There is a button on client form when I clik this button it open up the matter form with ClientID. What I want to achieve is when it open matter form like it copies clientID at the...