Search results for query: *

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

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

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

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

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

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

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

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

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

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)

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 ?

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

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

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.

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

I have excatly the same situation on a time sheet entry site, what I did is created an SQL function that calculates the differential and give the result on the post back. The SQL is very easy to write using the DATEDIFF() function

I am curious to know what type of field you used in the cr form ? As far as I know there is nothing to show images dynamically in CR

Your customer might want to consider another option that we use and it works very well for us : Since you don't usually want to track everything you might consider the option of using triggers on some tables in the ACCPAC database and create an "Audit" database where you keep what the customer...

You simply create manually the datagridview and use a DataGridViewComboBoxColumn binded to that column

I want to know if anybody tried or succeeded doing this : I want to move some ACCPAC reports to OLE-DB instead of ODBC connections (excluding any datapiped reports of course). When I change the connections to these reports using OLE-DB I have no problems printing them from the Crystal Reports...