Hi,
I'm using access and outlook 2003. I have a form in access that show product test information (test #, action, etc) using product ID as PK. what I need to accomplish is once, the test specialist creates a new test for a specific product, then the database creates an email to the manager with link to this database and open the form for that specific test.
I know how to create the email, but don't know how to link the database with form open for the specific test. Could someone please help me or at least point me out to the right direction?
Thank you so much.
8  7529  NeoPa 32,556
Expert Mod 16PB
What form will the link be in?
Where is the database relative to your PC and where is it relative to the manager's PC?
Any answer given without reference to this information is likely to be unhelpful and suspect.
I know this feature in Microsoft SharePoint, where you can actually link Access tables with SharePoint, and Sharepoint can send email with link of the specific record. User can directly click that link from outlook and they can see that specific record in detail. I can help you understand about this more, but pre-requisite is you should have MS SharePoint.
Hi Neopa,
sorry for the confusion, the database is in the server. It's only 1 database and it's shared for the test specialist and the manager.
and I would like the link to be in the outlook email. so for example if the test specialist created a product test for product Id 11 (using access form, testaction field, after update), then an email will be sent to the manager with a link that open the access form to that specific test. Can I do that in outlook?
Please help.
Thank you
Hi Narender,
Thank you for your quick reply, unfortunately, we don't use sharepoint. we only use ms office. Can I accomplish this project only by using access and outlook?
Thank you.
NeoPa 32,556
Expert Mod 16PB
I don't think if I told you how to send an email message to your manager with a link relative to "The server" that it would help you much. I need you to look at the questions again and give some thought to what possible answers would make sense before responding. I can help if you're confused, but I would have to understand your specific confusion first. So far I have as close to nothing to work with as makes no difference.
You may like to consider UNC type references which include addresses like "\\CoServer\DataShare\BobsDBs\YourDBName.Mdb". If this fits your situation then I need to know that, along with the specifics of the actual UNC address for your database. This is only a guess, as I have little to work with, but from the one clue you did drop I'm hoping it's some help.
Hi Neopa,
Thank you for your quick reply,
here is the code that I have so far (to avoid confusion) -
Private Sub TestAction_AfterUpdate()
-
Dim strMessage As String
-
Dim StrSubject As String
-
Dim email As String
-
StrSubject = "Test action has been entered/changed for the " & " productID " & Me.productid & " test No " & Me.testno
-
-
-
-
strMessage = "<HTML><Font Face = " & Chr(34) & "Arial" & Chr(34) & "><Font color = " & Chr(34) & "Black" & Chr(34) & "><Font Size = " & Chr(34) & "3" & Chr(34) & ">Test " & _
-
"Test action has been entered/changed for the " & " ProductID <b><i>" & Me.Productid & "</b></i> test No <b><i>" & Me.testno & ". </b><br><br></i> " & _
-
"Please follow this link to view the test action " & _
-
"<A href=""file://I:\producttest\producttest.mdb""><FONT face=Verdana size=3>producttest</FONT></A>" & _
-
"</Font Size></Font Color></Font></HTML>"
-
-
Dim appOutLook As Outlook.Application
-
Dim MailOutLook As Outlook.MailItem
-
Dim sbody As String
-
Set appOutLook = CreateObject("Outlook.Application")
-
Set MailOutLook = appOutLook.CreateItem(olMailItem)
-
-
Set appOutLook = CreateObject("Outlook.Application")
-
Set MailOutLook = appOutLook.CreateItem(olMailItem)
-
email2 = Me.mgremail
-
-
With MailOutLook
-
.To = email2
-
.Subject = StrSubject
-
.HTMLBody = strMessage
-
.Display
-
-
End With
-
End If
-
-
End Sub
-
This code is to open the access database and it worked fine. But what I need to do next is to add a parameter to the hyperlink that will open the form to the specific record which is the specific productid and testno that is mentioned on the email. can I do that?
Hi Bay
This is how I get email when I create/change a Record. From: Planning Team
Date: 08/04/11 17:51:35
To: Narender.Sagar@xyz....com
Subject: Requirement Details - Item ID1882
Planning Team - Item ID1882 has been created
Modify my alert settings | View Item ID1882 | View Requirement Details
(Above underlined are actually hyperlinks that I get, and You can click on this hyperlink to open that specific record ID.
Title:
Req_ID: 409.00
Requirement: 1,600.00
Committed Qty:
UOM: EA
Req Date:
Status: 0
Remarks:
Del-Date: 9/25/2011 12:00 AM Edited (I get this, If I edit this particular field, you know..:) its very nice.
Its really great, working jointly with MS Access and MS Sharepoint. I would say, think bit out of box and you can install free version of SharePoint (i.e. called SharePoint foundation server) - Of course you need some technical help to install it , but once that part is done, you'll get immense functionality of sharepoint that you can use in MS Access 2010.
Think again. (sorry if you feel annoying with word sharepoint again, but I thought I'll mention it once again, just because it can provide exactly that you are looking for and much more than that..!!)
NeoPa 32,556
Expert Mod 16PB NeoPa:
Any answer given without reference to this information is likely to be unhelpful and suspect.
As I said in my post #2 I cannot proceed, nor should anyone proceed, until you have provided the information requested. Without this information it is not possible to make suggestions that will help you.
I've posted everything I can think of to get these questions answered, but it seems there is still some confusion (as you seem to be trying to move forward without answering either question sensibly). I'm at a loss to know what further to say short of repeating myself yet again. I'll just have to leave it with you until you post something I can respond to.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: edself |
last post by:
I have a form which displays a subform datasheet of information. I'd like
to be able to quickly click on a particular record and open up another form
showing more detailed information about that...
|
by: fred14214 |
last post by:
Dear Group:
I have built and customized a form using the wizard to put command
buttons that will move to the NEXT record or PREVIOUS record. This
works, but it needs some refinement.
...
|
by: Chris |
last post by:
Hello all. I have a database that I use to send email updates to
people. Everything is working fine, but one suggestion I keep getting
is to add a link to the automatic emails that will open up the...
|
by: XxLicherxX |
last post by:
Hi,
Can someone tell me how I can open a form to a specific record from a
button on another form.
Here is what I want to have happen. I have one form called Computers
and another form called...
|
by: mstanley71 |
last post by:
Hi All,
I have a problem, I'm using Access 2002 SP3. and am trying to use a
button on each form to link back to a hyperlink on a table based on a
combo box selection on the same form record..ie...
|
by: Don Croner |
last post by:
I am using access 2003 with windows xp. I have created a data base for to keep track of my 180 employees. I have created a table with 21 records. Then I created a form to input employee data. I...
|
by: BD |
last post by:
I am coding with C# in Visual Studio 2005 for a database application
residing on remote MS SQL Server 2005. What I want to do is open the
same form but from 2 different places and only one...
|
by: menkenk |
last post by:
Good Afternoon,
I currently have an issue in trying to get a macro working for clicking a record in a subform datasheet to open a form with the complete record details of that specific record....
|
by: munkee |
last post by:
Is there a way to automatically have a web based data access page to start on a new record when you open the page? (Without going to data entry mode in page properties) If I go to data entry mode,...
|
by: JoeKid09 |
last post by:
Hi All,
Good morning! I am working on a form that is bound to a table with user’s name. I need to be able to go to specific record base on a text box value which contain user login name, if there...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
