User Makes Multiple Entries In A Single Day?
Mar 19, 2012
i have an access 2007 database in wich i have a table named abc_PersonalLog, wich also has three columns: Id (auto number), StarDate (text) and LogEntry (Memo). It is a Diary application. So, when the user makes a log entry, the StarDate column receives a string formed of concatenated year, month and day, i.e. if date is 20th march 2012, the string will be 120320, and the Log entry column, the text entered by user in a textbox.My problem is that, somehow, i have to retrieve that data, when the user will want to read log entries he made. I managed to assign the text property of a label to the LogEntry text for a given date.But, if the user makes multiple entries in a single day, the table will have several rows containing the same string in the StarDate field, but different text in the LogEntry fields. How can i display ALL the LogEntry texts for all the rows containing the same StarDate value? Here is my code so far:
[Code]...
View 4 Replies
ADVERTISEMENT
Sep 2, 2010
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]....
View 3 Replies
Jun 9, 2011
How can I prevent a single user from logging in to my asp.net website from more than one computer at the same time?I have tried using the application server side state managenment but it is not work properly.
View 1 Replies
Feb 15, 2012
in application am using list box i load items from a text file i want to remove single items from list and want to keep duplicate items in listbox?
View 9 Replies
Dec 23, 2009
Say I have a code with 3 methods that do some pretty intensive work. Would executing these methods on 3 seperate threads be faster then executing them one after the other on a single core cpu? And what if it's a dual core or HT?
View 8 Replies
May 7, 2010
I am trying to delete multiple selected entries from a listbox. When I run the code I have now, instead of deleting all of the items that are highlighted, it deleted all the items in the listbox.[code]
View 1 Replies
Oct 5, 2009
I have a problem, again. I don't know how to store multiple entries from one listbox into one cell from the database.
View 10 Replies
Aug 28, 2009
Im trying to make a program that makes a user type in a password, then open a folder where the user can put files. but once they close out of the file browser. the program needs to save the files and remove the directory. for example think of a file cabinet being the program, and the drawer being the temp folder. when the user closes the drawer, it goes back into the cabinet, or in this case the program.
View 7 Replies
Dec 9, 2011
This is a spin-off post from another issue I am working on. The problem is related to triggering event handlers when the user makes an input into a combo box, you might even call this a complaint.I have a combobox with a DataSource and ValueMember and DisplayMember. There is no DataBindings to worry about at this point. The combobox is DropDownStyle = DropDown and I havealso enabled AutoCompleteSource = ListSource and AutoCompleteMode = SuggestAppend.The datasource contains a list of Countires, and when the user types in an entry or chooses an entry from the combobox, I should be able to detect what the user has selected ortyped immediatley after the selection, some would say it's the very purpose of the combo box.Which event would you choose to deterine what the user has entered or Selected? few events come to mind:
SelectedValueChanged
SelectedIndexChanged
Validating
[code].....
View 1 Replies
Sep 30, 2011
In my program I've got several comboboxes that all have the same comboboxitems and when the user makes a selection in one of the comboboxes the selected comboboxitem gets disabled in the other comboboxes. (i.e. If the user has selected the comboboxitem with value 'a' in combobox #1 and selected the comboboxitem with value 'b' in combobox #2 then in remaining comboboxes both the comboboxitems with values 'a' and 'b' are disabled)
View 1 Replies
Jun 21, 2011
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.
View 22 Replies
Jun 11, 2011
I have 7 textbox entries and I would like to add them to a listbox and when I close my application it would save them, I have the code for the 7 texboxes and everything like that has been done, but I just dont know how to add multiple textboxs to a listbox then save the list box so when I close the application and reopen it, itll still be there. I know I need a button to add the list to the listbox, but how do I save them, so theyll still be there?
View 6 Replies
Oct 5, 2011
This is what I have so far for the following scenario: I want to have it so that if a users clicks submit without checking a check box from one section it throws up a dialog box that makes the process loop and give them a chance to check a box. The process wont continue until at least one check box is checked. The same thing above goes for my radio buttons as well. Here's my code:
[Code]...
View 2 Replies
Jul 29, 2011
I want to make a utility that allows the user to edit Jump List entries. There is some kind of tie between the raw junplist filenamess and the app, for instance:
Excel = cdf30b95c55fd785
Word = adecfb853d77462a
Those were found by trial and error and there are a few more on the net.
For MS Word the file is "C:UsersusernameAppDataRoamingMicrosoftWindowsRecentAutomaticDestinationsadecfb853d77462a.automaticDestinations-ms"
What I'm wondering is if anyone knows how to determine what filenames go with what program. Deciphering the files will be another issue for sure
View 7 Replies
Jan 31, 2009
I have data entries in my database that have a common field. For example:
account_id type user_id
1 new 1
2 old 3
3 new 1
4 old 1
I am using a query like this(mysql): SELECT account_id, type, user_id FROM table WHERE user_id = 1
This is just all theoretical. The problem that I am having with this is it is only returning the first result in this case account_id 1. How can I get it to find all the results with the user_id 1 because in the way I am thinking that it is failing is that it is finding only the first result and then ending?
View 1 Replies
Nov 29, 2009
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].....
View 4 Replies
May 10, 2011
I'm trying to create an invoice program in VS2005. I can make the database and insert and save all data regardingthe customer and the vehicle,but cant figure out how to create an input control where random items"car parts" could be inserted and saved. It would
View 4 Replies
Jun 5, 2009
Don't know if this is possible, but I'd like a config section to be generated when another developer adds my dll to their project. This way they don't have to look up in code or a doc as to what they need to put in their config file.
View 3 Replies
Dec 8, 2011
am trying trying to write some code for a ComboBox that does the following:
1. Allow the user to enter text into the combo box to type entries contained in the list source.
2. Enable autocomplete to assist the user in selecting entries in the list source, both from dropped down state and non dropped down state.
3. Restrict the user from typing an entry that doesn't exist in the list source.
My requirements are:
1. The ComboBox must run some code after a selection has been made or the user has finished typing an entry (not after the focus has been moved to another control)
2. The code must only run once after the user has made a selection from the combobox or has finished typing an entry
The problem: To achieve the above functionality, I had to run code on numerous event's. Sureley there is a better way, here are the events and the reason for the code:
SelectedIndexChanged:This is the code that is run when the user makes a selection. No Mystery here
KeyDown:
Must Run
If e.KeyCode = Keys.Return Then
ComboBox1_SelectedIndexChanged(Nothing, Nothing)
End If
View 1 Replies
Jun 22, 2010
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 Replies
Dec 13, 2011
I am looking for the code to consolidate multiple .xls sheets from within multiple work books in a file all containing the same format of information. Each sheet needs to be coppied to a new sheet within a single work book.
Once in a single sheet I need to then copy data from a range of fields into one consolidated sheet.
View 1 Replies
Oct 19, 2009
Suppose i have made a single user program that receives its data from a database on a SQL server. What things do I have to change to the program to make it a multi user program while preserving data integrity?
View 3 Replies
Sep 27, 2010
Is it possible to have a single class reside within two name-spaces and how can I do this?
To clarify: We have a class library (let say root namespace is classLib1), which has grown over time (more classes) and I want to logically group classes into different namespaces. However some of the older classes need to be grouped into these new namespaces (e.g classLib1.section1) and doing so will break legacy code in other assemblys that use this class library. So I want to be able to refer to a class using both name-spaces until we can phase the old ones out.
I can't find any information on this, which suggests there is a reason that people would not want to do this!?!
View 3 Replies
Sep 16, 2010
My program has two forms which get data from the same data source. After binding controls to tables and fields on both forms, I noticed each form has it's own apparently duplicate DataSet. Is it standard practice for each form to have its own DataSet even though they use the same ConnectionString and connect to the same database at the same time?
View 1 Replies
Apr 19, 2008
I originally developed a simple application software [VB.Net + MS Access] (Lets call this project A) but now I want to include more functionality in it. I have an encryption/ decryption software utility (Lets call this project B ) and a Text to speech generation utility(Lets call this project C) . That is, I want to add Projects B and C to project A. [Such that clicking on the main form of project A calls a form from project B or C as desired].In solution explorer, I right clicked--Add Existing Project--and added both the above mentioned projects 1 by 1. (Added B and C to the solution explorer with the already present A).As the application software's (Project A's) main form is the main form of my project, I want to have a menu option on the main form (Of Project A) so that a user could click on one of the menu options and the main form of my other projects ( Project B or Project C or Encrypt/Decrypt or Voice Generation) should open by him doing so. To this effect, I tried the following:
1. I dragged the form simply from one of the projects (From B or C ) into the folder of my Application Software (Project A).This generated a lot of Build errors and the Voice Generation utility (Prj. C) would not work like this.
2. Tried to reference a dll, however the authors of Projects B and C did not include a dll in their projects.
3. Now I came to know that to call a form residing in another project folder or even another folder within the same project, you have to give a path for the form. HOW DO WE DO THIS?
As you can understand, I cannot copy the entire code of the 3 projects here....I will try attaching my project here though..Here it is: http: rapidshare.co...MY_Prj.zip.html[Dear Administrator: The downloading option on the webpage does not allow files bigger than I mb, thts why I used an external link]As I said, in the application, Project A is TMS.NET ; Project B is EncryptFile and Project is C.I encountered a problem while adding project C [spoken word], so the project contains only projects B and A. I will try to attach project C seperately.That is, TMS contains proj A+B and Speech contains C.
View 4 Replies
Jan 12, 2011
I am trying to understand transformation matrices (not just their implementation in VB, but in general) and I've put about 3 full days into this so far. I believe I have the data in my matrices correct. Applying any single matrix to an array of points does a correct transformation.I am wondering if I understand how to combine multiple matrices into a single one.I understand you just have to multiply them together.I took this to mean you just have to multiply each element with its corresponding element in the second to make a third matrix?[code]
View 5 Replies
Mar 7, 2010
I've written an application with about 30 forms and am almost ready to publish, my biggest concern though is that i'm not sure if its a normal thing to do having all these forms and hiding, disposing and showing forms throughout the use of the application.I've toyed with the idea of converting to a MDI Child / Parent interface as well as having one form with lots of subcontainers that are hidden and then hiding / showing them as the navigational buttons are shown.Ive worked on this application for about 8 months now, but would be happy to rewrite the interface and appearance of it if i know that it is not generally an acceptable practice having forms flashing open and closed while navigating through the application.
View 3 Replies
Jun 18, 2012
I have some task regarding do operations on database using ADODB in Vb.NET.regarding using the same record set multiple times?
I have tried on this topic just by closing the recordset after performing First operation and doing second operation e.t.c.
In ADO.NET we have "MultipleActiveResultSets=True" in ConnectionString for SqlDataReader.Do we have any property like this in ADODB?
View 1 Replies
May 10, 2011
I'm working on a project that involves using multiple scrollbars. Scrollbar1 displays the medium value and its thumb is disable, scrollbar2 displays min value and scrollbar3 displays max value. I can try to use three separate scrollbars to accomplish thetask but that doesn't look nice. Therefore,
View 3 Replies
Dec 4, 2011
ok i need a code to save multiple textboxes in a single .txt..
EX:
TextBox1.Text = ("Michael Rittenburg")
TextBox2.Text = ("United States")
TextBox4.Text = ("Nashville")
TextBox3.Text = ("Tennessee")
TextBox5.Text = ("37203")
View 3 Replies