Search:

Type: Posts; User: kaczak1108

Search: Search took 0.02 seconds.

  1. Replies
    0
    Views
    558

    VB MailMerge excel with WORD

    Hi, i Have problems with my Mergefield.
    I wrote it on my document by dont't show me a value, wich exist in Excel..

    I wrote like this : {MERGEFIELD Suma_oplat_inst_IP_Solution (THIS IS NAME OF...
  2. Replies
    0
    Views
    893

    ByRef datatype mismatch - Bulkretrieve

    Hi everyone,
    I have small problem with that script.
    I look at bulkretrieve methods and i think i wrote this code correct, but there is some errors...
    I wrote earlier codes with this method and...
  3. Replies
    5
    Views
    1,140

    Re: ADODB.recordset

    but i have another problem:

    Public Function inserthgbstelement(title As String, status As String, rank As Integer) As String

    Dim conn
    Dim funObjid_elm
    GetDbConnection conn...
  4. Replies
    5
    Views
    1,140

    Re: ADODB.recordset

    i solve this: now looks like :


    Sub delete_dane()

    Dim conn
    Dim str As String

    GetDbConnection conn
    Set rs = CreateObject("ADODB.recordset")
  5. Replies
    5
    Views
    1,140

    ADODB.recordset

    Hi everyone, i have a small problem in my code.
    when i execute my code i get a error msg: " 3705" operation can,t execute when object is open


    Sub delete_dane()

    Dim conn
    Dim str As String
    ...
  6. Replies
    11
    Views
    1,481

    Re: function in visual basic

    i resolve this problem like that: i use data type converter

    inserthgbstelm0hgbstshow1 clng(funObjid_elm), clng(funObjid_show)
  7. Replies
    11
    Views
    1,481

    Re: function in visual basic

    Of course, and they are in type Long

    Public Function inserthgbstelement(title As String, status As String, rank As Integer) As String

    Dim funObjid_elm As Long !!!!!! there is type
    ...
  8. Replies
    11
    Views
    1,481

    Re: function in visual basic

    I have another problem: in function i wrote that type must be long and in parameters.

    Function:

    Function inserthgbstelm0hgbstshow1(funObjid_elm As Long, funObjid_show As Long) As Long

    ...
  9. Replies
    11
    Views
    1,481

    Re: function in visual basic

    ok thanks, I understand it now ! :)
  10. Replies
    11
    Views
    1,481

    Re: function in visual basic

    You have right :) byt why Visual basic tell mi that : "expected = " on this function in this line?



    dim y as long

    y = inserthgbstelement(Range("A" + CStr(x)), Range("B" + CStr(x)), -3 +...
  11. Replies
    11
    Views
    1,481

    Re: function in visual basic

    thanks you for reply :) i have another small problem.
    Could you tell me why this line is wrong? inserthgbstelement is a function:


    Public Function inserthgbstelement(title As String, status As...
  12. Replies
    11
    Views
    1,481

    function in visual basic

    Hi, i wrote a procedure and function. I transfer this function into procedure. If i try execute procedure i have an error: argument not optional on this function.


    Public Function...
  13. Re: error 424, i dont know where is the problem... Can you help me?

    Thanks for ypor reply :) I solve this like that:


    Function pobierz_objid()
    Dim conn
    Dim ptype_id As Integer

    ptype_id = InputBox("Podaj numer tabeli:")
    Set cmd =...
  14. Replies
    2
    Views
    1,488

    Re: visual basic script

    thank you. I change this :)
  15. [RESOLVED] error 424, i dont know where is the problem... Can you help me?

    I have created a function which must doing a sql function...
    if i execute there is a error msg "424".
    I dont know what is wrong...


    Function pobierz_objid()
    Dim conn
    Dim ptype_id As Integer
  16. Replies
    2
    Views
    1,488

    [RESOLVED] visual basic script

    Hi, can somone help me? I have script and i dont know what is wrong:

    Function LastRow()
    Dim c As Object
    With Sheets(1).Range("A:A")
    Set c = .Find(What:="*", LookIn:=xlValues, Lookat:=xlPart,...
Results 1 to 16 of 16



Click Here to Expand Forum to Full Width