Sending DTMF Tones To Dial Stored Numbers

Nov 1, 2007

Is there any way to take make access convert numbers into DTMF tones so as to quickly call a number being viewed on a form?
I am currently using external software... Have a command button that copies the number onto the clipboard and then opens the "dial" software using shell. I then have to click on the "paste" button followed by "play DTMF" within the "dial" software. 3 clicks... I want it to be just one!
Is there a way to get access to emit the tones directly?
Please help, this could be usefull for so many people!!!
:confused:

View Replies


ADVERTISEMENT

Numbers Stored As Text Convert To Numbers?

Jan 10, 2007

Ok so in excel I have some numbers that are stored as text. The reason being that they are zip codes and some begin with 0 and excel doesn't want numbers to start with 0....so when I import these into an access field that has an input mask for zip codes...will it convert these correctly since the field is a text with input mask?

View 1 Replies View Related

Display List Of Numbers Stored Into Field Of Database

Jul 7, 2014

I have a question regarding the display of a list of numbers that are stored into a field of my database. Currently the numbers are comma-delineated which is fine with me, but I was wondering if there is a way to change the display of those numbers on the form so that it is easier to read.

Example:

current format - 1,2,3,4,7,8,9,10
desired format - 1-4, 7-10

View 2 Replies View Related

Dial

Aug 29, 2005

Hi ,
i have a field in my users tabel call phone and i want to place a button that use this field value and dial it thru a modem cam i do this ????

View 2 Replies View Related

General :: Dial And Call Through Access

Aug 27, 2013

Can I make a product in access which calls on click event from phone.

View 5 Replies View Related

General :: Dial Button Not Working In Standalone Database

May 23, 2014

I have an Access 2007 database which has a form on which is a button to dial the currently selected phone number. All works fine. My intention is to send out partial databases to people not having access installed and they will use the access runtime module.

When the same database is run using the runtime it does not dial and does not give an error message. It just stays the same as though I didn't press the dial button.

View 10 Replies View Related

Modules & VBA :: Connect Access Database With Softphone - Dial Through VOIP PBX

Oct 11, 2014

Is there a way to connect access database with a softphone? I have an IP PBX and a soft phone and i need to click on a form and auto dial the contact. My DB contains all the data I need and also PBX.

PBX running asterisk software.

Do i need a module or something like TAPI that call windows dialer (but win dialer use a modem and not Ip phone I guess)..Or something that just wake up voip softphone and paste data?

View 2 Replies View Related

Queries :: Search For Multiple Plot Numbers Preferably In One Parameter Prompt With Comma To Separate Numbers

Aug 12, 2014

I'm having multiple problems with my database like things such as -

i'm currently working on the Query 2 - On the Phone database (ignore Query 1) and i want to search for multiple plot numbers preferably in one parameter prompt with a comma to seperate numbers. (this could be a multitude of numbers so i would like to be able to input as many as needed). Also when i do search on this query since the Criteria is a 'Between' Value i would expect everything between the 2 numbers input to show up - but a lot of numbers out of the range show up too - why is this? (The Numbers are like "69 to 136" and they will show up - but 1-69 and 136-170 would too

I would also like to implement the search results from Query 2 into the Form i currently have made but it just opens up a access table when the search is made?

i cannot link my database as it is too big for the server - But here are the Criteria for Query 2:

