I have an accounts program. My cash book shows data based on date picked from DateTimePicker. Cash book is not entered everyday. I want to make my datetimepicker so that based on dates found in the database, it changes colour or enable / disable some dates, for which cash book has been entered. How is it possible?
View 6 RepliesI am using visual basic 2008 and I am trying to create a form.
[Code]...
Is there anyway i can select multiple dates in a Date Time Picker in
View 1 RepliesI am working VB.NET 08 Access Database. I have Two "DateTimePicker" controls one is "StartDate" and one is "Enddate". Now I am selecting Startdate like May 1st OK. Now when I select Enddate control this calender shows only Equal or Greater than dates should be Enable. EndDate should be Always Greater than Equal Date. That's why when ever user selects the Enddate Before May 1st dates should be disable..
View 2 Replies1.I want to click the datetimepicker and textbox will display dates by dates,I want to know if I can do this. Example - textbox will display -> 2/10/2010,2/12/2010,2/25/2010.
2. Can I off the today default on the datetimepicker?
When entering a date in the text-part of a datetimepicker, one could find him in deadlocked situations in normal conditions, but even more if min/max dates are set.Explained by example: having format set to mm/dd/yyyy, having date set to 01/31/2010, wanting to change it to 02/28/2010.At this point the '02' for the month isn't accepted because the day is set to 31, not existing in month 02.
When min- or maxdates are set, the situations where fluid date-entering is even more difficult, are even more frequent.To keep some compatibllity, a new property named 'partialvalidation' which defaults to 'True' could make that when set to 'False' a date is only validating/validated when the control loses focus or any other event (EndCurrentEdit, ...).
I have a dateTimePicker and I set the maxdate to today's date Now when a user select the date after today's date it won't select it but it still be displayed. How can I remove them or disable them do the users can't even click on the date if it is after today's date
View 7 Repliesbeen a long time since i came to the forum. i use to program a lot in vb6 but its been a long time since i did it so im really rusty. now that im trying to get back to programming, im finding it a bit of a challenge in vb2008... i have this question, im using a datetimepicker control to select dates in a calendar. what im trying to do is disable the textbox in the datetimepicker so that the user can only use the drop down calendar to select the date and not enter the date manually! does any one knows how to disable the textbox in the datetimepicker but still be able to select a date from the calendar???
View 4 RepliesI'm using datediff to establish difference between two dates using datetimepicker.i.m nnot getting the right results. a one day difference returns a 0, a two day difference returns a 1 etc. the code I am using is posted below.
days = DateDiff(DateInterval.Day, dtpStart.Value(), dtpEnd.Value())
I was wondering if someone could help me. I have a database and i want to select all records between 2 dates.I use two datetimepickers and would like my datagrid to show only records between dates selected.
[Code]...
How to customize a DateTimePicker to show dates in other calendars systems ?
View 2 RepliesIs it possible to disable the dates that appear before todays date in a dateTimePicker control?I want to put in some validation so that my users can only select days in the future...ie a future appointment date?
View 5 RepliesI am wanting to retrieve the current weeks dates from a DateTimePicker control.
Eg, if i select Tuesday July 5, 2011, i will return the following dates: Sun July 3 2011 right through to Sat 9 2011
I've got a form with following controls: Two Datetimepickers Two Buttons One TextBox One ComboBox The idea is adding and subtracting dates using Datetimepicker contols... I found codes for doing Dates Calculation but is'nt quit correct;for example: if i want to add 21years from today the result will be: sat 30 Aug 1930 The Adding Codes on comand button: Private Sub BTNadd_Click(ByVal sender As System.Object, ByVal e As
[Code]...
I try to make a WFA for filling, reading etc. to a database. I want to compare 2 dates (actually 1 date is changed by 42 days) that are chosen by a user through a datetimepicker. After comparing the 2 dates the "newest" date has to show up in a non editable textbox. This Is my code (of course I have 2 subs for the datetimepickers as well).
Private Sub AwbdatumTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AwbdatumTextBox.TextChanged
Dim DatumbinnenkomstDateTimePicker As DateTime
[code]....
I have a program where you have three entries, CD name, artist, price and it goes into a listbox and .txt file when closing. I have to have a message box if you enter the same CD name. I have a code to open the .txt file and compare strings but I need to change it to compare only the CD name and not all three entries. Is there a way to do my string compare against my listbox without opening the .txt file?? The program loads the listbox from the .txt file when opening. Private Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click' adds CD information to the list box
' declare variables
Dim strName As String
Dim strArtist As String
Dim strPrice As String
[code].....
I've made a program for a small business that keeps track of what items there are, their prices, and the quantities of those items. I would like to add a button that goes along the lines of "Add to sale" or "Add to cart", and have it select the currently highlighted item in the database grid view to add the price column up, to make a total for a sale.
[Code]...
My first method is trying to get all entries in one of the database tables. However when I try to build the solution this is the error I get:
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Error
1 Value of type 'String' cannot be converted to '1-dimensional array of String'.[code]....
In my head form, in have a few textboxes related to an access database.
How can i put my entries in my database.
I already created a connection, dataset, tableadapter,...
I manage to show some data of my database in to the form but not in the other way.
I want to set a certain column to true or false automatically based on what value another column has entered. I managed to get this working by myself using the 'SQL Pane' in VB and testing it by using execute sql but I don't know what to do now. I assumed that I could just save it and it would work from there but that's not the case, it dissapears from the SQL Pane if I close the project (even though it worked fine when I ran the project the first time), so where do I put it/what do I do with it in order to get this to work?
View 1 RepliesI conected my access database with the form and I need the code to count how much entries are in the database and increase that number by one, and then to write that number in one textbox so that when I press save in the form the entry would have that numbar as id.
View 7 RepliesI created a simple database that has 3 tables & 2 joint tables for data entry purposes.The tables & fields are listed below. All items that appear in red are the primary keys
Employee
EmployeeID
- FirstName
[code].....
Is it possible for Forms to check for certain entries in an online mysql database and to create new ones? (login/registration)
View 8 RepliesI just starting coding in VB.net about two weeks ago so I'm still a begging and I learn best by seeing working code and then adapting it to my situation. That being said, I need help displaying table entries in a listbox. I've successfully created a database in my test application, added it to my Data Sources and used a drag / drop method to add Datagrid View & Details (labels & textboxes) to my application for testing purposes. Now I want to try and display table entries in a listbox.
Example Database:Table: Contact
- ContactID (autonumber) [primary key]
- FirstName (text 50 limit[code]....
Also is there any benefit or down side to creating a database in MS Access, create the relationships & tables, then attaching that database to my application or is it better to create the database in the application like I did in the example above by using the Add New - Service-Based Database option?
I have a program with two forms, one that handles the applications controls, and the other with the functions that open a file (csv), open a database, and query the database. The controls on the first form are a list box, three labels (to display parsed csv information), and three buttons (clear database, load database from csv, and load listbox).
The clear database and load database buttons (events) seem to function correctly.On the other hand, the load list box event doesn't function 100% the way I'd want. [And, I can't test the selected index event yet]
The code for the load list box event is:
Code:
Dim db As New DBUpdt 'second form
b.openConnection("weather.mdb") 'open database connection
db.query("SELECT * FROM stations") 'query database
Do While db.moreRecords
[Code]...
You see, in my new VB application, I have a form with a TextBox and a ListBox, and I need to make it so that, whenever some text is written in the TextBox, a SELECT operation must be performed in a table belonging to an SQL database, in order to return the elements of a particular column that are LIKE the text I just wrote in my TextBox. The results of this SELECT operation must then be written inside the ListBox.In other words, whenever I have some text inside my TextBox1, I have to do:
SELECT Description FROM Elements WHERE Description LIKE TextBox1.Text (this must be done whenever the text changes)And the results of this operation must be displayed in the ListBox on the side.
I am trying to take a database with multiple entries of 11 digit numbers and run a check sum algorithm that adds the 12th digit to the 11 digits as an output.The algorithm is as follows:
Add sum of odd digits starting with first digit, then multiply by 3.
Add sum of even digits, then add to result of odd digits multiplied by 3.
Take result and divide by 10. The remainder is the check sum which needs to be added to the end of the original 11 digits.
I'm looking to retrieve all the entries from one column of an access database table and copy to an array. this array i will then be randomly selecting values from it to create foootball fixtures. I'm confident of being able to achieve the random side of it but i'm struggling to get the records into the array.
View 12 RepliesIm making a 'DVD database'. I need to be able to cycle through entries in the database wit ha next and previous button but for the life of me cannot figure out how to do so.
[Code]...
I am working on getting a multiple values from a single column displayed in a single textbox or label. I know I should be able to find the information I need online, but I am coming up empty. I am using Visual Studio 2010 with SQL Server 2005. For example, I want to pull all the email addresses, that have a value, from a table and display them together. The output I am looking for is like this:
[Code]....