Linking with auto dialer

I am building a database and would like to know how to link it with my telephone dialing software. I have figured out how to run the function i want with windows autodialer, but i would like to use my own software.

My first attempt was to insert a button that opened the software. i think this will work, but what i need to know how to do is make access insert the telephone number from a record automatically after clicking the button.

Is it possible to have access open "phonesoftware.exe" then insert a selection of text (the phone number)?

I'm far from computer illiterate but access is a bit new to me. Thanks for your help guys!


Post your answer or comment

comments powered by Disqus
I have created a application with a "customer" type table that has an account # field that is auto-number field type. This is the field I used to link to all other tables. I am concerned that I may not be able to restore data to a new customer table when I upgrade the application due to the problems with auto-number fileds. Any thoughts on how to handle this ??
Thanks Chris

Hi, back again with one more trouble.

While there is no problem with data transfer between 2 Access tables with auto numbering PKI - Access keeps the key values equal in the 2 tables - when transferring from Access to Sql Server, the latter generates its own values in the PKI column, so you no longer can compare the two tables, nor is it possible to transfer data to related tables – as the key value needed for the joined fields changed.

Curiously you can change the values under the key in the SQL tables – something not possible for Access auto number PKI - so you could correct the SQL PKI column after transfer. However to do this you would need a reference to identify the registers, ie add a clone column to be filled with the original PKI data.

Or you don´t use SQL auto number PKI before transfer, changing the SQL PKI to auto numbering after data transfer (I suppose you can do that)

I don’t like any of the 2 solutions. Who knows a better way out?

Thank you for any reply,


I have a label on a form.
The label has a phone number in it.

Can I double click the label and have the auto-dialer call that number?

Tom

Started a new thread: Rebuilt database and still need help with auto number for multi user form. The code I have works for single user but not multi user. Also if someone opens the form and closes without adding anything to the form the number is used with blank record.

This is what I have thus far:
Private Sub Form_Current() Me.[PO] = Nz(DMax("[PO]", "tblPurchaseOrder"), 0) + 1
End Sub

Usually whatever I search regarding MS Access, I find some solution. But this time I could not see much about SMS a new record or use of Auto dialer command in a form. May be I did not have enough patience, hence this new thread.

In fact, I have been using email features in my dB but for me best solution shall be sending SMS. Kindly advise the best way to configure to do so.

I am using MS Access 2007. I would prefer to send SMSs in bulk. (8-10 numbers simultaneously)

best regards.

I have a main form named "master"
By a series of butttons the current subform is replaced by selected button with a different subform.
Unfortunaly the main frm does not link with any nested subform.
Any ideas
thank you
Dennis

PHP may linked with Access? online/offline? can you give a tutorial link on this ?

Hi all

This is my first time here, so please be gentle lol

I have a general question as I really did not know what to search on, please let me explain.

I have 4 tables, tblPatients, tblLocation, tblFinance and tblReques.

I want to import data which is in another access data base, which has 70 odd entries and was using frmPatients with sub forms frmFinance, frmRequest and frmLocation, these were all linked with auto numbers IDs.

But when I import and run the Patients Form is fine, however the subforms are not synching with it.

Hope this makes sense, any help very much appericated.

Cheers

I have 5 copies of a database that 5 users enter data into (including Pre, Post and Follow-Up information). These users send me their database quarterly and I am suppose to merge the data into one database from which to run reports, etc.

The problem comes in with the auto-numbering. Each "Pre" table has an ID that is auto-numbered. This auto-number is also stored when a corresponding "Post" (or follow-up form) is entered so that we can be sure the pre-, post- and follow-up are all linked to the same individual. When I merge the data, they are reassigned ID numbers in the Pre (while the Post still has the original Pre ID number) so now I've lost the link as to one individual's pre, post and follow-up form.

I realize now that the database shouldn't have been built this way, but is there any way to work around this. I've even tried exporting all of the rows for each of the 5 users into Excel and then importing them into Access in a new table (just so I could have the ease of running queries) but I seem to be getting errors doing that as well.

Any ideas?

Jen B.

Full disclosure...I'm very tech savy but Access ignorant.

Scenario: I am building a database to store student assessment information. I have a table with student information, a table with teacher information, and tables which will store the student's scores on a certain assessments.

Q1: I have a field in the assessment table for Teacher ID and Student ID which are linked to their respective tables. What I want to do is create a form for inputting the assessment data but the fields for teacher ID and Student ID to auto-complete or be combo boxes, I don't care which. That is, when a person is entering a student's scores, and go to enter their ID, they won't have to type the whole number out and hope they dont make any mistakes, they will essentially have a list of choices to choose from. Or as they type, the corresponding number will filter down. I already have refferential integrity on so that they can't enter an invalid ID in either field but I want them to have the choice.

Q2: In an assessments table, there is a 1-1 correspondence btw student ID's because only one student can have one score on a particular assessment. However, clearly one teacher can be tagged to several student's assessment scores. Can anyone think of a better way to tag the teacher to multiple student's scores without having fields in the assessment table for teacher ID which is repeated multiple times.

Thanks for any insight that can be offered.

