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!

  • Congratulations SkipVought 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. Tolambo

    refresh DataGrid

    Hi Myrtos Lets us understand this: 1 - Your OccCode is updated nicely right? 2 - Your Occdescr does not update immediately right? What this tells me is that you need to insert the SQL code which populates your Occdescr (source) column to a timer. Set the Timer interval to 2000 milliseconds or...
  2. Tolambo

    refresh DataGrid

    HI MyRTOS Datagrids are generally easy to handle. Most people seem to think you should code most of your vb objects from scratch but i say why re-invent the wheel? Set your datagrid's source to pick from an SQL command located in your data environment. At an event like column change or edit...
  3. Tolambo

    Loading AccPac 6.5 Files

    Hi Jay, i suppose nibhatt's trouble would be at the level of pathing? If you are already running ACCPAC on the stand alone PC what you probably wanna do is add the company to the start list but specify the path the application should use in obtaining the data which you have on the CD (i suppose...
  4. Tolambo

    Invoice & Recipts

    HI Hahsia Depends on what you would like to achieve. I do this all the time. I'd say you keep to your company policy (in what currency are your final reports prepared?)use whatever source currency you use for your accounts...in this case JPY and then apply the relevant exchange rate to obtain...
  5. Tolambo

    calculating the percentage

    Hi, You should insert a formule (@formula) and place it on your crystal report. The report should read: {Table.Field}*5/100 This will cause the Formula field to hold the 5% value. hope that helps: you may also include "if else statements" if the percentage changes
  6. Tolambo

    Parameters with wildcards

    Ngolem, That was a useful piece there. To avoid the proverbial Error Message "String Missing here.." one must make sure that the Parameter {?Detail} is defined as a string and that it is not a range. Crystall (with ACCPAC) usually will only allow you to use that code if the detail is a discrete...

Part and Inventory Search

Back
Top