Search results

  1. C

    MS Access database runs slower on SSD than on Spinning disc

    Use task manager to compare memory and cpu usage
  2. C

    Need Help With Code VBA For FIFO

    I would say FIFO is a method, it is not the only method
  3. C

    Need Help With Code VBA For FIFO

    Have you looked at the links provide by JDraw in post #3? Is there any reason why are you using FIFO? it is fraught with problems and often shows no real benefit in these days of relatively low inflation. Have you considered using standard costing/variance analysis or average costing instead...
  4. C

    Need Help With Code VBA For FIFO

    You also need to consider stock changes such as damaged items - can you identify which price to assign to stock writeoffs ?
  5. C

    Incremental Sequential Numbering by Year via Calculated Field

    It is perfectly doable by modifying the rownumber function and ensuring the query is sorted by 'group'. But without data and a clearer understanding of the requirement, not prepared to spend time providing further example.
  6. C

    Typing in a text box

    So have a number of small text boxes or images which display a X which a user can drag and drop to the required position over the image. Or perhaps display a number instead so the use can relate to some numbered text. Depends how much detail is required as to whether it is a fixed list...
  7. C

    Typing in a text box

    What sort of text are you entering? An X at each damage point? Or words such as dent or scratches? What about tyre or wheel damage?
  8. C

    Incremental Sequential Numbering by Year via Calculated Field

    Did you try the app I uploaded?
  9. C

    Typing in a text box

    Without understanding the actual requirement you could investigate using a web control and generate html code to display the image and allow you to type on it. Don’t understand: Is this one textbox covering the entire image? Or multiple smaller textboxes? Once you have your typed over image -...
  10. C

    Interesting puzzler

    Hope they don’t nick your computer 😀 Without seeing the relevant code and properties of the relevant controls, difficult to suggest what the solution might be.
  11. C

    Typing in a text box

    not so far as I am aware. If you show (not describe) what you are trying to achieve, there may be an alternative way
  12. C

    Incremental Sequential Numbering by Year via Calculated Field

    No idea what you mean. Provide some data and the expected result from that data
  13. C

    Incremental Sequential Numbering by Year via Calculated Field

    So modify the dmax to have a criteria to identify the group. I'm not prepared to spend my time on something that is poorly defined without a clear understanding on why it is required.
  14. C

    Solved RefreshLink Code Takes Forever to Complete in Runtime

    Is the BE in the exact same location?
  15. C

    Can't get a report to show in print mode

    agreed - but your problem, based on the consistent size of your report rows, is the subform control. If you were to print the form, the subform control can use can grow/shrink. you can mimic the effect by calculating the required height. Not sure if it works with reports, you'll have to try it...
  16. C

    Incremental Sequential Numbering by Year via Calculated Field

    see attached. because this is an append query, it doesn't need to be more sophisticated than it is - only requirement is that a unique value from one row to the next is passed, if it isn't you will get a duplicate. So if your values are 1 2 3 3 4 you will get a duplicate rownumber on the...
  17. C

    Pop up forms not "stacking" in the right order

    put this into a module called say modMonitors in your popup form load event put placeform me This is intended to place the form where the bottom left is at the cursor position - but then adjusted if required to fit on the monitor if the cursor is too close to the top or right for the...
  18. C

    Incremental Sequential Numbering by Year via Calculated Field

    OP isn’t clear whether they are appending a single record or multiple records. If the latter you can use a row number function starting from a known position determined using dmax
  19. C

    Can't get a report to show in print mode

    Why are you using a report? Why not a form? And you appear to be showing 2 reports but you say ‘my report’ Best guess is you need to resize the subform controls
  20. C

    Pop up forms not "stacking" in the right order

    The problem as I understand it is that popups can appear behind another popup - it is not high enough up the z- order. Opening as modal guarantees it will be at the top. Setting it to false simply disables the ‘user restriction’ to that form until it is closed. The OP doesn’t want that restriction
Back
Top Bottom