Search results

  1. C

    Solved Synchronize 2 Combox

    You had the example in post #7.
  2. C

    Solved Synchronize 2 Combox

    Try this update.
  3. C

    Solved Synchronize 2 Combox

    Here you can see the example to show all records just clear the value in the related filter control.
  4. C

    Solved Query selection in Access 2000.

    In the attached file you can see an example with your normalized data and search form.
  5. C

    Running Total in Access report

    To attach a file you must use the "Attach Files".
  6. C

    Add a column with 3 status in a Query

    To help concretely, it would be necessary to have a detailed description, from start to finish, of how the activity you would like to reproduce in the database takes place.
  7. C

    Convert Excel into Access Database

    First you should tell what the List, Amount, Currency, Accounts2 columns are for.
  8. C

    Solved How to link 3 comboboxes

    Maybe you should attach an example file because then you can't figure out what you did.
  9. C

    MaxOfDate Not Returning the Expected Results

    You need to create two queries: qryMaxRev with the following predicate:SELECT tblDrwgRegisterDtls.DwgID, Max(tblDrwgRegisterDtls.DateIssued) AS MaxDiDateIssuedFROM tblDrwgRegisterDtls GROUP BY tblDrwgRegisterDtls.DwgID; qryMaxRevData with the following predicate:SELECT tblDrwgRegister.DwgID...
  10. C

    MaxOfDate Not Returning the Expected Results

    Maybe it's better.
  11. C

    Quicken Report

    Insert the following instruction in the Report Load event: Private Sub Report_Load() DoCmd.Maximize End Sub
  12. C

    Query Assistance

    Here you can see an example of a mask with dynamic filters.
  13. C

    How to Delete Matching

    Private Sub Worksheet_Change(ByVal Target As Range) Dim bookName As String, authorName As String Dim strStartColumn As String, strEndColumn As String Dim intStartRow As Integer, intEndRow As Integer Dim intRow As Integer bookName = Range("G2") authorName = Range("G3") strStartColumn...
  14. C

    Query Assistance

    Where is the problem?
  15. C

    Solved Max qry in form

    Queries have changed.
  16. 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...
  17. 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.
  18. 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.
  19. C

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

    Show the ways you've tried.
  20. C

    Database setup for school objects

    Maybe if you attach the file you created it might be easier to understand and help you.
Back
Top Bottom