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...
...a dynamic array variable, declare its initial size
Dim DirectoryListArray() As String
ReDim DirectoryListArray(1000)
sFileDest = "C:\folderone\*.*"
'Loop through all the files in the directory by using Dir$ function
MyDir = Dir$(sFileDest, vbDirectory)
Do While sFileDest <> ""...
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?
...array variable, declare its initial size
Dim DirectoryListArray() As String
ReDim DirectoryListArray(1000)
sFileDest = "C:\ScannedClientDocs\*.*"
'Loop through all the files in the directory by using Dir$ function
MyDir = Dir$(sFileDest, vbDirectory)
Do While sFileDest <> ""...
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...
I've noticed that there are different 'packages' that one can buy e.g Standard, Enterprise, professional, architect. Seeing that I'd like use VB.net mainly for the development of database applications - which one should I buy? The standard version is the cheapest but someone told me that it may...
Thanks you two! Please tell me something, having started a project in VB6 and having created forms including controls and some code - would one be able to import/ export this into VB.NET and then carry on working in VB.NET?
This is more of a general one. I have developed a database in VBA/ Access 2000 (thanks to a few people on here who gave me some useful tips). It works fine but I'd like to upgrade it to include new features and also enhance existing ones. Eventually, I would like to link it to excel, word...
Hi all,
I hope that you can help me. I've only just started programming and I am struggling.
I have modified the code below (that I copied out of a VBA Book) to send one email per record in a query. Now I would like to modify it again such that it send one email to all the people...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.