• ** 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/

Search results

  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.
  16. RainLover

    Inventory Control, Location Table

    Thanks Guys.
  17. RainLover

    Inventory Control, Location Table

    The attached is a sample based upon Allen Browne.
  18. RainLover

    Continuing Adventures of Pepper

    I just tried to read this post from beginning to end. I did not make it. The only thing I can say is that I am an idiot. Bet I don't get many arguments over that. Good Night.
  19. RainLover

    Access 2000 Issue Table Deleting Data

    Not sure what this means when you say a record drops off. How does the user gain access to the Table, Query or whatever it is that allows them to delete or add a record. Have you got any further information that may help.
  20. RainLover

    Inventory Control, Location Table

    mjdemaris Can we define the problem a little better. If so are you satisfied that you can write an Inventory Control database then is your problem simply that you want a simple to use method that would give all locations their own identification that is not only unique but is also simple...
Top Bottom