tjams's Q&A profile

• Visual Basic 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 DoCmd.RunSQL sqldel, no after delete the record I have run time error, Please advice. Gee1 ...Show All

• Visual Studio 2008 (Pre-release) Multiple Service Hosts for single MSMQ/clustered MSMQ

  How can I have service hosts, running on different servers, and bound to netMsmqBinding all pointing to the same MSMQ I need this to a) have a service host use a clustered MSMQ, and b) support scale-out by simply adding additional servers. When I try to set the service endpoint address to point to a Queue that is not hosted on the same server as the ServiceHost, no errors are reported but no requests are processed. Hope some can help. Thanks It will work if your WCF service application runs in the same cluster context as MSMQ. If the service runs outside the cluster context or on some other machine, it will need remote transaction read functionality which is available only on Vista. ...Show All

• SQL Server Displaying inividual fact details in report body

  I have a dimension for account and measures for time taken for editing etc. which provide a sum of minutes taken to edit all documents in each account. The requirement is on clicking on the account link to be able to get details regarding each document in every account. for each document, I would need to display editor name, time taken, document type etc. How do I display details that are not an aggregation along the rows but individual details of each document I would suggest using the drillthrough mdx command - more details @ BOL: http://msdn2.microsoft.com/en-us/library/ms145964.aspx ...Show All

• Software Development for Windows Vista LoadLibrary Failure

  I am trying to load a standard library XLCall32.dll from within a stand-alone C# app using LoadLibrary and LoadLibraryEx. The code I am using is: //Imports... [DllImport("kernel32.dll")] private static extern IntPtr LoadLibraryEx( string dllFilePath, IntPtr hFile, uint dwFlags); [DllImport("kernel32.dll")] private static extern IntPtr LoadLibrary( string dllFilePath); //Call to code: string dllFilePath = "PATH_TO XLCall32.dll" System.IntPtr hmod = LoadLibrary(dllFilePath); System.IntPtr moduleHandle = LoadLibraryEx(dllFilePath, IntPtr.Zero, LOAD_WITH_ALTERED_SEARCH_PATH); The return value is zero and the dll is not being loaded. Checkng the dependenc ...Show All

• Visual Studio 2008 (Pre-release) Svcutil - July CTP - Metadata contains a reference that cannot be resolved

  Hi, I just wanted to try some sample code and generate the proxy with svcutil. The service is self hosted and I'm running into: C:\Program Files\Microsoft SDKs\Windows\v6.0\Bin>SvcUtil.exe http://localhost:80 01/Weather/out:proxy.cs Microsoft (R) Service Model Metadata Tool [Microsoft (R) Windows (R) Communication Foundation, Version 3.0.4312.0] Copyright (c) Microsoft Corporation. All rights reserved. Attempting to download metadata from 'http://localhost:8001/Weather/out:proxy.cs ' using WS-Metadata Exchange or DISCO. Microsoft (R) Service Model Metadata Tool [Microsoft (R) Windows (R) Communication Foundation, Version 3.0.4312.0] Copyright (c) Microsoft Corporation. All rights reserved. Error: Cannot obtain Metadata from http://local ...Show All

• Visual Studio Bizar ReportViewer toolbar is present, Report and data absent

  We have a real bizarre situtation when the report viewer on a page that is using a master page. When the report rendered contents appear within a html TABLE tag, everything is fine, we are able to see the report tool bar and the data.. The problem arises when we switch the master page and the report viewer control now sits under a contained DIV tag in the master page..When this condition happens, we are seeing only the tool bar but not the report contents..All the parameters for the report are the same.. We are wondering if you guys have seen or heard of issues like this with the report viewer. Here is the partial listing of the generated html when we are seeing the problem. I wonder why the style is set to display:none for the If ...Show All

