Search results

Im looking over an database that i have inheriated to reconstruct. i notice on form there is an event DataChange(ByVal Reason As Long) what does this do what is the purpose?

Good day, i have a form that i use i have search function in that form it works but there one problem it only allows me to search once i have close the form and restart the form

i need to be able to create a calendar in a form like the one in the picture i have no idea how i can do this i want to have the user put in a a letter for each result of the area being test on the calendar. https://www.dropbox.com/s/z3m37lfjls1fxue/calandar.png?dl=0

want to join two queries so i can take the count of one query and divided by another query to get the percentage of work orders that were completed. the numerator query: SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder FROM MaximoReport WHERE (((MaximoReport.WorkType) In...

I have many queries were simply to come up with a number that is a count of records with a specific criteria, to be used later in a calculation. Because those criteria are so lengthy, and change with each variation of the data that is collecting, I’m not sure if an IIF structure would return...

I want count-collecting in VBA using recordsets or the DCOUNT() function. instead of using a query. The queries I already have built are doing pretty much work , but when I try to link them together for your final report, if anything had missing or null values, it causes problems.query 1...

I have a table that is deleted and new data is uploaded to it on a weekly basis i need to create a query that takes criteria from the table and forms a denominator, and then another calculation for the denominator and then gets the percentages from those numbers for each departments compliance...

i have an unbound form that I need to get the results from serveral queries into the unbound text boxes I thought of using Dllokup but don't know how to do it.

I would like to create a form in which a listbox displaying records from Project is filtered based on the selection of a comboboxs Dept and Tech , Date From and DateTO combo boxes containing the Project Data in other words, i want to select "Deot " (value 1) in the combobox, "Tech" (value 2) in...