e_espinosa6's Q&A profile
SQL Server Run-Time Error
Private Sub cmd_DeleteTables_Click() MsgBox "Click yes when prompted to delete records" Dim sqldel As String sqldel = "DELETE tbl_physical_main.*, tbl_physical_main.[Material Number] FROM tbl_physical_main WHERE (((tbl_physical_main.[Material Number]) Is Not Null))" DoCmd.RunSQL sqldel, no sqldel = "DELETE tbl_noDataForTag.* FROM tbl_noDataForTag" DoCmd.RunSQL sqldel, no sqldel = "DELETE tbl_SAPmaterials.* FROM tbl_SAPmaterials" DoCmd.RunSQL sqldel, no MsgBox "All previous inventory data has been deleted and the next inventory load may continue." End Sub -------------------------- Run-Time Error '94' Invalid use of Null Please help me! When you come upon these types of problems, prind out the commands tha ...Show All
Windows Forms Permanent Cropped Image In Picture Box....
Hi everybody, Do you have idea how to make a cropped image permanent inside a picturebox control I have a first image loaded into a picturebox control then I crop(cut/get) part of that image, but when the form lost focus and then return to focus, the first image is seen in the picturebox which should be the cropped image. Please provide codes. Thanks in advanced. [code] private void CropImage() { //bCrop = true; if (cRect != Rectangle.Empty) { Rectangle sRect = new Rectangle(); sRect.Location = pictureBox1.Location; sRect.Size = pictureBox1.Size; pictureBox1.CreateGraphics().DrawImage(pictureBox1.Image, sRect, cRect, GraphicsUnit.Pixel); // ...Show All
SQL Server Opening package stored in MSDB
I created a package using the Import\Export wizard and saved it to the local Sql server. Under Management Studio I can see the package, can run in, import it, export it BUT how am I supposed to edit (modify the thing) it TIA, barkingdog In SQL 2000 one edited and managed DTS packages in the same environment. This was perhaps ok when packages were simple utilites for the DBA. But in SQL 2005, SSIS Packages are much richer objects and have a full developer environment to support them, as well as a better management environment. So in 2005 we have BIDS for developing (editing) and Management Studio for administration of deployed packages. Just like a code project, one typically develops in a spec ...Show All
Windows Forms GUI Design Issue
I'm trying to build a GUI for my application, I'm having a problem deciding the best way to Design the GUI. The end user wants to be able to create a grid like scenario. Ex: ----- LTA ------- 70 80 90 680 GrpA GrpB GrpC FCA 600 GrpC GrpA GrpB 500 GrpB GrpC GrpA Lets assume this is a grid of scenarios my end user wants to describe. FCA and LTA are Values from a database Table. GrpA will be all Customers with: LTA equal to 70 and FCA equal to 680 {plus} all customers with LTA = 80 and FCA=600 {plus} all customers with LTA=90 and FCA =500 Same kind of deduction goes for ...Show All
Visual Basic Can someone please explain to me how view a file on a remote computer
I am new to vb.net and am struggling on setting up the connection string to a remote computer so that I can search log files for error messages thank you, paul Hi Paul Ok ... How are you connecting to the clients Is it feasible to copy the text file from the remote machine and then check it (System.IO.File.Copy) Richard ...Show All
SQL Server C# and SQL Express
hi Y'All! I've been having quite some fun doing C#, im doing an accounting system just for the fun of it. I find C# quite user friendly (though Im using the express edition). Its not really that cryptic. Though one must be able to grasp the concept of OOP. Well, enough praise about the language, I know i wont get any freebie anyway. Just some question though. 1. Im planning to use SQL Server express as backend, right now Im using firebird and plan to change backend. What are the limitations of SQL Express edition like can I use it in providing for example a network of 10 users with an accounting application. 2. I plan later to create a C# program (windows application) that will access a database for example in the internet, the da ...Show All
Visual Basic Html Table to datatable?
Does anyone know how to fill a datatable from a html table scheme Example: <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4> <TR BGCOLOR=#ADAEAD> <TD COLSPAN=3><B>Data</B></TD> </TR> <TR BGCOLOR=#FFFFFF> <TD>Name</TD> <TD>Favorite Color</TD> <TD>Language</TD> </TR> <TR BGCOLOR=#FFFFFF> <TD>Steve</TD> <TD>Red</TD> <TD>Spanish</TD> </TR> </TABLE> To a datatable containing the elements: Data Name Favorite Color Language Steve Red &nb ...Show All
Windows Forms Decompile .NET
Hi all I am wondering how to protect .NET applications from being decompiled or in other word prevent it from reverse engineering I hope of any one can help Thx all Hi, you're looking for .net obfuscation ... Hope this helps, Andrej ...Show All
.NET Development How to read array returned from Web Service method
I am trying to take the output array from a web service and move it into a datatable using c#. I have a web reference to the service as well as a proxy. The WSDL is: < xml version="1.0" encoding="utf-8" > <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetSitesForContactResponse xmlns= http://companyA.com/pms > <GetSitesForContactResult> <SiteResult> <SiteId> string </SiteId> <SiteName> string </SiteName> <Address> string </Address> <Address2> strin ...Show All
Windows Live Developer Forums R
I'm having some trouble implementing suggestions from this WIKI entry: http://viavirtualearth.com/wiki/fullscreen.ashx I did a modest amount of experimenting. It seems to be OK whenever I have coded this way: <div id='myMap' style="position:relative; width:100%;"></div> and fails to render map at it if changed to be like this: <div id='myMap' style="position:relative; width:100%; height:100%;"></div> In other words, the presence of height in the style results in no map (both IE6 and FF 1.5.0.9). I'm assuming your using the first method as described in the wiki Sounds like theres something you've added into the code thats interfering with ...Show All
Visual Studio Express Editions How to sense when a usb drive is disconnected?
I need to be able to sense when a usb drive is disconnected. I can do it with a timer and check ever so often to see if Drive exist. But I would like to tap the raised event when the drive is disconnected. Can/how I get to the operating system event from Visual basic express Thanks Dave Thanks ReneeC, WMI is a little steep for me now, I have a bunch of other stuff to learn first. I thought about polling it with a timer, but decide to just check the drive on mouse clicks. I will make a call to this sub on mouse clicks. Ugly but workable. Public Sub CheckDriveExists() ' datafilepath is drive and file path Dim Drive As New DriveInfo(datafilepath.Substring(0, 1)) If Drive.IsReady Then exi ...Show All
.NET Development programatically Accessing the Mail
hi, my task is programatically accessing the mail server whether it is hotmail/gmail/yahoo etc using vs2005 C#.Means fetching the my inbox contents into my machine.Can you please suggest me some good references.Its very urgent and i am new to these technologies.Please give me solutions. Thanking you inadvance A.suneel. Basically we do not offer mail retreival APIs in the .Net Framework as of version 2.0. We are considering adding these in a future release and feedback such as this is very helpful. If you need to do this through managed code, then you may want to search the internet for a POP3 and/or IMAP4 implementation. POP3/IMAP4 are the typical protocols used to access mail fro ...Show All
Visual Studio Tools for Office VS 2005 Pro, VSTO and Office 2003 Professional Enterprise Edition
anyone, i'm sorry if you've answered this question a hundred times. i looked through all your FAQ's and comments and the web in general on the compatibility of these programs and tools. On my work computer supplied by Intel, I'm running Office 2003 Professional Enterprise (has Infopath), VS 2005 Pro and VSTO (trying to run). i'm aware from your requirements from the MS Product Info page that you need the standalone versions of Excel, Word and Project or whatever since i'm running the Enterprise version of Office 2003. i don't understand why you need a less powerful version of Office 2003 with the integrated versions of those apps for this to work. is there a config, a fix or patch to downgrade my Office 2003 Pro EE (remove InfoPat ...Show All
SQL Server Maximum number of subscribers and Transacational replication.
Hi: Is there a limit on the number of subscribers for Transactional replication . My question is how many maximum number of subscribers can we have in transactional replication . How do I retrieve this information throug T-SQL (any DMVs or system tables ). Please let me know. I am looking to know for both SQL 2005 as well as SQL 2000 and also if anyone can tell me if anything has changed in SQL 2005 for transactional replication that would be great. Can anyone please let me know . Thank you AK Hi there, You can check the following article for new replication features and improvements. http://msdn2.microsoft.com/en-us/library/ms170959.aspx One of the performance enhancement feature is mul ...Show All
.NET Development Getting process owner
Hello I have been doing this simple util that allowes me to filter our products process information. There are few information that I can't get out. Like the user name who owns the process and the session ID. I have tried to search msdn put no luck. If that info is not found from system.diagnostic could you point me the way ...Show All