Almost There...
Hey,
Just an update on my status, I am slowly getting through this issue, i think I'm about halfway through. When I finish Ill post it up for others to view.
Thanks
Raven7738
Last Activity: Aug 6 '10, 06:15 PM
Joined: Jun 29 '10
Location: Pennsylvannia
-
Can I write a shell code in Access 2007?
Hey,
I have an autoexec macro in my program. When the frontend of the program opens up, I want the macro to run a module to check the local drive (C:) for the same program. If the program is in the C: drive, I want the open program to overwrite the original program. If not, I want it to save a new copy in the C: drive. I also would like this to happen without the user being asked where to save or what to call it.
... -
Thank you guys for the help!Leave a comment:
-
I have done a test run with a split database but the results automatically constantly update the backend which is why I am trying to do this. Unless there is another way to only allow it to update when the program is closed.Leave a comment:
-
How to create a temp table?
Hey,
So I currently have an access program which I am going to split to allow mutiple users to use it. However, reguarding one of my previous posts, I have made it so people can check checkboxes and select an option that allows them to send an email to those selected people. When the checkboxes are selected by one person, those marked checkboxes appear on another person's database which I don't want to happen.
I figure... -
The password is no longer needed. Originally I had it so that the user had to manually log in, so the password was only so others couldn't edit others information. Now the code pulls the username from the already logged in user and filters information from the database using that information. The username is output into a hidden text field (txtUser) which a query uses as a filter....Leave a comment:
-
My final solution:
...Code:Private Declare Function WNetGetUser Lib "mpr.dll" _ Alias "WNetGetUserA" (ByVal lpName As String, ByVal sUser As String, lpnLength As Long) As Long Private Sub Form_Load() Const lpnLength As Integer = 255 Dim status As Integer Dim lpName, sUser As String Dim Edt As String sUser = Space$(lpnLength
Leave a comment:
-
How can you run a Query using Active Directory values?
Hey,
So I originally had a form asking for an ID and password. A query would take those two values and pull up information in a database that contained both those values. I need to change this so that instead of a user putting in this information, the query will look up both of these values in the active directory and pull up information on the user.
Any ideas of how I might go about this?
I am using... -
I figured out the issue. In the program I am doing, I created a query that pulls a value from a search form and comes up with a list of results based on that value. The parameter it was searching for was that value put in that control which for some reason its wouldn't pull.
Thank you for your input....Leave a comment:
-
Alright, I figured it out. For those who might find this as a reference, this is my final code:
...Code:Private Sub btnEmail_Click() 'Declare Values Dim rst As DAO.Recordset Dim ol As Outlook.Application Dim inbox As Folder Dim msg As MailItem Dim rcp As Recipient Dim Eml As String Dim EmlTo As String 'Create New Mail Item Set ol = GetObject("",Leave a comment:
-
If don't put in the commas I get an error saying too few parameters.
Adding parameters (e.g. .OpenRecordset (1,1,3)) Tells me that the database engine could not find '#Temporary QueryDef#'.
What should I do from here?...Leave a comment:
-
Ive taken it away but I still come up with the same issue...Leave a comment:
-
I spelled Current wrong haha...
But now more roadblocks:
...Code:Private Sub btnEmail_Click() 'Declare Values Dim rst As Recordset Dim qdf As QueryDef Dim ol As Outlook.Application Dim inbox As Folder Dim msg As MailItem Dim rcp As Recipient Dim EmlTo As String 'Create New Mail Item Set ol = CreateObject("outlook.application")Leave a comment:
-
I have changed my code to this:
...Code:Private Sub btnEmail_Click() Public rst As Recordset Public qdf As QueryDef Dim ol As Outlook.Application Dim inbox As Folder Dim msg As MailItem Dim rcp As Recipient Dim EmlTo As String Set ol = CreateObject("outlook.application") Set inbox = ol.Session.GetDefaultFolder(olFolderInbox) Set msg = ol.CreateItem(olMailItem)Leave a comment:
-
How to select values using a loop
Hey,
I'm using Access 2007. I have a code to open a new message in outlook 2007.
...Code:Private Sub btnEmail_Click() Dim ol As Outlook.Application Dim inbox As Folder Dim msg As MailItem Dim rcp As Recipient Set ol = CreateObject("outlook.application") Set inbox = ol.Session.GetDefaultFolder(olFolderInbox) Set msg = ol.CreateItem(olMailItem) -
Raven7738 replied to How can I make a Yes/No column to select email addresses to add to a new message?in AccessThank you for your help...Leave a comment:
-
Raven7738 replied to How can I make a Yes/No column to select email addresses to add to a new message?in AccessI looked into the mailto: syntax and came up with SendObject function in macro. I am currently researching the set filters you mentioned, but is there a code that may allow me to take those filters and put it into a macro argument such as the "To" argument in SendObject?
From there I can just have the macro run to edit messageLeave a comment:
-
Raven7738 replied to How can I make a Yes/No column to select email addresses to add to a new message?in AccessI am currently using Windows XP Professional OS and Outlook 2007...Leave a comment:
-
Raven7738 started a topic How can I make a Yes/No column to select email addresses to add to a new message?in AccessHow can I make a Yes/No column to select email addresses to add to a new message?
Hey,
I'm currently using Access 2007. I've created a form that shows a list of search results in a subform. I want the user to be able to select specific people from the list and press a button to input all the selected addresses into the "To..." box in a new outlook email.
The database has email addresses in a column already. I was curious if it was possible to create an new "yes/no" column...
No activity results to display
Leave a comment: