I need help with changing data source/which database my Access application connects to.
We got this application from overseas,it is a Access front with an SQL db, I have restored the database, so we have the database, however as soon as I click to do anything in the program I get an error because I need to change the database it looks for.
I was told to open the application and go Tools-Database Utility Manager and Linked Table Manager and get all the tables and select the tick box to "Prompt for a new location" however I have no tables to be selected once I open Linked Table Manager.
I have never done this before, if this sounds familiar to anybody I would appreciate any help.
Can anyone tell me if it is possible to link access to outlook so that access can send out reminders through outlook to people regarding different information??
Is there a way in Access to create a database that stores (a list of) Ms Outlook emails? And then, is there a way I could drag and drop an email from Outlook into the access database?
Here is what I would like to do. I have a folder say with 100 pdf's. What I would like to do is from an access folder be able to point to the specific pdf and have it create a link within the access form to the pdf they point to... Does this make sense?
Is there a way from within an access form that you can have a button that lets the end user look in a folder and select the pdf... and then create and store the link in an access form???
I was hired to write some reports in Access 2000 for a small company (max of 6 users at a time). The database was created by someone else and he decided that moving to Oracle was the answer to some of their issues (losing data due to record locking). The guy did not know Access at all so that DB is screwed up (another issue all together). I had no problem creating the reports and they ran fine on my home and work computer. When I imported the reports into the Access DB at this company they ran fine (but VERY slow). I then got a call 3 days later from them saying the reports wouldn’t run. The owner decided to upgrade to Access 2003 to see if that would help but that created another set of new error messages. When I try to run the report it gives two messages: "can not perform action/make changes in record primary key" and "record not found". These reports are based on simple select queries. Trying to run the reports freezes the application. I even tried to open the tables and it either freezes the app or takes about 15 minutes to open. These tables are linked to Oracle 8i. The newest OBDC drivers have been installed and the newest Oracle 8I edition has been installed. Since I can run the reports in Access I assume the issue is the link with Oracle. I have very little Oracle knowledge. From what I can tell the data is stored in Oracle and Access pulls the data via the links. Has anyone experienced this? Does anyone know how to fix the issue? Your help is very much appreciated!
i want to know how to link 2 combobox in the access like id i chose a department in the other combobox show me the list under that department and the other think how i can create a search button to the date and to the department i want and how to create a button to calculate from many tables.
I thought I new enought about access databases. I've used the Time & Billing database as a template for my sister to use, but her partner uses a MAC. How can I get the MAC to access the database? I believe the MAC can use Excel but how can I link these two, if at all.
Before I ask my questio I want to let you know that I have searched the forums for an anwser but I just couldnt find it. Or the code didnt work.
What I want is pretty simple for the most of you guys....but not for me. lol
I have a front-end and a back-end. I want to perform a check if the back-end is still in the same place. When its not it should promt the user for the new location.
I have just been shown the delights of a Business Intelligence tool called Cognis Impromptu, a report building tool, reports are built up like tables, very similar to using SQL query builder in Excel.
Reports that I have built can be saved with a .IMR extension, so when they are opened the Impromtu tool refreshes them.
My question is threefold;
Can I link Access to these tables, so as to use them in a database?
If I can link them, when Access opens them, will they automatically refresh?
When I open the reports manually, they refresh, but I have to OK a security dialogue box, nothing really critical, just really a check box. If Access will refresh these reports when they are opened, how can I bypass the check dialogue box?
Hope you guys can help, as I feel that I have a potential to do some really good work by using Access in conjunction with Impromptu... :cool:
Hi, How I can link to website MS Access database? File->Link Tables doesn't understand http or ftp. Provider doesn't support MS Access. Thanks for your advice.
Sue manage the acc.mdb database file, The database has one table which is called "input", Sue made the form, the form is come from "input" table info. and also Sue made one button to send the specific record to the Tom via outlook, once Sue send out, the mail has created a link, which link can open the document (NOT attached file). Once Tom receive the mail from Sue, Tom will click the link to open the document, and also fill out one signature inside the document, after filled it out, then the signature will automatically populate in the specific field of the "input" table in the acc.mdb database file.
If I have a link setup from an access 2010 table to a word 2010 document, is there a way to export the hyperlink address in the table to word as an executable link. Rather than having to insert the link manually as a hyperlink.
I have a system automated that, when our warranty team receives a warranty part that somebody else has requested information for, will email that person letting them know it has been received.
I want to include a hyperlink in the email that points to the database, opens it with 2 argument containing 2 variables in which one of the forms can auto populate and the information be shown immediately.
So first, I would like to know how to create a hyperlink within the code that sends the email. Second, I would like to know how have the database check for arguments upon opening. I can do the rest.
For instance, John Smith requested part number 123456 on claim number 55555, serial number 7777777. The database is located at "S:SharedWarranty ReturnsWarranty Returns.accdb". Therefore, the hyperlink would aim at the location and carry the arguments 55555 and 7777777.
Current emailing code (obviously variables are passed into the function):
Code:
Function sendemail(msg As String, subj As String, recipients As String, ccrecipients As String, xclaim As Integer, claims() As Variant, serials() As Variant)Dim rsnote As Recordset Set cdomsg = CreateObject("CDO.message") If recipients <> "" Then With cdomsg.Configuration.Fields
I'm creating a contacts database in Access. My emails are saved on Novel's GroupWise (web-based, not a client application). My database is on my hard drive and contains the usual: name, address, preferences, etc.
Is there some way to link the actual text of a customer's email to the entry in my database that deals with that customer (for example, field 1= name, field 2= phone number, field 3= actual text of email)? If the web source is a problem, would there be a way to do it if I imported the emails to Outlook or Outlook express?
I am new to Microsoft Access and have a little problem. I have searched the forum and nearly found the fix but I didnt quite understand what to do, so im creating a new thread.
I have a Access Database and have a client page that stores all the information about that client. We produce reports (scanned word/pdf) for each client and we store the report files in a client folder using the Client ID taken from Access.
My question is can I somehow produce a link from the Client Form in Access to the Client Folder or Files in explorer. I have seen the Hyperlink option but that is only availabe in Design View.
I am using a networked database built by somebody else. I have added a networked DYMO labeller which runs via a simple report in Access 2003.
The probelm I am having is that the default label type I specified in the report (30321) keeps changing, it will change intermitantly and to any available Dymo label listed in the paper size. Nobody else has access to the reports to change it.
One day I come in and the label has changed to a Video Top (30326) label the next day it is a File Folder (30330) label.....the Dymo is having no probelm in any other applications and it doesnt seem to be a probelm in any of the databases I have built which are also networked.
Any ideas would be appreciated....getting sick of wasting labels and resetting the default all the time.:mad: :mad: :mad: :mad: :mad: :mad: :confused:
I have a Summary report and a detailed report in MS Access. Upon clicking one of the records in the Summary report should open the detailed version for that record only. Lets say the Summary report has a list of employees. Upon clicking an employee record/link in the summary report should open the detailed report containing the details for that employee alone.
Through word of mouth I hear that you can creat a link that can go from Access and link to the personal company system. Is this true? If it is, is there a standard code to use?
I want to link into the active directory to get a list of staff usernames, so it will update the user table as new members of staff are created etc. We currently have around 130 staff, so rather than manually updating the user table i want it to pick up the usernames from AD?
So I've just started with a company where my job is to manage a ton of data. I am new to Access (2010) and am completely impressed by all the awesome things it can do. However, I am running into some issues with knowing the best way to get my current data (which is all in Excel spreadsheets) into Access.
We are working with about 68 customers in 6 different focus areas (or areas of improvement). To make it easier for them, my company has not required them to enter all their data for each area into a centralized database. Instead, we are pulling reports (into Excel) from 3 different databases. The customers who are not currently submitting data to these databases are sending us Excel spreadsheets with their data (they send a seperate spreadsheet for each focus area). So you can see where my problem lies ... NOTHING is the in the same format. Even then the Excel spreadsheets look different from month to month (and customers submit a new, updated form every month with the current month and previous months) because the people managing the data before I came along changed the format a few different times and the customer has the ability to change them too.
Basically, I would really really really like to be able to just link the Excel files to my database, but I am struggling knowing how to do that with my data in so many different places and forms.