- Upvotes Received
- 6
- Posts with Upvotes
- 6
- Upvoting Members
- 6
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
Am a Lebanese guy currently working in KSA as system developer in a hospital called SMCH (Specialized Medical Center Hospital). It is my first employment as programmer even though I have developed and sold some applications before. My previous jobs were…
- Interests
- Computer Games, reading
158 Posted Topics
 | Re: VB Calculator Hi, Check this sample it may be a little complicated but you can isolate the code you need out of it.  |
| | So every time you are pressing a key you are opening a connection to the database and selecting and closing the connection. I don't think this is practical nor reliable. What you have to do is to create a dataview on the form level, and on the load event fill … |
| | A more simple answer is having a good Internet Security product, as well as avoiding any suspicious sites, links or downloads. Any device connected to the net is exposed to a lot of threats, yet many of them can be easily avoided and the rest can be captured using antiviruses … |
| | Why do you need a new form to do the search? On the same form "form1" fill the dataset in a dataview "MyDataView", then bind the datagrid to this dataview. Add a textbox to search the date, we will call it "txtDateSearch". Now after filling this textbox and pressing search … |
| | What you've done seems to be correct. Try to take the SQL query to the server and run it there may be you have problems with the date format?? |
| | I didn't exactly get what you need but I think you have to apply the height prperty of the row that contains the label to **autosize** instead of obselete or percentage. |
 | I think Pollatep is correct, your if statement is wrong. you have to add the object with each condition: If typeof obj is TextBox or typeof obj is ComboBox or typeof obj is ListBox then  |
 | Sorry but no one will read this code to find out what is wrong. Simply post your problem in couple of lines so we could help.  |
| | Use the following code to add the rows and fill the data at the same time, this shall solve the problem: For N = 1 To 5 DgvInvoiceDetails.Rows.Add(xlsheet.Cells(N, 1).value) Next |
 | No need for a timer simply use the sleep function: Process.Start(My.Computer.FileSystem.CurrentDirectory & "\first.exe") Application.DoEvents Threading.Thread.Sleep(10000) Process.Start(My.Computer.FileSystem.CurrentDirectory & "\second.exe")  |
| | There are hundreds of online examples check this: http://support.microsoft.com/kb/315828 |
| | |
 | Am not sure if you can do that. But as an advise don't use your external, instead buy 2 flash drives and make them bootable drives for windows 7 and 8. It is much faster and reliable than optical drives and at the same time you will protect your external …  |
| | If you have your windows 8 CD or iso image you can do the following: http://www.askvg.com/how-to-install-microsoft-net-framework-3-5-offline-in-windows-8-without-internet-connection/ |
 | Make her a secured personal diary |
 | The connection string is the same whether you want to use the server name or IP: ex: Dim conn As SqlConnection = New SqlClient.SqlConnection("server=192.168.1.1;database=xxx;UID=yyy;pwd=zzz") |