• SQL Server SELECT Query duplicating rows

  Hi, I have a small problem that i cant seem to get my head around regarding the results of the following SELECT query. The result set contains two rows for every Employee - one for Annual (EntitlementID = 1) and one for Long (EntitlementID = 2) Where have i gone wrong Thanks in advance. --Tables: Employee (EmployeeID, EmployeeCode) -- EmpEntitlementValue (EntitlementID, EmployeeID, Balance) -- Entitlement -- Department -- Position -- Contact (FName, LName USE Employees go SELECT EmployeeCode As 'Employee Number', FName + ' ' + LName As 'Employee Name', Department .[Name] As 'Department', Position .[Name] As 'Position', CAST(DAY(DateStarted) ...Show All

• Commerce Server Any way to make the CS 2007 help portable?

  This is kind of off topic, but hopefully one of you legends will have a great solution. Is there any easy way to copy the Commerce Server help onto another PC This used to be easy as it was a single CHM file. However, the help system has changed again and this no longer seems possible. I can't just install the Help as the install will not run without pre-reqs. I want to do this do I can do design work on another PC that does not have CS on. I know the docs are online, but it is not a great experience... You can always use the online version of Commerce Server 2007 Documentation ( http://msdn2.microsoft.com/en-us/library/ms864793.aspx ) on computers where you don't want to install the entire product. H ...Show All

• .NET Development Sending data elements and files by http POST

  Hi, I want to make an application that send by http post some input elements (user and password) and a file. I was using webclient wit UploadValues and UploadFile methods, but I need to send all (data and file) in only one http request. (but I don't n know the way or method for that) Please, If you have some code example, i will appreciate so much Thanks in advance ...Show All

• Smart Device Development Need help in SMS sending using VB.NET

  today download a project SendSMS using VB.NET from msdn home, namely Sending SMSs from your Microsoft .NET Compact Framework-based Applications but when i run it, there's an exception saying that "MissingMethodException" after pressing button send and please anyone know what happen how can i fix it thanks a lot hi~Ilya i havn't got a ppc phone here, i can't test it on a real phone, and i have to test it on my pc, what's more, i should finish until this evening and i don't know whether it will be ok in a phone, have you ever met this problem and fix it in a real phone thx ...Show All

• Windows Forms How to speed up datagridview

  Hi, I have a datagridview and i bind it to an arraylist. The arraylist contains about 50 000 of records. When a large number of rows(say 49000) being selected and I try to remove them all at once, it's such a lengthy process almost takes me 20mins. I have been looking for the solution all over the net, but i still couldn't find any. I have read an article on "Using the Selected Cells, Rows, and Columns Collections Efficiently" but it didn't tell me how to determine which rows are selected. So I can't determine which rows need to be removed from the datagridview. Can anyone help me with the problem How are you removing the rows Many times it is faster to manipulate the datasource than the act ...Show All

• Visual C# Getting applications Paths

  Does the System Namespace has something like system.path I need print out the current cs files path.. because for some reason I'm trying to load some images in a program that I'm creating.. but for some reason.. It only works when I add in the full path to it. interesting, it should. It returns a string of the path/location of where your application is running from MessageBox.Show(Application.StartupPath); (or Console.Write) ...Show All

• Visual C++ Vista "for loop" problem

  In code that runs correctly in XP, I have a for loop. 1. for (int nIndex = 0; nIndex < 256; nIndex++) { 2. array[nIndex] = something; ... In Vista, at line 2, nIndex = -856238756375 or something like that, ie. uninitialized. Obviously, this causes a crash. Is this a known bug I installed Build 5728 yesterday and cannot reproduce the problem. I did have problems with crashes related to USB driver. In my VM, I removed the USB port and now it seems pretty stable. ...Show All

• Smart Device Development sketch(on a transparent image )

  HI , Can anyone teach me how to create a transparent image in a picturebox. so that by placing this transparent image on top of another  picturebox (with image inside) , so that i can sketch on this transparent image i m using VB 2005 thanks. ...Show All

• Visual C++ CEDIT Base Class

  Hello all, It would seem that the Class Wizard wont give me the option of creating a new class with the base class of CEDIT. CEDIT does not appear in the pull-down. Which version of VC++ are you using You are talking about CEdit from MFC Did you create an MFC application and did you choose to add an MFC class CLR or ATL don't have CEdit. -- SvenC ...Show All