Samoyed's Q&A profile

• Microsoft ISV Community Center Forums How to detect if Access is opened exclusively

  Hello, I've just adjusted my Access database to use local tables to do data entry then send that data to the shared data tables (split DB - GUI/Data mdb's) and as a result will need to ensure that users have got a local PC copy of the GUI database file. So testing for the GUI file being opened exclusively via cmd /excl command line would be good (or via the Access DB options ->Advanced -> exclusive ). I can't seem to find the VBA method for testing if the CurrentDB is opened in Exclusive mode. Does anyone know the answer ...Show All

• Visual Studio Express Editions Visual Studio 2005 Express - how do i add and use active X controls?

  What I need to do is add an active x control to my project and use the methods from that active x control. I know how to use the object browser, add a COM component (although the one I need is missing from the list) and see it's methods. How do I add it to a form There's no Object Container control in VB2005. The help file says the Web control can be substituted 'in some cases'. I can use that and point the URL to the active x file I want to use, but then I have no way accessing its methods. Alex A general flow of adding a control to the toolbox Open a form in the VB Express IDE Right Click on the Toolbox and select Choose Items Choose COM Components and Browse Point to the appropriate file. ...Show All

• SQL Server Daylight Savings Patch for 2000 Server

  I was wondering if there is a simple patch for 2000 server. It seems that the only fix is to edit the registry and to use the time zone editor app. If there is a simple patch like there is for the 2003 servers i would appreciate it if anyone can show me where. I have about 80+ servers with 2000!!! Much appreciated! Look at this KBA http://support.microsoft.com/ kbid=928388 for more information. ...Show All

• .NET Development How to use folder path to find pathnames of certain files

  Hello, For a windows application I have created I have used the FolderBrowserDialog to retreive the pathname of a desired folder. Now that I have that pathname I wish to look in this folder for all files with a certain extensions (.html and .htm to be specific), after I find each file I would like to store the file's path name in an array of strings. Also I wish not to look into subfolders, but just at the root of the folder. Is this possible I have looked all over the web and just cannot find anything that will help. I have looked at filestreams and have not gotten anywhere either. Can someone please help me with this matter Thanks, Tareq Ismail sure its possible. you need to use ...Show All

• SQL Server Show dimension members only if there is data associated with them

  Hello, Is it possible to set-up dimensions to contain only members that have a match in the fact table I would like the dimensions pull-downs to show only members with data. Thanks, Philippe Has anyone found another way around this other than using a named query in the DSV to replace the table. My relational tables are setup in a "Kimball" fashion with a couple of fact tables and a bunch of shared dimensions. From my experience, this is a fairly standard approach to DW design. Hard to believe MSFT doesn't have a bettwer way of handling restricting dimension members only to those with data. Or is there some undocumented/hidden setting I'm missing Or something obvious that I'm naively ...Show All

• Smart Device Development multiple exe for single Application

  Our smartdevice application weighs around 1MB so we are proposed to use Multiple exe files rather than a single one.. now we have 4 exe's each weighs around 250 kb all i want to know,is there any added advatage going for multiple exe's for a single application Will that effect available runtime memory for the application Are there any security issues what is the best process to handle the applications with Large exe thank u Aditya. The main advantage I am aware of is that startup time for your exe is roughly proportional to the size of the exe due to hashing the exe file to verify signatures on it. Hence you should probably find your little apps individually start faster than the big app would have. How ...Show All

• Visual Studio Tools for Office Setup project for VSTO 2005 SE

  Hi all, So far I am concerned by deployment of Office Code Behind solutions, i was really happy to have found two great technical article addressing all issues about making a complete setup with a bootstraper to install all the prerequisite. But as those valuable ressource adressed all VSTO 2005 issue (installing runtime, language pack and so on), what's about VSTO 2005 SE Sure that the runtime of SE does not have the same product code and also maybe not the sames arguments on the command line... It is already evident that there are no more language pack... Then, those two wonderful articles and the dowload that you can find with them are obsolete... I have already spended few days seraching for an updated package.xml for ...Show All

• Visual Studio Team System CTP5 patch bug - Object reference not set to an instance of an object.

  I consistenly get an error dialog that says "Object reference not set to an instance of an object." whenever I invoke the SQL Server 2005 Wizard after installing the CTP5 patch. Without the patch, everything is fine. I've done this three times and a coworker has done this once. John - Have you had a chance to try this using our latest CTP - CTP6 If you are still having problems with CTP6, maybe we can get your database from you and try to debug the issue. ...Show All

