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: *

  1. ilanilan

    Changing Optional fields in Accpac

    Thanks so much for all your efforts, but I worked out that I was missing (') in front of my string and that was the reason it was not importing into the data base! Have a great week end - Sorry for any inconvienence I may have caused you.
  2. ilanilan

    Changing Optional fields in Accpac

    Thanks so much for all your help ! Much appreciated, I hope I am not being too much of a pain... but... I was unable to detect the name of the optional field I had origionally created. I followed your clear instructions by locating the sub folder "TYPE" for CSOPTFH, CSOPTFD, ICOFD,tables but...
  3. ilanilan

    Changing Optional fields in Accpac

    Thanks so much for the data base tables that need editing - although when I tried to run a "Microsoft Query Wizard" from Excel 2007, I did manage to find the tables but when I reached the last step of the wizard i received the following error "Incorrect syntax near the keyword 'VALUES'...
  4. ilanilan

    Changing Optional fields in Accpac

    Error after trying to delete from IC Description: Incorrect procedure. You cannot delete optional field ITEMUNITQTY because it is in use in Inventory Control. Source: 13:02:02
  5. ilanilan

    Changing Optional fields in Accpac

    I tried to delete in Inventory Control after the message appeared when i tried to delete in common services..Both do no work for me... the error message is : same as before :Cannot delete as it is being used by inventory control"
  6. ilanilan

    Changing Optional fields in Accpac

    I tried to delete it but the error message pops up, "Cannot delete as it is being used by inventory control"
  7. ilanilan

    Changing Optional fields in Accpac

    I am unable to edit the type of string my optional field has been originally set up as. Eg changing from a text field to a number field. How is this done? Thanks so much for any help! BTW i am the end user...

Part and Inventory Search

Back
Top