enric vives's Q&A profile
Microsoft ISV Community Center Forums Accessing Visual FoxPro data using VBA (Excel)
I am trying to query some records from a FoxPro database in Excel using VBA. I am able to grab all the data I want, based on my criteria, except for the dates. I cannot query by dates. Could you please educate me as to how to query records from a FoxPro database file by date/time in VBA Thanks in advance. MPG. The guys here might have your solution... http://www.dbforums.com/printthread.php t=437921 ...Show All
Visual Studio Express Editions End, Stop, Application.exit coming up with compile errors..
Yes, I know this is probally a noob question, but...Does anybody know why end; , stop; , and application.exit; wont' work It comes up with a compile error, would what I have (or don't have) in Using effect anything. I'm just moving from visual basic 2005 to C Sharp, and I need enough knowledge to be able to convert one of my big vb games to C sharp. So right now I'm just trying out different statements, and stuff, seeing how it works with C#. Application.Exit required parentheses as I had posted: Application.Exit(); you need the InitializeComponent as it is there, why would you wish to move it somewhere else Fortunately its just a method call which you don't need to worry about. If you mov ...Show All
Visual Basic the application requires that assembly office be installed
hi when i try to install MS VB2005 Express application on a user's pc i get the following error message: " unable to istall or run the application . The application requiers that assembly office version 11.0.0.0 be installed in the Global Assemly Cache (GAC) first. Please contact your system administrator" how do solve this issue Download and install the Office 2003 Primary Interop Assemblies . ...Show All
SQL Server Unable to install SQL2005 I64 on a 2003 SP1 Itanium
Hello, I have many problem when I try to install SQL 2005 Ets edition ia64 on a 2003 ets Itanium edition. When I launch the setup, all is all right. But during the installation, it tryes to start MSSQL services. The staring of this service failed. So I try to start the service mannually. Nothing. Error messages I can get (in the event log) : Source : Service Control Manager ; ID : 7000 Description :Service SQL Server (MSSQLSERVER) failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. Source : MsiInstaller ; ID 10005 Description : Product: Microsoft SQL Server 2005 (64 bits) -- Error 29503. Failure of the starting of service SQL Server. For more i ...Show All
SQL Server Duplicates
Hi! Grateful for some help as a newbie... I have a OLE db SQL command: SELECT DISTINCT convert (char(8),date,112) as day,...etc Resulting in error "Violation of PRIMARY KEY constraint 'PK_Dim_Date "... so Column Day in Dim_date contains duplicates. I suppose i need a delete in Lookup or how would I eliminate duplicates in Dim DELETE day from dim_date where day in(Select day from date ... curiousss wrote: Thank you so much! How about if I delete and empty the whole table. This command does not seem to work though. DELETE day FROM dbo.Dim_Date truncate table dbo.dim_date will delete the whole table delete from dbo.dim_date will do the same thing, sort of This whole scenario you have set up here i ...Show All
SQL Server How many user current "connect" to a row in table.
Hi all... Iam a newbie and i have one question want to ask experts ... . I am current working on one App which have some user connect to database at the same time. And i want to know: how many user connect or use (read , update) to one row in a table Could it be possible to know that If you have one solution to solve this problem , please let me know :) ... Could it be done by Software , T-SQL or anything ...., iam happy to know. Thanks all. A trigger is fired on a statement level. When the trigger is fire you could write a message / row in a event table which is polled by the application. In another table you could save the information that the application of User A has received the notification but the application of user B d ...Show All
Visual Studio Team System Development Project Plan marked as read-only
We do have the problem that a project plan (*.mpp) can only be opened in read-write mode very rarely. Although no one of our team has the project plan open ms project states that the file is in use and therefore can be opened in read-only mode only. Even when one team member opens the file on his machine and closes it afterwords he can not open it again. The same behaviour is observed when the file is opende using sharepoint project home page. After some unpredictable timespan the file is not locked any more. Is this a known issue thomas So is there a solution to this 'read-only' problem that I am missing Has Microsoft released and fixes or patches ...Show All
Smart Device Development Using a cdb database with evc++ 4.0
Hi there, I'm quiet new at this stuff (former VB6.0 programmer) and now i'm trying to build an apllication wich should access a database with 5 table's. This application should be running under windows CE 5.0 and therefor i chose the *.cdb database. This is how far i'm right now, i don't have enough background in evc++ or c++ to fully understand the info from the MSDN. Has anybody got an example for me to get me on the way Why you've chosen database which is long deprecated and no longer available And why C++ you don't know instead of VB.Net ...Show All
Visual C++ about VC+MySQL problem:)
about VC+MySQL problem:) i install mysql odbc V5.0 driver i need to ADO Connect MYSQL DB; code: _ConnectionPtr m_CMConnect; ::CoInitialize(NULL); m_CMConnect.CreateInstance(__uuidof(Connection)); m_CMConnect->Open("Provider=MySQL;server=localhost;DataBase=test;port=3306;uid=root;pwd=","","",-1); but Program run error..... how to Ado Connect MYSQL DB; thank:) Hello Re: about VC+MySQL problem:) Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups. ...Show All
Smart Device Development Intercepting SMS messages and Creating a Notification
I'm trying to intercept a message, do some analysis on it, provide a custom notification, and save it to the inbox. I'm using InTheHand, the Microsoft.WindowsMobile managed classes, and OpenNETCF libraries at my disposal. A couple of questions: 1) The first question is with regards to the MessageInterceptor class. After intercepting a message, I can't find any way to pass it thru to the SMS account's inbox. The Accounts.SmsAccount.Inbox doesn't give me any methods to save a SMS message. The only way for it to go to the regular sms inbox is to use "Notify" instead of "NotifyAndDelete" for the MessageAction. But this will give me two notifications - the original and the custom one I'm popping up, instead of ju ...Show All
Visual C# Compile with specific assembly version?
Hi! Is there a way to manually tell what version of a referenced assembly must be If I right-click on the reference and then set the property "Specific Version" to true, I still can't choose version for the "Version" property. What I can do is open the csproj file in notepad and type in the version I want, but I would like to be able and do this from within the IDE. Also, I don't want to be able to compile if I don't have the right version, so I guess if there is some thing I can set in the .config file it's not going to work, because then I will get a runtime exception, not a compile error. Regards /Tommie Thanks for your explanation Michael. I'll try explaining what I'm tryi ...Show All
Visual Basic showing wait cursor
alright, I know this dates back to vb6 you used to do I believe Do.cmd.Hourglass=True (maybe wrong, its been a while since I used vb6) how do you show the wait cursor and return it back to normal in vb Davids Learning 'wait: Cursor = Cursors.WaitCursor 'change back: Cursor = Cursors.DefaultCursor There was no option to use "nothing" Thanks though, you got me in the ballpark. Davids Learning ...Show All
Visual C++ Help with Arrays
I've been trying to create a multidimensional String array using Visual C++ & .NET 2.0, but I'm having troubles getting my head around the syntax of the Array class using the MSDN documentation. My big questions are how do I declare a multidimensional array and how can I directly access its members Using simple single-dimension arrays, I can do the following: array<int>^ arrayInt = {1, 2, 3}; arrayInt[0] = 1; However, if I try the following, the syntax fails: array<int>^ arrayInt = { (1, 2, 3), (4, 5, 6) }; arrayInt[0][0] = 2; The compiler vomits on me with that. The first line is fine - it's the second line that the compiler doesn't like. Using the debugger, it looks as though my declaration doesn't work ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Clarification regarding EULA and Legacy ps_1_x Compiling
According to the docs found in the December SDK for the page "D3DXSHADER Flags" in order to enable compiling via D3DX of HLSL ps_1_x profiles, we must include d3dx_31.dll in our distribution. To the best of my knowledge, the EULA forbid redistributing D3DX DLL files. This is based on the discussion on the DXDev mailing list a while back. What is the solution for this -Pat Let's re-phrase it: docs actually mean what DirectX redist included with you application should contain (and install) d3dx9_31.dll. There is an article in SDK documentation describing how to prepare slimmed version of DX redist suited for your app needs. ...Show All
Windows Forms How to find out wether given toolstripitem is on toolstrip(non overflow part of toolstrip) or in the overflow part of toolstrip?
How to find out wether given toolstripitem/control is on toolstrip(non overflow part of toolstrip) or in the overflow part of toolstrip hi, could you please check this out hope this is of some help. http://www.windowsforms.net/FAQs/default.aspx PageID=2&ItemID=769&CategoryID=3&tabindex=22 thank you, bhanu. ...Show All