• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by RainLover

  1. RainLover

    Count Down Clock

    Bob Sorry I did not understand. I will have a look.
  2. RainLover

    Count Down Clock

    ypma That was long ago. Do you want me to check on something for you. US is the normal format that one should use. How and where did you pick up a problem. I Think yhere is more to this than meets the eye. Also check Allen Brownes site, there is more to learn there. Does someone want to...
  3. RainLover

    Inventory Control, Location Table

    Why do you need to limit. A lot can change in the next year or so.
  4. RainLover

    Inventory Control, Location Table

    Why do you not answer my questions as asked. Is there a problem?
  5. RainLover

    Access not using date properly

    I believe the Allen Browne site has some good examples of formatting Dates. Just for future reference.
  6. RainLover

    Inventory Control, Location Table

    I posted a copy of Allen Browne's Database. Why are you not using that. I do not understand your design I cannot help other that what I have given already
  7. RainLover

    Inventory Control, Location Table

    What is this DSum for? I think you need to post a copy of your Database. What is the final result that you want. Is it the actual profit made or is it the average profit or is it something else. Please explain the best you can.
  8. RainLover

    Inventory Control, Location Table

    I can't see what the problem is now. Why do you need to enter new prices every day. Why do they change on a daily basis. What product are you dealing with.
  9. RainLover

    Inventory Control, Location Table

    If you use a Main form where you enter the Date and Stocktake. In the Sub form link the two together via the Parent Child fields. From here on as you enter a record into the Sub Form the Date and Stocktake get entered automatically. Do you understand? If not I will have to adjust the...
  10. RainLover

    Inventory Control, Location Table

    Too hard to say when my knowledge is limited. You can default today's date but other than that I don't see any more. What specific problem do you have.
  11. RainLover

    Inventory Control, Location Table

    The simple answer is that they are different so store them differently. I would think that you could come up with reasons to combine the tables but that simply creates surplus code. Do you have something special on your mind other than what others are telling you.
  12. RainLover

    Is Microsoft Access a 'proper' database?

    No I haven't. I am semi retired so what I can't do in 2003 or 2007 does not have any real interest to me.
  13. RainLover

    Tax

    Please explain
  14. RainLover

    This time goodbye is for good

    Bob Thanks for all the help. You will be missed by many especially the new comers. Best wishes in your new undertakings. Rain Lover from down under.
  15. RainLover

    Tax

    A point of interest. The Sum of the Tax on each order does not necessarily balance. It may be Dollars out. This is simply written off. If you notice GST the Tax department always rounds this off to the nearest dollar.
Top Bottom