Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PhilPPhillips
  • Order by date
  1. PhilPPhillips

    System Error: File cmcurcod.btr is not open

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

    keep same session in terminal services

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

    keep same session in terminal services

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

    PO receiving problem

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

    PO receiving problem

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

    PO receiving problem

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

    PO receiving 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...
  8. PhilPPhillips

    Adjusting clock in time

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

    Adjusting clock in time

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

    Display field in Detail section

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

    Display field in Detail section

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

    Display field in Detail section

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

    I get "#Deleted" in every field after going to next record

    There are no triggers on the underlaying table.
  14. PhilPPhillips

    I get "#Deleted" in every field after going to next record

    MS SqlServer 7.0
  15. PhilPPhillips

    I get "#Deleted" in every field after going to next record

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

    updating all records displayed on form

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

    help with dates

    Thanks PHV, works great.
  18. PhilPPhillips

    help with dates

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

    insert trigger on iminvloc

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

    insert trigger help

    Duh!! Thanks Denis that did it.

Part and Inventory Search

Back
Top