Search results

This should do it Dim rsEmail As DAO.Recordset Dim strEmail As String Dim strBody As String Dim strSubject As String Dim strContact As String Set rsEmail = CurrentDb.OpenRecordset("QrySendEmails") Do While Not rsEmail.EOF strEmail = rsEmail.Fields("Email").Value strBody =...

You can do email with a macro using the SendOject but doing it this way can have unpredictable results. Here are two different samples using VBA code that should get you started: Email Report! Send email

What exactly are you going to do with the database? Are you just gathering form information or do you plan on storing data that neeeds to be secured?

I bought Sams Teach Yourself Visual Basic .Net 2003 on clearance at Barnes & Nobles for $7.95 and it came with a 60 Trial demo of Visual Studio 7 (.Net)

Yes and more. Although, many use them together. VB (.Net) as the front end and Access as the data store or back end. It is a great way to make stand alone "Access" applications.

I started using ASP.Net early on when the framework was still in beta and fell in love with it instantly. There is a lot more to know then there was with classic ASP but once you get the hang of things the effort it takes to learn new things pays off instantly. I just received the VB.Net IDE...

Aziz, if you are just getting started with VB and want a long future with it. I would recommend that you start with VB.Net now. It is more OOP then was VB 6 and is the direction that MS is heading with all its development tools including those for the new Office (at least that is the rumor I heard).

I think this is what you want to do, assuming you don't need to loop through a list of email that is. Add this to the top of the code: Dim strEmail As String strEmail = Me.txtEmail ' txtbox that holds the email address ' ..........Some Code Here.......................... ' ..........Some...

If you are serious about putting a database on the web I would skip DAP and start learning ASP.Net. From what I understand DAP is ok for basic viewing and editing but not much more. With ASP.Net you can achieve most everything you can do in an Access form. Having said that, the learning curve...

I have never used DAP so I don't know ig you are able to set the path yourself. If so, then modify the path to use the URL and just to be sure you may want to use a complete URL like this: http://yoursite.com/images/image1.gif Just make sure the files are located in a folder that the...

By the way the option to turn off error reporting is under the System applet in the control panel. Select the advanced tab and choose error reporting. Once that is opend up you can disable the "feature" there. I give this reply one thumb up. :D

This is a cut and paste from another thread I responded to a long time ago. While this will not teach you VBA it is a good way to get to know the syntax. It also allows you to instantly create VBA from already made macros. --- begin cut and paste --- One trick that you can use to help you with...

Gotcha I misunderstood exactly what you wanted to do the first time. Hopefuly someone will come up with an idea on this soon but in the meantime I will see if I can dig up something for you over the weekend.

If you are in an environment that has a server or at the very leas a workstation with an available share you can do so. The syntax would look something like this: \\ServerName\ShareName\FolderName

I am not sure where you are at with the email thing but did you get the Dlookup sorted out?

Ok lets start with this. Say you have four fields in your table like this. name - (text) email - (text) send - (yes/no) problem - (text) For the sake of this thread we will assume your table is called TableName and that you want to use a command button to trigger the app. After you have it...

No problem. I am glad it is going to work out for you. FYI I am not sure whether you noticed or not but I did not use the BrowseFolder module at all in my solution. I used the GetFile one noted on the post above.

Attachment included

This should do the trick. Look for a form that says "BucksForm" open that and press the button. You should get an open dialog box. Just pick your file and it should be inserted right into Outlook as an attachment. The Module used to spark the Open Dialog is from here: Call the standard Windows...

Why is the mail returned? Is it just a case of users entering bad emial addresses? If so you may want to consider having them enter the email twice or using an email confirmation routine that won't add them to the Send To list until the email address has been confirmed as a good one.