Recent content by sammers101

Not sure what the best way would be to do it. All of these options work during runtime? As far as the loop I am sending an email to each customer with a list of comics they are receiving. Then I go to the next customer and do it again, for each customer.

Is it possible with CBO to reference a report or a form with something like the following? .TextBody = "customerComics" Currently I am attaching my report as an attachment but I would prefer to have it in the actual email instead. I'm using runtime access. I was also having problems adding a...

I used the same settings server: smtp.gmail.com port: 465, authentication: basic, SSL: yes I just had to allow less secure apps https://myaccount.google.com/lesssecureapps https://support.google.com/accounts/answer/6010255?hl=en#zippy=%2Cif-less-secure-app-access-is-on-for-your-account We're not...

Works Awesome! I didn't see a setting to allow less secure apps with my website's email server but I was able to get gmail to work. Only minor issue is before it would use whatever the default email was (I had two different ones) and now I'll have to code that in, but the alternative was buying...

that could work if I could figure out the server settings. I tried a few things, I was thinking it should be: server: smtp.gmail.com port: 465, authentication: basic, SSL: yes

Makes sense. Is there another way I can send an email at runtime? I would be open to using outlook. I'm using thunderbird currently because I had a hard time getting outlook to work with gmail.

Tried to make a test database and it still has the error with no spaces in the names

When using runtime access (tried 2013 and 2016) I am getting an "SendObject isn't available right now" error. I have no problems with it when using the full version of Access. I'm using thunderbird. Maybe there is another code I can use or a way to get it to work? Some forums suggested...

I used that before and switched to ShellToFile Me.link for some reason (can't remember now), but that appears to be working. Thanks

I'm getting a compile error. I was trying to use ShellToFile for links in a table. Is there another way that allows users to click links that are part of a list? Some items in the list have a link, others do not. They are different links. I was using this code: Private Sub cmdOpen_Click()...

that seems to work perfectly. I will try that out thanks :)

I do not have a msgboxx function, I was copying the code Microsoft had on their website, it appears they have a typo. I found the error, I was trying to use ShellToFile for links in a to do list. Is there another way that allows users to click links that are part of a list? Some items in the...

Removing the extra x worked. I had copied what MS had *eye roll* https://docs.microsoft.com/en-us/office/troubleshoot/access/error-saving-database Now to see what the actual error was...

Did I do something wrong with the module code? Option Compare Database Option Explicit Sub Generate_Compile_Error() MsgBoxx "This will cause an error" End Sub

I've deleted all the forms and reports to try to narrow it down and still getting the same issue. Very odd, only thing left is a brand new form named start, local tables, and a module with the code Sub Generate_Compile_Error() MsgBoxx "This will cause an error" End Sub I'm thinking I will try to...