I'm running Microsoft Visual Basic 2010 Express on Windows 7, using a Regional Setting set to New Zealand.
When I enter a date in a NZ format (d/mm/yyyy), the IDE highlights the date and tooltip reports date constant not valid. But it is valid for NZ! Meanwhile, the IDE happily accepts dates in the US format.
I would have expected VB to look at my PCs regional settings and set this as the default format. What is wrong here? I have reinstalled the application, but still have the same problem.
Using OLE and Jet, you may receive errors when saving system dates and times to databases in different regions.Consider what happens when saving dates and times returned using the Now() function in Canada or the US: the date string "#2010/02/03 08:59 AM#" will save fine. If using 24 hour time, the string "#2010/02/03 08:59#" will also save fine.
If you change your system region to Spanish (Peru) or Spanish (Mexico), the ante meridiem changes from "AM" to "a.m." (or "p.m."). The date string becomes: "#2010/02/03 08:59 a.m.#"Note that this will NOT save correctly to the database and throw a System.Data.OleDb.OleDbException. The workaround we use is: Public Function clean_date(ByVal strDate As String) As String Dim str_buffer As String
My Australian dates (dd/mm/yyyy) are being converted to U.S. date format (mm/dd/yyyy) despite using custom date specifier for Access table fields.Allen Lamb
Within Control Panel -> Regional and Language Options, there is a Formats tab, with a drop down of all possible language formats. I wish to retrieve this list using VB.NET. Could anyone point in the direction of which Windows API call to use?
This has been driving me batty for the last while. I have an application that is passing up data to a SQL server table. Part of the data is dates. Because of settings on the SQL server the update will not accept the MM/dd/yyyy format. I have been trying for quite some time to get around this.
For some more information. Changing the update method or the server regional settings is not an option and I don't want to change my regional settings as this may not reflect the production server when this goes live.
Here is what I have tried so far
Code: Dim dateEnd As Date = Date.MinValue Dim dateStart As Date = Date.MinValue If IsDate(Me.txtPostEnd.Text) Then
[Code]....
It works fine if the day is 12 or below because it still thinks that is the month. Is there a way to force the code to recogize that I want to use dd/MM/yyyy format or even dd/MMM/yyyy format?
This has to be done at thhe vb code side as the update to the SQL server is completed via a custom framework so I can't customize the SQL code to insert the data using a CONVERT
example: inside regional date format setting i set "Short date format dd/MMM/yyyy" and inside vb.net program i set "strSQL = strSQL & ",'" & Date(Date.Now.ToString("dd/MM/yyyy")) & "'" ----> working fine. if user changed the regional date format setting to other format like "mm/dd/yy" facing problem during saving record into sql table. error date conversion. It's possible to avoid using computer regional date format from vb.net? or have any other way...
i used date in my project often. but every time i used format(now,"dd/MM/yyyy"). But i want to change the system date format to "dd/MM/yyyy" permanently.
Is there any way to make VB.NET to accept for all Date Formats as in VB6.0...I'm upgrading VB6.0 applications to VB.NET... Here I'm finding the Functionality difference due to VB.NET feature which goes for System date Settings.I tried using CultureInfo. But it also specifies only one format at a time..removing this functionality difference
Explanation : IsDate("MM/DD/YYYY") Returns False if the system date setting is of "DD/MM/YYYY"
I have a program (below) which runs an SQL query on an Access database to bring back records based on the date a user selects. This issue seems to be that US date formats are the only date formats that SQL queries accept. I may be wrong, but this is my understanding. All my dates in the database are in EU date format (dd/mm/yyyy). What happens when i run my code is that I can not access a record with the date of 08/05/2010 unless the input date is 05/08/2010.
I've searched around but can't find a clear answer for this. From my winforms VB2010 app, I'd like to be able to detect the country of the user's PC at runtime. Specifically, all I really need to detect is whether the user is in Australia or Canada.Most things I've seen will say "have a look at System.Globalization.CultureInfo", but with no clear example. I also know that the old-school "GetLocaleInfo" API can be used for this as well. I do have some code using the latter, which detects Australia when LOCALE_ICOUNTRY returns a value of 61. However, that won't work for Canada, as it returns 1, which is the same as USA (I know that these are based on telephone country codes).
I am creating a VB 2010 program that lets your select the program(s) you want to install (chkbox) and hit run. Then have it launch the installer ( the file is across the server) and accept the predefined keystrokes to proceed through the installation process. Afterwards, it starts the next install. Below is the code that I have. What i cant get to function is the unit accepting the keystrokes, its almost as if it wont take focus ( even when i have used Appactivate and threading.thread.sleep). I have even gone so far as to identify it as a process to manipulate the thread. To be honest, i'm at a loss and need any help at all. The final sub that contains "btntest" is where I am at currently in my attempts. [Code]
I'm new to VB and I'm trying to get this app to recognize that a "C" is the same as "c" but for some reason its not recognizing it. Its seeing the lower case letters as 10%.
Here is the code I currently have... Private Sub btnCalculate_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles btnCalculate.Click Dim subtotal As Decimal = CDec(txtSubtotal.Text) Dim discountPercent As Decimal [Code] .....
I am throwing some data out into Excel and am having some formatting troubles. I have 5 columns (date, time, a long number I don't want displayed in scientific notation - text is fine, text, text). I can get it all working with numberformat, however I have to do them different ways.
Date works this way cell.numberformat = "m/d/yy" and it formats it to say 3/1/11
Time works this way cell.numberformat = "h:mm AM/PM" and it formats it to say 8:07 AM
For the long number cell.numberformat = "@" and it doesn't change the format and it gets displayed in scientific notation
BUT if I use cell.style.numberformat = "@" it works as it should, but it messes up all of the date and time cells. Apparently when you use style.numberformat, it doesn't just apply to the cell you're working with. If I try using style.numberformat with the date and time formats, they don't change and are entered as if I didn't change the format at all.
I am working on a program. I've got the following Private Sub frmTabel_Activated(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Activated Dim strHoofding As String strHoofding = "Geleend bedrag : " & _ strRechtsUitgelijnd(Format(glngBedrag, "‚¬ #,##.00"), 15) & vbCrLf & _ [Code] ..... What it should do is placing the four formats but I am only getting result from glngBedrag' Like this: [URL]
I have a lot of keyboard keys stored in different formats. For example, "Up" may be stored as a string, as a decimal (200) or as hex (C8). I need to convert all of this different representations to strings so they can be easily understood by the user, and then back again when I save them.When I capture the key press using the KeyDown event, I can grab the decimal value from KeyEventArgs.KeyCode, which can easily be converted to hex if needed.
I am loading an image on picturebox, then trying to paint some particular pixel but it does not work for the tif image that I have. I got the following error message "SetPixel is not supported for images with indexed pixel formats."
I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
I am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
Is VB Express 2010 slower to compile and run that older versions of VB Express? I've installed it this weekend and it seems a little sluggish on my quad core computer with 1 gig of RAM. I have VB Express 2005 installed for my students at school and it seems to fly just fine. Those school computers are older P4s with 512k of RAM.
Initially my app worked with excel fine, now it causes my computer to reboot only after Excel has been opened (two or more times). I have opened and closed Excel files 20+ times without running thru either of my apps (they all uses identical code for excel) and it has never caused a reboot or a crash.
run either of my apps and have the app control excel has become a crap shoot, it will reboot my computer. Adding to that I then have to do a manual shutdown because the reboot process after is unstable. (System doesn't respond properly). My code in this app is small, should make for a good example. I can provide the entire project to anyone who would volunteer to test it. (First I need to know how to send the project).
there Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
I am using VB 2008 and have a datetime picker. I wam trying to use this value in an INSERT command to load in to a table but I just can't get it to work. I debug it out which shows something along the lines of "24/03/2010" but it just won't accept it. However, if I create a string variable e.g. strDate = "24/03/2010". it works. I am obviously doing something wrong in the conversion.
I have an app using UK default dates.When i deploy the app i noticed i get some date related errors when saving data (as some test PCs were setup with US regions). Setting the locale and other regional settings back to UK resolves the issue but wondering if there was a quick way of doing this?
Actually I am a basic user, but I like to utilize the sources around me to solve my problems and one of those sources my little knowledge about VB.Net. Today, I am forced to do some changes in the regional setting i.e. Format, Standard Digits & Native digits "Shot attached" many times a day for printing purpose through an ERP system. Therefore, I need to read the current setting for those options and two buttons (one to change them, the other to restore the previous setting).
I fetch data from an SQL Express database table named ALARMLOG to a datagridview1. One of the columns of ALARMLOG is "TheTime" which has datetime data type values. This values are in the following format "22/04/2010 13:23:45 PM".When I fetch the data to the datagridview1 I get "22/04/2010 13:23 PM".The problem is that I can't display the seconds in datagridview1. I tried the CORVERT command of SQL in order to convert from datatime to varchar but nothing...
I am writing a personal accountant software using VB2010. What I'm looking for now is to get the week date range of a specific date (Monday to Sunday). For example, if the given date is 16/03/2012, I want to get back:12/03/2012 -> 18/03/2012
strSQLString = "SELECT MatchID FROM tblMatch WHERE MatchDate = " & aDate.ToShortDateString.ToString which gives me the following string:"SELECT MatchID FROM tblMatch WHERE MatchDate = 10/23/2011"
