i want to allow user to select or find access database file when the software is executed/opened for the first time. after user selects the file and as he clicks open the software shows the full path of the file and then stores it with the provider and datasource in a txt file for future use.
View 3 RepliesI am implementing a chat client in an application. Conversation windows are tabbed and I have to alert the user for new messages. My temporary solution was like this:
There is a timer with 500ms interval ( always running ).
For Each t In SuperTabControl3.Tabs
If TypeOf t Is SuperTabItem Then
If t.Tag = "1" Then
[Code]....
Will this cause performance issues? I have no possibility to try on an older computer but they will use this application on slow pc's.
I am writing a program that has to print an alert message in a textbox if the user inputs invalid data. Invalid data would be a negative number. The textbox is the same textbox as the result would be in provided they input valid data. Here is what I have but it will not print the alert.
[code]...
i'm currently using VB.net 2005 with an Oracle 10g db.1. Alert the Admin by displaying on the main page a list of users who are due for re-certification if there are any. - I've managed to do this except my date calculation for the alert is wrong. When a user is certified say on 25-06-2010, they will be up for re-certification in 25-06-2011. I need my program to start alerting the Admin a MONTH before the user is due for re-certification. So basically start the alert on 25-05-2011.Currently this is my logic in VB.
Reason = Get value in Reason field (If this field is not empty, then don't raise alert for this record)
Renewal = Get the re-certification date
Sysdate = Get current system date
[code]...
Alert the Admin via email - I've managed to create an email (stored procedure in Oracle) that contains the skeleton. I say skeleton because althought the mail executes fine, I've not managed yet to include the list of users due from the db. I created a Curser and dumped my results in there, but not sure what to do after that.
My application needs to be able to be pointed at different SQL Servers and different databases and I would like to provide the end user with a nice method of selecting both the server and database (the app is for use by other IT staff).Ideally, I was thinking of allowing them to browse to the server (with possibly entering credentials or even better, using their Windows credentials as the databases in question should be accessible to the relevant people via their AD account), and then listing the databases on that server allowing them to select one to use.
I would like them to then be able to easily change the server and database whenever necessary.I imagine I would then need to build the connection strings based on what they select but at the moment I have got rather stuck in just trying to create a form with some kind of Server Browser (I've not got as far as a database browser!).Failing some kind of server/database browser options, I would change to some simple text boxes where the user can enter the name of the server and database directly with some kind of connection verification button.
Finally, is it easy to connect to multiple databases on the same SQL Server at the same time? Is it just a case of creating and referencing multiple connection strings?I am using VB 2008 Professional and SQL Server 2005 Standard.
I have created an application which asks the user to enter password to login.Now how can i inform the user(if his caps button is on) that his caps button is on while he is entering his password?
View 3 RepliesI have a MaskedTextbox which takes Us Phone numbers. Using The MaskedTextBox ensures the user can enter only numbers and the number gets formatted right.
Here is the problem I am having: How do I add an error message if the box is left empty? I am not trying to validate the number, just need a way to add: "You forgot to enter a number." Can I add this to a MaskedTextBox?
How do I add a message box or alert to a MaskTextbox if the user hit submit without entering numbers?
for the first time i am havin this kind of issue, i tried some google'in Private Sub frmMain_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code]...
Trying to select an integer from an Access Database using an SQL statement in VB[code]...
View 5 RepliesI have a VB6 application that is accessing an sql server 2008 database using odbc. The application also accesses an ACCESS database. How can I create a temporary table in my ACCESS database using a table from the SQL database. I have tried the following:
SELECT GLTransaction.* INTO TempAPEntry0 In C:DOCUME~1DONNPS~1.000LOCALS~1TempCSAReport2564.MDB FROM GLTransaction WHERE GLTRSource = 641;
Using 'SELECT from' with value from a text box in vb.net with access database
View 11 RepliesHow can I catch error if the data that user select not in database?
This is my code.[code...]
I need to create a notification system for my application that will alert the user once new items have been sent to their queue, which is made of up database entries. The latter part of this question may need to be asked in the database forum, but I guess we'll figure that out First, since I haven't created anything like this before, I need some direction on what the best possible solution would be.The notification system should always be running and work independently of the main app. With this requirement, I thought a Windows Service would be best.
The notification itself will just be a quick form that alerts the user. I'm sure most of that will be fairly easy to create. The only issue I'm wondering about is how to constantly check the database and determine a new record has been inserted.Would a windows service have a timer or something that allows me to constantly check?If it does, how would I determine a new record has been inserted?
I have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
I am using VB 2008 Express to connect to an Access 2007 database. I have a combo box called SelectYearMonth that is populated by the database. When I used the Access report VBA, I used the AfterUpdate() event to calculate a sum. I need to know how to do the same operation in VB 2008 Express using the SelectedIndexChanged event of the combo box.
When I made a report in Access using VBA I coded my calculation as:
Me.ExactReprintTextbox = DSum("Pages", "HBELP_FINAL_Q", "YEARMONTH = " & [SelectYearMonth] & " AND JOBTYPE = 'E'")
While this works great with Access VBA, this syntax does not work in VB 2008 Express. How do I code this in VB 2008 Express?
I need to calculate the sum of all "Pages" of a particular "JOBTYPE" in the Access database for the YEARMONTH selected in the combobox. I have a query in Access called "JobTypeExact_Query" that contains all the pages of that particular JOBTYPE that I need. What I need to do is limit the calculation results to the YEARMONTH selected in the combobox.
I want to do is make a notification system, kind of like aim were a new little box will show up to alert the user of a couple different things.
This is how far i have gotten :
Dim popups As ArrayList
Public Sub newEvent(ByVal title As String, ByVal description As String)
popups.Add(New Form())
[CODE].........
I use an arraylist because i dont know how many messages will come around the same time, but i could switch to an array if i must. this is the form that i made as kind of a template :
[CODE]..........
Its just got a couple text boxes for now. how can i make these new forms every time i have a new message to display and the clean up after them when they are done.
I am using VB 2008 Express to connect to an Access 2007 database. I have a combo box that is populated by the database. When I used the Access report VBA, I used the AfterUpdate() event to calculate a sum and place the results in a text box. I need to know how to do the same operation in VB 2008 Express using the SelectedIndexChanged event of the combo box.
The combo box is called "cboYearMonth" and is populated by my database, this is working correctly.
The text box that I want the calculated results to appear in is called "ExactPagesTextbox"
I have a query in Access called "JobTypeExact_Query" that contains all the pages that I need. What I need to do is calculate the total number of "Pages" limited to the YEARMONTH selected in the combo box. YEARMONTH is a value in every record in this query.
I don't know if this is the best way to do it or not but here goes.I have an access database and a datagridview and they link via a SELECT statement at runtime.I want to total one column named LNLMTS and display the result.I am looking at using SELECT Sum LNLMTS FROM tblProduction WHERE SO=@so AND DATE=@date
View 8 Repliesi have a problem to retreive whole rows of a datagridview and transfer to my new access database in vb environment anyone can give me advice or examples of how to do it ? for example my datagridview colums have JOB_NO, ERR_DESC , REMARK
now i would to post all row (not selected datagridrow) from this datagridview to my new database .. i search at google using row count may do the job but i still fail on ...
I am looking to select all the tables from a microsoft access database. I just need the SQL statement i think, i can connect to the database that is needed.
View 4 RepliesI have a problem on my coding here. It should insert the new triggered alert into database but it does not work.
Protected Sub repeaterAlert_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs) Handles repeaterAlert.ItemDataBound
Try
stockCodeheader.Text = " Stock Code "
plcNameheader.Text = " PLC Name "
[Code] ......
I was just wondering if there was a way with, using VB.net, be able to create a program to detect when a message is received in Windows Live Messenger, and alert the user?Essentially, MSN is minimized in background and our program, Program A, is also running in backgroung.Friend X sends us a message, the MSN icon blinks as usualy, but also a window pops up and shows the name of the user and the message.I was just wondering if there was a way to connect to MSN in some fom to be able to do this?
View 1 RepliesI have an access database that has columns where the data is a tickbox, i would like to select all the ticks from one row. Erm i'll try and be more descriptive: The database has the family of aircraft in the first column and then each subsequent column is to do with a calculation and i want to assign boolean variables the value of true if the tick box is checked and false if it isnt. How can i assign the values of the tick box to a variable?
I have this query:
CODE:
Where accessConn is the connection to the database and cmbFamily.Text is the row in the column family that i want to select all the KG_IFP values from.If you're not living on the edge, you're taking up too much room
I use this code to populate info from Access DB to txtBox[code]...
View 1 Repliesthis code links to the access database but but I just get only the first row in each combobox...
and I want also cboBox3 depend from cboBox2 depends from cboBox1, how can I do it?
Imports System.Data
Imports System.Data.OleDb
Public Class frm
Dim objConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = DBSOURCEDB.mdb;Jet OLEDB:Database Password=pass;")
[Code]...
I am trying to retrieve information from one row that has four columns(name,company,address,phone) so that once it is displayed in 4 different textboxes, I can transfer to a word document.
View 2 RepliesI am new in programming and I am using VB2005 and I can user either SQL2005 or MS access database.Here my scenario:I have created a project where the user can add a new record, (Support Desk) there are times when a new record is added, it may need a backup (Pictures, Document)to be included in regards the problem.
I need to know if anyone has some sample code on how to attached any type pf file (jpeg, BMP, doc, txt, PDF, excel) and be able to save it to the database.
add user to access database but it's doesn't work the problem here
SavInto.ExecuteNonQuery()
I have a program which I am securing with a Username and Password box, in which the user enters their credentials. In the database, the username is a number field (VB would not accept this as a string and was looking for it as Int32). And the password is a text field. I have the form linked to the database by an OleDbConnection with a DataAdapter (DaUser) and DataSet (DsUser). I am using a datarow which I have declared at the top of my code i.e. Public drUser As DataRow. The problem arises when the user enters their username and password.
The following code searches the primary key row of the database (Username)
drUser = DsUser.Tables("User").Rows.Find(txtUsername.Text)
When the Username entered does not exist, I'm getting this error when trying to display on the form the users email:
NullReferenceException was unhandled - Object reference not set to an instance of an object.
I've tried both if statements and try/catch to basically say if the Username doesn't exist... display an error message etc.
My aim is to try to add a new user to a access database. Im doing this using from a form named frmRegister. It seems like the code is working perfectly, and I get no expectations that indicate if any errors occurred. However, the user doesn't get added to the database.
The code I'm using is:
Public Class Register
Dim connectionString As String
Dim connection As OleDbConnection
Dim OLEDBAdapter As New OleDbDataAdapter
Dim OLE As String
[Code] .....
(Files too large for attaching here)
Rar format - [URL]
Zip format - [URL]