Search results for query: *

I am using one MS Access 2003 as a front end user interface for forms and reports, and another as the back end. This is a user requirement. I cannot use linked tables in the front end, so I am managing all forms through ADO Recordsets and the form recordset properties. I was hoping to do...

I am creating a report based upon two tables with a 1 to many relationship. Both tables have a quantity field that I must aggregate on. However, when I create the query the quantity from the primary table is aggregated for each instance of the child record. This causes a erroneous value in...

We recently had an occurance where a user was posting an Inventory Batch Transaction with about 76 Item Transactions. During the posting, the user's pc lost network connectivity and the transaction hung. So she re-posted it and it processed. However, the hung transaction was in the system...

I am trying to create a quick deployment for my app using the Package and Deployment Wizard (PDW). I am running into a problem with the oledb32.dll files. I get an error that it failed to load resource oledb32r.dll, followed by an error registering the oledb32.dll. The oledb32r.dll is not...

Hello All; I am in the last stage or developing an automated integration system, and have one last hurdle, I hope :) Does anybody have a good method that will automtically close Great Plains? I know the vbScript within Integration Manager doesn't work properly. I have tried using a SendKeys...

I am using ADO recordsets to access a DB using an OLE DB connection string. The DB is a SQL Server 2000 and it has an Index call IX_FieldIndex. Here is the sample code Set rstFD = New ADODB.Recordset rstFD.ActiveConnection = gvCnn rstFD.LockType = adLockReadOnly...

I am using two forms to display data. The first form allows for searching and viewing key fields. There exists a treeview and two listviews. When the user selects a specific record from a listview a second form opens showing the details. When moving from the search form, I am simply hiding...

I've figured this was easy, but have never figured it out. How can I open a form using using its name in a string variable? i.e. Load strFormName where strFormName is the name of the form? Thanks in advance baugie

I am trying to set up an auto notification system that will update selected people of success/failure of system processes. I want to send e-mail directly to the exchange server bypassing Outlook. Has anybody attempted this? I have worked on sending messages thru Outlook from VB, but havn't...

I'm writing a two part script within IM for the integration to get the next Doc No and pass it back to upon successful document process. I getting the Doc No. and assigning it to a variable using SetVariable "sDocNo", (Doc No.) from the Before Document Commit script. After this...

I am creating an automated integration process, and we are using Integration Manager which requires a login to the Dynamics interface. We are contemplating several ways to insure a seat is available for this process. I know that the currently logged in users are stored in the ACTIVITY table...

I am using the standard Integration Manager for SOP integration. I have most of it figured out, but one thing I can't understand is how IM decides which version of window to open. We have a modified Sales Transaction Entry screen which the login id has access to, but IM continues to use the...

I am using Integration Manger to import Sales Trx data. I am using regular Integration Manager that uses the GP User Interface as it's data entry point. We have VBA code behind the Sales Trx screen which I thought would automatically run during the integration, however it is not running. The...

I am trying to provide my users with a list of the ODBCs configured on their computer so that they can define their own lookups into other systems. I'm sure this is simple, but I can't find the right method. Any advice? Thanks in advance, baugie

I am trying to create an automated integration process within the Sales Order Module of GP. I was going to use the SQL Optimizer, but apparantly I cannot because we have the inventory bins option enabled within our system and that is not supported by SQL Optimizer. I want to make this...

I am trying to create an automated integration process within the Sales Order Module of G.P. I wanted to use the SQL Optimizer since this does not require a log into G.P., thus allowing it to run without user interaction. I read through the documentation, and it listed some limitations on what...

I am getting an overflow error when using the AVG function. What would cause this problem?

I am trying to create a query to group on the data by month for the previous year. I have the query grouping by month, but can't get it to stop at the data prior to one year earlier. Here is an example of my query: SELECT (Format([shDate],"mmm yyyy")) AS [Month], (equation as...