• Visual C# Use internet explorer urls

  I'm making a webbrowser. Now i want to load the same urls that IE uses to a combobox, and set them too. In fact, I just want to know how to get access to the IE urls, so i can set/get them in my app. I hope that I am clear enough. Thanks in forward which urls favourites or urls in general urls in general, I believe in the combobox there is a property called autocompletesource, in here, set it to "AllUrl" which will then hopefully show the url's stored in the system as you are typing. in the autocompletemode set it to perhaps suggestAppend to make it complete the urls whilst you are typing and filters the url appropriately as you are typing ...Show All

• SQL Server Using an Excel Query to access SQL Server

  I set up an Excel spreadsheet for several users that queries a SQL Server. I provided the spreadsheet to the users and set it to refresh when ever it is open. The query is working fine. The problem is the users are prompted with a SQL Server login screen every time they open the file. The login screen shows the server name, the username and the password. All they have to do is press 'OK' and the screen goes away. Why are they being prompted with this screen What can I do to eliminate the users from even seeing this window I also receive this window whenever I open the file and I created it on the workstation where i'm opening it. Thank you for any input or suggestions. When you create your datasource in ...Show All

• Windows Forms scroll to bottom

  how do i make my panel scroll automatically to the latestest content.. My panel starts with showing the data on top and then the new data comes down and down and then scroll bar shows up which keeps getting bigger but i can't see my new data without scrolling. How can i make scrollbar autoscroll to the latest data thx Sameep This is precisely what I am wanting to do, but I can't get your code to work. My code fragment is included below. What I want is for the textbox to contain the reams of info (don't know if it matters but includes newlines) stored in my arrayofoptions object - but to display only the final 3 lines or so (but in such a way that if anyone wants to scroll up they can). Any hel ...Show All

• SQL Server problem with setup XMLA

  i am using XMLA on windows Server 2003 (sp1) and SQL server 2000 (SP4), and i am not able to connect to XMLA source http://my_serwer_name/xmla/msxisapi.dll when i try to connect http://my_serwer_name/xmla/msxisapi.dll in browser, i don't get soap error. browser connecting unlimited time. I try with anonymus and integred authentication. Always the same result. Any ideas ...Show All

• Microsoft ISV Community Center Forums Data from multiple listbox(s) to one array

  Hello looking for a quick way to loop through multiple listboxes contained on one userform and take all the data from each and add it to an array. Dim cCont As Control For Each cCont In Me.Controls If TypeName(cCont) = "ListBox" Then ' how do I loop through each list box and dump the data End If Next cCont I am new to this... Thanks Hi, Yip you should be able to do something like this... For Each cCont In Me.Controls If TypeName(cCont) = "ListBox" Then Dim lstBox as ListBox Set lstBox = cCont Dim iCount As Integer For iCount = 0 To Me.lstBox.ListCount - 1 MsgBox Me.lstBox.List(iCount, 0) Next End If Next cCont ...Show All

• Visual Studio Express Editions Error 1935

  During the installation of office i had the following error: Error 1935 : an error occurred during the installation of assembly component {10bac0e7-53ca-4cba-a2df-44d565eb2a0} HRESULT 0x80070005 Is there anyone who knows to solve this problem Have you updated your computer with all the lastest updates from Windows Update Try also disabling any antivirus and firewall software when installing VS Express. If it still fails can you post your installation log 1. Open Windows Explorer 2. Paste %temp% into the Address bar 3. Paste the contents of dd_vsinstall80.txt (only the timestamp applicable) into a post. ...Show All

• .NET Development Adding shortcut key to TabControl

  Hi guys, Greetings! How can I add shortcut key to TabControl Pages. Let say I have two tabs. Tab1 has the label Supplier then Tab2 has the label Product . I want to assigned shortcut key to Supplier Tab and Product Tab. Let say F2 and F3 or which is advisable... Please do aware that I uses Alt-key to other buttons inside each respective tab. Like &Save, &Cancel, &New etc... Thanks, Beast Forever Hi Matt, I got it to worked. Thanks again! By the way, do you have any wallthrough for creating a data entry for master/detail form Like Customer (master) -> Orders(detail) I already have the relation and able to display the contents but no idea for letting the ...Show All