Search results

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...

how can i display the subforms in the layout i need with no lines and no record selector or navigation so the user can not tell its a subform

can you show me how you can do that im new to this access world

i user the unbound form because the values needed are from several different queries not a table

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.

Here is the code for my database. :banghead: Option Compare Database Option Explicit Dim FiltStr As String Private Sub cboDept_AfterUpdate() Me.cboTech.Requery BuildFiltStr End Sub Private Sub cboDept_GotFocus() Me.AllowEdits = True If FiltStr = "" Then...

i tried that already it didnt work well got an error at the on click event on my listbox

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...