I am looking on how to split data I take from a database. Because I got a database that stores Date/Time and Notes all in one record, is there any way I could Split it into date and notes when it reaches my application.
View 2 RepliesI've been trying make a mdi notepad that can start up new instances of a "note" which is unique from the other notes as in you can save/change/cut/ copy/ paste in the individual notes without changing the properties of the other notes..something like a tabbed notepad but instead of tab control i have a mdi container. but i can't make it work. [code] problem with it is that whatever you cut/copy/paste in one mdi container richtextbox, it automatically cuts/copies/pastes in the other richtextbox controls in the other containers..
View 2 RepliesIs there something like a doc.GETITEMVALUE("Attachment")(0) ?Also, I can't find any documentation for the domino API. Does anyone have a good resource for this?
View 1 RepliesI want to update a date field in my table when a record is updated to reflect when the last update was made. I have this for the parameter: objEXTCommand.Parameters.AddWithValue("@entryDate", Now.Date)
However, this inserts the Date and a time of "12:00:00". I want the date and current system time. I've gone about several ways, but none seem to work. I try this: [Code]
As part of my current project for making student's lives easier by making an All-In-One application with many common programs carbon-copied inside it, I have a slight problem with sticky notes.
I am trying to recreate Sticky Notes as much as possible from the Windows 7 Sticky Notes Application. My problem is, I put a richtextbox on the sticky notes panel and wanted to either add a background image, or a transparent backcolor (my Panel that the textbox is in has the background image of the themed sticky notes). So my question is, is it possible to somehow dynamically make a property to allow the backcolor of a richtextbox to be transparent? or allow a background image?If you find an answer helpful, click the Helpful button. If you find an answer to your question, mark it as the answer. [URL]..
I got this code to get alll the notes loaded
Private Sub Load_History()
Dim myCnt As Integer
Dim myStr As String
[code]....
It displays 10 latest notes for me, but I also want it to display the name from the same row as notes.
I got a question on sql splitting a record into peaces.I got a big record like this and all of this in one piece of record:
"
5/21/2009 1:03:49 PM
Order has been placed
5/25/2009 1:45:49 PM
[code]....
This is used for making notes, so you can keep adding notes on it until it's done.And I know this is not the 'best' way of keeping these records, this is the way how it was kept until now.So now my manager comes to me and asks to make a different structure of processing these notes.Because it is stored this way I can only retrieve full record from the database, but what I need is a way how to take for example only the 'top line' of it.Example:5/25/2009 8:45:49 PM Confirmation send
Look at the code. all i need to do is take all notes from orders table.
The connection is openned
Private Sub Load_History()
Dim myCnt As Integer
Dim myStr As String
Dim totalrows As Integer
Dim myDataset As New DataSet
[CODE]...
What I need to know is if there is a way to combine forms. What I mean is, that when the program is open there is only 1 item on the toolbar instead of multiple shown on the toolbar. For example, I open the main app. and click on notes. The notes would open another form, but I wouldn't want another item on the toolbar, just the main 1, and if the X is pressed on the second form, it should just close that form, not the whole program. I mainly want this so that all the forms will minimize at once... and won't have the extra clutter of all the forms having a separate item added to the toolbar. So simply, I want 1 main form shown on the toolbar and when multiple forms are opened from the same project, it doesn't add to the toolbar and just keeps the one main tool bar.
View 2 RepliesI am using VB 2008 and want to record a start date and time and then the stop date and time in a rich text box, i can get the start time into the box but so far can only stop the time instead of 2 seperate times, what i have is a drop down box with a list of computers 1-10 i was trying to get it so you picked a certain computer and that went into the text box then you started the timer and that was recorded, finally you stopped the timer and that was recorded but as i am a total newbie it does not work
Here is the code i have.
Public Class Form1
Dim time2 As Date
[CODE]...................
I just can't seem to wrap my head around this.I wan to split a string up to a certain amount of characters.Eg if the string is "Hello"I want it to split up to 3 charactersthe result then would be "Hel".I tried various things, googled it, but I can't seem to find anything good.
View 7 RepliesI m using VB.net 2005 and MS Sql 2000.In my database date is in format of 2007-07-09 11:02:47.000. date&time.
When i m using the filter condition to get the record by passing date.it gives me zero record.
Can tell me what is the format of date to retrieve value in VB.net 2005.
I want to split my string into two values, I can split it at a point such as , or ? but how can I split it so AAAA will be AA and AA or ABC will be A and BC the only thing normal is the last two will be one and the first one or two will be the other. There will always be a string or 3 or 4 letters.
View 3 RepliesIn a rich text box I have a lot of lines of text, all of them have the same pattern:
12345 - Something here - something else here
65474534 - stuff here - random crap here
The number of words/numbers varies from line to line. What I'm trying to do is remove the third part, so the result would be:
12345 - Something here
65474534 - stuff here
I've tried using many variations of Split(), but since the number of words varies it doesn't always split it correctly. Also It doesn't seem to go down the lines of my rich text box, and it just sticks with the first like?
I know I can use the Split function to split things, but that works with chars. I want to split pieces of text by a word, namely: [ CODE ] (without spaces) I tried entering that into the Split function but it would split [, not including CODE] Is there an other method to do that?
[Code]....
how can i search a record in a database by specifying the range between the two dates using two date time pickers the first date time picker is to display the start date and the second to display the end date b the records are to be displayed in a list view below is a code attached that am currently using [code]
View 14 RepliesI have a form to add a new record to a database. In the form load event I have[code]...
If i comment out the line that sets the dateadded field, the record is added fine.
I have a dataset, which have a column create_date which have value(5/12/2011 12.54.00) , but i want to select the value from dataset with date only not by time (i.e. 5/12/2011),[code]
View 3 RepliesI have a CheckedListBox with some stuff in it and a ListBox with nothing in it. I'm using this code to get the Selected one in CheckedListBox1 to ListBox1 and splitting it:
[Code]....
eally been struggling with this one, and i cant seem to find a simple method of doing it...surely there must be one? I have a list of values that i am loading into a variable. I am trying to split that variable by the whitespace that separates each value...the only thing is the whitespace varies in size. eg.
View 3 RepliesI want to know if is there's a way to update a certain record if it reaches a specific date. [code] I wanted to automatically update the "IN" status to "OUT" status when the date.today = DateUpdate.. I am using MsAccess2003 to connect VB.Net2005express edition (using Odbc Connection) Coded it at back end(no controls)
View 1 RepliesI have table name "WO" in oracle db I want "Whenever I start my program, I want it it look at all the works orders, and if any works order has a date that is exactly one month before today's date, then I want the program to display a message and create copies of those works orders with a schedule date of today's date and save it".
Here is the structure of my database
DESCRIPTION VARCHAR2(200)
REQ_DATE DATE
WO_T VARCHAR2(30)
TASK_PER VARCHAR2(50)
ORIGINATOR VARCHAR2(70)
[Code] ....
Please also view the attached project file by following the given link [URL]
I have an MS Access database that has a field called DeletedDate. I want to use a Delete statement that will delete the record(s) when DeleteDate is 30 days old or older. I have tried several different Delete statements but none seem to work properly. They will always delete some of the records, but will leave some records where either DeleteDate is older than 30 days or will delete recored where DeleteDate is not yet 30 days old. I have tried these using DeleteDate as a Text field and as a Date/Time field. Which should I use? These are the Delete Statements that I have used:
'sComm = "DELETE from Agents WHERE Deleted = 'Y' AND DeletedDate < " & System.DateTime.Now.Date.AddDays(-30) & "
sComm =
[Code]....
Select a date and display record in datagrid?[code]...
View 20 RepliesDay Programmers how do i Update the record based on the Date & Time?? here's the code:
[Code]...
the problem is... it's updating but not on time... it's updating in advance... i just want to update it in the date & time that the record has and i'm thinking that it' may affect the other record's that not on time to update
how do i Update the record based on the Date & Time??
here's the code:
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
lblTimeOfDay.Text = Format(TimeOfDay, "hh:mm:ss tt")
[Code]....
i just want to update it in the date & time that the record has and i'm thinking that it' may affect the other record's that not on time to update
This code i had use for create a field in DB Access 2003:
SQL = "ALTER TABLE plano_contas ADD declperiodica06A char(40) WITH COMPRESSION NULL)"
Dim command1 As New OleDb.OleDbCommand(SQL, con1)
con1.Open()
command1.ExecuteNonQuery()
con1.Close()
like you see the code create a Text field with 40 lenght...Well the problem is:When i save a new record the record it's save in this mode: "100......... .........................." - the points means spaces and should be:"100"After try a lot of things i'm without more solutions in find why this happen!
I have two textboxes 1 button and 1 gridview and 1 button
database structure [code]....
Am using Visual studio 2005 with MS Access. I have a Datagridview with a date column in format 11/23/2011(Month/Date/Year).
Now i want to know how 'search criteria based on particular month and date'.
For Example if select 'Nov' as a month from combobox and click on search button, only November month details should be displayed.
I have three textbox ... textbox1 and textbox2 and textbox3
I want when I choose from date in textbox1 say 1-May-2011 and to date in textbox2 say 30-May-2011 and in textbox I type 1,2,3,4,5
I want on button click ... event the values will be entererd in database from 1-May-2011 to 30-May2011 as : mentioned below :
DATABASE STRUCTURE
ID Date Items
1 1-May-2011 1,2,3,4,5
2 2-May-2011 1,2,3,4,5
3 3-May-2011 1,2,3,4,5
so on till 30_may-2011
Record will be inserted in database according to from date and to date choosen in textbox1 and textbox2 respectively ...