Search results

Sir how can I get the second last values in my above question with different string lenghts like I get first value by using query "FirstWord: Left([Place],InStr([Place],", ")-1)" like wise how to get the second last values in below strings "Abit Khind, Akola, Ahmadnagar" "Bhor, Shiroda, Akola...

Yes Sir got the result But my last doubt is if there are strings like "Abit Khind, Akola, Ahmadnagar" "Bhor, Shiroda, Akola, Ahmadnagar" "Akola, Ahmadnagar" etc where there are multiple commas then What will be the function to get "Akola" result in the above three samples

Thank You Sir, Got the expected result I have another doubt. In the string below "Bhor, Shiroda, Vengurla, Sindhudurg" what would be code to search the second or third word

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

Sir, actually if I learn to use sql view code in a vba code, then I am likely to better understand the vba coding. It is bit easy to design a query in access. So I intend to use the same in vba code. Which I want to learn, so please guide

Sirs, I am still not able to get the message Whether to go with existing queries or go for VBA with SQLA code

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

Sir I am trying and learning arrays I could use your guidelines to develop my concept. One more thing Sir, can we use the SQL code of a query directly in the VBA code, so it becomes less likely to be edited by someone else.

Sir thank U for your guidance, I could learn some amount of coding Thanks Once Again

Sir, I tested the Db, still there is minor problem. if txtAgeYear and txtAgeMonths are blank, there is no '<' symbol in between value of combo2 and combo 3

Yes Sir the results are good, but in the 1Concatenate_frm, after I insert values in txtAgeYear & txtAgeMonth I get the expected result, but after that if I delete the same values other than that of other comboboxes, then still is of remains in the result box. And, Sir can we make a single table...

Sir, I am attaching the ComboBox Db1 Here i have made two forms 1Concatenate_frm and Concatenate_frm , whereby I have used 5 tables with indexed values as RowSource in 1Concatenate_frm and and used Select query(SELECT TOP 5 Data_tbl.ID, Data_tbl.Names AS A FROM Data_tbl; ) as rowSource in...

Sir, actually I wanted to know that why I have to press the backspace to get all the results. e.g. in the lastname combo, when I type word 'w', I get only Wacker but on the contrary I should get Wacker & Edward in dropdown And to get both the dropdown values matching to 'w' I have to press...

Sir I am trying to understand the coding, but it seems to be quiet complicated. Sir , can you please simplify it The "Private Sub Report_Open(Cancel As Integer)" is affecting other reports of my original database which are not dependent on the "MonthlyReportSearch_frm" So, suggest some other...

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

Sir now the expected results are appearing in the report

My fiscal year starts from 1st April and ends on 31st March next year

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

Thank You Sir Sir if I want to implement the same in other Db, then what should I do