Search results for query: *

Hello, I'm having trouble with CRM integration with Great Plains and am trying to learn more about several error messages that are in event viewer. For example, when a new customer is added in GP the inetgreration does not carry the customer over to CRM. I could use some help on what these error...

Hello, I have a button when clicked executes a stored procedure and populates a window and grid. I want to be able to check the user against a table and only allow the procedure to run if the user is in the table. Any Ideas how I can accomplish this? Here is the code I'm working with: Private...

Hello, I have very little VBA knowledge but have been giving a task which I need some direction. I have the code below that when the button is clicked will populate a window with data that is returned by a stored procedure. This all works great. What I need to do is only allow the window to be...

Hello, I'm trying to populate a combobox with data from a SQL table. I have posted in the VBA forum but think I should post here as well as this may be a great plains issue. The Great Plains VBA combobox appears to not have the additem or rowsource methods. How do you populate a combobox in VBA...

Hello, I have been working at this for days and am no better off. I could really use some help. I need to populate a combobox with data from a column in an SQL table. I have put together the code below but am having an error at this line: invBegNum.additem rs.Fields.Item("RMDNUMWK").Value...

Hello, I have a form with a drop-down list that I would like to have populated with data from a database. Can someone show me an example of how this is accomplished or point me to a tutorial? Much Thanks!

Hello, Can someone please show me an example of how to pass a parameter to a stored procedure? I have a crystal report that uses the stored procudure. I can call the procedure with this: Set s = CreateObject("InternetExplorer.application") s.Visible = True s.Navigate...

Hello, I need to be able to pass two varibles to a stored procedure that is used for a crystal report which should also run when a button is pressed. I believe that I have the stored procedure configured correctly to take the two varibles and have bound the crystal report to this procedure. I'm...

Hello, I'm new to administering GP and this error keeps occuring when a user is invoiceing. "A save operation on table 'pop_po' cannot find the table." It typically happens 5-10 times a week. If the computer is restarted the user is likely to be able to accomplish the task. Has anyone seen this...