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?
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...
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...
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...
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...
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).
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?
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...
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...
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...
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"), "^"...
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...
I have the following code:
<tr bordercolor="0">
<td valign="top" class="apartmentinside"> Members/Shareholders:</td>
<td class="apartmentinside">
<asp:DataList runat="server"...
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...
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...
I need to loop through the number of rows in a dataset by changing the row number of the following:
coDS.tables("company").Rows(0).Item("coname")
First, how do I stop a loop in a dataset once it reaches last record?
Second, do I change the "Rows(0)" to this...
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 ("") value. Once the user makes a selection from the dropdownlist and updates accordingly then wishes to go back and clear...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.