PC Review


Reply
 
 
FrankC
Guest
Posts: n/a
 
      14th May 2010
I'm not sure if this is the right discussion group.
I have a database application that uses Autodial from a form.
It's not working. It skips 2 digits in the number when it tries to dial.
I would like to reinstall it (autodial) but don't know how. Is it part of
Access or Windows or what? I'm using Office 2003 and Vista.

Any advise on how to reload it or fix it?

Thanks
Frank
 
Reply With Quote
 
 
 
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      15th May 2010
Here's the code that you need. If it's the same, you have a different
problem:

Private Sub cmdDial_Click()
On Error GoTo Err_cmdDial_Click

Dim stDialStr As String
Dim PrevCtl As Control
Const ERR_OBJNOTEXIST = 2467
Const ERR_OBJNOTSET = 91
Const ERR_CANTMOVE = 2483

Set PrevCtl = Screen.PreviousControl

If TypeOf PrevCtl Is TextBox Then
stDialStr = IIf(VarType(PrevCtl) > V_NULL, PrevCtl, "")
ElseIf TypeOf PrevCtl Is ListBox Then
stDialStr = IIf(VarType(PrevCtl) > V_NULL, PrevCtl, "")
ElseIf TypeOf PrevCtl Is ComboBox Then
stDialStr = IIf(VarType(PrevCtl) > V_NULL, PrevCtl, "")
Else
stDialStr = ""
End If

Application.Run "utility.wlib_AutoDial", stDialStr

Exit_cmdDial_Click:
Exit Sub

Err_cmdDial_Click:
If (Err = ERR_OBJNOTEXIST) Or (Err = ERR_OBJNOTSET) Or (Err =
ERR_CANTMOVE) Then
Resume Next
End If
MsgBox Err.Description
Resume Exit_cmdDial_Click

End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"FrankC" <(E-Mail Removed)> wrote in message
news:58AFAC23-CD70-4987-B639-(E-Mail Removed)...
> I'm not sure if this is the right discussion group.
> I have a database application that uses Autodial from a form.
> It's not working. It skips 2 digits in the number when it tries to dial.
> I would like to reinstall it (autodial) but don't know how. Is it part of
> Access or Windows or what? I'm using Office 2003 and Vista.
>
> Any advise on how to reload it or fix it?
>
> Thanks
> Frank



 
Reply With Quote
 
FrankC
Guest
Posts: n/a
 
      16th May 2010
Thanks Arvin,
I check the code and it's the same. When I hit the dial button, the number
comes up correctly in the 'Autodialer' window but gets messed up when it goes
to the 'Dialing' window. I'm going to reload Office and see if that works.

Frank

"Arvin Meyer [MVP]" wrote:

> Here's the code that you need. If it's the same, you have a different
> problem:
>
> Private Sub cmdDial_Click()
> On Error GoTo Err_cmdDial_Click
>
> Dim stDialStr As String
> Dim PrevCtl As Control
> Const ERR_OBJNOTEXIST = 2467
> Const ERR_OBJNOTSET = 91
> Const ERR_CANTMOVE = 2483
>
> Set PrevCtl = Screen.PreviousControl
>
> If TypeOf PrevCtl Is TextBox Then
> stDialStr = IIf(VarType(PrevCtl) > V_NULL, PrevCtl, "")
> ElseIf TypeOf PrevCtl Is ListBox Then
> stDialStr = IIf(VarType(PrevCtl) > V_NULL, PrevCtl, "")
> ElseIf TypeOf PrevCtl Is ComboBox Then
> stDialStr = IIf(VarType(PrevCtl) > V_NULL, PrevCtl, "")
> Else
> stDialStr = ""
> End If
>
> Application.Run "utility.wlib_AutoDial", stDialStr
>
> Exit_cmdDial_Click:
> Exit Sub
>
> Err_cmdDial_Click:
> If (Err = ERR_OBJNOTEXIST) Or (Err = ERR_OBJNOTSET) Or (Err =
> ERR_CANTMOVE) Then
> Resume Next
> End If
> MsgBox Err.Description
> Resume Exit_cmdDial_Click
>
> End Sub
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.accessmvp.com
> http://www.mvps.org/access
>
>
> "FrankC" <(E-Mail Removed)> wrote in message
> news:58AFAC23-CD70-4987-B639-(E-Mail Removed)...
> > I'm not sure if this is the right discussion group.
> > I have a database application that uses Autodial from a form.
> > It's not working. It skips 2 digits in the number when it tries to dial.
> > I would like to reinstall it (autodial) but don't know how. Is it part of
> > Access or Windows or what? I'm using Office 2003 and Vista.
> >
> > Any advise on how to reload it or fix it?
> >
> > Thanks
> > Frank

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
autodial =?Utf-8?B?dGluc25pcHM=?= Windows XP Internet Explorer 0 22nd Mar 2004 05:46 AM
IE6 - No Autodial =?Utf-8?B?ZGVu?= Windows XP Internet Explorer 5 18th Feb 2004 02:06 PM
Autodial Fran Windows XP Basics 2 21st Dec 2003 08:01 PM
Autodial John Windows XP Help 0 27th Oct 2003 03:05 AM
#$%& Autodial! jpChris Windows XP New Users 3 13th Sep 2003 06:00 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:06 AM.