Search results for query: *

System Error: File cmcurcod.btr is not open We started getting this message when using Order Entry / View / Order View / By Customer Number view. The company I am in has never even had Currency Manager turned on, so I don't know why all of a sudden it would look for this file. We upgraded...

I upgraded to 7.6.300c SQL (from 7.6.300b) over the weekend. Now, when we try to receive against a PO, and get to the Line No. field and press F2, we get the PO Line Review window but the OK button is grayed out. But, if we type in the Line No. and then press the Line Review button, the Line...

I have a SQlserver table with the following fields. Emp_id, clock_in, clock_out, and hours_worked. Clock_in and _out are datetime fields. On my report I want to show the clock_in time as 7:00 if they clocked in between 6 and 7. Also, if the clock_in time is set to 7 I obviously need to...

I have a form that lists all of the inventory items our service guys used. Each item is assigned a code indicating who the service guy was that used that part. The service guy code corresponds to another table that stores their code, full name and other data. My question is, how do I display...

I have a form that users should be able to both update or add records. If they add a record by filling out all appropriate fields and then go to the next record (using the enter key)to enter another item, all of the fields of the record they just entered say "#Deleted" in it. But if I exit the...

I have a PO receiving form. Right now my users have to go to each item and enter the received quantity [rec_qty]. But I'd like add a button that would update the [rec_qty] field to equal the [qty_used] field for every item displayed on the form. Once all the records are updated they can then...

My database stores dates in YYYYMMDD format. I have a form that inputs dates in a date format i.e. 2/6/2006. I am trying to convert this into the YYYYMMDD format to save to the database. So far this is the code I have. nYear = DatePart("yyyy", [receiptDate]) nMonth = DatePart("m"...

Has anyone created a trigger on the table iminvloc that would automatically create item locations for each location defined in imlocfil? Every field would be the same except for the "loc" field. My users want to create one item location record and have all of the others automatically create...

I've never created a trigger and need some help. I have an inventory location table (iminvloc). Everytime a new record is inserted into this table for location "20V", I'd like to insert a duplicate record in the same table, except for the location field, for every location defined in another...

I am trying to use an access query to create a comma delimited text file. I need to include a sequential line number with each record. My current query is like: select field from table My output from this is like: field_data field_data etc. But I need my output to look like: 1...

IS there any reason for me not to delete old work tables, for example GLJNLxxx_sql, OEDISxxx_sql, BMREQxxx_sql? I have almost 1000 of the GL and OE tables and it makes for alot of scrolling when going thru the list of tables.

How do they stay in business? Their software is horrible. Doing a Macola upgrade is a freaking nightmare. We recently upgraded from 7.6.100a to 7.6.300b. I am still (3 weeks later) trying to fix every issue that has popped up. Here are the two most ridiculous problems I've encountered that...

I just upgraded from 7.6.300 to 7.6.300b and I get an error when I try to open a few screens. When trying to open the Vendor Maintenance screen I get a Microsoft Visual C++ Runtime Library box that says Runtime Error! Program m:\macsql\MacExe.exe abnormal program termination Then a MSL...

Has anyone ever tried to convert data from Visual Manufacturing (v6.2.8.009 MSSql)to Macola (V7.6.100a MSSql)? I am trying to create three tables from Visual data: inventory master, inventory master/location, BOM product structure. The first problem I came across is that some of the Visual...

Is there a way to set up a A/R service code so that you can change it's description when a service code item is added to an order? Using version 7.6.100a

Using Crystal 8.0. Most of my reports use a date range parameter, usually first and last day of the month are selected. Is there a way to have the beginning and ending dates in the range default to the first and last day of the current month? Now they both the start and end dates default to...

I am looking to upgrade to 7.6.300. I currently run 7.6.100a, Microsoft SQL, all users connect via Citrix. Does anyone know of anyone in the Balt-Washington area that can help us with this upgrade? We've had problems with Macola's support people on previous upgrades. When we went to SQL...

I am trying to copy data from a table in one database to a table in another database. The two table definitions are the same. The catch is that I need to modify some of a certain field's data to avoid duplicate data. For example, if I try to combine the two customer master records I must...

I am creating a spreadsheet that directy queries my Macola database (MS SQL server). My question is how do you bring in a Macola date field that is recognized as a date by excel? If I use this expression in my select statement I get a text field in Excel that looks like a date...

Can some simply explain what Flexibility is? What can you do with it? How do you know if it's installed, I know we're licensed for it. And is there any training available? Thanks ...