Create a combo box that contains the values:
- Year 7
- Year 8
- Year 9
- Year 10
Thats easy enough, but i need to then need to do the following:When a option is selected, i want to display a seperate table for that year.For example, if i select "Year 7" a table specificly for "Year 7" is displayed.(Using visual studio)
I'm just starting out at vb.net but have done programming before. i am trying to use a treeview to display information in a seperate table on the same form dependant on which nod of the tree is clicked. Secondly is it possible to import the information from an excel spreadsheet or does the information have to come from an access table.
[Code]...
I want to enter Year, Month & Date in a separate TextBoxes to get a Function work as these 3 have to be given as parameters for that Function. I've been using 3 different TextBoxes to enter the Year, Month & Date. Now, I thought of using either a DateTimePicker / MonthCalendar for this. how to get it done. By clicking a Date in the DateTimePicker how can I get the Year, Month & Date separately fed into the Function? [Code]
Is there any way of getting the year, month & date separate from the DateTimePicker / MonthCalendar?
I'll get straight to my problem - I'm currently coding in Visual Studio.I have a table (countries) with the columns ID | Name. The table is filled with around 28 records.I also have a form with 4 combo boxes (set up as 1,2,3 & 4) that I want the user to select. These combo boxes will display the names from the table countries. I then want to use the selected names in the combo boxes to Insert into their corresponding ID into another table. For example England would have the ID 1, USA the ID 2 etc.So, is it possible to have separate combo boxes that will give separate ID values but using the same table? At the moment I can't seem to find a solution.Eventually the form will have more than 4 combo boxes so I don't want to use separate bindingsources for each combo box.
View 5 RepliesI created a telephone number form where the user enters the telephone number in a text box as (nnn) nnn-nnnn. The first 3 digits in parenthesis are the ISD code, the next three are the area code and the last four are the local number. I need to separate out these three fields of the phone number and display in three separate text boxes labeled appropriately. Now, suppose the user enters the phone number in a text box as a continuous string of 10 digits, where the first three represent the ISD code, the next three represent the area code and the last four represent the local number. I'm lost as how to change this string into the form (nnn) nnn-nnnn. This is what I have
[code]...
This command will show todays date:
Code:
MsgBox(DateTime.Now.ToShortDateString())
I am trying to display only year in datetimepicker in vb.net
View 6 RepliesI have a MonthCalendar1 on my form and i am trying to save the day the month ans the year to a table from the MonthCalendar1.
.Fields!ISBN.Value = txtBookIsbn.Text
.Fields!SupplierID.Value = txtSupplierID.Text
.Fields!Date.Value = MonthCalendar1.BoldedDates
[code].....
How do I get final output to display month, day, year? Would I need another replace array? Or can I dynamically format from SQL table?[code]...
View 7 RepliesHow to set current year in AssemblyInfo file?
I used
Instead of this:
<Assembly: AssemblyCopyright("Copyright 2012, Company Name.")>
tried this:
<Assembly: AssemblyCopyright("Copyright" + DateTime.Now.Year.ToString() + ", Company Name.")>
I get invalid constant error.
I don't want to use registry key entries, what is the optimum way of doing this? (so that when a user right clicks on EXE & looks for assembly information can see current year).
I'm using VS in Vista. I have using a DataBase in SQL2008 which its date format is year,month,day. In my app I have the date format as Format(Now, "d") which shows 13/12/2009 but when inserted it displays as 1900-01-01 in the DataBase. How can I have the date format to dispalay year,month,day as in the database.
View 10 RepliesI have a database of asset information with asset age as one of the columns..now i wish to display all the assets which crossed 4 years in the current year
View 8 RepliesThe program I am working on uses arrays and a text file. In one section of the program it's suppose to display the most active year for storms between the years 1990-2008. The year that has the most active storms is 2005, but I don't know how to write it in the code so that it displays. Attached is the text file.
So far I have a For Next loop that counts the arrays.
Public Class frmHurricanes
' Class Level Variables
Public Shared _intSizeOfArray As Integer = 18
[CODE]...
i want to insert booking_no as combination of year and sno(year/sno) into database here iam giving the code as follows,,,,,,,,,
here sno stated from 1.........
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("guest1").ConnectionString())
Dim booking_no, sno As String
If Len(sno) = 1 Then
[code]....
but here booking_no was not inserted properly,it was inserted as "0/ ",,iwant to insert booking_no as "2010/sno" ,
how to validate the day if the selected year is a leap year in combo box.
View 1 RepliesI am currently updating an application I wrote to view Car Insurance Policies, using a backed SQL database and a front end vb.net GUI. I now need to make a change.
I haev added a new table which has all Active Policies, and i have the old table with every policy there has been active or not. We do an import from a separate company, and there is no Active/Not Active field.
I need a query/code that will populate an "Active/NotActive" field in the old table. For example:
CODE:
I have problems figuring out how to separate a single person to display on my listbox.
I am currently working on an assignment called "Douglas Resort Reservation" and we are supposed to select a query from the combo box Guest Search. For example, when I select Barb Allen, I get the info to display properly, which is good. But, I still have a problem.
When I try to click my button 'Prepare Invoice', I want Barb Allen's info to be displayed in my listbox 'Invoice'. But, now I don't have that complete. I have a whole list of items generated when I load my whole thing from my Form Load event from the textfile RESORT.TXT. I get a whole list of items instead of individualized items.
My question for you is: "How can I get just ONE name and person's information to show up?" when I press the button 'Prepare Invoice'.[code]...
how to seperate a single person to display on my listbox. I am currently working on an assignment called "Douglas Resort Reservation" and we are supposed to select a query from the combo box Guest Search. For example, when I select Barb Allen, I get the info to display properly, which is good. But, I still have a problem.
When I try to click my button 'Prepare Invoice', I want Barb Allen's info to be displayed in my listbox 'Invoice'. But, now I don't have that complete. I have a whole list of items generated when I load my whole thing from my Form Load event from the textfile RESORT.TXT. I get a whole list of items instead of individualized items.
"How can I get just ONE name and person's information to show up?" when I press the button 'Prepare Invoice'.and display information like this:
Barb Allen 604 777 1234
# of Adults 3
# of kids 1
Check In 2008-12-01
[code]....
I need to connect to a SQL Server from a network drive, I'm unable to due to the security settings on the network drive and I'm unable to have these changed.Is there any other ways of connecting to this SQL Server?
View 13 RepliesThis is what I'm trying to accomplish. When the user enters 4 words into a textbox such as "hello my beautiful girl". I want it to display it into a label and I want each separate word to display into a different line.
View 6 RepliesI have an Array called myDat
It contains Name and date of birth;
Joe
12/15/80
Tom
7/11/65
and so on ... Keeping the same order so they match I want to put the names in one array and dob in another
how to seperate a single person to display on my listbox.I am currently working on a homework assignment called "Douglas Resort Reservation" and we are supposed to select a query from the combo box Guest Search. For example, when I select Barb Allen, I get the info to display properly, which is good. But, I still have a problem.
When I try to click my button 'Prepare Invoice', I want Barb Allen's info to be displayed in my listbox 'Invoice'. But, now I don't have that complete. I have a whole list of items generated when I load my whole thing from my Form Load event from the textfile RESORT.TXT. I get a whole list of items instead of individualized items.My question for you is: "How can I get just ONE name and person's information to show up?" when I press the button 'Prepare Invoice'.and display information like this:
Barb Allen 604 777 1234
# of Adults 3
# of kids 1[code]............
I have produced some VBA in Access that creates a spreadsheet.I have also created an SQL query that retrieves records from an Access table.I have 48 tables (each table for a specific institution centre).I have created another bit of VBA code that creates a spreadsheet and loads the records from the query in to the spreadsheet.Each centre has a unique Sequence Number (Indent Number)At the moment though, all I can do is import one table (records for one institution) in to a spreadsheet. I want to end up with calling the function and having an output of 48 spreadsheets being saved to my desktop, each spreadsheet containing records of a different center.I have thought about putting a loop in, but not sure how I would quite go about it.
Here is my code to create the spreadsheet:
Public Sub ExcelExport(lngIndentNumber As Long, strFolder As String, strCrit As String, strReport As String)
', ctlLabel As Label,
DoCmd.SetWarnings False
[code]....
I'm using VB.net 2005, .net framework 2.0
I'm currently having a form that has a button starting a long process, with feedback into another windows textbox (call frmProcessLog).
I'm using a Background worker to laucnh the process, upgrade the status of the process and display feedback on the frmProcessLog textbox, and to know when the thread process ended up, (from the cancel button, from an error or normal termination).
the main thread process has some msgbox in it, asking questions to the operator (yes/no/cancel).
I've added the msgboxstyle.systemmodal to the msgbox call which works "ok" excpet if the operator decide to ignore the showing message box and click the cancel button on the frmProcessLog form, which is still clickable even though I supplied "systemModal" to the msgbox. this makes the msgbox hidden behind the frmProcesslog form and the process can still continue.
If I close my frmProcessLog form, I will see the previously msgbox behind it and If I end up click one of the button it will end up at an application error because the thread that called it is not existing anymore.
So I would like that the msgbox to be launched from the thread making it as if it was launched from my frmProcessLog window in a modal way.
I want to create a game using visual basic 2010. I'm a specialist in VBA and Excel but not VB 2010.I want to display and hide a whole group of objects. In Acces I used for such cases the TabControl. For example in Tab1 the Game, in Tab2 the highscore and in Tab3 the options. Then I made it transparent, so that the Tabs (Buttons) are not visible, only the objects in Tab1 Tab2 and Tab3. With VBA I select the Tabs controlled by my own buttons (jpg). I tried the same in VB 2010. Without success.What can I do to switch between game, highscore and options without using popups. I want to display them at the same positions. So game objects and option objects should hide and highscore objects should be shown. And the other way round. Like the handling is with different layers in photoshop!
View 2 Repliesi want to create a table that include a current year data and as well as previous data to be compare. here is the example of the table that i want to create: but i want to compare one of the annual data with the previous year. as example i want to compare between the data of current AR of 2007 with the current AR for 2006, Current AR of 2006 with current AR for 2005 and go on~, but i have no idea how to do it.
View 1 RepliesI have this cash register program with separate forms for the items and the display form. The code works untill you press the button 2x. It says 5.5 + 5.5 = 11.5??? Can you fix this code?
CashReg.ListBox1.Items.Add("Item 1")
Dim cash As String
cash = (5.5)[code]....
I currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
i have to create a mortgage calculator (I know we have killed this mortgage calculator). Has to display an amortization table to display the list after doing the calculation. Here is the actual assignment:
Write the program in VB.Net (not Web based) and have it accept user input of the amount, term and interest rate. Display the mortgage payment amount. Then, list the loan balance and interest paid for each payment over the term of the loan. The list will be longer than the screen, so use loops to display a partial list, hesitate, and then display more of the list. Insert comments to document the program.
I have created 4 buttons. Calculate, Clear, List, and Exit. The buttons all work, but the list does not. Not sure what i am doing wrong.
[Code]...
I have a TabControl object on my form with many tabs created in code (TabPages) and my problem is that the same objects that are in the initial TabPage needs to be in the other TabPages created in code, I have this done in code when the user clicks the 'New Tab' menu option, however the same code is used for any new tabs created. The problem created here is that I have an event against one of the objects that appear in the other TabPages, but because the same code is used to create any new tab pages, the event will only work on the newest tab page, if that makes sense? By the way these objects that appear on the other TabPages are properties at the top so events can be handled against them in the respective subroutine.
[Code]...
