PanzerDivisionMarkus's Q&A profile

• Microsoft ISV Community Center Forums Sql SELECT query from VBA in Access

  I would like to run a select query from within a VBA sub and have the result put into some sort of string. I can't figure out how to do it as dcCmd.RunSQL only accepts action queries. Can you please give me a suggestion on how to do it I want to do the select query in order to turn a customer name into a customer id so that I can have a proper reference to my table of customers from my table of purchases. Purchases come from a text file that I'm processing in VBA. Thank you. This worked for me as well but I'm working in Access 2003 and the default data access library that Access tried to use was ADO so I had to change it to include DAO instead. I found this site: http://allenbrowne.com/ser-38.html which ...Show All

• Visual Basic Hello nooby here... needs a quick answer!

  Ello... I am in the middle of programming a game... ... again.. in visual basic... and I can't seem to find a way to make it check to see if a image is a certain image... Basically... what i want it to do... ... is when you click it... have it check to see which picture is up... Example (Red is the part I'm stuck on and can't seem to get to work I've tried so many different things its insane... but I'm sure one of you experts has the answer I'm looking for) : If Picturebox1.Enabled = true And Picturebox1.picture = ("C:\Picture.jpg") Then Picturebox1.Image = Nothing Picturebox1.load = (C:\Picture2.jpg") End If ANY help what so ever would be appreciated... Thank you all, Moveit you are pretty close; you need to ...Show All

• .NET Development is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

  im trying to do a simple select statement across sql server express. it is able to return me the query when i try on sdk but the a/m error appear when i try on web browser or emulator. btw, im doing a web service with mobile app. command = new SqlCommand("SELECT MAX(AID), UID, isDefault FROM Alert where (UID =" + uid + ") AND (isDefault='" + isdefault + "')", dc.Connection); above is my code when i try on web broswer and emulator. SELECT MAX(AID) from Alert where (UID =1) AND (isDefault='n') above is my code when i try on sdk (vs.net2005) what is wrong im trying to find the latest entry into the table by searching the largest AID in the table. im wanting to get ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Jerky sprite movement, too much keyboard sampling?

  Hi all, A question if i may, i have installed XNA and all the necessary gubbins, and have walked through the tutorial on learnxna.com I am just trying out the basics at the moment and am attempting to get a user controlled sprite move across the bottom of the screen, on the x axis, responding to left and right keys. This works fine. When a space bar press is detected, a projectile object is created, in the same place as the bottom sprite and is added to a class scoped arraylist (for storing projectile objects). In the update method, the array list is looped and any projectiles created have their position updated (so they move up they axis). The array list is looped and draw in the relevant positions in the draw method. This rea ...Show All

• SQL Server Bypassing locks when doing insert or update

  Hi, I want to bypass locks while doing Insert or Update. I am only updating a log db and I don't care about one or two fields getting junk as I won't use it later (atleast as long as I am working with my current company ;) ) I am using MS SQL 2000 I am getting too many deadlocks and messages like these "Process ID was deadlocked with another process and has been chosen a victim. Please rerun the transaction". Please tell me how to achieve this. Regards, Noorul you can try using a 'NOLOCK' locking hint....but u have to be sure..it wont affect ur data (ACID).... correct..and longer part will be to try and find the source of deadlocks..and remove it.. ...Show All

• Visual Studio Express Editions Setting a default directory in a picture viewer

  Hi! Being a newbie to Visual Basic Express (coming from the QBASIC era) I'm finding OOC a bit overwhelming. I've managed to piece together a simple picture viewer. My main problem is I'm using a new instance of FileBrowserDialog to locate a folder on another drive each time I start the program. I want this folder to be the default folder when I call the FileBrowserDialog. Here is what I have right now: Private Sub GetListOfFiles( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim x As New FolderBrowserDialog If x.ShowDialog() = Windows.Forms.DialogResult.OK Then Dim folder As String = x.SelectedPath Dim pattern As String = "*.jpg" f.Clear ...Show All

• Visual Basic Call a vb exe in asp

  Can some one help me with calling a vb program within a asp hi, Use ShellExecute command of the Shell ActiveXObject (in javascript) var oShell = new ActiveXObject( "Shell.Application" ); oShell.ShellExecute("Notepad.exe", "", "" , "open" , "1" ); regards, Perumal.R DSRC Pvt. Ltd, Chennai. ...Show All

