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...

77 - I still haven't found a workable solution I want to use. Tricerat has a product called Simplyfy Printing which looks like you can configure how the printers are named. The product is used mostly for print driver elimination and looks like it needs a client install. Too much overhead...

77 - Did you ever find an answer to your question? I am having the same problem but with the Macola application. Macola will remember what printer you last used for a report but it remembers it with the TS session number appended to the end of the printer name. When you reconnect and get a...

The ironic thing is, I only did this upgrade because of a fix to that particular program. Before when you clicked the PO line review button the window popped up over top the first window, and then the user would have to move the line review window to see what's behind it. They had to do this...

My last post was a shot a Exact, not this board. You guys here have been a great help when I've needed it and you've provided the help on your own time. Its odd you couldn't replicate that problem, when I called Exact, the tech experienced the exact same problem as I did using their own...

I've gotten the same response from Exact that I got from this post. Nada. Two days, no reply to my support call. The difference is, I'm paying Exact for an answer and this is the first time I've gotten no answer from this board on a problem.

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...

That formula gives me an error that the keyword then is missing. I need more detailed information than that to complete these two formulas.

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...

It is a continuous form. Basically the form lists (in the detail section) all of the items used by the service guys. Each record is assigned a loc (location) code. I would like to have a field show the location's name from the table where the locations are stored. If I use this as the...

If I put the dlookup command as the control source for a unbound textbox will it work on a detail line? I've been trying it out and so far all I can get is the same answer for all the detail lines.

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...

There are no triggers on the underlaying table.

MS SqlServer 7.0

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...

Thanks PHV, works great.

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"...

I am aware of the Add/Delete Item Locations application. However, I don't need locations for every item for every location. My users just want to be able to create locations "on the fly" that will create all the locations they need. I was able to do this with a trigger that calls a stored...

Duh!! Thanks Denis that did it.