Your video tutorial is amazing! I feel its the happiest moment of my life when I learned from your video. Thank you very very very much. God Bless You.
@paleozon
7 жыл бұрын
Thank you, Amir, for all your efforts!
@AnneTroy
10 жыл бұрын
Thank you so much, Amir. I have a feeling you'll be helping me a lot on my project.
@8cookies306
9 жыл бұрын
Thank you for the tutorial, it is really helpful
@RajKumar-ql6vm
10 жыл бұрын
Thanks Amir! Really useful.
@cathvk7862
8 жыл бұрын
Thanks soooo much for this Amir, fantastic! You're a star :)
@inarossouw4816
10 жыл бұрын
Thanx Amir! :) ur the BEST!
@abdu710
10 жыл бұрын
Great Tutor. thanks alot. From Ethiopia.
@gorifky
6 жыл бұрын
18:16 saved my headache, thank you sooo much
@harrychinogara9625
5 жыл бұрын
Thanks bro..you helped me a lot
@BaimbohDivine24
4 жыл бұрын
i love this. very helpful for me
@kabeeth
5 жыл бұрын
thank you very much, you solve my problem
@user-vw4ji7hi5y
7 жыл бұрын
Thank you so much
@muhammadnurikhsan1369
5 жыл бұрын
bro you are my hero
@jeffreybonto4173
2 жыл бұрын
Informative!
@BatWoman02
10 жыл бұрын
Amir
@donboscoo
8 жыл бұрын
Thanks Amir for the video, however for all the guys who asking for the close match, you can use the LIKE instead of = and through 2 wildcards, one before the keyword you will type in and another one after. ex. The default is ="FirstName = '" & Forms![frmEmployeeList]![SearchBox] & "'" the modified is ="FirstName Like '*" & Forms![frmEmployeeList]![SearchBox] & "*'" it will work just fine
@AmirParmar
8 жыл бұрын
+Don Bosco Thanks for the info, it will help a lot of people. I don't know a whole lot about Access and usually learn as I do research.
@donboscoo
8 жыл бұрын
Amir Parmar actually you helped me a lot with the code, but i looked for how to use the wildcards,and then, whala ;:D and for the learning, same is here bro, still trying to figure a lot of things out, anyways keep the good work and thanks again for the video :)
@r_b5951
9 жыл бұрын
Thank you Amir. Nice tutorial. I have a similar split search form with multiple search boxes for various criteria. When the various criteria are entered and the 'Search' button is clicked, the full list (approx. 100 records) filters down to the desired criteria only. To make the form more user friendly, I created a macro 'RemoveFilterSort' & a button on my form to restore the full list of records. Is there also a macro I can link to a button that will clear all search criteria entries, so I don't have to manually select, then delete, the criteria I previously entered? (I tried 'UndoRecord', but that was unsuccessful.) Thank you for any comments.
@alimoh9752
4 жыл бұрын
I am from Libya . I need this lesson thank you
@jaikushwaha12
8 жыл бұрын
how i can creat multi field search box for on my database???
@zeinabalsaady8893
9 жыл бұрын
Thanks for your quick respond. Another issue. I created a button to search for a list box for the customer. Whenever I click on the customer from the list box, it display another customer in the combo boxes and the text boxes in UI area to show the information. What Macor should I used to display only the record that I click on it
@AmirParmar
9 жыл бұрын
Zeinab Alsaady You could look into using Dlookup function to fill up the Text boxes. Or the Auto fill way, so in the drop down the Customers name, phone, etc is shown, the statements in VBA will fill up the appropriate boxes.
@mfrancis114
9 жыл бұрын
Hi, Thanks for your time in making this video. Questions on the SearchRecord Macro. You were using a Continuous form in this video, I tried to use the same method on a Single Form view and it does not go to the record I search for. Any tip? thanks for your help
@AmirParmar
9 жыл бұрын
mfrancis114 Hi, it should not matter, in my example the search is still happening on the main form and not the subform. I did a quick on test on a single form and it worked. Make sure you are typing the name of the Form and the name of the Text box field exactly as it is. Let me know.
@mohamedyoussef8352
9 жыл бұрын
goooooooooooooooooooooooooooooooooooooooood
@mr.anonymous3534
10 жыл бұрын
Hi Amir, I can create a print button fine that prints the current record that's not the issue I'm running into. This issue is I have a form that pulls information from a table by the record ID. When I try and email directly from the form the attachment contains all the records from the table. I'm trying to create an email button on my form that only prints the current record from the form. I am trying to avoid having to query a report just to email that same report. Instead, I would just like to email the current record from the form.
@davidrobertson3257
4 жыл бұрын
will this work so that you know you have nmerous records and wii you thebe able to view them
@BokehKai
8 жыл бұрын
Cool! Thanks. But what if there are multiple records match "Paul"?
@robbyaranguren6991
9 жыл бұрын
i followed your tutorial and it works great so thank you for that. however, i was wondering while using the search button on the form, i am unable to search for partial words or phrases and it appears to only search if what i enter matches the case.
@AmirParmar
9 жыл бұрын
Robby Aranguren you could try wildcards ie * symbol. I tried with r* and it worked, but still a bit finicky if I try to search again. If I close and open it, it works again. I also tried adding Requery command to the same Macro.
@GMSfosho
9 жыл бұрын
Amir Parmar Where would you insert the wildcard at?
@AmirParmar
9 жыл бұрын
+Grace Jedlicka For some reason I never saw your comment, KZitem has been acting funny. To answer your question, the wildcard goes in the search box, so instead of typing Rob, you can type R*
@doglover2666
9 жыл бұрын
The tutorial is very helpful, but when I use the text box to search for a specific record, it only brings me to the first record in the form. I have the text box search function on Form A (using as a dashboard). My records are stored on Form B. How do I write the macro to use the text box search on Form A to look up the transaction number on Form B and go to that specific transaction number I am asking for in Form B (Rather than the first page in the form)?
@AmirParmar
9 жыл бұрын
Xandra Kulla Tabler create a query with all the fields, now create a Report based on this Query. Setup the report as you need it. Now go back to the query and in the criteria, point it to the Text box on Form A. Add a button on form A which will open the Report. Hope this helps.
@johnwatkins39
6 жыл бұрын
Amir, again great video. This question has nothing to do with the current video, Im sure you haven't created one for what I'm about to ask you. Is it possible to create a quiz in access that would pull the questions from an excel workbook? Also maybe be a self grading quiz. Thanks again Amir
@AmirParmar
6 жыл бұрын
john watkins look into creating forms in Google drive or Microsoft OneDrive m.kzitem.info/news/bejne/urBtnJ2nhIB-mZg&list=PLcmYWY91gQNdHYFEm8mfwJXV0ylnpXCxW&index=10
@shijijob4645
7 жыл бұрын
Hi Amir,Thank you so much for your tutorials. It is great. I have a question regarding access. At my work I got a project to do in access. I have to create an output( report or query )in the field order user put it in the set up table. Like, if setup table as Empid = 1, SSN = 3, EmpName =2 , Empltype= 4, School = 6, Abreason = 5 then output should come in the field order Emplid, EmpName, SSN, Empltype, Absreason, School. User can change order any time. Do you have any suggestions doing that? Thank you.
@AmirParmar
7 жыл бұрын
Not sure about it. So people get to choose certain fields in any order, but the result will show the order you want. In access the Form is setup in a certain way, so people will need to choose things from it. And your report is based on a query, and u set it up to your liking. I am pretty sure there is a way, I have not encountered it.
@bk-wq2ks
5 жыл бұрын
Would this work with a Combo box in the form (with a list) rather then a text box? I can't seem to get it to work with the Combo Box? Otherwise awesome video!
@jaddaniel4240
10 жыл бұрын
Hi Amir, I did the same but i have a problem with the search for a student, the issue is that when i click the search button it doesnt work ( im using office 2007 )
@yasseraref5024
3 жыл бұрын
Hi Amir. Thanks for this Tutorial. However, just a question pls. can we do same search box or text to a Report as well same as the Form?! If YES, what is the Macro Code?
@AmirParmar
3 жыл бұрын
I have never tried it, but you can accomplish anything with Access.
@deborahtjokrotekno6253
7 жыл бұрын
Hi Amir, thank you for the video. Do you have any other video that might help me? I need to search customer records (tblcustomer) by city (tblcity). 1 city can have many customer. I did use subform and macro to do it. However I find difficulties in showing all records and print report based on the result. Other than search by city, I would like to be able to search by status (active/no active) AND city. Hopefully you can help me with this. thank you.
@AmirParmar
7 жыл бұрын
this should be easy, I think. 1. Create query with all your fields, for now, add a city and customer to the criteria and run to the query to see the results. 2. Now create a Report based on this query and customize it the way you want it to look. 3. Create a Form with 2 boxes give them names like txtCustomer and txtCity, save the form 4. In the query, remove the Customer and City name and replace them with the Form fields Forms!NameofForm!txtCustomer and forms!nameofForm!txtCity 5. Add a Button to the Form that will open the Report. 6. So now in the form, you can enter a City/Customer and use the Report button.
@hfkidsworld
6 жыл бұрын
Hellow sir how are you your tutorials are very useful i like it. Sir I am make a text search box in form but he is not search. when i click search box open a small window then i type student name and search work. why?
@jeffreycasey6111
7 жыл бұрын
Great Video, Amir it was very useful. Is there a way to add a message box if the record isn't found. For example you type in "Rob" but there are no customers with the first name of "Rob" in the database; a MessageBox populates "Record Not Found" Thanks!
@AmirParmar
7 жыл бұрын
see if you can use this www.functionx.com/vbaccess2010/topics/msgbox.htm or on this link go to the 1st Comment www.experts-exchange.com/questions/28675592/Pop-up-message-in-ACCESS-Macro.html
@cryscakes6160
9 жыл бұрын
question. i am doing the searchrecord macro. I typed in the code, but its not working... it says type mismatch. Here is the code i used ="HO Last Name = '" & [Forms]![House Officers Look Up v2]![Search] & "'" am i doing something wrong?
@AmirParmar
9 жыл бұрын
Crys Curkendoll-Draconi It looks like there is an issue with the field's data type. Also make sure that the names are right.
@farhananadia3462
4 жыл бұрын
Can i know where get " where condition"
@waritthornviriyamontree3559
9 жыл бұрын
If i want to search a non-specific(Rob) name how can i do.I want to check that name is in my database or not.
@sarahshaw5565
10 жыл бұрын
Hi Amir, What if I wanted to search for a name, but I only knew a piece of the name... Could you send me the expression or point me in the right direction to create an expression to do a search for only part of the name?
@AmirParmar
10 жыл бұрын
Sarah Shaw You can wild cards to search for partial names. if you want someone starting with letter P you use P*. check this link for more office.microsoft.com/en-ca/access-help/examples-of-wildcard-characters-HA102809757.aspx
@rickmcafee1653
8 жыл бұрын
Amir, if the form has a subform in it, does this affect the macro?
@AmirParmar
8 жыл бұрын
+Rick McAfee It should not.
@ridhimadhawan253
8 жыл бұрын
Amir, thanks for the great video! I want to turn off and on active contacts quickly, so I may run reports and email from the DB. Can you please help?
@AmirParmar
8 жыл бұрын
one easy way would be to create a query, in this query create a Criteria for Active Contacts. Now create a Report based on this query. You can place a Button for this on a Form. And with the Query results you can also run the Mail Merge to email (External Data - Word Merge)
@cjlabuschagne9155
9 жыл бұрын
First of all Thank you for the great Tutorial. I managed to get the text box search right but I see it only works for extract matches. Is there any way that it can match partially? Thx
@AmirParmar
9 жыл бұрын
Cj Labuschagne you could try wildcards ie * symbol. I tried with r* and it worked, but still a bit finicky if I try to search again. If I close and open it, it works again. I also tried adding Requery command to the same Macro.
@cjlabuschagne9155
9 жыл бұрын
Amir Parmar
@cjlabuschagne9155
9 жыл бұрын
Amir Parmar Wildcards dont work when use them on mine…
@AmirParmar
9 жыл бұрын
Cj Labuschagne try closing and opening the file.
@lamiesali6429
8 жыл бұрын
This is great Amir thank you so much! One question though: I have a "main menu" form, and I'd like the search box to be on it instead of on the form that displays all the records. I couldn't figure out how to do it I added OpenForm first, then the SearchForRecord in the main menu form, but it didn't work. When I cut the search box from the main menu and paste it in the other form that displays all the records it works, but not when it's in the main menu Can anyone help?
@AmirParmar
8 жыл бұрын
So the main Menu is the Form that is like the Switchboard, which has buttons to all the Forms and reports? If you look at the code, it is looking for a open Form, with a particular field, this field is not on the Main Menu so it will not work. there might be another way, if I find it, will reply back.
@lamiesali6429
8 жыл бұрын
Amir Parmar exactly. The field is not on the MainMenu, which is why my code has the name of the field then the name of the form that has all the records(instead of the MainMenu form). But apparently it doesn't work because the searchbox is placed in the MainMenu Thanks a lot
@ssdusd
2 жыл бұрын
Awesome 👌 Can we send Email without Attachment? And Change the name with a number counter؟
@charlessotis6672
6 жыл бұрын
Mr. Parmar, Thank you so much for your excellent videos and instructions - you've helped me so much. At the present time I have to compute a child's age to determine if and when the child is eligible for benefits. Would you please give me the parameter formulas for doing this? I have quite a number of children's ages to compute and any help from you would be greatly appreciated. Chuck
@AmirParmar
6 жыл бұрын
Hi Charles, in the link below are some instructions for figuring out date of birth, however you can use it for figuring out any date related calculations docs.google.com/document/d/1SRJ-YKb8uqtVm-h5nubirUC3UlPVWtlKZMAcmGpaeq4/edit?usp=sharing
@sumana9864
8 жыл бұрын
Hi. I need to create a 'form' that counts votes. I think I can do this through macros. Could you help?
@AmirParmar
8 жыл бұрын
+Sumana you may not need Macros. Create a query that will have the Yes or No and use the COUNT option in report to count them.
@deborahtjokrotekno6253
7 жыл бұрын
Hi Amir, do you have any tutorial covers on search by date range in access vba?
@AmirParmar
7 жыл бұрын
not in VBA, but had it via query and form.
@RamzyElias
10 жыл бұрын
*^**_^☆☆☆ good video ❄ Merry Christmas ☆☆☆^_**^*
@AmirParmar
10 жыл бұрын
Merry Christmas to you too!
@aaronkary1643
9 жыл бұрын
I was able to create the search button, info field, and macro. But when I hit search it only flashes in form fields and does not populate and stay visible. Any ideas?
@AmirParmar
9 жыл бұрын
Aaron Kary there might be mistake in the code, use the sample File from the link and try with it.
@jessatabion4553
9 жыл бұрын
what is the code for search button? tnx
@mikekyler4326
5 жыл бұрын
I followed the video to create a search button for the record ID(auto number) It appears to be working, but the data that populates the fields flashes and it goes back to the existing data. What am I doing wrong here?-Thanks!
@mikekyler4326
5 жыл бұрын
Nevermind I found a reply from three years ago This is for searching numerical fields ="FirstName = " & Forms![frmEmployeeList]![SearchBox] & "" Thanks Amir!!!!
@helenharris9120
9 жыл бұрын
Amir I need to search for a numerical ID and I have tried to follow the instructions to create the search and find macro but it doesn't work for me. Are there particular rules for number only searches? I have used loads of your other videos and they have worked perfectly.thx
@AmirParmar
9 жыл бұрын
+Helen Harris Hi Helen, you have to remove the single quotation from the search command. So try using this ="FirstName = " & Forms![frmEmployeeList]![SearchBox] & ""
@helenharris9120
9 жыл бұрын
I did try this however it still doesn't find anything.
@AmirParmar
9 жыл бұрын
+Helen Harris it is a bit finicky even when it works. If you had the form open, close and open it again and try the search. Make sure that in the Macro you are using the "Search for Record" and also add the "Refresh" command in the same macro. as I was typing and testing, it started working. Very strange.
@helenharris9120
9 жыл бұрын
+Amir Parmar Thank you Amir I have got it working now using your advice. I appreciate the help. You will probably here from me again as I am pretty new to all this. Thanks
@khaledghazal4746
9 жыл бұрын
i tried a lot but i could not succeed if you please rewrite the where statement so i can copy as it is to my project thank you it was good presentation
@AmirParmar
9 жыл бұрын
Khaled Ghazal if you download the zip file, it has a text file with the where statement. But here it is, hopefully it will show up ="FirstName = '" & Forms![frmEmployeeList]![SearchBox] & "'"
@triptiagarwal6325
7 жыл бұрын
while creating a macro the Email database object command does not shows up. What should i do?
@AmirParmar
7 жыл бұрын
Close and open Access.
@ShaharKelley
5 жыл бұрын
Hi, I have a split form and for some reason, when I search, nothing happens. Should there be any difference in this macro in the case of a split form? Thanks.
@AmirParmar
5 жыл бұрын
see if this link helps, when the form are in sub form, they have to be called differently access.mvps.org/access/forms/frm0031.htm
@ShaharKelley
5 жыл бұрын
@@AmirParmar But is a split screen - a sub-form? I think not, as in the design view I can't see to bottom part, the list. It does not have controls of its own. I did see though, that at the top of every column at the bottom part (Access 2016) there is a drop-down list with options to Sort/Search/Filter by that column, so it does solve the problem in a way. I would still prefer to have a dedicated search box at the top part.
@d3tester667
5 жыл бұрын
Thank you for this but this is useless if you have to match the exact full name. Can you please show me the syntax of how to match any in FullName? So if they type only last name in a field that holds full name it will find it. I've tried a bunch of different stuff Like "*" and whatnot. I'm stuck. Also, I can't get And to work so I can search multiple fields. ="Caller_Name And Injured_Name
@samir19661
9 жыл бұрын
Hi, I create a form with split view. When I open the form alone, it shows split form with datasheet. but whenever I try to move it to the User Interface, does not show the datasheet underneath of that form. Would you please let me know How to do it? Thank you
@AmirParmar
9 жыл бұрын
Sam Al how about creating the wizard to create your form, add the all the fields of one Table and than choose the other table and Add the fields of the 2nd table, this will be the sub-form. This subform will be visible when you to go to the Design view.
@AmirParmar
9 жыл бұрын
Sam Al Hi sam, post your comment again. There too many weird characters in that post, so had to delete it. If I read the comment properly, it was about the Search button; even I have some interesting issues with the search, it works sometimes and sometimes not. Try closing and opening Access and the field might work only once.
@karlbonoan5544
6 жыл бұрын
hello i just want to ask the problem about "microsoft access cannot find the referenced form"
@AmirParmar
6 жыл бұрын
Looks the form is missing or the name has changed.
@hichemboudali6168
9 жыл бұрын
Good presentation but it doesn't work with my project I think that the problem is in the statement of search (I have the french version of Office 2013)
@AmirParmar
9 жыл бұрын
Hichem Boudali as you type the Tool Tip will offer some help. Maybe some english words are in the code are inserted in French.
@DamageInc86
7 жыл бұрын
How about printing only the selected records from a query that is being shown in a subform? I cant find a solid solution to that. can email dbase file if that would help.
@AmirParmar
7 жыл бұрын
Can you create a report based on the query. Now add a Button that will open the Report to be Printed.
@DamageInc86
7 жыл бұрын
I did get a report going, but it wasn't that simple to print, had to get some code for checkboxes and records, and the button to print. So thankful for the people over at www.access-programmers.co.uk/forums/
@Noureddin1
9 жыл бұрын
hi there.thanks for your videos. I need your help.I have a 2 fields in subform1[Relation] 2 [DateofBirth I want the validation rule for the date of birth to be => 1/1/1987when the relartion reads "Son"] .
@AmirParmar
9 жыл бұрын
+Noureddin Bagas I think you will need to use a IIF statement. IIF([Relation] = "Son",what should happen if True, what should happen if false) fill in the part for True and false.
@vinodmittal8119
5 жыл бұрын
I hv seen all the videos which u hv made in hindi. No doubt u hv imparted a lot of knowledge. Even thhough i m a maths teacher but i learnt a lot from these videos and i made a full system of keeping the records of students fee. I struck on a pt. I m entering the fee of a student through receipt Form and suddenly i found on the column of student name that this child is not in your student information table as i am getting it through lookup combo box. So i want to make a macro on this form which will open the form of stu info and after filling the detail i will return on receipt form and will be able to pick this new student from drop down button. How can i do this work through macro or other way.
@AmirParmar
5 жыл бұрын
Hi Vinod, sorry about the delay, I have been busy/lazy at the same time & don't use Access much. You can create a Query that will search for the record. you can put a Button on the Form to open that query.
@vinodmittal8119
5 жыл бұрын
@@AmirParmar thank you sir
@vinodmittal8119
5 жыл бұрын
@@AmirParmar thank you, I think i had mingled up many things in my discription. I have two tables student info and receipt and two forms of the same name. My qus is how can i enter the data in student info while i am working on receipt form.
@AmirParmar
5 жыл бұрын
@@vinodmittal8119 I am guessing that both tables are related, as each student will have Receipt associated with them. How is your database setup? It will be good to have a table for students, maybe another one for Courses, 3rd for what you are calling receipt. in the Receipt you can have relationships with Courses and Student table. Try to create a Form with both table and see how it shows things.
@vinodmittal8119
5 жыл бұрын
@@AmirParmar thank you
@mr.anonymous6824
10 жыл бұрын
Hi Amir, How do you create an email button on a form that only prints the current record? When I create an email button on my form the PDF attachment has all records on it.
@AmirParmar
10 жыл бұрын
Mr. Anonymous are you trying to email or trying to Print. In access 2013 I see an option to print only current records. Email buttons tend to print Reports, so you can create a query that will only print one record and create a Report based on this query.
@parthapratimdas7737
6 жыл бұрын
Sir I faced a problem creating a Search For Record macro.I followed your instruction. But when I click the search button the record show for a fraction of time but not stay on screen.Please help. My where condition is:- ="Employee Code = '" & [Forms]![frmRegister of members]![Searchbox] & "'" When I try to run the macro in macro window, it shows Type Mismatch & Action failed with a error code 2950
@AmirParmar
6 жыл бұрын
maybe there is a difference in what you are searching for try this: you have to remove the single quotation from the search command. So try using this ="FirstName = " & Forms![frmEmployeeList]![SearchBox] & ""
@parthapratimdas7737
6 жыл бұрын
Sir thanks for your response.I tried without single quotation but still not working.
@emiliotzum186
6 жыл бұрын
I'm on a site that has several tabs. i can click on it but each clickable tab has no id, name or class. It just has: Title Title ("Music Tab") I have tried IE.Document.getElementsByTitle("ElementName")(0).click IE.Document.getElementsByTitle("ElementName")(0).submit IE.Document.getElementsByTitle("ElementName")(0).select IE.Document.getElementsByTitle("ElementName").click IE.Document.getElementsByTitleName("ElementName")(0).click But none of those work
@wimvos6584
9 жыл бұрын
Dear Amir, thank you for your tutorial. but it does not work in my database access2010. This is the WHERE code: ="SYMPATHY Naam = '" & [Formulieren]![Beschrijving antilichamen]![ZoekTekst] & "'" SYMPATHY Naam is the field in form Beschrijving antilichamen and ZoekTekst is the searchBox. Why does it not work out?
@AmirParmar
9 жыл бұрын
+Wim Vos Here is the code I used in the video, looks like your code is missing the word Forms after the first & ="FirstName = '" & Forms![frmEmployeeList]![SearchBox] & "'"
@JohnHendricks05
8 жыл бұрын
+Amir Parmar Hello - Sorry to bother you, can help with a LIKE style string? Where the search box find all records matching "xxxx" search. Such as searching for a users ID, but IDs are in the system as Domain/ID. Without having domain info I'd like to search the IDs without knowing the Domain.
@AmirParmar
8 жыл бұрын
Hi John, check out this link, it might give you the solution allenbrowne.com/ser-62.html
@nonsookafor722
8 жыл бұрын
hello amir.... how can I save date from a form to multiple tables
@AmirParmar
8 жыл бұрын
+nonso okafor Hi, I have never tried that, it might require some VB and also look into Dlookup function. But why do you need to do that? If you have proper relationship, you can always pull up the Date in query or Reports.
@deborahmegawatitjokrotekno7684
9 жыл бұрын
Hi Amir; I have followed your instruction, it worked well however when I used it with report instead of form. It failed. Any commend?
@AmirParmar
9 жыл бұрын
Deborah Megawati Tjokrotekno which part were you trying with report, Email or something else?
@deborahmegawatitjokrotekno7684
9 жыл бұрын
Amir Parmar I have a customer report group by city and I want to be able to print all the customer as well as per city based on the search. Hopefully this is clear enough.
@AmirParmar
9 жыл бұрын
Deborah Megawati Tjokrotekno This is how I would approach it. First make a Query with all the fields needed, for Criteria in City add [Enter name of City] run the query, it will prompt for a city name, enter and see if you get results. save and closeNow create a Report based on this Query, when finished, it will again ask for name of City, enter and see it works. Save and close. Now open the Form which has the box where people will enter the city name. Get the name of the Box. Now open the Query in Design view, and change the City criteria to point to the text box in this form. And on the Form add a Button that will open the Report. Hope this helps. Let me know.
@deborahmegawatitjokrotekno7684
9 жыл бұрын
Amir Parmar Thanks Amir! Yes I do manage to get it right and include return all when the text box value is null. Do you have any video for access that explain line counter/max line counter when I want to print my report in certain format. Thanks.
@AmirParmar
9 жыл бұрын
Deborah Megawati Tjokrotekno No I have not made a video on Line counter or max line counter. Will look into it, have not used that feature.
@umarmirza6971
10 жыл бұрын
where is the link to the sample file for search button?? can anyone help please
@AmirParmar
10 жыл бұрын
Umar Mirza hi i think there is not sample file for this tutorial
@abdulsms
7 жыл бұрын
how to make query particular report print
@AmirParmar
7 жыл бұрын
you could make a Query and create a Report based on this query. in the query Criteria of a field like ID or Invoice Number, put [Enter number] this will prompt a question to enter number, every time a Report is run. you could also make the query read boxes on the form and a button opens the Report.
@abdulsms
7 жыл бұрын
Sorry this my humble request could you plz make video for query particular report and print page iam using purchase database so I need to make supplier query and report
@AmirParmar
7 жыл бұрын
Hi Abdul, i have covered the topics in my tutorials.
@Noureddin1
9 жыл бұрын
I tried to do the same thing but it did not work on seraching for first name, notice that i am using access 2010. please advice....
@AmirParmar
9 жыл бұрын
Noureddin Bagas are you trying the same example as mine or something in your own file? I am using Microsoft Access 2010 in this video too, so that everything will be the same for you. Try to duplicate the example as I have shown and than try to experiment.
@Noureddin1
9 жыл бұрын
Amir Parmar Thanks for your reply really appreciated, the only thing different is that I am applying it on a real form, containing main fields for an employee and 2 pages (subforms) under the main employee information for including information about his parents in one page & the other for his wife & children. linked by the Employee ID (one to many ) and by the first and second name . Again thank you Amir. you are so brilliant .
@AmirParmar
9 жыл бұрын
Noureddin Bagas So were you able to get it to work? I have never done this with a Subform. All the best.
@Noureddin1
9 жыл бұрын
Amir Parmar Unfortunatley, it didnt work!! I still stuck with it. I tried several times but no way. I try to apply it in a seperate form. I ll back to you master. thanks a lot.
@adnankazi2215
5 жыл бұрын
Can anyone help me - I am trying to make a family data base - with one button of search the whole details I want in form
@AmirParmar
5 жыл бұрын
Have tried to look online, there might already be something out there.
@adnankazi2215
5 жыл бұрын
I got it :) but now want an auto mail on their birthdays by access
@trajkomiki
9 жыл бұрын
Do not work if you have two identical names, it gives me just first
@AmirParmar
9 жыл бұрын
Miroslav Andreevski Did you see on the bottom; if you click on the arrow it goes to the 2nd record?
@deepumb678
10 жыл бұрын
Hi amir, Can u tell me how to print selected item
@AmirParmar
10 жыл бұрын
Hi Deepu, do you want print them from a Table? there are many ways to do this. One way is to Filter the records that you want; another way is to create Queries. In other programs you can use CTRL key to highlight some Rows but not in Access. You can use SHIFT key to highlight bunch of Rows.
@deepumb678
10 жыл бұрын
Amir Parmar Hi amir, in this video we can search every employee ,I want to know how to save eatch employe to report file.it means I don't want to save all employee names in report file, I need to select partculer employe name.if we put command button like submit how to do pls tell me any commands
@AmirParmar
10 жыл бұрын
There might be many ways to do it. but try watching this video on parameter query and see if that solves your problem Microsoft Access 2007 2010 2013 pt 7 (Parameter query with Form; Macro & Append/Update/Delete Query)
@zaidbinsaleem
8 жыл бұрын
Dear Amir, i tried creating a search macro with the following but its not working. Please help. ="DonorName = '" & [Forms]![FindDonor]![SearchBox] & "'"
@AmirParmar
8 жыл бұрын
+Zaid Bin Saleem Remove the Bracekts [ around the word Forms
@zaidbinsaleem
8 жыл бұрын
Access automatically putting brackets around upon saving. What to do?
@AmirParmar
8 жыл бұрын
+Zaid Bin Saleem Not sure what else could be up. Can you try it on the sample file I have in the description and let me know. There might be an error in the name of the form or the search box or the code is in the wrong place.
@cathvk7862
8 жыл бұрын
+Zaid Bin Saleem Hi there - I had that issue too, but discovered that I did not type the ' = ' at the beginning of the expression - once I did it worked perfectly.
@haideri0313
9 жыл бұрын
Search didn't work :/
@haideri0313
9 жыл бұрын
Nvm, it works :)
@paulcagle4119
9 жыл бұрын
Don't copy and past in a tutorial. Also, the code does not work. I made the exact table and form and it does not work.
@AmirParmar
9 жыл бұрын
Paul Cagle Hi Paul, not sure why it is not working for you. And if you look in the description, you will find a link; this link has a zip file, which has a sample database and also a txt file with the code that I copied and pasted.
@kevingutierrez5901
9 жыл бұрын
s
@inarossouw4816
10 жыл бұрын
Thanx Amir! :) ur the BEST!
@kabuldesign4971
5 жыл бұрын
how i can creat multi field search box for on my database???
@jessatabion4553
9 жыл бұрын
what is the code for search button? tnx
@AmirParmar
9 жыл бұрын
jessa tabion I will paste it in the next comment, hopefully it will go through. You can also go to the link that is in the description of the video and download the zip file that contains the sample file and the code.
Пікірлер: 172