Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FirasSHhady

    promlem with HyperLink

    the massage is: run-time error -2147417848 (80010108) the object invoked has disconnected from it's client any ideas
  2. FirasSHhady

    promlem with HyperLink

    here is the code again but with refine hope to get some help Private Sub cmdOKNewCust_Click() Dim strCustName As String Dim FirstPeriodSum As Double Dim sbAdd As String Dim scTip As String Dim txToDsply As String Dim Cust_Sheet_Name As String Dim Cust_Number...
  3. FirasSHhady

    promlem with HyperLink

    Dera here is my code which copy an existting sheet and make a hyperlink to it in the main sheet with friendly name. but when press the button of that form i always have a error messeage, and the compiler stope at the hyperlink line code. the message tell am that the add mwthode for hyperlink...
  4. FirasSHhady

    How to pass a control to general sub?

    Dear SkipVought I attach the invoice form and code window snapshot. Dear Andrzejek I htink I've to pass the textboxes name bcz i wanna the General sub to use different set of textboxes each time. But what I'm failing at is that I cann't told the general sun what is that textboxes. I think...
  5. FirasSHhady

    How to pass a control to general sub?

    I'm using Excel 2007 the meassage appear in the change event code told me that type miss match.
  6. FirasSHhady

    How to pass a control to general sub?

    I have design a form as an Invoice with 15 row, each consist of tow comboboxes and 3 TextBoxes, txtVal, txtNum, txtPrice. When anyone of these 3 textboxes change I wanna change the value of txtVal TextBox. And to do that I named each controls line with line number (i.e txtVal1, txtNum1...
  7. FirasSHhady

    Problem with Visual Studio .NET Prerequisities ?

    Hi everybody, it's my first time dealing with VB.net. And while I'm installing it (MS Visual BAsic 2003) the installation process ask me to download the Prerequisites, ... My System info: OS: Windows xp sp2 build 2600 I've the last updated from the Microsoft site for windows Xp ... so...
  8. FirasSHhady

    where is the problem??

    I'll do sir, thank's alot again. with all my respect.
  9. FirasSHhady

    where is the problem??

    The code work very good, thany you Mr.johnwm for you help, and I have cople of questions please: 1. Waht about passing the controls by type, I think I sould use some thing like this: Dim Ctrl as Control For Each Ctrl in Me.Controls If Ctrl.Type=Lable Then Call Alignlbl(me,Ctrl,30) Next 2...
  10. FirasSHhady

    where is the problem??

    yeh, now I just open the properties window , and copy the name of the label I have on my form. But the problem still as mentioned above. sir, I try the code in the form code window, without taknig it to a Module code and it's working (as it was). But I don't want to do that I want to pass a...
  11. FirasSHhady

    where is the problem??

    this is copy&past from my projrct' windows, now the vb tells me that there is an Error and the error is: Sub Or Function Not Definde, and set the curser at (Lbl), at the line marked below. ____________________________ Private Sub Command1_Click() Dim ctrLoop As Control For Each ctrLoop In...
  12. FirasSHhady

    where is the problem??

    Thank Mr.johnwm, it's really great tips to me, but when I chang the code as above the result still the same. I wounder if I could attach the project of my program, but I don't know how in this forum. But I think the 2nd tip need alittel more explain. thank's alot. Feras
  13. FirasSHhady

    where is the problem??

    1. yes, it's a control array. but look, I try to pass the array to General sub in the Module to use it frequently. 2. Yes, I dim the Control.
  14. FirasSHhady

    where is the problem??

    In the Form code window: ------------------------ Private Sub cmd_Click() For Each Control In Me.Controls If Control.Name = "Lbl" Then Call Alignlbl(Control, 30) Next End Sub Private Sub Form_Load() With Form1 .Width = 7000 .Top = 100 .Height = 8000 End With End Sub...

Part and Inventory Search

Back
Top