Visual Basic

FirstPrevNext

Re: How can I fit a child form to be inside a MdiParent waner michaud11-Aug-09 3:11 waner michaud 11-Aug-09 3:11  Thanks, what if I change it to show() Can it be then a MdiChild and how Best regard Re: How can I fit a child form to be inside a MdiParent DaveyM6911-Aug-09 3:35 DaveyM69 11-Aug-09 3:35  Create the child instance, set the MdiParent property of the child instance to the parent form (Me if instaciating in the parent) who's IsMdiContainer should already be True, then call the instance's Show() method. Dave BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus) Re: How can I fit a child form to be inside a MdiParent Dave Kreskowiak11-Aug-09 3:49 Dave Kreskowiak 11-Aug-09 3:49  That would be the normal way to show an MdiChild form, yes. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009... Re: How can I fit a child form to be inside a MdiParent DaveyM6911-Aug-09 1:47 DaveyM69 11-Aug-09 1:47  A modal form by it's nature is not part of the MDI. It is possible to contrain it's movement to within the MDI client area though. I wrote an article[^] about this - it's in C# but easily 'transposed'. Dave BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus) Deleting a Database Record when DeletedDate is XX Days Old mrtupperware10-Aug-09 4:52 mrtupperware 10-Aug-09 4:52  Here is the code that I am using: DELETE from Agents WHERE Deleted = 'Y' AND DeletedDate < '" & System.DateTime.Now.Date.AddDays(-30) & "'" The code deletes the correct records, but it also deletes records that are within the 30 days. I.E. If I ran this today, in addition to the correct records, it will also delete records where DeleteDate is 7/15/2009 , 7/29/2009 , 7/19/2009, etc. It does NOT delete dates 8/01/2009 through today.. Any ideas please? Re: Deleting a Database Record when DeletedDate is XX Days Old Luc Pattyn10-Aug-09 5:20 Luc Pattyn 10-Aug-09 5:20  your statement is implicitly using DateTime.ToString() which applies the regional settings, not necessarily what SQL needs. You should use an explicit ToString() and provide a formatting parameter that is compatible with SQL. As an alternative, use a parameterized SQL statement; that would take a real DateTime, not a string. Hence no formatting problems at all. Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem. Re: Deleting a Database Record when DeletedDate is XX Days Old mrtupperware10-Aug-09 6:08 mrtupperware 10-Aug-09 6:08  OK, I since have changed my statement to: DELETE from Agents WHERE DeletedDate < " & Date.Now.Date & "" Now it deletes nothing Re: Deleting a Database Record when DeletedDate is XX Days Old Luc Pattyn10-Aug-09 6:24 Luc Pattyn 10-Aug-09 6:24  Did you actually read my previous reply? Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem. Re: Deleting a Database Record when DeletedDate is XX Days Old mrtupperware10-Aug-09 6:39 mrtupperware 10-Aug-09 6:39  Sorry, I didnt explain well enough. I changed the Data Type in my MS Access database to Date/Time and changed my statement to: DELETE from Agents WHERE DeletedDate < " & Date.Now.Date & " I would think that should work, but it doesnt delete any records. Re: Deleting a Database Record when DeletedDate is XX Days Old Luc Pattyn10-Aug-09 6:40 Luc Pattyn 10-Aug-09 6:40  Did you actually read my previous replies? Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem. Re: Deleting a Database Record when DeletedDate is XX Days Old mrtupperware10-Aug-09 6:48 mrtupperware 10-Aug-09 6:48  Obviously I am new to this and I didnt understand what you meant. I thought that your last comment meant that I would be better off changing the data type to Date/Time, therefore I did that. I appreciate your answers, but if you are going to be curt, please allow me to figure this out on my own or get help elsewhere rather than be insulted because I dont happen to know and understand everything that you do. Thank you again for your assistance. Re: Deleting a Database Record when DeletedDate is XX Days Old Luc Pattyn10-Aug-09 6:54 Luc Pattyn 10-Aug-09 6:54  As you are not inclined to use DateTime.ToString() nor SqlParameter class, feel free to continue in any way you see fit. Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem. Re: Deleting a Database Record when DeletedDate is XX Days Old mrtupperware10-Aug-09 7:06 mrtupperware 10-Aug-09 7:06  Thank you, but did you read MY last post? Re: Deleting a Database Record when DeletedDate is XX Days Old Gideon Engelberth10-Aug-09 10:01 Gideon Engelberth 10-Aug-09 10:01  The comment Luc is trying to make is that "stuff" & date.now.date & "more stuff" will call the default ToString method of the Date object returned by Date.Now. More than likely, the string output by the default is confusing the database engine because it is expecting a different order. You should look into the overloads of ToString that take an format string argument and determine the format expected by the database. Alternatively, you could use a parameterized query. I'm not big on the syntax, but it believe it would be something like 'DELETE your stuff WHERE DateToCompare < @date'. The actual syntax varies from database to database. Then you could use the OdbcCommand (or SqlCommand, or whichever version applies to your database) along with the Parameter class to go with your command. The OdbcParameter MSDN page has a good example of this. The ANSWER - Deleting a Database Record when DeletedDate is XX Days Old mrtupperware12-Aug-09 10:21 mrtupperware 12-Aug-09 10:21  I found someone who knew the answer to me problem. The Field needed to be a Date/Time Field and the correct Delete statement is: DELETE from Agents WHERE Deleted = 'Y' AND DeletedDate < #" & Now.Date.AddDays(-30) & "#" The Pound Signs made all the difference. Thank you for your assistance. Rick Auto Increasing VARCHAR data type column in SQL SERVER 2005 Dambod10-Aug-09 2:59 Dambod 10-Aug-09 2:59  hi there, i want to create a column that increments automatically when data for other columns are inserted. The data type for this column is varchar made of the following format based on some conditons BD/00001/99A EX/00002/00B PS/00003/00A the numbers between 00001-00003 will be incrementing each time a new data is inserted. others are conditions based, usually not changing. any help would be appreciated Re: Auto Increasing VARCHAR data type column in SQL SERVER 2005 Luc Pattyn10-Aug-09 3:32 Luc Pattyn 10-Aug-09 3:32  I would use two fields, one strictly an autoincrementing number, the other (the composite field you want) fully calculated from the available data. Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem. Re: Auto Increasing VARCHAR data type column in SQL SERVER 2005 Dambod10-Aug-09 3:56 Dambod 10-Aug-09 3:56  u mean using stored proc (somevariable + autonumber) as Columnname, can u give me some hint, if u have thank u in advance. Dependency for MSchrt20.ocx in VB.NET Nanda_MR10-Aug-09 1:30 Nanda_MR 10-Aug-09 1:30  I saw in Dependency walker MSchrt20.ocx depending file and I searched in internet But I can't get all file. Wt i post last time error was clear in my system. But In client system package not opening when I add a chart otherwise it will come. Now how can i build setup. Re: Dependency for MSchrt20.ocx in VB.NET Dave Kreskowiak10-Aug-09 4:18 Dave Kreskowiak 10-Aug-09 4:18  You have to add the MsChrt20.ocx file to your installation and any files that it depends on. Seriously, I'd look into a different graphing package, such as ZedGraph[^]. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009... How to Get Current Login User Name Anubhava Dimri10-Aug-09 0:02 Anubhava Dimri 10-Aug-09 0:02  Hi All, My application run alwase with admin rights (Previlages). Write now i m in guest account and try to run my application with admin rights. So how to Get Current Login User Name... Thanks If you can think then I Can. Re: How to Get Current Login User Name Luc Pattyn10-Aug-09 1:05 Luc Pattyn 10-Aug-09 1:05  Hi, 1. Environment.UserName 2. eg_Anubhava wrote: Write now i m in guest account and try to run my application with admin rights. You can't. Guest has no rights whatsoever. Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem. Re: How to Get Current Login User Name Anubhava Dimri10-Aug-09 2:07 Anubhava Dimri 10-Aug-09 2:07  I want the name of user which is login. I m login with Guest Account and I m running my application as administrator then how to Get the Login User Name (Guest). If you can think then I Can. Re: How to Get Current Login User Name Dave Kreskowiak10-Aug-09 4:07 Dave Kreskowiak 10-Aug-09 4:07  Again, Environment.Username returns the name of the user that is running your code. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009... Re: How to Get Current Login User Name Anubhava Dimri10-Aug-09 18:03 Anubhava Dimri 10-Aug-09 18:03  Environment.Username returns the name of the user that is running your code. But i want to know where from i m tring to execute it. Just Follow these step. Goto Guest Accout then Select Exe and Right Clink on them. then Use the Option Run as administrator then enter user name and password. In that case how can i get the login user name. If you can think then I Can.

Last Visit: 31-Dec-99 18:00     Last Update: 15-May-24 14:21 Refresh ᐊ Prev1...964965966967968969970971972973 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.