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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by johnny9864

  1. johnny9864

    I have an issue in the .Net library AP Sage300 (Version 2019)

    I have an issue in the .Net library I have no issue creating a vendor using a macro: Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkSysRW = OpenDBLink(DBLINK_SYSTEM...
  2. johnny9864

    .net existing sessions

    I used many times in the past the login process in .Net libraries but I need in a new project to know where the user is logged in. Is there a way to figure out what is the current logged in session(s) or at least to what company it is logged in ? I found some mention of an object called...
  3. johnny9864

    Hi all, I am very familiar with ver

    Maybe there is nothing wrong with using CR as the report engine but the real problem is using ODBC as the connection method for the reports. I have a customer using item descriptions that take about half a page in that case the ODBC connection cuts the text. At least if I had the possibility of...
  4. johnny9864

    Hi all, I am very familiar with ver

    Hi all, I am very familiar with versions 5.x, I was wondering if in present versions 6.0 and up Sage made at least an effort to correct the big obvious problems: Being a local administrator to run ACCPAC Using ODBC as the only connection for reporting Using Crystal Reports as the only...
  5. johnny9864

    How does one graphically print aspx files?

    It is not possible because a lot of the controls are not known to the html, the code is interpreted into html native code. The only thing I can think of is a screen shot from the design view
  6. johnny9864

    ASP.Net with SSRS vs Crystal Reports

    I faced the same decision for our projects and I came to the conclusion that there is pros and cons to SSRS and CR. In some cases I found that one is better and vice versa depending on the customer and the type of report. So I came up with this solution that is pretty simple and lets the...
  7. johnny9864

    Change order by in a selectcommand using parameters

    I do not know Access, but in SQL a stored procedure would look like this : DECLARE @Statement nvarchar(255) Set @Statement = 'SELECT * FROM [THISTABLE] ORDER BY [' + @Orderby + ']' EXEC @Statement Where @orderby is a parameter for the sp Maybe this can be applied somehow to Access or at...
  8. johnny9864

    Frames without frames

    Thank you both for your inputs, it seems ,like I originally taught, that it is not possible outside of normal asp.net coding. I will use an HTML frame for now and see in the future if it is possible to recode that starting page. The only solution I came up with is to do all the coding in the...
  9. johnny9864

    Frames without frames

    Ok a better view of I want to do: Lets say I develop pages to maintain stuff with each their own code behind for example EditEmployess.aspx, AddEmployees.aspx, etc... All these pages of course have no menus or anything, just the Data showing and edit controls. Then My Default.aspx presents...
  10. johnny9864

    Frames without frames

    That is easy to do yes but thameans I lose the code behind and all other code for the page. Or can I set the code behind within the div. (I don't think so)
  11. johnny9864

    Frames without frames

    I want to write an app with a treeview on the left and the corresponding page on the right. Perfect frame scenario. Can I replicate this in asp.net where when i click on the left tree, the right "frame" updates with the content of a page ?
  12. johnny9864

    Item pricing based on order total.

    I was looking at item pricing with one of my customer and they had a question. They would like to give a discount on an order not on a single item based on the quantity but rather based on a type of items based on the total purchase. These items are grouped by a IC Category. In other terms...
  13. johnny9864

    The damned finders

    Is there any way I could setup the finders when I am trying to open documents to show me recent documents instead of documents from 1997 first ? When I search for item numbers and things like that its fine to have the order by alphabetic order but for documents this extremely annoying, there...
  14. johnny9864

    Notify icon to all employee computer's when adding new employee

    Since you are using SQL, the best thing to do is to use SQL notifications, it's very simple to implement in C# and reliable. I implemented that in 2008 for a customer that deals with a list of members and I even notify if a second employee opens a same member.
  15. johnny9864

    SharpDevelop : Need some guidance

    You will have a lot of reading to do :-) 1- Form.Show() or Form.ShowDialog() 2- Read everything you can on the notion of datasets, datatables, SQLconnections, Datareaders, SQL adapters and I am probabelly missing some

Part and Inventory Search

Back
Top