Recent content by sanand

Hi, I have an access query that gets COUNT of CONTACT NUMBERS as per the ID column. The same details are displayed on the crystal report. I now want to add another column to the crystal report that should give me the actual CONTACT NUMBERS equal to the COUNT thats been displayed. these CONTACT...

Thanks so much. It really worked... :)

I have used the code some what like: Dim dbs as DAO.database dim rst as DAO. Recordset Set dbs = CurrentDB() strsql = "select * from table where id = " & Cstr(txtid.value) Set rst = CurrentDB.OpenRecordset(strtSql) rst.MoveFirst txtCreated.value = rst!Created txtOpened.Value = rst!Opened...

Can you please elaborate a bit on code. Didnt got exactly what u meant. :(

Hi, We have an access form on which when we enter a unique number say Id and click on the button ‘Fetch’, we should get the details populated in the form from the database. Database is an Access database Fetching will happen through a simple select query like: 'SELECT * from Test where Id =...