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

  1. B

    Property Problem

    Try it out, its nice on these eyes through longer durations and helps me process what I'm seeing more easily.
  2. B

    Property Problem

    Im dumb, I figured it out. There is no return datatype on the gets! I've done this right on many other classes, but for some reason, this one is the one to absorb all of my Monday dumbness! Hahaha
  3. B

    Property Problem

    Hello, I am building some classes, and I have run into a problem that I don't understand. The compile errors out on the Private Property Let Description line. If anyone could point out what the problem is, I would be extremely grateful! =] Kindest Regards, Daniel
  4. B

    [Sub] CreateDirectories - Approve Or Improve Please

    Thanks again for the guidance! Just came back for the function, thought I'd give a thanks. =]
  5. B

    Set field to Null instead of zero length string

    If Len(txtBox.Value & vbNullString) > 0 Then
  6. B

    Material Controller - Piping/Mechanical (Oil & Gas/Powe Plant/Petrochem) We kind of have the...

    Material Controller - Piping/Mechanical (Oil & Gas/Powe Plant/Petrochem) We kind of have the same jobs... ish.
  7. B

    Design Help Required For: ConvertNumberToDefinition Function

    I have it working, I just was wondering if anyone knew of a formula that would be as minimized as the first function's formula. Rather than looping to the highest known factor of the definition length.
  8. B

    Design Help Required For: ConvertNumberToDefinition Function

    Its more or less defining a custom set of characters that hold values with respect to their position in the definition. Which follows the same design as what we use today, its just not commonly thought of in that way. 1 is a character and can contain any value that we think of it containing...
  9. B

    Design Help Required For: ConvertNumberToDefinition Function

    This is for all common, and custom base numbering systems. A numbering system can be define by placing each of its characters into a string in order from value 0 to Max. "01" Binary "01234567" Octal "0123456789" Dec "0123456789ABCDEF" Hex "!@#$%^&*()ABCDEFGHIJKLMNOP0123456789" Custom
  10. B

    Is it worth working?

    You can become a hell of a lot more of a "human being", a dynamic conversation simplified for now, if you choose to tackle life in the environment of the real world. Being pampered by your country's tax money, in my eyes, can be a life limiting experience that stumps and/or limits your growth as...
  11. B

    Design Help Required For: ConvertNumberToDefinition Function

    Hello There, Sometime in the past year, I posted a function that converted non-decimal based string values. Like HEX "0123456789ABCDEF" and/or any other numbering definition you can think of. I have recently come across another application that requires a custom format of numbering. Bringing...
  12. B

    Syntax error

    You could always make a public function within a module that acts as an interface between VBA and the database engine... Idk what kind of flags that raises for anyone, or if it causes huge performance issues, but yeah...
  13. B

    How to create .HTMLBody tables for Outlook Email

    Also to save room, you may be able to use this within your header tags: .HTMLBody = "<HTML><head><style> th, td { text-align: left;}</style></head><BODY STYLE=......" etc
  14. B

    How to create .HTMLBody tables for Outlook Email

    try <th style="text-align: left;"> Some html parsers don't like when you don't finish with ;
  15. B

    Help wanted, relations between tables

    Without having the time to look through your previous suggestions. I noticed that you're attaching linking primary-keys to primary-keys. Be sure to create a foreign key within a table when trying to relate to another table. [ID] is a commonly accepted naming convention for a foreign key in a...
Top Bottom