General :: Dial And Call Through Access

Aug 27, 2013

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

View Replies


ADVERTISEMENT

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

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

Modules & VBA :: Static Shell Function Call Works But Dynamic Call Fails

Sep 4, 2013

I'm having to recode some old MS Access DBs so they will run in the following environments:

Office 2000 on WinXP
Office 2003 on WinXP
Office 2010 on WinXP
Office 2000 on Win7
Office 2003 on Win7
Office 2010 on Win7

When I wrote my code for Office 2000 on WinXP things were simple because directory paths were the same across all computers and I could hard code pathing when using a shell command to launch other files.

My new approach is to make a function call to the Windows registry to determine the default executable and path for opening a file based upon its extension (see apicFindExecutable in basWindows API module).

I'm able to use code to create a shell call and debug print it to the immediate window. If I put my cursor in the immediate window at the end of the shell call and hit [enter] the external file will open as desired. If I try to open the external file directly through code, I get a file not found error.

To recreate the error take the following steps:

(1) browse to files that are accessible from your computer
(2) click the PREPARE DATA AND OPEN MAIL MERGE DOCUMENTS command button

Shell function call is made by the fnOpenFile function located in the basOpenFile module. There has to be a trick here that I'm missing.

View 5 Replies View Related

General :: How To Make Sound Like Making Call To Another Computer Using Vba

May 19, 2014

I'd like to make noise to another computer, or start same sound file or simply to call another computer on lan or through vpn connected computer using vba...

That will be nice if I can press button on access form and user on another computer hear some noise or to loo like it is call

View 1 Replies View Related

General :: Call Quality Monitoring - Recordset Can't Be Updated?

Oct 10, 2013

I am creating a database for call quality monitoring. Just when I thought everything was working perfectly, I get an error saying the record set can't be updated. I can't find anything useful about it online either.

Here is my database:

I have a table which is essentially an template for call quality. each record has a primary key ID number. I also have a table for staff and their teams which is linked to the other table.

I have a form where you can select the staff member, and there is a tab control where the second tab has their quality results via a sub form. I have made the primary key a hyperlink so when clicked it brings up the quality form of the original record. however it can't be updated and gives me the message saying record set can't be updated.

I want the user to be able to click the hyperlink, bring up the record and edit where required.

Is this even possible?

View 5 Replies View Related

General :: Invalid Procedure Call Or Argument In Accde But Not In Accdb

Aug 6, 2012

I'm getting this error (invalid procedure call or argument - DLL error 0, number 5) on my accde file but not on the accdb.

View 1 Replies View Related

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 4 Replies View Related

Making Call List In Access

Jul 5, 2012

We have 4 managers and 16 foreman. Each month a manager is tasked with calling 4 foreman for progress reports.

I'd like to create a simple program with Access to have the foreman assigned to the managers differently each month. It would have to remember the past 4 months so the same names aren't assigned to the same managers. It also has to randomly assign the foremen so the managers don't have the same foreman after 4 months (if that makes sense).

View 1 Replies View Related

Call An Excel Macro From Access Module

Dec 7, 2004

I am trying to populate an Excel Shreadsheet (Template in Effect) with Data from Access. This is going ok no problem. Although I need to run an excel macro, which does some formatting to the WorkSheet after each entry in the Access Recordset. I've tried copying the VB over, but getting some errors, and frankly, I think it's easier if I just call the macro itself, rather than try to adapt it for the Access context. Though, I accept it would be a cleaner approach. Can I do this?

View 1 Replies View Related

Modules & VBA :: Possible To Call Windows Search Function Into Access?

Nov 3, 2014

I need a search function that will not just open files based on their names but also drill into the documents and search based on what's in it. The only way I can see now is to use the Window's search function (the one at the start button). Is it possible to call that function into access?how do I re-create the search style of the windows search bar for a specific folder? Something like streamreader

View 1 Replies View Related

Do Not Call Database

Jul 6, 2006

Hi,


1. We have one master table with many records.
2. We'd like to filter out records from the "master" table that match the records on other "exception" tables.
3. As I add records to the "exception" table, I'd like to generate a new table with the records from the master minus the exception table.

I've been reading up and I think that this could be done with queries.
Any suggestions?

Thanks,

Adrian

View 1 Replies View Related

How Do I Call This Function?

May 3, 2007

I did some searching and found this function posted by someone in response to the exact same problem I'm now encountering.

But how do I call this in my query?

Function StripZeros(pstr As String) As String
Dim n As Integer

n = 1
Do While Mid(pstr, n, 1) = "0"
n = n + 1
Loop
n = IIf(n > 1, n, 1)
StripZeros = Mid(pstr, n)

End Function

View 2 Replies View Related

How Do I Call The User Name?

Jul 6, 2005

I am using some code found on this site to creat a log in process. It works great but I want call the UserName and insert it into my database showing
Welcome<Username> you are currently logged in..

Can someone tell me how to call this from a form?
following is the code behind the log in on the "Onload" event.
Thanks in advance.
Fen

Private Sub Form_Load()
On Error GoTo Err_Form_Load

'To ensure a user has logged on correctly we check to see if a userlevel has been set.
'I use the same Select Case below in the "Form_Load" event of each form as some forms you
'may want to set different thins for different user levels rather than setting them
'globally in a module.

With Me

Select Case User.UserLevel

Case 1 'All OK


Case 2 'All OK


