Search results

  1. C

    open form on specific record through listbox filter record issue

    The correct file is in the attachment, because the things to change were different. Excuse me but what you have achieved is truly something almost unwatchable.
  2. C

    open form on specific record through listbox filter record issue

    Private Sub DynamicList_Click() If Me.DynamicList.RowSource = "SELECT * from tblMasterTables WHERE MasterTablesPK>3;" Then Select Case Me.DynamicList.ListIndex Case 0 'Current Stock Me.DynamicList1.RowSource = "SELECT ItemsPK, ItemsListName, CurrentStock...
  3. C

    open form on specific record through listbox filter record issue

    In VBA the measures must be converted to twips. Private Sub DynamicList_Click() If Me.DynamicList.RowSource = "SELECT * from tblMasterTables WHERE MasterTablesPK>3;" Then Select Case Me.DynamicList.ListIndex Case 0 'Current Stock Me.DynamicList1.RowSource...
  4. C

    open form on specific record through listbox filter record issue

    It would be easier to understand and help you if you attached an example file.
  5. C

    lower level bill of materials

    You should explain the procedure part better: 1. buy raw material say 3 mtrs 2 make bosses out of raw material say 20 3 electrically tin the boss say the same 20 not calling up 40 to be made
  6. C

    How to handle Item discount and Invoice discount levels.

    In order to understand how the data recorded in the tables are, you should show an example with the same, because it is not clear whether DiscountAmount and ItemDiscount are two discounted amounts or are percentage values which will allow the relative amount to be discounted.
  7. C

    Strange problem with equation inside vba module

    We should see how you recover the three fields and what type they are.
  8. C

    Strange problem with equation inside vba module

    If logarithms must be base 10, divide the expression by Log(10) 495 / (1.29579 - 0.35004 * (Log(87 + 97 - 32)/Log(10)) + 0.221 * (Log(167)/Log(10))) - 450 which as a result of 33.7396011841917
  9. C

    getting error on my form on one database but not the other which is the same

    Perhaps it would be easier to understand if you attached the file, with a minimum of data and replacing any sensitive ones.
  10. C

    Export multiple access query to same workbook two sheets

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query1", CurrentProject.Path & "\FileName.xls", True DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query2", CurrentProject.Path & "\FileName.xls", True and it will create the excel file "FileName.xls", with two...
  11. C

    Solved Correct way to update data

    Attach a sample file.
  12. C

    multi criteria DSum

    You have a message in your private mail.
  13. C

    multi criteria DSum

    Maybe if you attach a sample file it would be easier to help you.
  14. C

    Solved Update Vehicle Table from Form field...

    In the attached file you can see an example.
  15. C

    Should work but doesn't

    Maybe if you attach a sample file it would be easier to understand and help you.
  16. C

    Solved Problems exporting text file

    Using the Output method of the DoCmd object, the export takes place regularly, as you can see in the attached example.
  17. C

    Solved Update Vehicle Table from Form field...

    If the relationship between Trip and Vehicles is correct the query is correct, perhaps if you attach the file it is easier to show you how you should change for what Pat Hartman rightly said.
  18. C

    two lines but only want the last line in my purchase order

    If you attach a sample file it would be easier to help you.
  19. C

    2 records with the same id number in query

    Try modifying the query by entering DISTINCT. SELECT DISTINCT StockID, StockNo, OnOrderQty, Allocation, allocated, batchno FROM StockLevels WHERE StockNo=[Forms]![stocklevels]![Stocklist For Purchasing].[Form]![StockNumber];
  20. C

    Linking Excel File and Editable

    Meanwhile, you can try to simulate the import by working with all the files on your computer. If everything is correct in this case the problem is with the server. However, if you provide the sample files we could also check what happens.
Back
Top Bottom