The only function I found & worked with me was a function that prints a form at run time. Which means to print the desired form I should open the form, and with a button click on that form the pritings is intiated. Otherwise, The print function will print me the background & not te summary of th order I want. You get my point now? It is kinda complicated actually. I just can't find the correct printing function. John,

Suppose I have an application that takes orders and save them in an Access databse. And after taking each order I need to print a summary of that order. The summary should contain the items, prices, order number... I need to automatically print this summary right after I save the order. Can this be done in VB.net? I tried to save the orders in a table called Order1 & the summary in a table called Summary. And I retrieved the need information from Summary to a new form. But this form is being only printed at run time, which I want to avoid? So is there any way to automatically print the summary for each order, right after the order itself? I am using a VB.Net application with an Access database. Thank you in advance. John,

Hello, How can I avoid connecting to a database through a connection string? Because everytime I change the database location I should set a new connection string with the new location. Is there a way to avoid this and save the database within the project itself? And keep the connection there no matter where I install the database? Can I still select, update, delete ... from the database? John,

Thank you all for replying. It was a great help to try diffrent methods. John,

Is there a good way to connect to a password protected Access databse usig VB.Net? I tried some of those but it is still giving me errors!! "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;" "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;" "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="

Hy, I just wanted VB.Net program or formula that do the same job as the Excel one. That's all. I couldn't read well the Excel formula & I need to use i in VB.Net. J ,

Is there anyway to translate this Excel program into a VB.Net one ? The Program goes like this: I enter 2 fields : Density & Temperture . They will be converted and used later on to get the Coefficient , The putput is Tabel ASTM table 54-B 2 Input Boxes: in locations I8 and J8 Box K8 =IF((J8*100)-INT(J8*100)<0.1,INT(J8*100),IF((J8*100)-INT(J8*100)<0.3,INT(J8*100)+0.2,IF((J8*100)-INT(J8*100)<0.5,INT(J8*100)+0.4,IF((J8*100)-INT(J8*100)<0.7,INT(J8*100)+0.6,IF((J8*100)-INT(J8*100)<0.9,INT(J8*100)+0.8,(INT(J8*100)+1))))))*10 Box L8 =IF(K8<=771,(346.4228/K8^2)+(0.4388/K8),(IF(K8>=771.1,(IF(K8<=787,(2680.3206/K8^2)-0.00336312,(IF(K8>=787.1,(IF(K8<=838.49,(594.5418/K8^2),(IF(K8>=838.5,(IF(K8<=1075.5,(186.9696/K8^2)+(0.4862/K8)))))))))))))) Output Box M8 =(ROUND(EXP(-L8*(I8-15)-0.8*(L8^2)*((I8-15)^2)),4))

Hy , At uni it is wireless connection and at home the connection is wired !! I mentioned that befor in the first messaged i posted ! Thx for the help Andy . J ,

Hy , Thx for ur answer . But whats the code like ? Check if the file exist and the copy it to another directory on a button click ? How the code look like ?! Thx again. J ,

Hello , I am using this code to send an E-mail from a Gmail account : Dim SmtpServer As New SmtpClient() SmtpServer.Credentials = New Net.NetworkCredential("xxx@gmail.com", "password") 'SmtpServer.Credentials = New Net.w SmtpServer.Port = 587 SmtpServer.Host = "smtp.gmail.com" SmtpServer.EnableSsl = True mail = New MailMessage() Dim addr() As String = TextBox1.Text.Split(",") Try mail.From = New MailAddress("bankersystem@gmail.com", "Web Developers", System.Text.Encoding.UTF8) Dim i As Byte For i = 0 To addr.Length - 1 mail.To.Add(addr(i)) Next mail.Subject = TextBox3.Text mail.Body = TextBox4.Text If ListBox1.Items.Count <> 0 Then For i = 0 To ListBox1.Items.Count - 1 mail.Attachments.Add(New Attachment(ListBox1.Items.Item(i))) Next End If mail.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure mail.ReplyTo = New MailAddress(TextBox1.Text) SmtpServer.Send(mail) Catch ex As Exception MsgBox(ex.ToString()) End Try When I use the broadband connection at home , all work fine . However when I use the wireless connection at uni , It gives me always an error that it cannot connect to host and cant send the message !!! Any idea ?! J ,

Hello everyone , I am trying to back up a database using VB.net . Is there any coding for that ? I need to backup a database connected to !!! Not a database that is not connected to !! Because when I open my program it will automatically connect to the database . J ,

I just need some help . Its been a while since im trying to figure out what the problem is :S Any appropriate forum to posy this message ? J ,

Hello everyone , How come I still get an overflow error , yet the inpu entries are still being inserted into the database ?! I just get the exception & when I check the database all seems fine . All inputs r in their places and inserted correctly !! I converted into long and other types . I tried the CLNG , VAL ... But still overflow but the diffrence is that the values r inserted into the database . Weird , No ? J ,

Hello everyone , How come I still get an overflow error , yet the inpu entries are still being inserted into the database ?! I just get the exception & when I check the database all seems fine . All inputs r in their places and inserted correctly !! J ,

Hello everyone , I am trying to insert values in one table of the database getting the values from TextBoxes and ComboBoxes . Yet it is allways giving me an overflow error no matter what I tried . This is the sode i used , I used many does this is 2 examples of what I did but none worked: First trial: Dim a As New Int32 a = TextBox1.Text Dim b As New Int32 b = ComboBox1.Text Dim c As New Int32 c = TextBox5.Text Dim d As String d = TextBox6.Text Dim ed As New Int32 ed = TextBox7.Text Dim f As New Int32 f = TextBox8.Text Dim r As New Int32 r = 0 Dim s As New Int32 s = 0 Dim t As New Int32 t = 0 cmd.CommandText = "insert into CA values(" & a & "," & b & "," & c & ",'Personal'," & r & "," & s & "," & t & ",'" & d & "'," & ed & "," & f & ")" cmd.Connection = cn cmd.ExecuteNonQuery() Trial 2 : cmd.CommandText = "insert into CA(accno,custid,balamt,acctype) values(" & TextBox1.Text & "," & ComboBox1.SelectedItem & "," & TextBox5.Text & ",'" & RadioButton1.Text & "')" cmd.Connection = cn cmd.ExecuteNonQuery() I also tried to replace a, b, c... with " & textebox1.text & " But nothing worked . The database got CA table with 10 fileds in it wich i am trying to inser the values . Anyone got a clue ? CA tabel has : Name: CA Primary Key: accno Column Name Data Type Description Accno numeric Account Number Custid numeric Customer ID Balamt Money Balance Amount Acctype char Account Type custidofjoint1 Numeric Customer ID of Joint Account Holders Custidofjoint2 Numeric Customer ID of Joint Account Holders Custidofjoint3 Numeric Customer ID of Joint Account Holders Busaddr varchar Business address of the customer overdr money Overdraft Amount ovdrlmt money Overdraft Limit John ,

I hav this program and when i try to test it an build its solution its always giving me duplicate errors . for each form i get the same error . Can anyone pls help me with it ? If u want to take a lok at the program pls mail me at: jonathan_cris@yahoo.com PLS someone help me here !!!