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

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.

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

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

If there is a lady customer, who is enrolled by her maiden firstname, middle name and last name. She has a unique national number or ID Now, after marriage her middle name and last name will change. Or even after her divorce she re-marries the again her middle name and last name will change. At...

Is there any formula to calculate approximate birth month and year in the format of 01/mm/yyyy from approximate age in year and month. e.g. if someone gives age as 10.2 years, then what should be the approximate birthdate as on today.

Sir I have a string field value in a column Place in Place_tbl, for example 123, abdf, sygea, dsead kasr, dladr, ase, 4896 2123, abdf, sygea, dsead 523, abdf, sygea, dsead 93, abdf, sygea, dsead 125, csd, edrf, dsead sdfg, 124, jkf, 92hn if I use the query shortenedPlace...

Sir, How to put the CustomerID which was not inserted in the related another table to the customer table. e.g. I have one tables Customer_tbl And I created a Visit_tbl where I update the data using a update query using the Customer Name Initially I had not inserted the CustomerID in the...

Sir, I have a string field value in a column Place in Place_tbl, for example 123, abdf, sygea, dsead or kasr, dladr, ase, 4896 I want the result without the last word 123, abdf, sygea kasr, dladr, ase What should be the query design Please Help

I am trying to get the last word in a string with multiple commas. I do get the expected first word by the query "FirstWord: Left([Place],InStr([Place],", ")-1)" I apply the similar to get the last word using "LastWord: Right([Place],InStr([Place],", ")-1)" Now here I get weird results of last...

Sir in access 2003, there was a facilty that we could scroll (navigate) through the forms by rolling the mouse wheel back and forth. Can we have the same in access 2016

Can we design a database where we do not design a query, instead we use the SQL view of a query in vba code, so the code works more faster. Secondly no chance of accidental deletion of any query designed

Can we reduce the limit list of Combo box values without actually reducing the values in the table. For example, Suppose I have a table XYZ having 100 values from 1 to 100. Now I have a form with ten combo boxes, where I want to have the same table XYZ as row source to all the ten combo boxes...

I am trying to get a progressive yearly number on monthly basis for a fiscal year. I tried the hints given to me on this forum, but there is error in the progressive yearly number, especially for the months of Jan, Feb And March on beginning of new year from 2013 to 2021. Also the same error...

How to start renumbering from a certain date on monthly and yearly level in a append query. So for every year, for example 1st April to 31st March we get a new serial number and similarly on monthly ground from 1st date of every month. Every Year on 1st April the Yearly number should reset to 1...

how to insert a default value of zero in a access query if the calculated result is null So I converted it to Nz statement, still no results i.e. Null not converted to Zero Here is my sql statement SELECT AgeAll_qry.Month, Nz(AgeAll_qry.CountOfAge,0) AS Expr1, Nz([Age<18_qry].CountOfAge,0)...

Hello Everyone