| | The best way to do it is to fill your dataset "sqlDS" into a dataview then you can filter the dataview using the rowfilter method. Ex: Dim DV as new DataView DV.table=sqlDS.tables(0) GridControl1.DataSource =DV DV.RowFilter = "name = '" & me.textbox1.text & "' |
| | Hi, Check this sample project [URL="http://www.a1vbcode.com/downloads/ITEMDETAILS.zip"]http://www.a1vbcode.com/downloads/ITEMDETAILS.zip[/URL] You will find on the asme site more complex solutions. It helped me alot while shifting to .net some years ago. |
| | Hi, I think it has something to do with your computer regional and language settings (languages and non-Unicode languages) and not with VB itself.  |
| | Hi, Use the below code while changing just the file name: [code]Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long Const SW_SHOWNORMAL = 1 Private … |
| | Hi, Check the attached example, I hope this is what you are looking for. |
| | Hi, I previously had a function that gets a screen shot but i can't finf it any more. Look on the internet for a function that perform "Print Screen" and then a function to crop that picture. |
| | Re: Textbox ??? Actually this is how things work but still you don't have to write this for every control, just handle it by every control you need to apply enter key one ex: [code] Private Sub EnterKey(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) _ Handles [COLOR="Red"]TextBox1.KeyPress, TextBox2.KeyPress[/COLOR] If e.KeyChar = Chr(13) … |
| | Check this [url]http://www.developerfusion.com/code/198/evaluate-string-formulas-in-vb/[/url] |
 | Actually you have one of 2 options. Either create a windows authentication login for each of your domain users and give them permission for reading or writing to the database, and then you can use the same connection you are using (you can reach that from the SQL enterprise manager … |
 | You should use: "Delete From Users where UserName ='" & DataGrid1.Text & "'" Even though am not sure what you mean by DataGrid1.Text  |
| | Assuming that the field names are firstName and Age this query will only insert the values that are in newTable and not in NewTable2 [CODE]"INSERT INTO newTable2 (firstName, Age) " _ & "SELECT T1.firstName, T1.Age " _ & "FROM newTable2 AS T2 RIGHT JOIN newTable AS T1 ON T2.firstName = … |
 | Actually you just need to use: [CODE]Dim oExcel As Object = CreateObject("Excel.Application") oExcel.Workbooks.Open("C:\DailyLogs\DailyLog.xlsx" oExcel.Sheet1.PrintPreview() [/CODE] Why are you opening the PrintPreviewDialog1?? |
| | Hi guys, Am in a big problem, I have a 120 GB external HD which I use to store and move my most important files. Yesterday I have attached it to my relative's laptop and since then the nightmare started. When I connected th HD to my laptop it didn't … |
| | Hi, The best you can do do is to create an mde file with hiding the database window and menues and running a startup form. This is the nearest you can do to simulate an exe. |
| | Hi, Your best and simplest solution is to use ASP which will require you to install IIS from windows cd. And for how to do it, there are 1000s of codes describing connecting ASP to DB on the web. |
| | Re: Simple login simply when u get the user name from the first form store it in a session variable: session("user")= me.txtuname.text and on the second page u can refer to it in your sql: ...where username='" & session("user") & "'" |
| | |
| | Hi, Try this, I haven't been able to test it: [code]Dim Oword As Object Dim Odoc As Object Private Sub Command1_Click() Set Oword = CreateObject("Word.Application") Set Odoc = Oword.documents.open("C:\temp.doc") Odoc.SaveAs FileName:="c:\x.rtf", FileFormat:=wdFormatRTF Oword.quit Me.RichTextBox1.FileName = "C:\x.rtf" End Sub[/code]  |
| | Hi, Are you using XP and Vista on the same network??, if so this will be the problem. But I have browsed the internet for a solution for this porblem and found non that worked (thank you microsoft). |
 | Hi, Use the inbuilt function nz Expr1: (nz([prod_group_name],"") & " - " & nz([model],"") .... |
| | Hi, Man i dont wana to dash your hopes, but what you r trying to do is quite difficult using such controls. I advise you to look for an alternative idea.  |
| | Hi, Am not sure what is a far point but you will sure need datagrids, and other form controls like text boxes, buttons, labels...  |
| | Hi, try this [code] <html> <head> <script langauge=javascript> function baby(a,b) { document.p.text.value=a; document.getElementById(b).checked=1; } </script> </head> <body> <form name="p" > <input type="checkbox" name="cat(10)" id=10 > <input type="checkbox" name="cat(11)" id=11 > <input type="text" name="text"> </form> <a href="javascript:baby('Hello',11);">Click Here</a> </body> </html> [/code] |
| | Re: ABOUT IE Hi, Most probably you have a spyware or adware that trying to access internet, and ususaly for a bad purpose. Go to run then type msconfig and press enter, go to startup and check those processes one by one (google each of them as some are not supposed to be …  |
| | Hi, Main two virus attacks are web and removable devices. AVG is not bad if it is updated frequently, but I advise you to pay for a Kasparsky for further protection. But in all cases avoid visitng untrusted web sites or using p2p applications like limewire or emule. For the … |
| | Hi, Mainly not starting in safe mode is resulted of either corrupted windows (you will need to reinstall or repair windows), or virus attack were some viruses will prevent you from going into safe mode. |
| | |
 | Hi, Your example is not that clear but i guess that you need to transfer your query to a crosstab. |
| | Re: Error handling Hi, If you are using access you have to include the code in the before_update event of the text box. |
| | Hi, Please check the attached example. Hope it will work for you. |
| | Hi, What do you mean by table variable??? |
| | |
| | Hi, My friend, your question have nothing to do with MSSQL, you should have posted it in Vb.net forum and i think you will need to use Cellstye.forecolor=Color.green |
| | Hi, This is an excellent forum but it is not specialized in DBs. In fact you will find alot of sites only intrested in MSSQL but I don't think you will find those expert examples you are looking for. I advise you to start building your database step by step … |
The End.