Search results

  1. G

    Tags - yay or nay?

    I don't really like what they did with all the tags on that forum. Ugly and doesn't match the rest of the design... Not exactly what your idea is. But as long as it doesn't add 80's style rectangles I am fine with it :)
  2. G

    Name 5 things that really annoy you

    People using unordered lists to sum a top 5 list (and not using the correct BB code) Drivers who don't uses their turn signals Using religion as a personal excuse Fake media Mosquito's
  3. G

    Coronavirus - are we all doomed?

    As long as China does not reveal the actual extend of this epidemic, it is hard to say. Here in Belgium they tell us that we are prepared... How can they be prepared ? Do they have a working anti virus ? Why don't they share info and help all those people in China ?
  4. G

    Service Unavailable

    Glad you got the forum back up and running :D Awesome work !!!
  5. G

    Service Unavailable

    Well there is/was one user I believe is capable of doing this... Hope it will be resolved soon !!
  6. G

    Import single Cells from excel

    Why can't you just link Access to the Excel sheet ? https://support.office.com/en-us/article/import-or-link-to-data-in-an-excel-workbook-a1952878-7c58-47b1-893d-e084913cc958 You can have 1 table that is in sync with the excel or if you don't want a link, create the table once then append the...
  7. G

    PC vs mac

    No matter how many friends offers to test an Apple product, I will never buy one. I don't deny some are great devices, fast and reliable... But the cost and no way to fix simple basic stuff is a big minus. I can't get used to the OS. If you take care of windows, it will last a long time. I have...
  8. G

    Life after VBA

    My two cents on "giving good chances int the new world" is your ability to adapt and how quick you can learn a new language. Here we learned Java and .net... My first job was in Dataflex, now programming mainly in x++ (around September it will be c#). Still creating small programs like nfc...
  9. G

    Thanks and Like

    Am i seeing a trend in all the posts of vba_php ? I think it is a great idea of a like button. I would hit that button more often than the thank you one. It feels like some personal button and sometimes I hesitate. I like the solution, but will not use it personally so giving a thanks for it is...
  10. G

    Hello

    Welcome and have fun building the tools needed :)
  11. G

    Dates Confusion in VBA

    My guess is that Date() will display the date in dd/mm/yyyy. But when comparing it will use the internal date format. (See the post in here : https://techcommunity.microsoft.com/t5/access/formatting-date-where-you-don-t-live-in-usa/m-p/255436 )
  12. G

    Hi from Switzerland

    Welcome Moritz !!
  13. G

    NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

    Education systems may differ from country to country. But when there are strikes, it is all the same. I see it now in Belgium. Teachers are angry because they must work harder... I had the luck to live in France. 20 years ago, the french teachers were angry. And guess why ? exactly the same...
  14. G

    Canada - a nation crashing with No Survivors & Britain Abolishes Itself

    This is not only a thing in London. I live in Belgium and I feel the same. I am not racist, those people are running from war (strange that the majority are only men) But the impact is great in some towns. Houses are in decay, theft rate is going up (from bicycles to restaurants)...
  15. G

    NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

    Maybe some of us want to see the beauty of the earth each morning when we look to the sky :p
  16. G

    Calculating Working Hours with Lunch Breaks

    I know the solution was already made, but this was the reason why I asked him to make a new thread. The code was made with conversion because the user asked for it. The time was formatted in hours : minutes He also had a holiday table.
  17. G

    Calculating Total Work Hours Between Two DateTime Fields

    The code is based on a x hour day. So if you have less, then change it to less. Also note that what you ask is a little different. I made this with the following in mind : "(work hours are 08:00:00 AM to 17:00:00 PM each day)" So 5 days a week same hours. You will have to change it to add only...
  18. G

    How to take all data from a column in query, and show in one form field

    Maybe this does the trick : SELECT staging_t.container_ID, ConcatRelated("container_ID","staging_t","staging_t.ordernumber Is Null") AS Expr1 FROM staging_t WHERE (((staging_t.ordernumber) Is Null)); That will concat all the container_ID from the staging table where ordernumber is null.
  19. G

    Hello from Italy!

    Welcome on this amazing forum :)
  20. G

    Calculating Total Work Hours Between Two DateTime Fields

    The code was made 3 years ago. I just started to learn access stuff... It needs indeed some extra work to make it pretty and more generic. The code was for a specific need of the person who asked for it. I will try a more elegant solution for you... Basically you need to add an extra condition...
Back
Top Bottom