Need a control/button in Access 2007to open another document
I am creating a database for work. I am hoping to create a button/control in access that will take a person to the correct Word/excel documents that needs to be completed and printed off for the client. At this time I do not eant to create a merge documet, but that will be coming later. Now I jsut need to get access to open the word or excel document. Can access do this? And if yes, how do I set it up?
An expert who has achieved level 3 by getting 1000 points
An expert that got 10 achievements.
An expert that got 5 achievements.
An expert who has answered 1,000 questions.
Re: Need a control/button in Access 2007to open another...
Yes it can be done, however, it is not some thing can be done with this service.
if you need to know how, please email me at firstname.lastname@example.org
I do need to see the access that you have created in order to do what you need to create.
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones). click here to download the app (for users in the US for now) and get all the help you need. Good luck!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
You may try this third party tool programmed with best technology the tool support all windows and MS office versions. You may try free demo version of this software to preview your recovered access database. SysTools Access Recovery you may check How tool works and its user friendly interface make this easy to handle.
You'll need to instantiate (create an instance of, or an item in memory) what is known as an ODBC connector. You will also need to create a database or have a database to work with - Microsoft Access will work fine for this, alternatively you can use OpenOffice's version of Access.
The code you'll want to use will be approximately
Dim ws as Workspace
dim db as database
dim strConnection as string
let strConnection= "ODBC;DSN=" & DatabaseName & ";UID=" & UserName
& ";PWD=" & UserPassword
set db=ws.OpenDatabase("", False, False, strConnection)
"The Microsoft Jet Database Engine cannot open the file '(unknown)'"There are several causes for this error message:
The account that Microsoft Internet Information Server (IIS) is
using (which is usually IUSR) does not have the correct Windows NT
permissions for a file-based database or for the folder that contains
The file and the data source name are marked as Exclusive.
Another process or user has the Access database open.
error may be caused by a delegation issue. Check the authentication
method (Basic versus NTLM), if any. If the connection string uses the
Universal Naming Convention (UNC), try to use Basic authentication or
an absolute path such as C:\Mydata\Data.mdb. This problem can occur
even if the UNC points to a resource that is local to the IIS computer.
error may also occur when you access a local Microsoft Access database
that is linked to a table where the table is in an Access database on a
Check the permissions on the file and the folder. Make sure
that you have the ability to create and/or destroy any temporary files.
Temporary files are usually created in the same folder as the database,
but the file may also be created in other folders such as the WINNT
folder. For additional information about how to identify which folder
does not have the correct permissions and how to configure temporary
files, click the following article number to view the article in the
Microsoft Knowledge Base:
Microsoft Access 97 database connectivity fails in Active Server Pages
If you use a network path to the database (UNC or mapped drive), check the permissions on the share, the file, and the folder.
Verify that the file and the data source name (DSN) are not marked as Exclusive.
"other user" may be Microsoft Visual InterDev. Close any Visual
InterDev projects that contain a data connection to the database.
Simplify. Use a System DSN that uses a local drive letter. If necessary, move the database to the local drive to test.
Follow the instructions in the following article to work around this problem:
FIX: ASP fails to access network files under IIS 4.0 and IIS 5.0
It seems that you have your Database(.mdb) file is created in Office 2003.... thats why you are unable to open it in 2007.... I faced the same problem.... then I came back to 2003 in order to use our database......
have to follow few steps.
1. new database - give any name
--> design table
e.g id, name and file (the datatype of the file should be hyperlink other wise it wont work)
--> enter some records (in file field write a, b ,c)
--> when you put record in file field then click on hyperlink option on top.. (like first record id=1, name=fahad, file=A) select the A and click on hyperlink option on top and give the hyperlink of the pdf file
--> design the form
--> run the form
--> click on desired file
--> it will open
--> looks complicated but its easy
I cant assume your level of confidence in programming, however, following are some simple steps you can follow to achieve (for complex implementations, much more time and details will be needed, i can help u with them as well)
1. Create a database in Access ( i assume u r using Access 2003) 2. Create a System DSN (if aren't clear, how to create then goto administrative tools under control panel and you'll find Data Sources (ODBC), here u need to create System level DSN for Access driver (may be Jet 4.0+) 3. In java, you need to import java core libraries for sql (javax.sql package specially) 4. you are almost done, just google for database code in java, simple code will be around 5-10 lines (just for your reference, search with these keywords, ClassName(""), jdbc:odbc:YourDSN) 5. Open a connection using Connection object 6. Fetch the records (select query) using Recordset object 7. You're done.
you can create static data base in Excel works heet and link each cell to another sheet.
or you can create a dynamic data base in access. you need a MS access book. there are lots link you need to understand in order to have a working data base.