• Software Development for Windows Vista How to handle exceptions in a State Machine Worklow?

  Hello, I'm trying to create a State Machine workflow, but I cannot get the exception handling working. In Sequential workflows the Visual Studio Workflow Designer has three icons in the lower left corner of the workflow where you can switch between the workflow and the "Fault Handler View". In a State Machine workflow, I'm missing these icons. I'm using the July CTP of the .NET Framework 3.0 and RC4 of the WF Extensions for Visual Studio. I tried a different way to handle exceptions, but with no luck: I added an EventDrivenActivity to my root-state (the whole state machine). On that EventDrivenActivity I right-clicked and chose "View Fault Handler". In that FaultHandlerView I placed one FaultHandlerActivity with ...Show All

• SQL Server (Select All) Checkbox As Default

  All, When creating a dynamic parameter list from a query, Reporting Services graciously provides a "(Select All)" checkbox. How can I select this checkbox by default so that when a user generates the report, all of the values are selected Thanks The closest you can get is to compare the number of rows in the dataset used for the valid values list (e.g. =CountRows("ParameterDataSetName")) with the number of selected parameter values (e.g. =Parameters!P1.Count) -- Robert ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360: Detect widescreen vs 4:3?

  Right now it looks like our games pretty much dictate their size and whether they're windows or full-screen. But, obviously, once we get to the 360 the choice of windows vs full-screen will be gone. And I get the impression that if we code for 720p that the 360 will automatically downscale if needed. But I still don't know how we're going to detect whether the output is headed for widescreen or 4:3. If we make the choice to program for widescreen only will the 360 letterbox for us, or will it just get squished or truncated Nothing like this is currently known. My guess is that you should code your game to accept window sizes for 4:3 and 16:9 e.g. clip the sides, add letterbox bars or add extra graphics ...Show All

• Windows Forms Exiting from a UserControl Prematurely

  I have a UserControl that contains several textboxes. Under certain conditions I need to exit the Control (ie move to the next control on the parent form after the User Control) from a text box that is not the last one in tab order on the control. In the Validation Event of the text box I have tried changing focus to the last textbox in the control and executing Me.ProcessTabKey(True). The focus remains with the last text box. I have tried Me.ProcessDialogKey(Keys.Tab), but that seems to go off into loop. I could throw an event, but that would require that the parent form always process it. What is the secret of exiting the UserControl programatically either forward or backward Any help would be appreciated. ...Show All

• Visual C++ ReadProcessMemory crashes computer

  I am using CreateProcess, then using the process handle that returns and passing it to ReadProcessMemory. I have about 10 addresses I iterate through using ReadProcessMemory on each of them every 200 ms. Whenever there is a change detected in one of them, it will output the string ReadProcessMemory returns from the target process's memory. When I print this string to the console, my computer will emit an extremely loud system beep and crash, or it will just emit an extremely loud system beep. I haven't tested my program on any other computers yet, but if it is a computer specific-issue, but I'm running the program on a Dell Inspirion 9300 laptop. On a related note, if I'm playing a game or doing something else fairly processor intensive (r ...Show All

• Windows Forms Displaying selected data in a DataGrid

  I'm trying to display a datagrid of selected data from two 2 tables in my database. My SQL statement for the data is: "SELECT Rentals.dueBack, Movie.title FROM Rentals inner join Movie on Rentals.Movie_ID=Movie.movie_id WHERE Rentals.id=" & decSearch How should i go about creating the code so it displays the selected data into a datagrid. Hi...first you need to store your query into a dataset. you can use a dataAdapter to fill the dataset. Then assign your dataset to your datagrid. Here's a sample code for MS Access OleDb Imports System.Data.OleDb Dim myConnection As New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; User ID=Admin; Data Source=<your databas ...Show All

• Visual Basic How can I get video from a usb webcam? (IN VISUAL BASIC .NET !!! )

  Is there any way that I can get the video from a webcam (usb) to preview it and then save it In VB please and please dont show me the links from a1vbcode and Coding 4 Fun cause I dont understand how it works there (and pasting the code isn't really easy (Idont know what is for what) ) MSDN links would do good (i searched but I didn't find anything). But still, Any help would be great I am very new to VB i tried using ur sample for one of my assignment. I figured out the save file dialog already. now the rob is when i start the prog this msg came out: "LoaderLock was detected Message: Attempting managed execution inside OS Loader lock. Do not attempt to run managed code inside a DllMain or ...Show All

• Visual Studio Express Editions how to modify a timer?

  hi all, i found this simple timer on http://www.developer.com/lang/other/article.php/792901  5:  using System; 6:  using System.Timers; 7:  8:  class myApp 9:  { 10:    public static void Main() 11:    { 12:      Timer myTimer = new Timer(); 13:      myTimer.Elapsed += new ElapsedEventHandler( DisplayTimeEvent ); 14:      myTimer.Interval = 1000; 15:      myTimer.Start(); 16:  17:      18:      19:        20:      21:    } 22: 23:    pub ...Show All