Search results

  1. 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.
  2. C

    Strange problem with equation inside vba module

    We should see how you recover the three fields and what type they are.
  3. 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
  4. 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.
  5. 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...
  6. C

    Solved Correct way to update data

    Attach a sample file.
  7. C

    multi criteria DSum

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

    multi criteria DSum

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

    Solved Update Vehicle Table from Form field...

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

    Should work but doesn't

    Maybe if you attach a sample file it would be easier to understand and help you.
  11. 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.
  12. 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.
  13. 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.
  14. 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];
  15. 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.
  16. C

    Open To Suggestion

    Is the size of the image within the PDF file always the same? Does that grid of black lines always appear in the image?
  17. C

    Overlaying Text and Image

    Sorry maybe it's easier and quicker to help you if you attach a sample file.
  18. C

    close order when line items add up

    I think there are problems in the structure of the tables involved in the orders as, in my opinion, the structure should be: tblOrders OrderID OrderNumber OrderDate SupplierID etc... tblOrderDetails OrderDetailID MaterialID MaterialQuantity...
  19. C

    Solved Running sum of query, report with opening and Closing balance

    In the attachment you will find an example. However, the first thing to do is learn how to manage the properties of the various fields of the tables and in particular: Size (if the type is Text, don't always leave 255 set as you almost always won't need all those fonts (this is to avoid...
  20. C

    Record validation

    You say 100m and 300m combination is allowed but the 300m event is not in the event list (100M, 200M, 400M, 800M, 1500M, 3000M, Long Jump, High Jump, Shot Put (5.00Kg) , Thread (1.5Kg), Javelin (700 gms), 4x100M & 4x400M Relays)
Back
Top Bottom