Search results

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...

Sir as per my thinking, we have to make tables on similar grounds for Religion ( as some people change religion) Marital status Education Occupation/Profession Contact number Email Id Spouse details Sir what about customer's permanent address and Temporary address Sir any customer who on first...

Yes Sir This will take care of all my doubts Thank You

I want the relevant name/address at the time of the report. So for some reason we want any report on any date, the they should bear the relevant name and address ON THAT PARTICULAR DATE

Thank You Sir Actually we have a table which we use to create reports in which we store the customer ID_FK with other data. Now in due course of time if the name or address changes, then all the previous report which should actually bear the old name or address, now will bear the new ones. So...

But what about name, for that too we have to keep a separate table