Search results

Paul, Great. Thanks a million. It does the job on my side as well.

Hi, Here is my stripped db. Looking forward to your advice. In FrmStartscherm: 1：Select button "Search Contact + tasks" 2:In the field "SearchFor" in, FrmContactSearch, type any search term. Whenever you start with the letter "I" it will backfire.

Hi, I am getting a runtime error '2110' - access can't move the focus to the control SearchResults. This ONLY happens when the first character I type in the SearchFor field is the letter "I". All other characters do NOT give the error. Any idea why it only backfires on character "I"? The Form...

Dear code builder pbaldy, What I do with the results is: I have a Material number that needs to be released. I want to quickly find if that number appears in any of those queries. If it does appear, then I need to do go the specific queries. I check the query to see which field, in which area of...

I got it. Thanks, I will try that out for sure. Last question: Why does a temp. table have your preference?

pbaldy, I much appreciate your quick reply. I'm missing "Query name" in the results, and also... only queries that have results need to be included. Perhaps you could fit that in for me?

Hi， I'm looking for the smartest way to solve the following: Certain data is imported to Access weekly from the company main system. The Access database contains about 250 queries that checks the correctness of imported data, via criteria in each query. Each query that checks data, is called...

Hi, What you want requires a lot of explanation,a lot of knowledge and a lot of patience. Even then, many changes can take place in a company, and you may have to rebuild the databse frequently. Just a few tables and a tick box is not enough.It goes much much further than that. This kind of...

Hi Nathan, To show only the records from TableA on a Form, you can use the TableA as a source for your Form. The relationship is neglected in this case, because TableB will not be part of the source. To show records from both TableA and TableB on a form or a Report, you use a query containing...

If I understand you correctly you want to show all instructors and count how many trainers per instructor.Sounds like this is what you need: a (Total) query that groups on instuctor and counts records for each trainer.

Hi. Go to Video tutorials on this forum (Top right side). Then go to Reports, to learn about Reports. You do not need to base the Report on a table, but in design view, just type your text using a text box. Once you have done that and saved the report, go to Video tutorials Forms, to learn about...

Hi, there are different ways to get your result. If you only need plain text, then I would create 1 or more Reports in Access. Write your instructions in the report(s), then make a button that opens the report(s) while you are on a form

In your form or report, in the HEADER or FOOTER add a text box. Inside it type the following: =Count([YourField]). The success of this will depend on whether you place it in a subform or a main form.

Press HOME. Then press SHIFT + END. All you text is selected.

Hi, In your query design view, go to the criteria row below "Start Date/Time" and also below "End Date/Time". In both places type the following: Between [Enter date1] And [Enter date2]. When you run the query, it will prompt you to enter dates. You need to enter both dates twice, because you do...

Aaron, What do you mean where to put it? Normally one would place it to the right of the fields you mentioned that make up this Invoicetotal. By the way, if your form is based on the query you mentioned, you would only have to add the field InvoiceTotal form the query into the form.

Try this in the form: =[Quantity]*[Price Per Item]+[Clear Agent Fee]+[Duty]

Hi MBA, Try adding a Text box to the header. Inside this you could type: =Iif([Volunteer]=-1;"Volunteer" ;" Member"). That should do the trick

When you create a report this way, the new report is "looking" for the field names that you had in the previous report and query. Perhaps you did not change all the field names in the new report. It could also be that the grouping/sorting in the new report is still refering to a field that you...

Hi Sonia, Welcome, hope you find what you're looking for.