Search results

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 😥😥😭

Is on default at 255 :(

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

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...

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 '------------------------------------------------------------ '...

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.

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

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

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

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...

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...

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. 😬☺

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...

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

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

I see what you are saying but the emails created from Access will be automated to be sent every Friday's as soon I finish this. So I won't be able to change the value manually.

What I don't get is how I create the table template on Outlook and can use it on Access so I be able to add the values shown on the Access email template above. How do I generate that table from Access and send it to Outlook looking like the Sketch I did few posts above.

Yeah I did read some like that but this language is way too advance for me. I dont know how to do that. I just read that is possible doing it this way :cry:

Is there an easy way to convert an html file into VBA? I made a table in Outlook the way I want it to be when sending the report and saved the email as HTML . Can I use that format and apply that table in VBA? Not sure if is my language barrier but man my searches seen not to find any of my...