I am having a really hard time with the hour(TimeOfDay) VB Express 2010 command, is there any one reading this that could enlighten me on this problem please.My local machine time is in standard time, but the VB hour(TimeOfDay) command sent to a text box on my form is in Military time, is this a bug or do I need to use another command that I am not aware of, or can I use the format command to force it to
standard time and if so how do I accomplish this task please as I have battled with this for few weeks now and I am all out of ideas as to the nature of the problem.
I know about the following:-format(TimeOfDay,"h:mm:ss") 'displays time in standard time with out a padded zero format(TimeOfDay,"hh:mm:ss") 'displays time in standard time including a padded zero!
format(TimeOfDay,"H:mm:ss") 'displays time in military time with out the padded zero!
format(TimeOfDay, "HH:mm:ss) 'displays time in military time including the padded zero!
how could I do the same with the format(Hour(TimeOfDay),"?") function I also notice that the minutes and seconds can include or exclude the padded zero, I would also like to have control over these two commands please.
I just downloaded the latest VB Express. It seems that thought the functions are available, there are many that are not as fully functioning as they should be, like PRINT dialogs and TIME/DATE dialogs, etc. Are some of these functions not fully developed in VB Express because they are only available to the licensed version?
1. I've registered my VB 2010 Express, will it still expire?
2. Will the applications I made using VB 2010 Express expire after some time?
3. Is it OK to write my code in the designer.vb file? I don't know why, but when I started writing my application it took me to the designer.vb instead of form1.vb code.
4. I've been working on an application for a week now, but suddenly I can no longer access my Design View(Shift-F7). All my codes are written on the [form name].Designer.vb. I can still view my codes but I cant access my form layout. On the solution explorer, my forms no longer have the 'form icon'. When i press Shift-F7 nothing happens. Right-clicking the form on the solution explorer doesn't show 'View Designer' option. How can I fix this?
I have found a tutorial that will teach me how to set up my first Database, but the first thing it tells me to do is right-click on the Data Connections Icon within Database Explorer and choose "Create New SQL Server Database" ... unfortunately, this option is greyed out, so I am assuming I have to choose "Add Connection" first ...[code]...
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.
I have a program that I need to operate functions based off of hotkeys.One of the most important things I need to be able to do, is hit Escape at any time and end the program.Remember, the program form will not be up, it will be a number of any other applications, I need like a global hotkey or something.
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.
When you refrence a Function like this one:[code]You may want to be able to get more out of that, like this.[code]So how would I be able to add subs or functions onto a sub or function like that?
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...
When I try to code in VB2010, I usually unmark the reference to Microsoft.VisualBasic. Because I do not want to use the legacy functions of VB6. I want to complete walk in .Net path. And I have found some alternatives for the old VB6 functions. But the rest not. Where can I find the list of those methods or classes (alternatives for the VB6 functions) ?(For eg: when I tried to find the difference of 2 dates, I couldn't find any other alternatives. So, I came back and used the Microsoft.VisualBasic reference for using DateDiff())?
I came about these two functions (ReadHEX and WriteHEX) that, obviously, read a hex offset or write a hex offset of a file. However, these functions were written in VB6. The main thing I'm not understanding is how to open a file (in a filestream I presume) and then to either read or write a certain offset from the file. I'd also need to convert the string I'm writing to hex before I actually right it, but I've got that under control. Here's the current functions as they were written:
I have a windows 7 computer with vb 2008 express on it. it works really well, except only one thing. when I try to debug an application ( usually windows forms), it produces a run-time error saying: Error while trying to run project; unable to start debugging.
I'm wondering if this is possible, I want to be able to call functions from within the program itself by means of an ArrayList? I want to be able to do something such as:
FunctionsList.Add(SomeFunction) FunctionsList.Add(SomeSub) For Each Function in FunctionsList Call Function Next
Would this be possible? It's important for a project I am working on.
I am trying to write a program that shows the user the current system time and date using progress bars in VB 08 Express but don't know how to start it, I am having trouble with getting the program to refresh the minutes and seconds progress bars
I'm writing a report scheduler that is somewhat of a clone to the backupexec scheduler and the layout can be seen in post #10 here: [URL]..It works great and saves/edits/deletes records just fine, but now i need to compare those records one at a time in a windows service that i'm writing in order to trigger automated report creation and emailing - i already have the report and i already have the code for the emailing, i'm just looking for the most efficient way to loop through the table (that i've pulled in to a dataset) and compare its records with the current date and time - if true, the event fires.
[Code]...
1stSun, 2ndSun etc are bit fields, time is a datetime, and the remainder are varchar. My service checks the database every thirty seconds.The english version of what i'm trying to do is "Connect to the database, grab the entire table (it will always only have 5-6 entries max, so i felt 30 second sweeps was okay), and If today is the 1st Sunday of the month, and it is currently 11:00:00 a.m. (could be any day or time, this is just an example) - loop through the dataset to identify if any records match the time field or greater - if they do, fire the report
I have a dll. Instead of referencing it, I would like to be able to import its functions directly into my application. Anyone have a code to get started?
In our VB6 applications, we added a few utility functions for tracking the amount of time spent in a function. We did this to track performance bottlenecks. Basically, how it worked was there were two utility functions: StartTickCount() and EndTickCount().
You would pass the name of the function in each, and the functions would use a dictionary to get the tick count when StartTickCount() was called, and then subtract the tick count when EndTickCount() was called. This wasn't perfect because it didn't of course take into consideration that calls to get tick count takes time, etc, but basically it worked for our purposes. How to make sure to call StartTickCount() at the beginning of each function and EndTickCount() at each exit point:
Private Function SomeFuction() as String ' indicate the function started StartTickCount("MyClass.SomeFunction") ' some logic that causes the function to end [Code] .....
Anyway, is there any functionality built in, either through the VS 2010 debugger or in the System.Reflection namespace, to do something similar in VB.NET? Basically, what I want is to log the number of times each function is called, the total amount to time spent in that function, the average number of seconds spent in that function, and the maximum amount of time spent in a single call in that function.
I am porting an app from VB6 and I run into problems with references to functions and subs. Basically, let's say I have 2 classes added to the project, like this.
Public Class OOOOO Public Shared Sub BBBBBBB(ByVal FileName As String) ... Call CCCCCC() Call DDDDDD() etc. ... End Sub [Code] .....
I had to make the BBBB() shared to be able to call it from another function AAAAAA() from another class PPPPP. However, I get error on the references in the BBBBB(), that CCCC() and DDDD() have to be made also shared (so instead of 1 error I got number of errors). When I tried to make them shared as well, I got tens and tens of errors due to other references of both variables and functions.
I use an access database and some queries return calculated fields resulting from functions in the code module of the database These queries are not listed in the "Views" tab of the query designer when adding a tableadapter in the data source designer