Search results

  1. M

    Queries not returning new data

    Simple version: Any new data I add to my database isn't showing up when I run a query. Longer version: I've noticed it on 2 queries. One which is my ChargerSearch query with the field name: ChargerSearch: "Charger ID: "+[Charger_ID]+" "+"Scheme Contract: "+[Scheme_Contract]+"...
  2. M

    Autofill Field Based On Related Field In Previous Form

    Ok, so I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record. How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being...
  3. M

    Display some information from query in pop up window

    Hello, to give as brief of an overview of the situation as possible, I've created a query called "JobHistoryQuery" and a form called "JobHistoryMultiForm", this displays all Jobs related to an Asset and all the information about that job. There are some fields (BilledMonth, BilledYear...
  4. M

    Multi-Column Combo Box

    Hi, this is probably something very simple that I'm overlooking but I have a problem with a combo box on a form. To give a brief overview I have a "Jobs" table, in that table is a "Parts Required" and "Parts Used" field that is linked to a "Parts" table. This table contains 3 fields "PartName"...
Back
Top Bottom