Search results

  1. M

    Import rows and columns from excel

    Sorry no Each spreedsheet had different data once it was added in would have been messy sorting it out thanks mick
  2. M

    Import rows and columns from excel

    Didn't know I could do that very interestings but, no As I said I needed to add data which had to be done during the import as in this case I had just under 10,000 entries from 330 spredsheets I got it working as it was a one off I'm not worring about the code as it worked lol. Many thanks mick
  3. M

    Import rows and columns from excel

    I've found a workaround It seems its only looping through the rows fro the number of columns so changed the code as I only want th last 25 rows Sub AllExcelFilesInFolder() Dim wb As Workbook Dim myPath As String Dim myFile As String, StrExtShort As String Dim myExtension As String Dim R As...
  4. M

    Import rows and columns from excel

    Just noticed I had this in wrong place i = 77 but still only getting 6 rows
  5. M

    Import rows and columns from excel

    I have 330 excel sheets I need to import rows 77-101 and columm A,B,F,G,H I have it working upto a point IE. It wont move to next excel row. I have to do it with the code below as I will be adding a date to each entry in db which is part of the filename which is not a problem. Sub...
  6. M

    Query To Count Levels

    Thanks.
  7. M

    Query To Count Levels

    I do remember getting an answer to this a few years but can't find the post as at the time didn't need to use as had a code solution but am starting something new an would like to use the query. I have a totals query that returns Total 5 4 3 3 2 2 2 1 1 1 This would normally give an output like...
  8. M

    The Covid cure has arrived!

    I just had the pfizer jab now I'm waiting to see it turns me into a normal human being
  9. M

    Hello everyone from Iraq

    Hi Shamal Welcome Aboard!
  10. M

    Colour Output for forums

    last test thanks Adam Ant - What's Going On Alison Moyet - Love Resurrection Andra Day - Rise Up Big Brother and The Holding Company - Piece Of My Heart Billy Ocean - Red Light Spells Danger Billy Squier - On Your Own Bonnie Tyler - Faster Than the Speed of Night Bonnie Tyler - Here She Comes...
  11. M

    Colour Output for forums

    I'm working on a posting system for Apollo I have it working on my forums And vBulletin but needed to test with Xenforo I.E. this site lol The output below seems to work just like VBulletin wich is good for me lol Test list from 21/12/2020 design version data Adam Ant - What's Going On Alison...
  12. M

    Solved Listbox Vertical Slider issues

    Thanks It's one of the styles from my style manager and all the buttons where custom built for me
  13. M

    Coding for 50+ years

    Hi welcome aboard
  14. M

    What is this...?

    Your supposed to lay flat on your back waving your arms up and down while opening and closing your legs.
  15. M

    Controlling Unauthorized Distribution of Database

    My System allows them to register there copy but doesn't force them too.
  16. M

    Controlling Unauthorized Distribution of Database

    As a though I would only need visit my sites templates /examples job done lol
  17. M

    Controlling Unauthorized Distribution of Database

    You would be suprised what I could put together just from what I've found on the net
  18. M

    Controlling Unauthorized Distribution of Database

    I've been at it over 20 years and still wouldn't feel right about selling my programs even though most of the work is mine I'm just in this as always wanted a job working with access but now i'm an old fart I stand little chance lol
  19. M

    Delete backup database

    You could give each file a name that included a formated date and or time of the backup should be quite simple to find then
  20. M

    Controlling Unauthorized Distribution of Database

    I agree with @CJ_London you shouldn't start selling systems until you can develope them from start to finish we all use code from the web but if thats all your db contains then freeware. I could even host the file but wouldn't allow it if I thought you had just stuck a load of code you found...
Top Bottom