How to Create Multi-field Search Form in Ms Access using Continuous Form. | Edcelle John Gulfan

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น •

  • @Jojosmith342
    @Jojosmith342 ปีที่แล้ว +2

    For those who had the issue with search, I replace the % with wildcard * as Edcelle's instruction below, it works great. Thanks a lot Edcelle for your valuable tutorial. Thumbs up for another wonderful lesson.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว +3

      Thanks.
      That's highly appreciated.

    • @erw1nk779
      @erw1nk779 11 หลายเดือนก่อน +1

      Thanks, that's why mine didn't work

  • @kinganthonyx
    @kinganthonyx 11 หลายเดือนก่อน +1

    Wonderful examples and well explained

  • @yousseff8990
    @yousseff8990 2 ปีที่แล้ว +1

    Many Thanks for the explanation and clarification, but please clarify if we want to limit the search in a column by combo box or check box.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Limit the record to be displayed?

    • @yousseff8990
      @yousseff8990 2 ปีที่แล้ว

      @@EdcelleJohnGulfan
      Like filters in excel select more one columns

    • @yousseff8990
      @yousseff8990 2 ปีที่แล้ว

      Display records by ID where the items in column one like Apple and city in column 2 London

  • @mrvictor2010
    @mrvictor2010 ปีที่แล้ว +1

    Big Like as usual

  • @Adorable.Princess
    @Adorable.Princess 2 ปีที่แล้ว

    Thanks finally I could learn it. I saw many other videos and was not working

  • @bossoftwareandtechnologies8731
    @bossoftwareandtechnologies8731 2 ปีที่แล้ว +2

    Excellent Work

  • @mariano-cucinotta
    @mariano-cucinotta ปีที่แล้ว +1

    Hi thanks for the file. I encounter the following problem: I copy the code with the related buttons and text box, but on your file it works and in my database it does not. Are there any special settings to set in the database? I can't understand why if I import my table from your database and change the data source and rename the fields it works, but in mi database the same settings doesn't work.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว +2

      Try to change the wild card criteria.
      Instead of using "%" try the "*".
      Sample: Me.filter="[ItemCode] like '*" & SearchText & "%'"

  • @dreamsmol2362
    @dreamsmol2362 2 ปีที่แล้ว

    Hi,
    How to filter multiple items like if we put in the search box Rock, Tom. It should show both the records. Please help...
    Thanks!!

  • @Jaydayvid
    @Jaydayvid 2 ปีที่แล้ว +1

    Thank you for this bro im learning a lot!

  • @joemilan1301
    @joemilan1301 ปีที่แล้ว +1

    PLEASE SIR, MAY I HAVE GET SAMPLE MS ACCESS VBA CODES FOR CREATING TWO CBO WITH SEARCH TEXT WHERE ONE CBO IS FOR MULTIPLE TABLES SELECTING AND OTHER CBO IS MULTIPLE COLUMNS OR FIELD FOR AUTO SEARCH WITH SEARCH BOX BY HELPING THE SEARCHING TERM FOR QUERY TO DISPLAYS OTHER FIELD TEXT BOXES. THANK YOU

  • @thushara691
    @thushara691 11 หลายเดือนก่อน +1

    Can create a list box to identify items you want to move to a different table?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  11 หลายเดือนก่อน

      Yes and associated with append query.

    • @thushara691
      @thushara691 11 หลายเดือนก่อน

      Thank you! I have sent your email, and if you get a chance to look at much appreciate it.

  • @sekolahihsanalfara
    @sekolahihsanalfara ปีที่แล้ว +1

    Hallo, Sir. Do you have any solutions, if i fill a field on a form, and the value will be store at a field on many tables, please. thank you for your feedback

  • @mloucel7
    @mloucel7 ปีที่แล้ว +1

    Hello.. Let's say you want to open another form based on a record you found while searching, using a button [Open This Record] is that possible? will it work with something like docmd.openform ? or how will you do it?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว +1

      Yes. I have a video about opening specific report or record in a form.

  • @jonathanlosito7718
    @jonathanlosito7718 2 ปีที่แล้ว +2

    Hi Sir, do you have a sample code if I got multiple tables. Everything is working fine by the way except for multiple tables. Appreciate your feedback on this matter.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      Hi. Have you tried using Query? Combining Multiple tables and apply this method.

  • @richtercastanares740
    @richtercastanares740 6 หลายเดือนก่อน

    Sir good day. Thank you for this tutorial videos. it helps me a lot. Sir I created ad multi-field search form using the union query. I want to open the specific record in a form but the problem is it will open all the records with the same ID. how can i change the numbering in ID field so that it will no longer duplicate?

  • @Abdullah_Alhathloul
    @Abdullah_Alhathloul 8 หลายเดือนก่อน

    Very helpful 👏👏

  • @iaonibutinatirintetaake1229
    @iaonibutinatirintetaake1229 6 หลายเดือนก่อน

    Thank you, Can you help with developing a tracking file system, I am developing a tracking file system and very confusing. I have three table including File Table, Letter Table and Letter Detail Table but very complicated for me given that one file have many letter to keep and the letter where also circulated using the allocated file. Can you help please

  • @darkphet
    @darkphet 2 ปีที่แล้ว

    Hello bro, thank you so much for sharing your knowledge !!!

  • @selvarajandiappa3143
    @selvarajandiappa3143 2 ปีที่แล้ว

    Sir.. On the above everything works fine when name, address but when phone number, the first search works fine the second search on phone number does not work.. So I have to exit and open again the the number search works

  • @babyboss6047
    @babyboss6047 ปีที่แล้ว +1

    Sir good afternoon po. Pano po mag disable ng editing sa mga list tsaka sa pag disable ng pagdagdag ng record sa continous form. Thank u

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว +2

      Hi sir good afternoon!
      Sa Form Property hanapin mo ang ALLOW EDIT at e-set mo to No.
      ALLOW ADDITION din set to No.
      Salamat

    • @babyboss6047
      @babyboss6047 ปีที่แล้ว +1

      @@EdcelleJohnGulfan thank u sir. Laking tulong po ung mga ginawa mo 🙏🙏🙏🙏

  • @Michiworkstechnologies
    @Michiworkstechnologies 9 หลายเดือนก่อน +1

    Your teachings are awesome sir.I have learnt alot. Thanks for sharing your knowledge. Suppose I want to inbox you how will i get you?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  8 หลายเดือนก่อน

      You can contact me through my email. eduardogulfan@gmail.com

  • @Ag-mi6qb
    @Ag-mi6qb 2 ปีที่แล้ว

    Thank you very much for the video

  • @YvesAustin
    @YvesAustin 2 ปีที่แล้ว +1

    Nice trick. Any idea why the asterisk search character did not work? I recall I had a similar issue at some point

  • @santrehNgoding
    @santrehNgoding 2 ปีที่แล้ว

    sir... how to open a report specifically from the searchtext results? thanks very much...

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      Try this.
      th-cam.com/video/APQVs3FpebY/w-d-xo.html

  • @marieklamo2383
    @marieklamo2383 10 หลายเดือนก่อน +1

    thank you so much sir

  • @aamalmarzouqi
    @aamalmarzouqi 2 ปีที่แล้ว +1

    Great job but you forgot VBA in Close button

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      Owwwwss. Just type only Docmd.close
      Thanks

    • @aamalmarzouqi
      @aamalmarzouqi 2 ปีที่แล้ว

      @@EdcelleJohnGulfan I tried by my self
      Me.closebutton
      I got error
      I will correct it now
      Appreciate

  • @ryanm.8282
    @ryanm.8282 ปีที่แล้ว

    Na-apply ko din to Boss Edcelle, nagiimprove na dahan dahan ung database ko salamat ulit!!🖐😄 BTW meron ka bang online book/guide na mrrecommend pra mapag aralan at possible matutunan ung mga VBA codes kht tulad ko na di nmn computer base ang natapos?

  • @aamalmarzouqi
    @aamalmarzouqi 2 ปีที่แล้ว

    If I want to add tow or three text box and for each box different search
    Like if i saperate price in textBox1
    And search of city in textBox1
    ??
    I tried but it's work in 1 box only

    • @aamalmarzouqi
      @aamalmarzouqi 2 ปีที่แล้ว

      I mean city in textbox2*

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Show here your code. I will check.

    • @aamalmarzouqi
      @aamalmarzouqi 2 ปีที่แล้ว

      @@EdcelleJohnGulfan
      i did two way
      Me.Filter = " [IDB_LICENSE_NO] like '*" & Searchtext & "*' or [Hscode] like '*" & SearchText2 & "*'"
      in this code i have to type in both Searchbox to get filter
      2-
      Me.Filter = " [IDB_LICENSE_NO] like '*" & Searchtext & "*'"
      me.filter = " [Hscode] like '*" & SearchText2 & "*'"
      in this code only the second is work

  • @mtop3147
    @mtop3147 ปีที่แล้ว

    Hi, Why are there no messages to see the search result. thank you

  • @selvarajandiappa3143
    @selvarajandiappa3143 2 ปีที่แล้ว

    Good day sir.. Refering to the above.. Once a search is done, can we double click to open it to a form?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      Yes Selvaraj.
      Check this link th-cam.com/video/Uo5pV_wQ4sc/w-d-xo.html

    • @selvarajandiappa3143
      @selvarajandiappa3143 2 ปีที่แล้ว +1

      @@EdcelleJohnGulfan thank you again sir.. Thank you for sharing your knowledge.. God bless you

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Welcome

    • @selvarajandiappa3143
      @selvarajandiappa3143 2 ปีที่แล้ว

      @@EdcelleJohnGulfan hi.. Can we have the backend stored in 1 drive

  • @legaspijonel2032
    @legaspijonel2032 2 ปีที่แล้ว +1

    can you create student registration system?

  • @ethiovox
    @ethiovox ปีที่แล้ว +1

    Subscribed bro

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว

      Thanks for subscribing this channel. It's highly appreciated.

  • @babyboss6047
    @babyboss6047 ปีที่แล้ว

    Hi may i know why my front access increased its memory every time i open it and closed? Thanks very good job sir

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว

      Increase the memory or increase the file size?

    • @babyboss6047
      @babyboss6047 ปีที่แล้ว

      Increase file size po sir. Pano po gagawin pag ganito. Thank u

  • @AbdulqadeerMohammed
    @AbdulqadeerMohammed ปีที่แล้ว

    Good day sir I Saw your video on how to create a text animation in a form Microsoft access please sir the video is not in zoom I'm not seeying the cords correctly thanks very much I'm wetting Sir I'm ABDULKADIR from Gombe, Nigeria

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว

      Hi sir thanks for watching.
      If the resolution of your screen is blurred, kindly adjust it to higher resolution for better view experience.
      In your screen during playing the video, click the Gear Icon and choose the resolution.

  • @stephenbeswick2163
    @stephenbeswick2163 ปีที่แล้ว

    Good morning I have been eating all your access database video the are grate to learn with. I have a database. My customer from is one colour we enter names and address etc, when editing this form can you change the colour of the form whilst entering the customers Infomation to tel my users they are in edit mode can you help me with problem I look forward to hearing from you grate video many thanks steve beswick.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว

      You can add another button ( Switch to Edit Mode)
      Let's say the name of the button is EditBtn
      Private Sub EditBtn_Click()
      Me.detail.BackColor = vbgreen 'if green
      End Sub.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว

      I will create a video about this soon.

  • @beerlomo3606
    @beerlomo3606 2 ปีที่แล้ว

    if Can't find , can show popup ?

  • @selvarajandiappa3143
    @selvarajandiappa3143 2 ปีที่แล้ว

    Morning sir.. How many fields can we search

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      As much as you want.

    • @selvarajandiappa3143
      @selvarajandiappa3143 2 ปีที่แล้ว

      @@EdcelleJohnGulfan Thank you sir

    • @selvarajandiappa3143
      @selvarajandiappa3143 2 ปีที่แล้ว

      Sir..need another help.I am using 2 different monitors for Microsoft access.both the monitors don't have the same page size. One fit the screen and the other becomes bigger.. What can do the have the same page size
      .

  • @matorwmasen
    @matorwmasen 2 ปีที่แล้ว +1

    👍 excellent work.
    Can you please share exercise file(products table)
    Thanks

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว +1

      Yes sure. I will post the link in the description below tomorrow.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Here's the link
      drive.google.com/file/d/1VGz4UwHh0SV0Mv4akcAekAn8w020tkrD/view?usp=drivesdk

  • @selvarajandiappa3143
    @selvarajandiappa3143 2 ปีที่แล้ว

    Sir can you show how to add date into job order.. Example 2207xxxx

  • @diandhie
    @diandhie ปีที่แล้ว

    Hallo sir, is possible to make a form from many queries? I have 12 queries and dont know how to make it show in 1 form😅and fill it in every different tables😢

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  ปีที่แล้ว

      Yes, you can.
      Either you join it together to make it one query or else create as 12 subforms.
      Make sure the 12 queries have primary key.

  • @cherdarl884
    @cherdarl884 2 ปีที่แล้ว

    Sir ano po pde gawin para di ma edit yung data dun mismo sa form view? Salamat po sana ma notice

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      May specific user lang na pwede maka.edit?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Try this.
      th-cam.com/play/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48.html

  • @andye9341
    @andye9341 2 ปีที่แล้ว

    I'm getting no results when I search..

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 ปีที่แล้ว

      Check your sql syntax or simply change * to %

  • @sudathhsbc
    @sudathhsbc 4 หลายเดือนก่อน

    Cord not working properly

  • @idlirbekteshi5648
    @idlirbekteshi5648 2 ปีที่แล้ว

    It is not working even after putting %

  • @selvarajandiappa3143
    @selvarajandiappa3143 2 ปีที่แล้ว

    8