Recent content by Diamond-Leopard

  1. D

    Import From Website

    So I have looked online and this doesnt seem to be something which is already set up within access so I ask the Gurus or Access found on this forum for a little guidance. Lets say I have a url which holds all the sales I have made and I want to import all of that data into a table on access...
  2. D

    Display an Image using its online URL

    So I have an inventory of about 10,000 Items and all of the images for these items are online and I have a list of URLS which show the image. I have a form and when I type in the Item Number I currently have it set to populate lots of text boxes with infomation such as Item Name, Item Cost...
  3. D

    Working Days Calculated

    Now that this is working I wonder if someone could suggest an edit? I would like this not to count the start date if the start date is a week day? Could someone show me how I would edit this code so that if the start date is a weekday It will exclude it? and start on the next working day?
  4. D

    Working Days Calculated

    AHHHHHH so it was txtAnswer = work-days(txtStart,txtEnd) As Integer Thank you everyone x
  5. D

    Working Days Calculated

    Thank you everyone for your help so far, I am struggling on and I feel like I might be getting there. Here is what I have found. It seems really simple but I cant get it to work. Function Work_Days(BegDate As Variant, EndDate As Variant) As Integer Dim WholeWeeks As Variant Dim DateCnt As...
  6. D

    Working Days Calculated

    Thank you for your incredibly helpful post suggesting that I engage a consultant , to be clear on what I am after here. I don't want to set up a holiday Inclusion. I just want Mon-Fri.
  7. D

    Working Days Calculated

    So I am guessing this code needs to go in a button click event? I tried that and I am guessing there are parts of the code that I need to change but I really cant work it out. Could you please just give me a clue as to what I should do with this code when I have moved it into my click event?
  8. D

    Working Days Calculated

    So I have looked through all of them and they have various codes to enter but the problem is im much stupider then you give me credit for... I'm not sure what I need to do with this code... I googled it and someone mentioned something about setting up a modual and then I guess you refer to the...
  9. D

    Working Days Calculated

    Hello Again My Wonderful Friends.... Here is todays problem :D I have a field named "Date Ordered" and I have another field named "Date Delivered" and what I would like is a calculated field called "Working Days Taken To Deliver" So as the name suggests I am looking an expression that I can...
  10. D

    Sales Report

    Ive got it, that worked. thanks again guys!
  11. D

    Sales Report

    That's great thank you, So I now have a totals query and it tells me the profit I have made each day... what I would like now is to do some maths with the results... A simple example is if each day to run it costs me £40. My Current Query Does this Date - Sales - Profit 19/11/2018 - 16...
  12. D

    Sales Report

    Thank you very much, I am reading that link now :D
  13. D

    Sales Report

    I have a table and it contains all the sales I have ever made, it has information like sales_date, Order_Profit, Customer_Name etc... I would like a button on a form which when pressed displays how many sales and how much profit I have made on each day... So I would like it to look like this...
  14. D

    Corrupted database, can't edit properties

    Never forget what you are, for surely the world will not. Make it your strength. Then it can never be your weakness. Armour yourself in it, and it will never be used to hurt you. Hope that helps :)
  15. D

    Run Query In

    I did it, It worked perfectly! You are truly a god to me :D Thank you very much
Top Bottom