Solved

Can ms Access be used to process e-verify requests?

Posted on 2013-11-03
4
292 Views
Last Modified: 2013-11-04
Is there a way to use Ms Access to verify one potential new-hire employee at a time thru the E-Verify government website?
0
Comment
Question by:bcreen
  • 3
4 Comments
 
LVL 57
ID: 39621356
Since no one has bitten at this yet, I'll start off by saying I'm not really sure.  However Access has a wide range of capabilities and at the end of the day, there's not much you can't do with it.

For example, you can use web based services that calculate sales tax with a POST request to a web server, or process credit card transactions.   You can also download FTP files, read/write to many databases, etc.

I'm not familer with e-verify, but I think we could figure it out.   If no one else jumps in by the end of the day, I'll dig into it.

But do you code or no?   I'm guessing any type of solution would require some coding work.

Jim.
0
 
LVL 57
ID: 39621561
OK, I did a little digging and here's what I found.

The design requirements for the web service method are not made public.   You only can receive a copy of the Web Service Interface Control Document after you've signed up for Web services.

Web services sign-up allows you to use the web site manually until your software is developed.

So the answer to your question is most likely yes, it is possible.   As I pointed out in my first comment, there already is Access software which can work with web sites for real time requests (sales tax, credit card processing, etc).

 However, without the document in front of me, I can't say with 100% certainty.  There are three or four different ways that software can interact with a web site.

 Keep in mind though that people offering services want to make it as painless as possible to use a service, so they often will offer different methods of communicating with a site, or will offer the most common standards, which is SOAP or simple HTTP POST/GET, both of which Access (VBA) can do.

Jim.
0
 

Author Comment

by:bcreen
ID: 39621587
Thanks Jim.  yes I am a 20+ year "coder" and love and use VBA extensively in hundreds of Access (and Excel) applications.

My client is already signed up with E-Verify, so they likely have access to the documentation; I will see if I can examine it.  Also, I can now google (or search on Experts Exchange) for "Ms Access +SOAP" and "Ms Access +HTTP POST/GET".

I've done so MANY things in the past that I never thought Access could do -- most with great success -- so I agree that there is USUALLY 'a way' to make Access work.  Already pursuing credit card processing.

A much appreciated response.  If no one can actually "show me the code", I'm inclined to accept yours as the solution !
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39621624
Well just so you have an idea of what this might look like, below is some code used to make an HTTP POST request.   The code below is capturing a credit card.

 I would not be shocked if the doc's included examples for VB or VB.Net.

 The only issue you might have is if the examples given use a lib that is only for VB.Net.  Then it might take some digging to find a compareable lib for VBA.

  Like I said though, generally web sites like these want to support the widest amount of software possible, so they will either offer multiple methods or stick to the simplest.

Jim.


                  ' Set the correct URL
                  'strPostURL = "https://test.authorize.net/gateway/transact.dll"
110               strPostURL = "https://secure.authorize.net/gateway/transact.dll"
                  'strPostURL = "https://developer.authorize.net/tools/paramdump/index.php"

120               strPostSting = ""
125               strPostSting = strPostSting & "x_login=" & URLEncode(strAPILogin) & "&"
126               strPostSting = strPostSting & "x_tran_key=" & URLEncode(strTransactionKey) & "&"
                  'For debugging.
                  'strPostSting = strPostSting & "x_test_request=" & URLEncode("TRUE") & "&"
130               strPostSting = strPostSting & "x_version=" & URLEncode("3.1") & "&"
140               strPostSting = strPostSting & "x_delim_data=" & URLEncode("TRUE") & "&"
150               strPostSting = strPostSting & "x_delim_char=" & URLEncode("|") & "&"
160               strPostSting = strPostSting & "x_relay_response=" & URLEncode("FALSE") & "&"
170               strPostSting = strPostSting & "x_email_customer=" & URLEncode("FALSE") & "&"

180               strPostSting = strPostSting & "x_type=" & URLEncode("PRIOR_AUTH_CAPTURE") & "&"
190               strPostSting = strPostSting & "x_trans_id=" & URLEncode(rs!CCTransactionID) & "&"

                  ' Additional fields can be added here as outlined in the AIM integration
                  ' guide at: http://developer.authorize.net
200               strPostSting = left(strPostSting, Len(strPostSting) - 1)

                  ' We use xmlHTTP to submit the input values and record the response
                  Dim objRequest As New MSXML2.XMLHTTP
210               objRequest.Open "POST", strPostURL, False
220               objRequest.Send strPostSting
230               strPostResponse = objRequest.responseText
                  'Debug.Print strPostResponse
240               Set objRequest = Nothing

                  ' the response string is broken into an array using the specified delimiting character
250               arrResponse = Split(strPostResponse, "|", -1)

260               If arrResponse(0) = 1 Then
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question