Case 3 'All OK
.Command26.Enabled = False
.cmdOpenUsers.Enabled = False

Case 4 'All OK
.cmdOpenUsers.Enabled = False
.AllowAdditions = False
.AllowDeletions = False
.AllowEdits = False

Case Else 'No userlevel set, must have got here via devious means !!

' MsgBox "No User Level Set. ", vbCritical, " LOGON ERROR"
DoCmd.Close acForm, Me.Name

End Select

End With

Exit_Form_Load:
Exit Sub

Err_Form_Load:
MsgBox Err.Description
Resume Exit_Form_Load
End Sub

Private Sub Form_Unload(Cancel As Integer)
Call LogUserOff 'Called from the Unload event incase the user just clicks the main
'Access Window Close Button or exits the Db some other way.

End Sub

View 4 Replies View Related

Call Module?

Sep 8, 2005

I have a bunch of Forms set up in Access that are updating tables etc......

At present 100% of the code is sitting on the Form. I have some code that is repeated because of a string parsing issue. What I am thinking of doing is writing this code as a couple modules and then call them when needed.

Does that make sense to write them as modules and call them?

How do you call a module???

Thanks

View 4 Replies View Related

Call Centre Database

Apr 6, 2006

Hello all,

Im really hoping someone can take a look at my database and help me!!

I have a query within my database that hold five different Departments, and each department has two difference phone numbers.

What im trying too do is add together the statistics of the two phone numbers that relate to the department!

And also be able too do a search by a cumulated date range, and by multiple departments!

Please, please, please, could someone look at my database and advice me

Many Thanks

Mark

View 1 Replies View Related

Call Procedure On A Different Form

Aug 30, 2006

Hi,

Is it possible to call a procedure that exists in one form on another form please?

Regards,
B

View 13 Replies View Related

Creating Call Lists

Nov 15, 2006

I am trying to create call lists which will compile one-to-many relationships.

For example, suppose I have 1000 employee records with the following fields:

Manager's Name
Manager's Phone Number
Direct Report's Name
Direct Report's Phone Number

Each Direct Report has only one designated manager, but managers may have more than one direct report. Further, for roughly half of the records, the manager and the direct report are the same person (independent workers).

When I run the report, I want it to print the Managers' information, and have the Direct Report information below. I have added an IIf query stating that if the Manager's Name is the Same as the Direct Report's name, leave all of those cells blank. When I create a report, however, the labels for Direct Report will still show but the data does not. It looks somewhat shoddy.

View 2 Replies View Related

Call Out Data Base

May 21, 2007

hi i want a call out database with a calender with blocks in to represent slots booked and free, with a form with time start, duration (default 60mins) address, work to do, and milage. and the a report for the customer to sign. i have tried for about 6 months with different ways and means, to no aval, it would help if i had som knowledge of vb programing, ect, i have basic knowledge of access, eg add data, search data, and reports. please can someone helpme design one, as i would be very greatful, thanks in advance

View 2 Replies View Related

ODBC Call Failed

Jul 16, 2007

I have a new user who is trying to connect wirelessly. I set up the ODBC connection on his laptop but when he tries to run a report that uses queries looking at linked tables he gets ODBC call failed. Is it because he is trying it wirelessly. I'm just the data guy so I don't know too much about networking.

View 2 Replies View Related

Difference Between 'Call' And 'DoCmd'

Apr 8, 2008

Can someone tell me the difference between 'Call' and 'DoCmd' and how each are executed. For my level of programming, an newbie at that, I've used it interchangably so far without a problem. But I'm beginning to think that there is a difference. I don't want to later have to go back to redo my code down the line. I'm beginning to think that I've been very lucky so far in being able to use it interchangebly and my luck will run out soon.:eek:

View 7 Replies View Related

ODBC Call Failed

Mar 7, 2007

Hi,

I have a standalone Access DB with 4 linking tables therein. They all point to tables that are stored in a server Access DB. I can open 3 of these tables in datasheet view without any problem, except one.
Whenever I try to open it, I am prompted following msg "ODBC call failed etc... server API error (#669) etc..."
And when I click OK to close the Error msg box, then another msg box appears with the msg: "Microsoft Access can't open the table in Datasheet view"

I've deleted the link table and recreated it. But I still can't open the table in datasheet view.
Does anyone knows what's to do? :confused:

View 3 Replies View Related

Invalid Procedure Call

Oct 14, 2005

why aint this working ?

Expr1: Mid([MinuteCode];1;InStr(1;[MinuteCode];".")-1)

View 14 Replies View Related

Function Call From Qry - What If Null???

Dec 1, 2005

Hi all!

I have a query that returns some fields with "#Error" ...

The reason is that I call a function in the query, and the function chokes if there are no matches in my query criteria and therefore no argument is sent to the function.

I tried putting this in the function:
var = Iif(IsNull(var) = True, 0, var)
-but I still get "#Error" when there are no matching records.

I presume this is because not even Null is given to the function as an arg.
Should I make the arg optional or how can I solve this??

Thanks :)

View 6 Replies View Related

ODBC --call Failed.

Feb 22, 2007

This error comes when try to run a query in Access. Does someone knows how to fix it?


ODBC --call failed.
[Oracle][ODBC][Ora]ORA-01013:user requested cancel of current operation (#1013)

Any help on this will be greatly appreaciated. Thanks a lot.

Wil

View 10 Replies View Related







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