Recent content by TecknoFreak

  1. T

    sequential alphanumeric order numbers

    Currently I only have 10255 records. But the ConfigNo is stuck at 10000. Every record auto populate the ConfigNo to the latest ConfigNo used +1 but is not working 😥😥😭
  2. T

    sequential alphanumeric order numbers

    Is on default at 255 :(
  3. T

    sequential alphanumeric order numbers

    I did because I searched the entire forum for my problem and this is exactly my problem.
  4. T

    sequential alphanumeric order numbers

    Hello DC, I have this exact problem. How you exactly do that in green to be able for the Prefixed to go beyond 9999? Is that done from the table itself or can it be done from the form? Sorry Im learning still VBA :( 🙏🙏🙏 This is my code...
  5. T

    sequential alphanumeric order numbers

    Hello guys, Sorry for asking in an old thread but this is basically the problem I have Based on that line above (d). Is there a fix for this? I got this going on as I auto populate that ConfigNo based on another box selection '------------------------------------------------------------ '...
  6. T

    Solved Function is not available in expressions in table-level validation expression.

    Thank you all for your input and tips. I was able to figured it out. The problem was caused by having an Acrobat library selected that others didnt had on their machine.
  7. T

    Solved Function is not available in expressions in table-level validation expression.

    *Is larger than allow here even zipped. Will have to upload it into Drive and share it that way in the morning
  8. T

    Solved Function is not available in expressions in table-level validation expression.

    I'm not even sure what table level validation this is. o_O How do I check that? Is super Weird. I have restarted and done everything possible to see why I cant generate the same error they all get on their side. I open it is perfect, they open it and they all get that error
  9. T

    Solved Function is not available in expressions in table-level validation expression.

    Just want to add I dont have that problem on my machine but everyone else does
  10. T

    Solved Function is not available in expressions in table-level validation expression.

    Hello everyone, "I'm sorry if this is the wrong section to make this thread". I have a problem where I made a linked .accde file for me to share with my team but they cant open it. They get a popup like attached below. I honestly have no clue of that this mean or what I need to share here to...
  11. T

    Hiding HTMLBody table rows if values are 0

    Hello guys, So I created a Report that generates an HTML table and send on Outlook while populating values from a Form. My question is; Is it possible to hide a Row if a Value on any Column is 0? 'Generate email here With oEmail .Display .To = "jeff.1@gmail.com...
  12. T

    Solved Email .HTMLBody to include totals from other Modules or Queries?

    Yeah is a bit of more info in the code. The goal was the table so thats why I just screenshot the table and not the entire email sorry. 😬☺
  13. T

    Solved Email .HTMLBody to include totals from other Modules or Queries?

    OK, thanks to all the people that helped me here and also all the people in this forum to keep so much valuable information for others to reach and learn from it I was able to figure out the html table in the email report. I will share my results below The body looks like this and here is...
  14. T

    Solved Email .HTMLBody to include totals from other Modules or Queries?

    I will give it a shot. Looks amazing 👏 I will post my final results here when done Thanks so much mate ❤
  15. T

    Solved Email .HTMLBody to include totals from other Modules or Queries?

    What I was asking is if there is a way to format this in VBA as html like I'm doing. Just doing it as tables like the sketch I did above
See more
Top Bottom