Search results

  1. O

    Joined queries and no records problem

    I have two queries that collect and join data from different tables. Lets call them qry1 and qry2.Those two queries have no criteria and always return data. Now I have a third query based on that two queries that joins these two queries for a report. Report is launched from a form where user...
  2. O

    Joined queries and no records problem

    I have two queries that collect and join data from different tables. Lets call them qry1 and qry2.Those two queries have no criteria and always return data. Now I have a third query based on that two queries that joins these two queries for a report. Report is launched from a form where user...
  3. O

    Cannot delete record in query with left join

    I have query, with left join, that just checks some values are matching or not and adds one field to query result that contains "match" or "no match" (iif is null expression). Query itself contains other fields too which are editable. Problem is i cannot delete record through this query...
  4. O

    Form for entering criteria

    Hi, Here´s my problem. I have a form that contains unbound textboxes, comboboxes and a button that runs query. The query criteria fields are linked to the textboxes/comboboxes on the form so the user can enter a criteria. In criteria i use -Like "*" & [textbox] & "*"- so if the textbox is left...
  5. O

    Need help with query join

    I have two querys with same number of fields and same field names. [BudgetNumber] txt [CostCategoryCode] number [TotalSum] number I need a query that calculates balance between these two querys. It should look like this, BudgetNumber (match with both querys), CostCategoryCode- all codes that...
  6. O

    Icons

    Hi! Does anyone know where are located those icons that are used in templates? I took a picture of one for you to understand what i mean. I see them lots in projects but i just wonder how to add on in my own project.
  7. O

    Binding query to textbox

    Hi, Here´s my problem: I have working form of Invoices (linked to tblInvoices) and I want the InvoiceNr to be checked if it exists in tblSomeTable. The check should be performed every time i move to next record on form (next invoice). If the invoice exists the text (txtbox or label, not msgbox)...
  8. O

    Need help with db structure

    OK, this´s what i need to do. I want to create a budget managing db. It should contain fields Budget nr (unique), Object (may repeat), Subcategory (must be unique for every Object), Product, Amount, Price. What i want the result to be, is a form where the 1-st three fields are comboboxes and the...
Top Bottom