Is it possible that any report can be linked with sub report For example
can we link any report with unbound object like a form.

hello i have a 2007 access DB tables,list,reports, and a main user input form that i have locked up with ribbons,menus all hidden......... I would like to sent up a simple form or report that a list of 6 main users can look at the main table on a daily bases and make changes to one row of info in the table and have it update and save................... I dont want them to have to go through main user input form and open and unlock and un hide everything so they can look at main table then relock all before they close out of DB.......just need a way they can go directly to main table make a change save and auto update DB thanks to all that have helped in past and on this issue



Thanks Darren

We have an ms access application and tables in that are linked with backend database SQL SERVER 2008

I used to manually link the access tables with SQL tables with the help of 'Table Link Manager' option. Now I want to do this programatically.

File DSN will contain belo information:

	Code:
	[ODBC]
DRIVER=SQL Server
UID=user1
PWD=password1
DATABASE=MyDB
APP=Microsoft Office 2005
SERVER=111.111.111.111,53314

My VBA code has to read this file DSN from the shared path and link the tables. Can you please provide the VBA code?

Hi,

I'm maintaining a frontend access db that can be attached to different backends depending on what company it is for. Each company frontend has tables that are linked to the same backend because they are common to all companies and other tables that are linked to their own backend. The tables that are linked to their own backend are specified in a table called "tblMyLinkedTables" containing the connect string of the of their specialized backend. This table is in the common backend db. I want to be able to change the connect string to the appropriate one for any particular company based on this table. I am using the following code the make the change, but the change does not actually occur. No error is raised either. It's as if the properties of tabledefs are read-only.

Public Function CorrectMyLinkedTables()
'Purpose: To update the table links of the db's linked tables so that they agree with tblMyLinkedTables.

Dim td As TableDef
Dim MyLinkedTables As DAO.Recordset

Set MyLinkedTables = CurrentDb.OpenRecordset("qryMyLinkedTables", dbOpenSnapshot)
With MyLinkedTables
.MoveFirst
Do Until .EOF
If Len(CurrentDb.TableDefs(!Name).Connect) > 0 Then
CurrentDb.TableDefs(!Name).Connect = !ConnectString
CurrentDb.TableDefs(!Name).RefreshLink
End If
.MoveNext
Loop
End With

End Function

Does anyone know why the above code does not work?

Thanks,

Mike

Access 2002 question.

I have a linked table which auto-updates from the contents of a folder in Outlook. This is working just fine and the result is a table that I cannot edit but can query.

One of the fields in the linked table contains the subject of my emails as a text string. The emails in my case will have a very standardized subject line which can, I hope, be copied into an array so I can pull specific values and populate another table. I cannot change the format of this subject line as it is auto-generated from another 3rd party application.