Plot No - (criteria = Between [Enter First Plot No:] And [Enter Last Plot No:])
Site - (criteria = Like "*" & [Enter Site:] & "*")
Product - (criteria = Like "*" & [Enter Product:] & "*"

The Query is the one im most concerned about , i can live without a form.

View 14 Replies View Related

Modules & VBA :: Automate Line Numbers And PO Numbers

Aug 24, 2014

I have 2 fields that I would like to automate if possible

One field is called "p/o number" and another field called "line no"

These fields are part of an ordering database

Let say I have 200 items to purchase form 10 suppliers

And form example 20 items from each supplier

What I do at present is put the order number on each line item and the line number

example

p/o number line no

1 1
1 2
1 3

2 1
2 2
2 3
2 4

What I want to do is just put the first po number in the required line . Put the first line number in i.e. "1" and the macro will complete all the p/o numbers and line numbers for me as per the ones marked in red.

Example

1 1
2 2
3 3

2 1
2 2
2 3

View 5 Replies View Related

Stored Procedure

Jun 12, 2007

Hi,
I need to write a stored procedure that sits between sql server and MS access. This procedure will make sure that the queries run in access against the data in sql server will not access data for more than two years back. This is so that the queries run against the sql server do not hang up the server for too long.

Thank you.

View 2 Replies View Related

Stored Calculations

Nov 29, 2004

I've read the posts regarding not store calculations. However, I was told by IS to store the mileage IRS deduction as it changed 3 times last year.

Any idea's how to handle this? I need the table to remember how much $$ was paid out in mileage expense. I had set up a field called mexpense and mileage, where =[Mileage]*0.375.

View 5 Replies View Related

Stored Procedures

Sep 11, 2006

Hi,

I am switching from sql server to msaccess and cannot find an equivalent of a stored procedure in access.

The task I want to do is the following.

1. I have a table with many field.s
2. I want to loop through all the fields and replace records which have a value of 0 with NULL.

How could I do this without writing seperate update statements for each of the fields.

Thanks.

View 5 Replies View Related

SQL Or Stored QUERY

Feb 3, 2008

What are the benefits of each a stored query or sql? I suspect that the stored query would run quicker>

View 1 Replies View Related

Calculating A Stored Value

Jul 1, 2005

I apologize that I am not a very good VBA programmer yet but I'm really trying....

I am attempting to calculate a value by adding two fields and storing the result into a third field - - My code only works if both of the fields are not null.

Private Sub PartialDepositAmount_AfterUpdate()

Dim PartialDepositAmount As Currency
Dim FinalDepositAmount As Currency
Dim DepositAmount As Currency

Me.DepositAmount = Me.PartialDepositAmount + Me.FinalDepositAmount

End Sub

If either field is null my result is null but I need to be able to add field one (or field two) to a null and store the result in the totals field.

Any suggestions will be greatly appreciated.

JohnJ

View 3 Replies View Related

Stored Procedures

May 20, 2005

How do you make stored procedures in microsoft access 2003, can you actually do this or is it not part of access?

View 4 Replies View Related

Using Stored Procedures In Access

Nov 15, 2007

I have an Access mdb that has a bunch of tables linked from a SQL Server. On the SQL Server I have some stored procedures that do inserts into various tables. In the Access db I have some local (lookup) tables, queries, and other things that for various reasons can't/don't need to be stored in the SQL server. I'm using Windows authentication to connect to the SQL server because the security is managed through our domain.

I want to write a form that has unbound text fields that, when I submit the form passes all of those values as parameters to a stored procedure in the SQL server. I have written just such a form in an .adp file, which handles the integrated security nicely.

However, I'd rather do this in a regular .mdb file. I've read up on how I can use an ADO connection to do this, then create a SQL string to EXECUTE the stored proc, grab all the values off the form, and build the SQL.

But the problem with this solution is the authentication - I can't use the SA user and password in this connection string, I'd have to utilize the logged-in user's information.

Is there an easier way to execute the stored procedure from an .mdb? Using the integrated authentication?

Failing that, is there a way that I can create "local" (to the .adp) tables, queries, and so on in an .adp?

View 5 Replies View Related

Parameters / Stored Procedures

Aug 25, 2006

I come from a SQL Server background and am very familiar with store dprocedures and input parameteres.

Is there a way to use a similar method in Access. or example, passing parameters from a button on a form to a query, which can change depending on the input parameter? If so, how ?

Also, how much scope do you have in this for running SQL IF statements and such in the query? It seems that many Access queris can only have one statement at a time.

View 7 Replies View Related

Set Parameters For Stored Procedure

May 31, 2005

I'm running a access 2000 adp front end working from a SQL2000 database. I've got a sproc P_insertsessions i can get this work from a cmd button on a form but i'm having problems setting the paramerters i want it to use controls on the form.
@contractid = contractid
@start_date = startdate
@end_date = enddate
@hours = duration

Can anyone help.

View 1 Replies View Related

How To Run Instruction Stored In A Memvar??

Mar 10, 2005

I'm used to doing the following with Foxpro:

mSetup = "Replace table.desc with alltrim(table2.code)+" ~ "+table2.vno+" ~ "+table2.po+" ~ "+table2.vendor

To run the process I use a macro substitution:
&mSetup

What can I do as an equipvalent with VBA??

Thanks in advance,

Steve

View 1 Replies View Related

Stored Procedures Disappear

Feb 27, 2008

Sometimes when I send a copy of an Access 2003 application to a remote user, a stored procedure or function will disappear. What causes this, and how can I get the entire application over to the users?

Thanks in advance!

View 6 Replies View Related

Combo Box Values Being Stored In Tables As 1 And 2 Etc..

Feb 12, 2008

Hi,

I have combo boxes on a form which are pulling values from a one table and being stored in another table. However they are being stored as '1' or '2' in the other table once selected on the form, as instead of being stored as their literal values ie 'car' or 'van'. Is there any way of making this happen, as it makes reporting a nightmare! Thanks in advance...

View 2 Replies View Related

Count How Many Lines Stored In A Field.

Jun 26, 2007

Is there any way to count how many lines of text are stored in a particular table field? How about counting how many times was the "enter" key pressed?

Thanks

Mafhobb

View 4 Replies View Related

Null Values In Stored Procedures

Aug 4, 2005

Hi,

I am calculating two fields (qtyorder-qtydesp) in a stored procedure.

The second field is from another query (view) which may not have a record relating to the main record (stored procedure).

The problem is the second field is simply left blank but I need it to be 0.

It makes the calculation in turn result in a blank field, i.e. 1-0 should equal 1 but because of the blank field it returns a null value.

I found that the good old Nz function wont work with stored procedures, is there any alternative?

Thanks,
James

View 5 Replies View Related

Pass List Box Value To SQL Stored Proc

Mar 27, 2008

I have and access form that has a list box with dates in it. I need to pick a date and then run a stored procedure in SQL based on that date. Can someone help me with the login to pass on the date?

So if I have listbox1 which is a list of dates from another table
and my procedure is simply

select * from main
where date = *******


How can I pass the list box value to the stored procedure? My procedure works with WHERE date = (SELECT(LEFT(GETDATE(),11))) but I have since learned that todays date will not always be used so I need to pass a value.

Thanks,
Dave

View 11 Replies View Related

Use Stored Proc As Recordset For Listbox

Mar 29, 2005

I'm working on and Access 2003 front end with a SQL Server Back End. I would like to take advantage of the speed of Stored Procs to populate a list box on a form. Here's the code I'm trying to use.

Set cmd = MakeStoredProc("StoredProcName")
Set prm1 = cmd.CreateParameter("ParamName", adInteger, adParamInput, , Me![ID])
cmd.Parameters.Append prm1
rstSource.CursorLocation = adUseClient
rstSource.CursorType = adOpenKeyset
rstSource.LockType = adLockOptimistic
Set rstSource = cmd.Execute

Me![ListBox].Recordset = rstSource


Access doesn't like this. What is wrong. I get the message "Object doesn't support the property or method"

Thanks for your help.

View 14 Replies View Related

Changing Stored Value Of Option Groups

Aug 8, 2005

Sorry if this is an easy one and I just missing it, but I have a form in an Access2003 database with option groups for ratings for 18 individual tasks ie:
Safety: 1. Satisfactory 2. Marginal 3. Unsatisfactory 4. N/A
The value stored in the table is 1,2,3, or 4 for each one, obviously.
How can I change the stored value in the table to "Sat" "Marginal" "Unsat" etc?
Or, if easier, make the report convert the numerical values to names?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved