General :: Dial And Call Through Access
Aug 27, 2013Can I make a product in access which calls on click event from phone.
View RepliesCan I make a product in access which calls on click event from phone.
View RepliesI 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.
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?
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 ????
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.
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
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?
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 RelatedIs 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:
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).
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 RelatedI 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 RelatedHi,
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
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
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
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
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
Hi,
Is it possible to call a procedure that exists in one form on another form please?
Regards,
B
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.
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 RelatedI 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 RelatedCan 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 RelatedHi,
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:
why aint this working ?
Expr1: Mid([MinuteCode];1;InStr(1;[MinuteCode];".")-1)
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 :)
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