Recent content by nirmal

Private Sub cmdCreateVisitOrViewAddHistory_Click() ' Open a recordset for the Visit_tbl table Dim db As DAO.Database Dim rst As DAO.Recordset Dim ID As Integer Set db = CurrentDb Set rst = db.OpenRecordset("Visit_tbl", dbOpenDynaset, dbSeeChanges) ID =...

Sir I don't know about code tag. Guide me.

Sir, I tried opening the form with acNormal, but the issue persists. I am sending the vba code of the Visit_frm Private Sub Form_Load() Set db = CurrentDb Set rst = db.OpenRecordset("Visit_tbl", dbOpenDynaset, dbSeeChanges) If Not (rst.EOF Or rst.BOF) Then rst.MoveLast...

Sir I didn't get what you want to say

This is my unbound form. So then why this automatic table is getting updated

Private Sub cmdCreateVisitOrViewAddHistory_Click() ' Open a recordset for the Visit_tbl table Dim db As DAO.Database Dim rst As DAO.Recordset Dim ID As Integer Set db = CurrentDb Set rst = db.OpenRecordset("Visit_tbl", dbOpenDynaset, dbSeeChanges) ID =...

Thank You Sir. It works accurately.

Sir I am attachig the database. Here when I open the sample report which is query based, if all fieds are not null, then I get the valuesin the report. If some cell value is null or empty, then the report values are blank. So here I want to still have the report values, even if some cell values...

How to get a query output in access query with multiple table joined, if some field in one table is null. If all table values are there then I get the result. But if one value in some table is null the I dont get the output. Please help me to solve this issue.

Sir this format also works Thanks Sir

Thank you Sir It worked as expected. Thank Again

I am trying to get the last month and year by =Format(Date(),"mmmm" & " " & "yyyy") Here I am getting March 2023 Actually I am trying to get the sequential last mont with year like February 2023 Tried all, but in vain Please guide

Thank You Sir for Your help Getting all desired results

Sir I have a Place_tbl with Field name Place e.g A, L, M, N B, L, M, N C, L, P, N D, I, Q, O E, L, M, N F, J, H, X G, L, M, N for working out the count of Only M Only N Not Like N Not like M but like N for which expression are Count(IIf(([Place_tbl].[Place]) Like "*N*",1,Null)) AS WithinN...

Sir, actually I am designing a database for medical professional. There they require to maintain all these records. Your point of profession (and education) I accept. But other things do matter. Sir, here they have to generate reports of back date if asked for. Thats the reason they have to...