maxvernon
Last Activity: Feb 26 '08, 06:22 PM
Joined: Feb 21 '08
Location:
-
add 3 more "End If" statements at line 35... -
did you put in four "End If" statements?Leave a comment:
-
make that four "End If" statements. Seems like you are assuming the VB "IF...ELSE...EN D IF" statement works like the Java "IF ELSE" statement which doesn't have an "END IF". In VB you must end each IF statement with a matching END IFLeave a comment:
-
without knowing exactly what the intention of the code is the compiler is telling you to add 3 "End If' statements just above line 68. for example:
67 End If
68 End if
69 End If
70 Proc_Exit ' This line used to be line 68
should do the trickLeave a comment:
-
SMTP code for VBA?
this is a followup post to the archived posting at SMTP code for VBA?
Assuming you want to send email from Access with your own completely customized message body, perhaps in HTML, perhaps in plain text, but you don't have or need Outlook and want a solution that is deployable to client machines without needing any third party components, then see the sample code at ** Link removed as per site rules **
This code also... -
I have just created a page detailing how to create an SMTP DLL which allows you to specify the entire body of the email as SMTP. In order to fully implement your report as the body you will need to do further research into compiling your data into an HTML page.
The SMTP DLL code is at ** Edit - Removed link to external code **
I hope this helps you out to some small degree...Leave a comment:
-
I will work on some sample code for you and get back to youLeave a comment:
-
Sending it the way you mention in your first post is the easiest by far. If you have no experience with .Net you are going to be in for more than you expected......Leave a comment:
-
good luck getting the result you want natively from Access. I send data from Access via email all the time for various purposes but have never been able to do it "the way I want" using Access by itself. More recently I have been building an HTML version of the report in code, then sending that as the body of an email using either the Redemption Outlook DLL or a DLL I wrote in VB.NET.
If you like I will put together some...Leave a comment:
-
you most likely placed the checkboxes inside a Frame in order to group them together logically. You really want to place them inside a Rectangle, not a frame. The Frame will allow only a single checkbox to be "checked" whereas the Rectangle will allow any, all, or none of the checkboxes to be checked at the same time.Leave a comment:
-
I have spent the last several days on this issue, and have come up with a relatively easy and simple to implement methodology for changing the color of a TabControl in Access 2003. I'm sure this probably works equally well in Access 2007 although I have not personally tested it. Granted, this solution is not a "native" Access solution, but instead makes use of the Rectangle control (as detailed in posts above) to trick the user into believing...Leave a comment:
-
Follow up to question about Tab Control colors
http://www.thescripts.com/forum/thread199041.html asks the question "Change background/tab colour of tabControl?". I've been working on this problem for 2 days and have come up with a nice, neat, simply way of doing this that takes almost no pain.
See ** Removed link to external code ** for a completely free piece of sample code on what to do.
The source code is for Access 2003 and includes a VB5 ActiveX...
No activity results to display
Leave a comment: