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 Mike Lewis 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: *

  • Users: Rexxx
  • Order by date
  1. Rexxx

    IM mapping to a custom field

    I'm using Integration Manager to integrate a General Journal. The General Journal form has a custom field (customer id) that I need to map integration to. Does anyone out there run IM that maps to a custom field that help?
  2. Rexxx

    Import question

    I've got expense data to import into GP on a regular basis. The version of GP I have is 7.50g30. I have Integration Manager available to use. First, I know I've got to have the data parsed to import correctly. I thought I'd use Visual Basic to get this routine accomplished. I've looked...
  3. Rexxx

    Creating Org Chart

    I've got an Excel database with the following five columns: Full name, job title, department name, supervisor, location What I would like to have happen is for a program to take this information and create an organization chart from it automatically. What I don't want to have to do is have a...
  4. Rexxx

    Crystal and GP Report menu

    Bradth In the GP menu, selecting Tools then Customize, there are two options Visual Basic Editor and Modifier. I see these items and I believe I'll need to use both to create the menu (is this correct?) but they are greyed out. I approached the GP administrator to provide access rights to use...
  5. Rexxx

    Crystal and GP Report menu

    Well I don't have a problem working with VBA (I have experience doing that in other applications). I'm helping out a GP client with reports so I'm not able to signon with admininstative rights although I can request the rights as long as I know what I need. Can I setup this button with my...
  6. Rexxx

    Crystal and GP Report menu

    What third party tool (for including Crystal Reports as a GP report menu item) would you recommend and what is the cost of it for unlimited GP users? My main concern is menu security (i.e., I can't have the GP world run a crystal payroll report).
  7. Rexxx

    Crystal and GP Report menu

    I create a Great Plain report in Crystal how do I add the report to the Great Plain report menu? In other words, the report file must be stored then called by report menu item .. what is the most efficent way to do this?
  8. Rexxx

    GP Smartlist

    Is there another approach beside using an addon?
  9. Rexxx

    GP Smartlist

    In regard to GP v7.5 and Smartlist v7.5, using GP HR module the payroll folders do not include columns needed for export such as paycode description. Is it correct that in order to add a custom table as a folder or add columns to existing folders an addon tool is required such as Any View or...
  10. Rexxx

    How to start a multiple column dropdownlist with what already there

    Below I have an array that populates a dropdown list box and inserts, as a first item of the array, that item of the array which is already part of the record which the user will then either leave as is or select another item in the array to change: Dim selectCMD7 As SqlCommand = New...
  11. Rexxx

    Replace chararcter in dataset (vb)

    vb Solution that works: dim temp as string For i = 0 to ds.Tables(0).Rows.Count - 1 temp = Replace(ds.Tables("company").Rows(i).Item("coname"), "^", "'") ds.Tables("company").Rows(i).item("coname") = temp Next or table specific For...
  12. Rexxx

    Replace chararcter in dataset (vb)

    I have a dataset named company and I am trying to replace every character (^) in the rows of a certain column (coname) with another character ('). Code I have is follows: For i = 0 to ds.Tables.Count -1 Replace(ds.Tables("company").Rows(i).Item("coname"), "^&quot...
  13. Rexxx

    CustomError message problem

    For some reason I keep getting a customerror message when I load an asp.net site that has an error. This changed overnight. If I logoff and back on as a different user I do not get the customerror message. The Web.Config file has CustomErrors mode = "Off". I cleared the browser...
  14. Rexxx

    databinder help with nested datalist

    I have the following code: <tr bordercolor=&quot;0&quot;> <td valign=&quot;top&quot; class=&quot;apartmentinside&quot;>&nbsp; Members/Shareholders:</td> <td class=&quot;apartmentinside&quot;> <asp:DataList runat=&quot;server&quot...
  15. Rexxx

    Need help to print one record after another

    I am using repeaters and I need for each record to print one after another (vertically). As of now, I can loop through the dataset but all I get displayed (printed) is the last record in the dataset. Somehow I need to get the display to loop too. Very much like a datalist would do ... but...
  16. Rexxx

    Help with a loop

    Zarcom, using either of your suggestions gives me the following compiler error. What to do? Compiler Error Message: BC32023: Expression is of type 'System.Data.DataTable', which is not a collection type. Source Error: Line 65: Line 66: Dim row As DataRow Line 67: For each row in...
  17. Rexxx

    Help with a loop

    I need to loop through the number of rows in a dataset by changing the row number of the following: coDS.tables(&quot;company&quot;).Rows(0).Item(&quot;coname&quot;) First, how do I stop a loop in a dataset once it reaches last record? Second, do I change the &quot;Rows(0)&quot; to this...
  18. Rexxx

    How do I add a blank value selection to my array? (vb)

    I have the following array (see below) and it populates a dropdownlist. The way it works now is without an initial selection the dropdownlist displays a blank (&quot;&quot;) value. Once the user makes a selection from the dropdownlist and updates accordingly then wishes to go back and clear...
  19. Rexxx

    Excel VBA to email attachments

    The code above allows the form to address and attach the file then save to Outlook draft by fetching the address from an Excel cell. I had to make other modifications to this code too so that it would continue to loop and save to a file by fetching a name from two Excel cells. I'll post it...
  20. Rexxx

    Excel VBA to email attachments

    Okay Kylua, this is what I came up with. In this code I'm working between two different worksheets since the one is getting emailed (actually saved to draft to release later): Public Sub Test() Dim olapp As Object Dim oitem As Object Dim Allattachments As Object Dim currentAttachment As Object...

Part and Inventory Search

Back
Top