Search results for query: *

I am working on a report viewer using the file list box to select the report, which works except it does not follow a shortcut file to the target. I have also tryed the common diaglog control which does follow the shortcut. My dilema is that I want to restrict the directory which the user...

We recently moved the Macola directory from one server to another. Everything works, except any screen that has a flexibility project on it takes about 1 minute to open. There are no error messages and everything works, it just is very slow to open. If I remove the flex client it works fast...

I am trying to change the Profit center on the order entry screen based on whether a userfield has the word "DEMO" in it. The idea of this is to redirect demo sales to a different profit center. The profit center is currently being set to the profit center assigned in the customer type...

I am getting the following error when doing an OE credit memo for a particular item: Execution Error: file 'INQPRGUP.LBR\IMINVADJ.int' error code; 153, pc=2561A, call=30, seg=0 this error occurs every time at the point you select the bin number in the bin allocation screen. It works for other...

When I install pervasive 2000 SP4 on my database the server stops listening on port 1583, if I uninstall it starts working again. Anyone have any Ideas... I have completely uninstalled and reinstalled pervasive. Thanks.

We just upgraded to MS Sql, when using crystal and access to evaluate text fields such as Credit hold and User Defined Fields, it does not work. Example: SELECT OEORDHDR_SQL.hold_fg, OEORDHDR_SQL.ord_no FROM OEORDHDR_SQL WHERE (((OEORDHDR_SQL.hold_fg)<>"H")) WITH OWNERACCESS OPTION; This...

I have been converting all of our Crystal reports to MS SQL, when I select trused connection I don't get prompted for a usernamd and password, It only works with Domain admin rights. I would like to use this for domain users, is there a way to give them rights? or a better way to go about...

We are about to upgrade Macola to MS SQL, Macola send us the .200 upgrade CD. We have been holding off upgrading to 7.6.200 as long as possible. I would like your opinions about upgrading to 7.6.200 then running for a couple of weeks to work out the bugs or Make both upgrades at the same time...

We are converting Macola to MS SQL from pervasive, It doesn't appear the FRX (ver 4.18) will work. Has anyone else run in to this problem and what are the alternatives to FRX? Thanks, Bob

I need a trigger an automated email when a new customer is added. How do I determine if a new customer has been added with flexibility? Any Ideas (Cus start date = currentdate)......

I have state stored as &quot;City, ST ZIP&quot; Address3 I need to extract the ST out of this string. Any ideas????

I have a few flex projects that use the pervasive table names, and in preparation of an SQL upgrade I was working on changing to the _sql tables, what I found was the macform.no.text does not have the 2 leading zeros that the oeordlin_sql has. Am I missing something or is there any easy way to...

What would be the best way to obtain a unique number (RMA Number) in a multi user environmet? If two users are entering RMA's and I need to Assign a unique number, how do I keep users from grabbing the same number. Thanks.

I am trying to prevent users from changing status 4 orders. I am using the following code, Is there anyway to close the form or exit? Private Sub DiscPct1_GotFocus() Dim statrs As Recordset Dim statstmt As String Dim ord As String ord = macForm.No.Text Call OpenMacolaConnection Set statrs =...

Is there a way to setup the outlook profile for exhange when a user logs on to the computer? Many people sharing computers. Please Help. Bobz

Can the I update records in a table from items selected in a listview control? I am working on a order reallocation by item, the form would show all orders for a specific item and the qty to ship would be updated to the qty ordered or 0 depending on whether it was selected or not. Just trying...

Am I missing something, I am trying to use the numbertodate function in cr9, I have downloaded the ufltdate function and put it in the windows\system and windows\crystal directories. Any Ideas.

I am new to Macola's MRP, I have a client that has changed buyer/planner for a particular item. On the Material requirements report only the CP entries have changed to the new buyer. The data is in the mrreqfil. the buyer info is not updated. Is there a way in Macola to update this information?

Anyone know if you can export a report to pdf using the cryst32.ocx control? I am launching a crystal report from VB and need to export the report to pdf. Any Ideas???

What is the simpliest way to display results of a recordset? I have used the get string method to display the results, but there are no collum headings. I want a basic datagrid, like an access query would display. I have been reading about flexgrid and list boxes, but am not clear on how to...