Search results

  1. C

    Solved Max qry in form

    create the query qryLastMovements SELECT INVENTORY_CHECK.LINKEDID, Max(INVENTORY_CHECK.ICDATE) AS MaxDiICDATE, Max(INVENTORY_CHECK.ICTIME) AS MaxDiICTIME FROM INVENTORY_CHECK GROUP BY INVENTORY_CHECK.LINKEDID; create the query qryInventoryOut SELECT INVENTORY_CHECK.ID...
  2. C

    Solved Max qry in form

    Maybe if you attach an example file with a minimum of data it's easier to understand and then help you.
  3. C

    Table for Products

    First of all you should explain the meaning of each column and which field in your database it can be associated with. If you attached an example file of your database with a minimum of data entered for a couple of offers following a request from two contractors, it could help us understand better.
  4. C

    Query - format MS SQL date/time extened that is linked to Access as yyyy-mm-dd

    Show the ways you've tried.
  5. C

    Database setup for school objects

    Maybe if you attach the file you created it might be easier to understand and help you.
  6. C

    Looking for some direction.

    How to interpret these writings 824761|826233|826234 Stage Final 826877 How to interpret these writings 824762|826230 How to interpret these writings 824771 DI 825708
  7. C

    Query in Subreport help

    Try like this
  8. C

    Query in Subreport help

    In the RPT_Employees_Main report you only need to set the employees_tbl table as the Record Source.
  9. C

    Query in Subreport help

    Without a sample file it will be difficult to help you.
  10. C

    Looking for some direction.

    From the excel file it is certainly not possible to understand much how a device is managed, perhaps you should show it in tree format.
  11. C

    Looking for some direction.

    You could attach the file by replacing the sensitive data with other random ones, this to have a precise vision of what we are talking about.
  12. C

    Convert code VBA to expression in query

    Nz([Forms]![frmMastr]![txtsucc];[Success])
  13. C

    Solved Query output using multiple tables

    If you don't attach a sample file it's not possible to do it in your imagination.
  14. C

    Table relationship problems

    From what you have created it is clear that you have never read a book on access, it will be good if you do if you want to create something decent.
  15. C

    Run-time error 3048

    See here: https://www.accessrepairnrecovery.com/blog/fix-access-error-3048
  16. C

    Add Options Without Pending in search form

    Attach file.
  17. C

    Solved Multi select issue after implementation cascading combobox

    The first thing to do is learn how to manage the properties of the various table fields and in particular: Size (if the type is Text, don't always leave 255 set (this is to limit data entry to what is strictly necessary) Required (if set to yes, it does not allow saving the record if...
  18. C

    Solved Row selection & Focus Issue in Datasheet Form

    The other fields must have properties Enabled = False Locked = True
  19. C

    Solved Add multiple selected items to continuous form

    Attach your db file
  20. C

    Solved Concanetate according to date

    In the attachment a variant to the previous solution.
Back
Top Bottom