By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

is Access 2003 going to do the Job?

P: 2
Hi

A few years ago I worked in a CRM company and gained a lot of experience with a proprietary database system. I am familiar with database normalization and setting up table relationships. I am pretty new to Access and have a couple of questions relating to a favor I am doing for a friend- Setting up a contact database for his recruitment company. So far I have imported his data and set up a number of tables as per his specification...

1- Is it possible to set up Access for remote users, or alternatively so they can all use the same database? Currently they have 2 users in one office, and another 2 users on different sites. They do not have any servers, it's just a basic DSL connection via a Broadband Router, and I am not sure if VPN would provide enough bandwidth.

2- I would like to set up the email field with a button that will send an Email to the address displayed using Outlook. Is it possible and if so how do I do it?

3- I also would like the capability of archiving word documents, which I guess would be done in a similar way to point 2.

many thanks

Chris
Sep 18 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi

A few years ago I worked in a CRM company and gained a lot of experience with a proprietary database system. I am familiar with database normalization and setting up table relationships. I am pretty new to Access and have a couple of questions relating to a favor I am doing for a friend- Setting up a contact database for his recruitment company. So far I have imported his data and set up a number of tables as per his specification...

1- Is it possible to set up Access for remote users, or alternatively so they can all use the same database? Currently they have 2 users in one office, and another 2 users on different sites. They do not have any servers, it's just a basic DSL connection via a Broadband Router, and I am not sure if VPN would provide enough bandwidth.
Although theoretically Access can create Data Access Pages which can be web enabled it is not a very successful or efficient method. However, Access can be used as a backend with a number of web frontend systems. VPN might actually be your best option.

2- I would like to set up the email field with a button that will send an Email to the address displayed using Outlook. Is it possible and if so how do I do it?
Depends on the requirements. The DoCmd.SendObject code is the simplest method of doing this. The syntax is as follows:

DoCmd.SendObject
[objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

3- I also would like the capability of archiving word documents, which I guess would be done in a similar way to point 2.
There are a number of options here. You can use a copyfile function. You can link the documents to the database using an OLE Object type field. Don't embed as it will increase the size of the database.
Sep 18 '07 #2

P: 2
Many thanks for you reply, it's been a while since I have used VB in anger but i'll dust off the cobwebs and give it a go...

thanks

Chris
Sep 19 '07 #3

P: 76
Sending e-mail using a button in VB will be easy enough. The biggest problem I have run into is using the data access pages. As Mary pointed out there are many other ways to get around using them. From what I have learned, you have to use IIS, the MS web server, to host the pages for things to work correctly. You can try to make the page available on a network shared folder but I have run into all kinds of problems doing it.

Here is an example of my e-mail button on a form.
Expand|Select|Wrap|Line Numbers
  1. Private Sub CMDemail_Click()
  2. Dim strToWhom As String
  3. Dim strSubject As String
  4. Dim strBody As String
  5. Dim strMsgBody As String
  6. Dim intSeeOutlook As Integer
  7. Dim strComment As String
  8.  
  9. 'check to see if there are comments for the salesperson.
  10.  
  11. strComment = IIf(Nz([emailcomments]) = vbNullString, "", "--Please Check for comments.")
  12.  
  13. [notifyCheck] = True
  14. strToWhom = [email]
  15.  
  16. strSubject = "WO# " & [wo number] & " is complete" & " " & strComment
  17.  
  18.  
  19. strBody = "Kight Door Shop" & vbCrLf & Date & vbCrLf & vbCrLf & [Customer Name] & " | " & [job name] & " | WO # " & [wo number] & " | is complete." & vbCrLf & vbCrLf & "Comments:" & vbCrLf & [emailcomments]
  20.  
  21. 'strMsgBody = "Hello?"
  22. 'strToWhom = "whoever@whoever.com"
  23. 'strSubject = "This is a test"
  24. 'strBody = "This is a test"
  25.  
  26. DoCmd.SendObject , , , strToWhom, , , strSubject, strBody, intSeeOutlook
  27.  
  28. End Sub
[email], [wo number], [job name], [customer name], and [emailcomments] are all fields from the form's record source. You can use whatever you like to accomplish your goals.

Have Fun,
James
Sep 26 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.