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 Chriss Miller 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. basquiat

    WSS 3: OneNote Shared Notebook - Vista

    Hi I've created a shared Notebook in a library on Sharepoint Services (Small Business Server 2003)...it works just fine from all XP workstations. Trying to open the shared notebook from Vista returns the following in OneNote 2007: 'OneNote cannot find the file specified' And after clicking...
  2. basquiat

    Combo Box selection updated to different Table

    Thanks Jebenson; Nice links! Thanks you;
  3. basquiat

    Combo Box selection updated to different Table

    Hi I have (I'm sure) a very basic SQL Server 2000 and VB.NET question; To simplify: I've got two tables on SQL "Employees" and "Transactions"; "Employees" has one Field... "EmpNo" and "Transactions" has 3 Fields... 1) "TransNo" (Primary and Identity) 2) "EmpNo" (Foreign Key) 3) "Amount" Now...
  4. basquiat

    Running Total of Info not Displayed

    Thanks lbass; I changed the way the report was grouped and followed your advice above; Works fine now; Thank you very much for the help;
  5. basquiat

    Running Total of Info not Displayed

    There's a field "AccNumber" holding the account numbers; Then there are 24 fields with the balance/movement for each month of the current year (BalanceThis01, BalanceThis02 .... BalanceThis12) and previous year (BalanceLast01, BalanceLast02 .... BalanceLast12); The balance field holds only the...
  6. basquiat

    Running Total of Info not Displayed

    Thank you for the feedback; Both your methods still give me the error…“running total cannot refer to a print time formula” I think it’s because it’s doing the calculation during pass #2 and I need it during pass #1? I am trying to write a Balance Sheet (for Financial Statements); The report is...
  7. basquiat

    Running Total of Info not Displayed

    I’ve got the following very irritating problem… I’ve got a table with 2 fields, account number and balance; Account Balance A 100 B 200 C 300 D 400 E 500 F 600 On my report I only want account D, E and F (in that order) and the balance next to...
  8. basquiat

    Need help creating addition formula

    I’ve got the following very irritating problem… I’ve got a table with 2 fields, account number and balance; Account Balance A 100 B 200 C 300 D 400 E 500 F 600 On my report I only want account D, E and F (in that order) and the balance next to...
  9. basquiat

    Conditional % Format

    Thank you very much!
  10. basquiat

    Conditional % Format

    Hi I've got a report with a formula field; Depending on the paramater selected by the user, the field should be displayed either as a number or as a %; Is there an easier way of doing this apart from adding another formula field with a % format and suppressing the fields based on the...
  11. basquiat

    Total of some of the Subtotals?

    Thank you, worked 100%;
  12. basquiat

    Total of some of the Subtotals?

    I've got a Income Statement report with a group called 'category' based on a account type code in the table; I gave this group a 'specified order' and with a formula divided it into 4 Named Groups Income, Expenses, Interest, and Tax; Each group has a sub total and there is a grand total, which...
  13. basquiat

    Grouping Grouped Totals?

    Thanks! It's doing the trick; But since the formula is now group1, it sorts it according to this group/formula; I've got 4 categories "Income,Expense,Interest & Tax"; How can I get the groups in that order since it's not ascending nor descending?? Thanks for your help!
  14. basquiat

    Grouping Grouped Totals?

    I'm using Crystal Reports 8 I am trying to create an Income Statement based on a Transaction Table; The table has an entry for each and every transaction captured; So there would be more than one entry per account type/code; For example... AccCode: AccDescr: Amount: 1000...
  15. basquiat

    VB Help with AR1300 UI

    Thanks! You helped alot!
  16. basquiat

    VB Help with AR1300 UI

    Thanks for the help Jay; I've tried your code but got..."Can't assign to Read-only property"; Any ideas?; Thanks again for the help!
  17. basquiat

    VB Help with AR1300 UI

    Thanks Zemp, that did the trick; If you wanted to remove certian fields from the UI, would you do it through Accpac's customize feature or can one remove it in "design mode"?; I managed to add text boxes to the UI; But couldn't remove text boxes or add additional tabs;
  18. basquiat

    VB Help with AR1300 UI

    Thanks Jay I couldn't find any online help on the UI info utility; Let say I wanted to for example change the description on AR1300, the customer screen, from 'Zip / Postal' to 'Postal'; I guessed, from the UI utility, that the labels name is 'afecARCUScodepstl' and that I'd be able to change...
  19. basquiat

    VB Help with AR1300 UI

    I am a new Accpac Advantage 5.3A user; I would like to customize the customers screen for my "CRM" staff; I've created a Data Link from VB to Access; And opened the AR1300 UI; Is it possible to cutomize this screen?; Remove tabs, change descriptions etc.? And... All the tables are accessible...
  20. basquiat

    Help with Basic - AR UI

    Jay, I am getting "compile error: Method or data member not found" on adsGroup. Any idea why? Thanks

Part and Inventory Search

Back
Top