Can I search by using multiple keywords in a way that the lines that do not have ALL the keywords are not blocked but any line that contains even one keyword appears and among them the ones with the most kewword matches show up first. Is that posible?
Thank you for a great tutorial. How did you create purple buttons that include both an icon and text (e.g New Customer)? Did you make them outside of Access (Photoshop) and imported them as pictures? Thanks Lena
Hi Austin72406, is there a method to search a subform showing a default query? I am trying to create a form with a subform. In the form i'd like to search for keywords in few fields.
Hi Austin 72406, I am building database for my work and would like to have command buttons like the ones you show in this video. BUT I am new to such code writing. Can you recommend the book for beginner. I have a local of ACCESS 2010 books but they say nothing much about expressions & code builder/Macro. Thanks in advance.
sorry, i have don't any book to recommend you since I don't really learn from the book. I have learned from all sources such as internet, forum, sample file, etc. More importance is practice, learn from your practice and others. it takes time to become a professional. I still need to learn a lot from others that I don't know yet. keep trying and practicing.
open report with same criteria using in SQL on the search function in order to preview/print the record from the search. you can use Tempvars to store the criteria on search function then call it as a criteria on open report.
austin72406 So the process is the same except carried out in SQL? I think I understand but I'm not sure how to call Tempvars in the SQL file because 'open report' has to be an embedded macro. So where do I employ the SQL?
That is my own code to check if your user name already set up in the TblUser or not. you will need to add or change your name in tblUser table. add your computer login name under the UserLogin field
the sample file is created with MS Access version 2010. It can be used with Access 2010 or newer version as stated on the download page on my website. You will need 2010 to open it.
Can I search by using multiple keywords in a way that the lines that do not have ALL the keywords are not blocked but any line that contains even one keyword appears and among them the ones with the most kewword matches show up first.
Is that posible?
Thank you for a great tutorial. How did you create purple buttons that include both an icon and text (e.g New Customer)? Did you make them outside of Access (Photoshop) and imported them as pictures? Thanks Lena
I have a How To at my website :www.iaccessworld.com/how-to-insert-picture-into-a-button/
How to insert picture into a button.
Hi Austin, I have a txt box which i'll type something and it will filter only if a check box is on. How can I do this?
Hi Austin! Can you teach the code for showing all records? Thanks!
Hi Austin72406, is there a method to search a subform showing a default query? I am trying to create a form with a subform. In the form i'd like to search for keywords in few fields.
You can use a Split form replace a form and subform
Hi Austin. what changes do i have to make on the vba code so that i can search a subform from a main form?
you can set the record source of subform to the search criteria.
example,
Me.SubformName.Recordsource = SQL statement from search criteria
Hi Austin 72406, I am building database for my work and would like to have command buttons like the ones you show in this video. BUT I am new to such code writing. Can you recommend the book for beginner. I have a local of ACCESS 2010 books but they say nothing much about expressions & code builder/Macro. Thanks in advance.
sorry, i have don't any book to recommend you since I don't really learn from the book. I have learned from all sources such as internet, forum, sample file, etc. More importance is practice, learn from your practice and others. it takes time to become a professional. I still need to learn a lot from others that I don't know yet. keep trying and practicing.
+austin72406 Thanks.
Dear Austin, I Bought this example, please help how to Advanced Search and Export to Excel Spreadsheet
Hey Austin72406,
How do you connect 'open report' to a keyword search? Does it have to be called via SQL or can you do it as an embedded macro?
open report with same criteria using in SQL on the search function in order to preview/print the record from the search. you can use Tempvars to store the criteria on search function then call it as a criteria on open report.
austin72406 So the process is the same except carried out in SQL? I think I understand but I'm not sure how to call Tempvars in the SQL file because 'open report' has to be an embedded macro. So where do I employ the SQL?
Hey guy, how to get hyperlink on CustomID to Open a Form ?
Is this a split form?
what are the commands under the "Unbound" boxes .. coz i did everything right but when i type any text then press enter .. nothing happen
use Search code/function under the AfterUpdate Event of that unbound text box. after you finish typing and press enter it will call the Search Code
Please can you explain what you mean by this? I have the same problem! Please help
Hi Austin, i bought your example file, but all is locked. How can i change data ?
Press F11 to see all tables or the Navigation pane.
Can you please upload samples file!!!!I will help you to change data property 👍👍👍👍
You have included split form in navigation form. Pls tell me how to do it?
Hallo mr austin... Can you make turtorial this video... From zero... I like it. 😀 i want study from zero tutrorial..
When i tried to the e-mail option in the customer detail it says "the object contain the automation object contact name".
do you know why it not work?
there are many reasons and answer that you can find from google. I cannot give you the answer since I don't see you code.
+austin72406
thanks May I have your personal email or business email? There is a code that I would like to use your services
Dear Austin, I Bought this , why I get message " Your computer login ID has not setup in the Tbluser. you will be logged in as a guest. please help
That is my own code to check if your user name already set up in the TblUser or not. you will need to add or change your name in tblUser table. add your computer login name under the UserLogin field
Sorry but your download link has expired. why?
the website allow 30 days in active.
How do I create an historic
you search for audit trails.
I bought this and I cannot open the file. so bad :(
the sample file is created with MS Access version 2010. It can be used with Access 2010 or newer version as stated on the download page on my website. You will need 2010 to open it.
Can you please upload samples file!!!!I will help you to open it 👍👍👍👍
thank u for that can you give me code if u wish
thank u........
He won't give you the code he wants you to buy it. Rip off!
impressively ugly user interface....