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!

Register Log in
  • Congratulations Chriss Miller 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. sarduspater

    decoding packed signed field

    I apologize for delay, but my pc had some problem. This is the result: SELECT RSDR.CTIPSOM, RSDR.DANNCON, RSDR.NRIF, RSDR.CTERINS , RSDR.COPRINS, RSDR.DDATINS, RSDR.COPRAGG , RSDR.DDATAGG, RSDR.SSTA, RSDR.COPR, RSDR.DCON , RSDR.NOPE, RSDR.CFIS , RSDR.CTIPARC, RSDR.IIMP ...
  2. sarduspater

    decoding packed signed field

    I use spufi before embed code in JCL. Thank you, SkipVought, it works fine. Candu si tene su 'entu es prezisu bentolare.
  3. sarduspater

    decoding packed signed field

    My router has a DNS problem. Now I try. Thenks for now. Candu si tene su 'entu es prezisu bentolare.
  4. sarduspater

    decoding packed signed field

    Link does not work... Thanks Candu si tene su 'entu es prezisu bentolare.
  5. sarduspater

    decoding packed signed field

    This is clear, but if I want join to a field in another table, I'm looking for a function for SELECT MT1.field1, MT1.field2, MT2.field1 in MyTable1 MT1, MyTable2 MT2 WHERE FUN(right(MT1.field4, 4)) = MT2.field2; (MT2.field2 is numeric) Candu si tene su 'entu es prezisu bentolare.
  6. sarduspater

    decoding packed signed field

    The problem is not to decode the sign, but the number. In other words, I try a function like f(right(myfield, 4)) returning 1578. Thanks Candu si tene su 'entu es prezisu bentolare.
  7. sarduspater

    decoding packed signed field

    Within Spufi I'm reading a field that contains three fields values in a string. It appears as 01F0058 0C2017C in hex, where 0001758+ is the field I would use for join with an other table. How can I convert this in numeric? Thanks to all Candu si tene su 'entu es prezisu bentolare.
  8. sarduspater

    Play MIDI and MP3 Files From Excel VBA On Windows XP PC

    Your pgm on my work's pc sounds very well. I think the problem is not Xp. Candu si tene su 'entu es prezisu bentolare.
  9. sarduspater

    Excel VBA Application Memory Usage Bloat

    Using Add method I think it would work: Sub xx() Dim w As Object On Error GoTo err Application.DisplayAlerts = False Do Set w = Workbooks.Add("obj.xls") ' .... w.SaveAs Filename:="obj.xls" w.Close Loop Exit Sub err: Debug.Print...
  10. sarduspater

    Excel VBA Application Memory Usage Bloat

    Read this: http://www.add-ins.com/support/out-of-memory-or-not-enough-resource-problem-with-microsoft-excel.htm Candu si tene su 'entu es prezisu bentolare.
  11. sarduspater

    Basic VBA Question

    Option Explicit Sub cc() Dim strRange As String, x As Boolean strRange = "A1:B2" x = SelectRange(strRange) End Sub Function SelectRange(strRange) As Boolean SelectRange = Range(strRange).Select End Function Candu si tene su 'entu es prezisu bentolare.
  12. sarduspater

    Need to convert rows of data into columns..

    Try this: Option Explicit Sub xxx() transpose Range("G2:G5"), Range("G1:J1") End Sub Function transpose(f As Range, t As Range) Dim i As Integer For i = 1 To f.Count - 1 t.Item(i) = f.Item(i) Next End Function Candu si tene su 'entu es prezisu bentolare.
  13. sarduspater

    Need to convert rows of data into columns..

    For example,if cell J2 needs to become G2 and cell J3 needs to become H2: Range("J2:J3").Select Application.CutCopyMode = False Selection.Copy Range("G2").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True Candu...
  14. sarduspater

    Calling Dll from excel or access

    Maybe it's a forum wrong section. I move question to Visual Basic(Microsoft) ActiveX Controls and DLLs Forum. Candu si tene su 'entu es prezisu bentolare.
  15. sarduspater

    Calling Dll from excel or access

    Using vb6 I created a DLL with many functions I use in vba. Now I would know wich program is calling my DLL (within it). If excel is calling it, GetModuleFileName function of kernel32.dll returns c:\..\..\excel.exe, but I would know wich workbook is running (Application.ActiveWorkbook.FullName)...
  16. sarduspater

    Calling Dll from excel or access

    Using vb6 I created a DLL with many functions I use in vba. Now I would know wich program is calling my DLL (within it). If excel is calling it, GetModuleFileName function of kernel32.dll returns c:\..\..\excel.exe, but I would know wich workbook is running...
  17. sarduspater

    access treeview.listimage property

    Very well, it works fine. Thank you, MajP. Candu si tene su 'entu es prezisu bentolare.
  18. sarduspater

    access treeview.listimage property

    I tried to modify plus-minus option inserting icons. In vb6 it works fine, loading images in a ImageList control, then refering it using TreeView1.ListImage = ImageList0 In this version of treeview control (access 2007) ImageList property is not available. How can I do? Thanks in advance...
  19. sarduspater

    JavaScript error

    This is my code in vba: Sub yy() savefile "C:\myDir\Aaa.pdf", "C:\myDir\Aaa.txt" End Sub Sub savefile(ByVal sfile As String, ByVal txtfile As String) Dim acroApp, acroAV, acroPD, jso As Object On Error GoTo ErrHandler Set acroApp = CreateObject("AcroExch.App") Set acroAV =...
  20. sarduspater

    JavaScript error

    Using an example I tried to obtain to save a pdf file in txt format within acrobat 8 professional. This is the code: mySaveAs = app.trustPropagatorFunction(function(doc, path, type) { app.beginPriv(); doc.saveAs(path, type); app.endPriv(); }); mySaveDoc = app.trustedFunction( function (doc...

Part and Inventory Search

Back
Top