?
Solved

Access 2007 Question:  How do I link Microsoft database to an area on the server.

Posted on 2012-08-13
5
Medium Priority
?
308 Views
Last Modified: 2012-08-14
Hi Everyone,

I would like to know how can I link to a machine address or server code automatically to a input form so the user would not have to add the code to input screen when they order. I have attached two screens displaying the input form and the initial table that the form relates to. Your help would be greatly appreciated.

jjc9809
Initial-Entry-Screen.png
Initial-input-table.png
0
Comment
Question by:jjc9809
  • 4
5 Comments
 
LVL 85
ID: 38288499
Do you mean you want to link your database to a server-based datafile? If so, you need to create Linked Tables.

http://office.microsoft.com/en-us/access-help/import-or-link-to-sql-server-data-HA010200494.aspx

See the section titled "Link to SQL Server Data", about halfway through the document.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38288521
Not sure of your terminology here ("machine address or server code"?) but you can use a function like this to get the Network User Name:
http://access.mvps.org/access/api/api0008.htm

Then you can insert this value automatically when a new record is created;
On the current event of the form, do something like this:

If me.NewRecord then
    me.Vendor=fOSUserName()
end if
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38288664
In the big picture, the vendor should be "Logging In" to the database, then any information associated with the vendor can be passed to the form automatically.
The Vendor ID will be stored, but the Vendor Name will be displayed
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 38288712
Or if the "User" is selecting the vendor, then you can use something like this...
(See attached database)

In the end, you need to provide us with more information on this system.

JeffCoachman
Database2111.mdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38288728
Here is a sample of a "Log In" form system
(When you click the new record button the VendorID is added to the table and the Vendor Name is displayed)
Database211.mdb
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

621 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