laughsloudly's Q&A profile

• Visual Basic Creating totals from imported data

  Hi, I have an access database linked to a data control and the relevant record source(s) called via SQL. Currently the data is output to a picture box and is selectable by date. What I am looking for is to select a range of items (all sales on the same date, all sales within a range of dates, that of monday through sundays date and also monthly) and show the total amounts for printing. (Sorry I'm having trouble thinking how to explain this!) Hi Mattneck, I think you'r looking for a way to filter some records by date for example: get me all records with date field between 1/12/2005 to 30/13/2005. ...Show All

• SQL Server Insert or Update null if the value is zero using Trigger on table

  Hi , I have 2 tables (Dept and Emp) The columns in table Dept are Deptno and Deptname. Deptno is bigint and it is primary key. In Emp table, columns are Empno(PK) ,EmpName and Deptno(foreign key referring to Dept) To Insert or Update record in Emp through application, value of Deptno is coming as 0(Zero). I want the value of Deptno to be inserted or updated as null if the value is Zero (0). How to do this in sql server 2005 by using trigger on table Emp Thanks in advance regards, Srinivas Govada I have a solution on sql server 2000, but I think there isn't many difference between 2000 and 2005. CREATE ...Show All

• SQL Server Images aren't being displayed in deployed Reports

  Hi everybody, When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images. But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed! I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!! Does anybody have any idea about what might be happening Thanks a lot!! Hi Rodrigo, I am also facing the problem similar ...Show All

• Visual Studio Team System Testing TFS with virtual server 2005

  Hi, Is it possible to test TFS With virtual server 2005 We would like test TFS- before making any decision. We are planning to start use TFS in our small size software company. We have very limited resource, that why it is import test TFS on virtual-server, if it is possible Yes! You can setup TFS on Virtual Server. Thanks, Wesley ...Show All

• SQL Server Upgrade to SQL Server 2005 Developer Edition

  I installed SQL Server 2005 Express Edition under Windows XP SP2 Home Edition. Am I able to upgrade to SQL Server 2005 Develeoper Edition According to http://download.microsoft.com/download/3/f/2/3f2a98cf-6a47-4927-9360-dc1c04de6e42/RequirementsSQL2005.htm it should work. Thank you.  Upgrading between Editions (Express -> Developer) isn't support in the June CTP. It is expected to be supported at RTM. Dan ...Show All

• Visual Studio Tools for Office Excel Capacities

  Are there any constants or functions available which gives Excel capacities like maximum rowheight, maximum columnwidth, max rows etc. Currently i have to check from documentation and create my own constants and functions which validates all these... Peter is correct as to the max rows value. For a longer list that compares current limits with upcoming Excel '12' limits, see David Gainer's blog: http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx ...Show All

• Visual C# How to Read/Write DBF file In C# use OleDb

  See the topic! Give me an example to show me how to do this ,thx! And my msn is  i_will_communicate_through_this_forum@msdn.com  I can't insert a Datetime Object into the DBF file,why Hi pj. I Try it by use Hard-code to insert data.It can insert new rows into DBF files. but when I change it to use OleDbparameter ,It can't work now. I don't know what's wrong with it. I think may be : 1,The Datatype Change wrong. OleDbType.Type is not fitted in DBF Type. like Logic(Query Out is T or F). 2,Make Parameters wrong. ...Show All

• Visual C# implement IEnumerable<T> multiple times

  Is it possible to implement IEnumerable<T> multiple times as shown below and then simply call foreach on types of INode and Page as in the code below without casting inside of the foreach statement to the IEnumerable<T> the client wishes to enumerate I get the following error: foreach statement cannot operate on variables of type 'Page' because it implements multiple instantiations of 'System.Collections.Generic.IEnumerable<T>', try casting to a specific interface instantiation public interface INode : IEnumerable < INode >{ } public partial class Page : INode , IEnumerable < ...Show All

• Visual C++ _tmkdir

  Can any one tell me if write permissions to the particular directory are sufficient for _tmkdir to create a new sub directory or are any higher permissions required. Thanks, KarthikR Hello KarthikR, The access rights for a directory are assigned by the administrator of the computer and generally should not be reassigned by a program. You'll note that C++ does not provide a way to alter or even read these access control lists. In order to find out what access rights you have for the folder, open up the folder's properties (in Windows Explorer) and choose the security tab, then Advanced. In this UI, the FILE_ADD_SUBDIRECT ...Show All

• Visual Studio Team System How to import TFS Users as Project Resources

  I have a new TFS project which has a number of our Active Directory users assigned with permissions. Our AD Friendly names are in the form "lastname, firstname". When I Get All Tasks from TFS in Projects, each name appears as two people. (E.G. Doe, John in AD appears as users Doe and John in the Project Resource Sheet.) Is there a way to get the TFS users into Project without having to change our AD I am too small a fish to force a company wide AD change! TIA Ron L I have seen many threads on this issue. This one suggests some possible work arounds. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=277816&S ...Show All

• Visual FoxPro Determining opened files

  I would like to ask if anybody knows how to determine how many files are there in a form during run time. Yes I mean "tables", sorry about the confusions. Well I also found another way to get the number of tables used a by form. "nTotMem = AMEMBERS(amems,THISFORM.DataEnvironment,2)" Thanks ...Show All

• Visual C++ Exporting const static data members to dll

  Hello there, I am using VC++ 2003. I have a class somewhat like this: // C.h class __declspec(dllexport) C { public: const static float CVALUE; static void foo(); }; // C.cpp const static float C::CVALUE = 10.0f; void C::foo() { } When I attempt to call C::foo() from an external program using my dll everything is fine. When I attempt to access C::CVALUE I get a linker error like this: error LNK2001: unresolved external symbol "public: static float const C::CVALUE". I checked the dll with Depends.exe and it seems that the symbol C::VALUE is being exported. Do you guys have a ...Show All

• Visual Studio VS.net 2003 Eval. UNINSTALL. "Setup is unable to determine a valid ordering for the installation."

  I tried uninstalling it and get a msgbox saying: "Setup is unable to determine a valid ordering of installation. See error log for further details" Where is this error log How would I uninstall I which MS can for once wake up and make something uninstall and not also fail on uninstall. A fat joke it is... Can you try uninstalling from the CD Something may be messed up with the cached version of the installer or the files on your box are corrupt causing this error message. ...Show All

• Visual Basic VS 2005 VB Templates

  I want to create a new template project for VS 2005. A VB 2005 project. I have read a bit online, but the information I am finding does not sync up with what I see in my Harddrive folders. I see many templates via the IDE, but I cannot locate them on my HD. I find similiar onex in my VS 2003 folders, but not under Visual Studio 8. Are there MSDN type reference material out there on how to do this these two MSDN links should help you create templates and full applications to use as templates. http://msdn2.microsoft.com/en-us/library/ccd9ychb.aspx http://msdn2.microsoft.com/en-us/library/ms185318.aspx Cathal ...Show All

• Visual Basic Updating Databases

  How do I prevent duplicate entries when working with ultrawingrid in VS 2005 I'm using a SQL database. I'm not fimiliar with ultrawingrid..but from a database perspective...a primarykey field keeps duplicate entries from being made.....so if I set up column 0 as a primary key field then the db will not allow any duplicate entires for that field. HTH ...Show All