[Code]...
this what do for summing total records....when it's integer it's fine ..but i m doing summing for time...late_time is datetime...it gives me error..how can i add all total time from ltae_time column....???
I haven't done any VB coding since school (15 years ago) but currently have a need to run what "sounds" a fairly simple app at work. I'm hoping some of you might be able to give me some pointers as to whether or not my idea is possible, and if it is, how best to approach it.
I work for a company where we send a number of standard emails to potential clients asking them to contribute to our magazine . if no response we then send a number of follow up emails. each and every time I send a new email to a new prospect I'm editing one of our template emails, putting their name and email address into outlook and manually sending emails. Then for every reminder I'm going back into outlook, clicking reply all and then c&p'ing our second or third reminder emails in each and every time. needless to say at least 2-3 hours of my day are spent editing and resending the same emails on outlook.
[Code]....
[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 RepliesI am having a remote server it has INVENTORY DATABSE , and also iam having same databse in my local system. I want to populate by local database table with my Remote database table through Vb.net code by click a button. How to do this .
View 1 RepliesI want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
i able to insert the table but i unable update to another table at the same time
my
Imports System.Data
Imports System.Data.OleDb
[Code].....
I am developing a software of a finger print log in/log out system. I dont know how will i get the time from the device and put it on a time log table that i can specify the log in or the log out from the system.. because the device only records time.
View 7 RepliesIm using vb.net and the database is mysql to write a time management system. how i store date and time to the database?
View 2 RepliesI have a database that has two tables in it. One is a table of items (table1) and the other is the table of current items (table2).On form load I need to generate a random amount of the items from table1 and populate table2 with them. I was trying to do something like this:
[Code]...
I added a table to my Access database. I added that table to my dataset. Using Database Designer VB Studio, my table and tableadapter show up in the design view. The class definition is in the datasetdesigner.vb, and it shows in the object browser. But, I can't reference it in code. I am a newby and obviously missing somethning.
View 1 RepliesHow can I update local dataset with mysql database without making duplicates. Assuming I set some column in mysql as primary key, which has unique string.
adapter.fill will just add duplicates, but adapter.clear before that is not an option.
So I want to update if the key column is the same with mysql data and if there is option for ignore adding new row.
I need to Update Access Database Table with Data from a Different Table. Not all the rows of original Table to be Updated will be affected. How do you loop through the 2 Tables to do the required Update.
The Table to be updated is called "RecordList" and Table with new Data is called "RecListReport".Every attempt I've made won't work. I tried to Use 2 Datagridviews but couldn't get it to work right.
NewTestConn()
Dim Testconn2 As New OleDbConnection(NewTestConn1)
Dim da As New OleDbDataAdapter
[Code]....
I am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information
DVD Information
Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
i have this loop i need to create a table at run time for these values in this loop
For b11 = 0 To n - 1
Dim tableofsports As New Table
MsgBox(sporttype(b11).ToString)
[Code].....
I am using VB 2008 and Access Database.
Also using Typed DataSet.
My Question is how do i add Where Clause to TableAdapter at Run Time
I want to allow User to select Fields tobe filtered and values they should have.
For this my Select query is common but no. of records it will show will depend on User selected criteria.
I am trying to get a date/time from an Access table into VB.NET as type Date via a DataGridView. I can format the date/time in the Access database any way that will work. I have formatted the Access column as
hh nn d mmm
and entered a value of 21:00 28 Aug 2010
If I read the DataGridView cell using:
Dim x
As Object = dgvTargetList(dgvTargetList.Columns("StartTime").Index, 1).Value
The value for x reports: Date = #12/30/1899 9:00:00 PM#
Apparently the conversion is losing the year value. get a DateTime data type?
I have a form that is used to navigate through records in a table one at a time. The form generates the number of textboxes required automatically. Navigating through the records is easy enough, but when I click the update button it comes up with the error: Object reference not set to an instance of an object.
Here is the code I have for when the Update button is clicked:
Dim con As New MySqlConnection
Dim da As New MySqlDataAdapter
Dim Query As New MySqlCommand
[Code]......
anyone can give a code for display time table. This is the example of the output. I am using widows form
4 times 1 = 4
4 times 2 = 8
4 times 3 = 12
[code]....
I am using the tutorial posted here for my database testing. I have gotten it to display the data using a messagebox but it just goes through them 1 by one. I want it to display all the data from the database in a table on my form.
Using connection As New SqlClient.SqlConnection("Server=71.200.87.112MySQLExpress; Database=database_test;User ID=sa;Password=greddy6;Trusted_Connection=False;")[cod
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 RepliesI have a form that cycles through a database table with next and prev buttons Database name is "China.accb" and the table is called Users Table Users has two fields, both text.One is called UserID and the otheris Password"am getting an error message when I try to click the next button that states: "Unable to cast object of type "System.String' to type System.Windows.Forms.Textbox'. I've highlighted the line causing the error below
Imports System.Data.OleDb
Public Class frmUsers
Dim intMaxRows As Integer
[code].....
I am using Autonumber datatype for the very first time when inserting anything to the table it does not give any problem but when i am trying to retrive data using the Autonumber field i get the following errorSystem.Data.OleDb.OleDbException was unhandled Error Code=- 21472 17913 Message= "Data type mismatch in criteria expression." Source="Microsoft Office Access Database Engine"below is the code that i have used. [code]
View 6 RepliesI'm not so good in databases and SQL. At the moment, I have a interface of a simple payroll system as well as a database design. I got 4 tables consist of Employee, Payroll, Deduction and Salary as you can see in the picture link below. Btw, I'm using VB 2008 express edition and mysql 2008.
Interface Design: [URL]
Database Design: [URL]
My question:
How can I link them properly? did I link them properly? How can I save the data into 3 different table from the interface u can see.
How to use master/details datagridview for the same table in run time?
View 2 RepliesI have a table of data exported to an Excel file that contains a Date/Time Field. The entries in the table are formatted like 01/01/2009 14:00 (military time). Every line in the table contains unique information that is specific to that particular date/time information, 1800 lines of data (the reason that I dont want to hand sort this table). How can I identify the items in the table that fall after a particular time of day? More specifically, I need to identify which of the data fields have a time after 14:00 on that particular day.
View 1 RepliesI am trying to populate a listview from a sql table and at the same time run a progress bar. Currently my progressbar does't run and also the listview does not poulate.
HTML
Dim lsvdupsitemlist As New List(Of ListViewItem)
Private Sub FindDupsBGW_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles FindDupsBGW.DoWork
[code]....
Basically I have a program that receives real time data from microcontroller and displays it in a text box. What I would now like to do is to store the values received into a table that can be viewed when the receive program finishes. However I still want the values displayed as they are received in addition to being stored in a table of some sort.
View 3 RepliesI have to write a code in vb.net (2010).To get a data from Database A table 1 and dump it to Database B Table 2.What's the best way to do this? Most efficient way? I know I can do this very easily in sql management studio but I need to write a code to do this in vb.net.
View 2 RepliesI need to create a table with just 1 column containing times (starting from 4hrs) which increase in increments of 10 seconds for each row. So it needs to look something like this:
04hrs 00mins 00secs - 04hrs 00mins 09secs
04hrs 00mins 10secs - 04hrs 00mins 19secs
04hrs 00mins 20secs - 04hrs 00mins 29secs
.....
06hrs 59mins 50secs - 06hrs 59mins 59secs
This will obviously take a long long time to hard code so I'm looking to create it dynamically. Based on what i'm currently trying to learn I'd like to be able to do this using jquery or asp.net (vb) but anything will do as long as it works!
i know how to generate the Datareports through Data Environment by Firing a query
View 1 Replies