The standard format of the subject field entry in the linked table would be something like "item1:item2:item3:item4" with the colon as a delimiter (again something I can't change).

I'd like to have the ability to separate say, "item1" and "item3" and have these values, along with other fields in the same email record, move to a second table for more refined editing, querying, etc. The other fields that I'll need are the date and time the email was received.

My resulting second table should mimic the first table like so.

Linked Table:
Field 1: "item1:item2:item3:item4"
Field 2: date from email
Field 3: time from email

Table 2:
Field 1: item1
Field 3: item3
Field 4: date from email
Field 5: time from email

One trick is that I'll need Table 2 to update when the Linked Table auto-updates with new emails.

Any suggestions and pointers would be greatly appreciated!

BTW: I'm new to access but I'd assume that you would create some kind of array from the subject string and then access the array to populate the fields? Since I'm new to access, I'm really not sure _where_ this kind of code would reside.

Thanks again!

Todd

I am using linked sql 2005 tables in access. I have the problem with Auto number.when i go for new record Auto number is not displaying the number.
Any helP?

I developed a Database in Access 2003.

I put the database in a server so more than one person can access to the database at the same time.

I did a quick link to the data base, to be able to access more than one person at once.

Now my problem is when somebody try to open the quick link from a computer with a Access 2007, I get this error:

The operating system is not presently configured to run this application.

Can anyone help me out to fix this problem.

thanks so much

I have two linked ODBC tables in my access applications. If I link them both with the same account, they work fine.

If I link them each with a different account, when I view one, it will work fine. When I try to view the other, it will give an ODBC call failed.

Regardless of which one I view first, it will work, then the second will not work.

Is this a bug in Access 2003?

I read a link on auto-population in a form. I thought I followed it to a "t" but my field is not being auto-populated. I have several tables, however, just two specific to what I am trying to do. I feel so close to a solution. I have a table called, "tblActivity" and "tblSimulators". I created a form based off of "tblActivity" and I want to add a field called "Fidelity" on that form. That field is housed in "tblSimulators". I have built a relationship between the two tables. The field connecting them is called, "SimulatorType".

Initially, I had "Fidelity" on the "tblActivity" but I erased the column since that data was housed in "tblSimulators". I added a text box to my form and called it "Fidelity". In the combo box for "SimulatorType", I added the field "Fidelity" in the row source query grid. I then went to the properties for the new text box and added, "SimulatorType.[Column(1)]" to the Control Source. When I go to form view and tab through the form, I read, "#Name?" and it does not auto-populate with the corresponding fidelity of the simulator. Any ideas? Thanks!!!

OK! First - I apologize to all of you who took the time to read the last post on this topic that I started a little while ago - I was able to set up a send object statement that did what I wanted to do so - in order to keep with board cleanliness - I deleted the previous thread started by yours truely

However - I now have a new issue/problem with my auto-email function - Posted below is the string I use to fire off the e-mail report:

DoCmd.SendObject acSendReport, [Forms]![frmReports]![List5], "Snapshot Format", [Combo4], , , "Attached Report", "Please find the report attached to this email", False

The code above takes the report selected in a listbox[List5] and the name of the person to receive the e-mail [Combo4] and send the e-mail - no problem EXCEPT....

When the code runs the e-mail is sent but for some reason the GroupWise software asks the user to select which address book they wish to use???? Is there something in the code that could be causing this??? - If I set the sendobject code to editmessage = True then I do not get the request for the address book selection?!?!?

Also - does anyone know of a way I can import a contact list into Access from Novell GroupWise?

thanks everybody!
Kevin

I am currently trying to analyze the presidential campaign contributions made by employees of large US companies for my thesis ( I am trying to link contributions made by all emplyees to stock returns on election day). I have a few problems concerning linking the data.

I have a table with the names of the companies, their ticker, CEO name, etc, which looks like this:

	Code:
	Ticker	Company Name	Market Value	Industry	CEO Name
ADSK	Autodesk 	342		19		Carol A. Bartz 
AEE	Ameren 		265		24		Gary L. Rainwater 
AES	AES 		242		24		Paul T. Hanrahan 
AET	Aetna 		115		14		John Wallis Rowe

I also have a table (with over 740,000 records) which contains the campaign contributions to certain candidate committees, as follows:


	Code:
	Committee Id	Contributor		Occupation	                        Amount
C00010603	Sant, Roger W Mr.	AES Corporation/Chairman		2000
C00383653	Saint, Alexia		AES Corparation/Business Analyst	1000
C00383653	Jayaratne, Josh		AES Consulting LLC/Consultant		200
C00383653	Crane, Eric C		Autodesk Inc./Attorney			1000
C00003418	Cohen, Sarah Ms.	A.T. & T./Sales				250
C00010603	lucas, jack	         AT&T/software engineer			250
C00010603	Ludolph, Charles	Consultant				200
C00010603	Lucas, Freddy		self/Dad				999
C00010603	Luckhardt, Jack C Dr.	Retired					300
C00010603	Luckhardt, John C						500
C00010603	Marsh, Kris Ms.		Aspen Valley Medical/Nonprofit Exec	250
C00010603	Marsh, Dave		self employed/audio producer		500
C00010603	Marsh, Leslie		RMACInc./Insurance Executive		250

The two links I would like to make are:
1. Using the company name from the first table(and linking with the Occupation field in the second table), find the total donations made by employees of a company to a specific committee,
2. Using the CEO name (and linking it with Contributor field of the second table) find out what the contribution is of the CEO of each company to a specific Committee.

The problem with the first link is that the company name in the second table is part of the general field "Occupation" which also contains the job title, such as "AT&T/software engineer" so that I cannot make a direct link with the "AT&T" company name from the first table. Is their a possible way to link one table with another using wildcards or is their possible another solution (looking within a field for a certain string)?

There is also the problem that different names are used, for example AT&T and A.T. & T. or AES, AES Corp and AES Corporation. I think the solution to this is to try and make a table with all possible versions of a companies name, or would their be a simple way to automate this as well?

The problem with the second link is that the names of contributors aren't written in a standard form, which also means a direct relationship cannot be made. Any ideas on this?

As you can read, it is quite a complex problem, and as I have no programming skills I am finding it hard to link this data. I would appreciate any input on this, as I cannot manually go through 740,000 records to look at the amounts that employees of all S&P 500 companies have conributed.

Thanks in advance for your help!

Onur

Hello,
I want to have a table linked with an excel doc (which is easy to do with the wizard) but I want this linked table to have a primary key (which the wizard does not allow) because this table will be in a one-to-many relationship

How else can I do ?
thanks

I have a table with the following info in it:

Aircraft ID
Aircraft Type
Engine Config
Airframe Config

I'd like to be able to enter the aircraft ID into my form, and the computer then checks to see if that aircraft ID exists. If it finds it does then it will automatically fill in the type and config details on the form and skip to the next part of the form without prompting. If the aircraft ID doesn't exist then I can enter all the details on the form and it stores them away for future reference...

I cannot for love or money make the relationships work, and auto lookup either. Can anyone point me in the right direction on this please?!

I have 2 tables, A and B, in a 1-1 relationship and on an SQL backend.
With my Access front end, I would like to be able to make renamed copies of these tables on SQL, create the 1-1 relationship between the copies, and link them down to my front end.

To make the copy, I was going to use:

	Code:
	SELECT *
INTO CopyA
FROM A

But I'm not sure how to go about creating the relationship on SQL and linking the new tables to Access.

Thanks,
Jonathan


Not finding an answer? Try a Google search.