Recent content by VbPanicStation

?

I have written a program in VBA ACCESS which is meant to send out automated emails via outlook. The problem is that when ever I run the program, a pop up is displayed which reads 'A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected...

I have written a program in VBA ACCESS which is meant to send out automated emails via outlook. The problem is that when ever I run the program, a pop up is displayed which reads 'A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected...

.

Hi, Please help!!! I have not used ado connection strings and SQL statements before so I am really stuck. What I am trying to do is access some tables/ query within the same ACCESS 2003/ 2000 database using VBA and then use the data to send out an 'automatic' email. Questions: 1. How do I...

Hi, Please help!!! I have not used ado connection strings and SQL statements before so I am really stuck. What I am trying to do is access some tables/ query within the same ACCESS 2003/ 2000 database using VBA and then use the data to send out an 'automatic' email. Questions: 1. How do I...

Hi Fumei, Thanks for your notes. I agree with what you have said about the message boxes & was going to remove them once the code was complete - left them in there only for 'testing' purposes - I wanted to make sure that the code was doing what I wanted it to. Good idea about...

Help please!

Hello again, I wonder if you can help. With your help - I have been able to compile code which does most of the things that I'd like it to do namely: 1. List all items of a specific directory in a list box 2. Enable user to multi-select items - using a mouse 3. Using a button...

Hi PHV - what I meant to say is that the .additem property is NOT displayed in my list methods/ properties. Not sure if there is somewhere where I need to select relevant references or not

Thanks PHV - I am using VBA/ Access 2000. When I type List1. & the list of methods/ properties is displayed - .additem is displayed. Is this because Is this because the relevant reference has not selected (as in tools/ references on the defaul menu)? If so, what is the reference name?

I'm stuck - please help!

Hi - thanks for the info about the Dir function. I have been looking on the net for VBA code I could modify to suit & have come accross the one below. It works fine except that I can not get it to display in a list box. Listing the contents of a folder in a list box will enable me to select...

Hi all, I'm new to programming - using VBA in access 2000. Hoping someone can help me. What the problem is: I have got three folders - temporary, master & archive folders. All folders have got files in them. What I'd like to do is for the code to move all the files from the temporary...

VBSlammer, m1kee - Thanks for your contributions. I really do appreciate it Another thing I am considering in the upgrade of my database is to redevelop it as an internet based application (internet form front end & access 2000 database) - that way anyone with an internet connection can access...