2,155 Posted Topics
 | It seems that your connection is looking for the database in the same place as to when you were developing your app. Go make sure that it is still in the same folder on the SAME pc you developed on as to where you have installed onto. In other words, …  |
| | No you can not "save as". an Activex control is build via code and then saved as an "ocx" file. This can then be uploaded to your web site. You will still need some coding done. There are hunfreds of web design applications available for download that will help you …  |
| | a Server is the way to go. Your database will be "housed" on the server. Your application can either be run from the server OR any other individual pc on the network. With proper programming and design styles it need not be unsecure. Any data entry will be saved "recorded" … |
| | I'm not that cluded up on the Datashape properties, but from a bit of research, try and drop the "1" after .Datashape.1... See the following link - [URL="http://http://www.a1vbcode.com/vbtip-102.asp"]http://http://www.a1vbcode.com/vbtip-102.asp[/URL] Their quote as follows - [QUOTE]As you probably know, a shaped ADO recordset lets you contain a hierarchical structure (parent/child records) in … |
| | Wow!!!, or should I say ouch. lol First of all you have set your datagrid's datasource to the same recordset TWICE. [QUOTE]Set DataReport1.DataSource = rs_cash_rd Set DataReport1.DataSource = rs_cash_rd.DataSource [/QUOTE] The first one is correct - Set DataReport1.DataSource = rs_cash_rd Secondly, what text are you getting from your combobox on … |
| | What exactly are you having problems with? Please elaborate more so we can help you solve your problem. Mention what you have tried so far, where the problem occur etc. |
 | Atched is a sample of the web browser. Click on 'Project - References' to see what is referenced to make the browser work. As far as your password generator is concerned, what exactly are you planning to do? |
| | Yes it is possible. I must however warn you that you will be writing into your systems registry to make it possible. Make a backup of your drive BEFORE attempting any changes to registry. We at Daniweb or anywhere else do not take responsibilty for any system crashes...... See the … |
| | There is an easier way.... You need to set your datagrid to a recordsource property. (set datagrid.datasource = rs) You then select the record you need and add the data to the textbox. [CODE]Text1.Text = rs!YourDataFieldName[/CODE] If you want to add the text when you click on a selected grid … |
| | Yu can not change an exe to a dll (dynamic link library). The one is an application, the other a library file. dll's can be written from WITHIN vb, but can not be converted one way or the other. |
| | Attached is a calculator app I have done quite a while agos. It covers more functions like sqr root etc. By using the keypress event, look at the attachment to get the ascii character for the key pressed and use that in your code i.e. - [CODE]If KeyAscii = 50 … |
| | As above, swop your code around, FIRST open RS and then SET GRID Property. If you are not using anything else from RS, you can close it now. Remember that to use the refresh property afterwards will also result in an error because you have closed RS. [CODE]Set datagrid1.DataSource = … |
| | I hope that this is what you are looking for.... Add a command button to your form. Set its tabindex property to 1 more than your textbox where the number to be exponened will be entered, and set its default property to "True". [CODE]Function Power2(ByVal exponent As Long) As Long … |
 | vb5prgrmr Hit the nail on the head. rs232 cable is the way to start. The easiest is to start off with a diagram on what you plan to read from the connected pheripheral (machine/appliance) and the code from there using his links to many examples. Good luck with this new … |
| | Go for the following - Create a databse with Login Details, Username, Password and Login Age. This can be done with Access, sql, mysql etc. with the correct connection string. Either create your app with a start up screen where the data is empty as in - [CODE]If rsLogin.BOF OR … |
| | It seems you have a problem in solving date/Times solutions. What exactly do you want to achieve with your code? I presume that the result should show up in your datagrid? Do you want to run reports from certain dates etc? or wouyld you like vb6 app to calculate the … |
 | Try the following - [CODE]With rc .ActiveConnection = deSub.conn .LockType = adLockOptimistic .Source = "select * from cooperatesubs" .Open End With Dim w As Integer Dim x As Integer Dim y As Integer Dim z As Integer Do Until rc.EOF = True y = rc.Fields("copiesgiven") z = rc.Fields("numberofcopies") x = … |
| | Re: =" =" " First of all, var (variance takes up unneccesary space or memory. Declare your text as an integer. i.e. [CODE]dim x as Integer x = Text1.Text [/CODE] The next question is? - Where do you want to copy the the temperature Integer? Into a database or just for calculation. There is … |
| | Re: SMS The following should help a lot - You need to register on [URL="http://www.clickatell.co.za"]http://www.clickatell.co.za[/URL] Look at attachment - |
| | Try the following site where there is quite a few treeview samples. Sure you will find your answer there. [URL="http://http://www.vbcode.com/Asp/code.asp"]http://http://www.vbcode.com/Asp/code.asp[/URL] |
| | Re: code need Abu, Try the following. Yes you can display more than 1 form, Just set the focus to the form you need. Remember that every form takes up memory, slowing your application!!!! [CODE]Public Sub LoadAllForms() Dim Form As Form For Each Form In Forms Form.Show Next Form Form1.Show 1 End Sub[/CODE] … |
| | try and use something like - [CODE]Text1.Text = dtPicker1,Value Text1.Text = Format(Text1.Text, "dd,mm,yy")[/CODE] Hope this helps... |
| | Try this link to a previous discussion. It might put you on the correct path to a solution. [URL="http://http://www.daniweb.com/forums/thread134994.html"]http://http://www.daniweb.com/forums/thread134994.html[/URL] or to read up more on randomize and get some sample code go to - [URL="http://http://www.vbexplorer.com/VBExplorer/random/random_numbers_1.asp"]http://http://www.vbexplorer.com/VBExplorer/random/random_numbers_1.asp[/URL] This link discuss the actual card game with sample code... |
| | Attached is sample code. Very important though is to remember that the field specified in sFieldName, must have a binary field type (ie. OLE Object in access) in your table.... |
| | Re: Payroll Sorry my friend, you are in the wrong forum... Looks like PHP??? not sure. Try a different forum, I'm sure someone will help there. Good luck. |
| | I agree with vb5prgrmr, Sample 1 (PASS) is the easiest and safest way of having the name available for ANY form... |
| | Try the following connection string page. Just search for the sql you are running, i.e. 2008, 2003 etc. [URL="http://http://www.connectionstrings.com/sql-server-2008"]http://http://www.connectionstrings.com/sql-server-2008[/URL] Hope this solves your hassles at connecting... |
| | Re: visual basic Can't someone just bomb this #$@%&^$% (Samira1993) out of here!!!!! I hate lazy people, especially arrogant ones! |
| | Try the following - [CODE]Dim x as Integer, y as Integer, z as Integer x = Val(txtQan.Text) y = Val(txtSalesQan.Text) z = x - y rsQan!Qauntity = z rsQan.Update 'rsQan is your recordset 'Qauntity is your field name[/CODE] Hope this solves your problem. |
| | With all this code, (my apollogies, I have not read through all of this) what are you trying to do? Do you receive an error or is it something you want to change? |
| | This is unfortunately a poll which I have started myself... Ignore the pole and look at the actual Zip file, there is numerous data logins, and connection strings availabl;e which will help you on the correct path... [URL="http://http://www.daniweb.com/forums/post989850.html#post989850"]http://http://www.daniweb.com/forums/post989850.html#post989850[/URL] Hope you solve your problem... |
| | Your connection string is faulty. You need to declare the connection first. [CODE]Dim conn As ADODB.Connection Set conn = New ADODB.Connection conn.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=C:\subscriptions2.mdb" 'Ensure that you have referenced MS ActiveX Data Objects Library in Project/Refrences. 'You can also use Jet 4.0 as below conn.Open "PROVIDER= Microsoft.Jet.OLEDB.4.0;persist security info=false;data source … |
| | Try the following link that explains random WITHOUT duplications or errors in detail... [URL="http://http://http://www.vbexplorer.com/VBE..._numbers_1.asp"]http://http://http://www.vbexplorer.com/VBE..._numbers_1.asp[/URL] |
| | Firstly select MS Datagrid from components. Add the grid to your form and the use the following code - [CODE]Private WithEvents cnGrid As ADODB.Connection Private WithEvents rsGrid As ADODB.Recordset 'In your command button etc. click event add the following Set rsGrid = New ADODB.Recordset rsGrid.Open "SELECT * FROM YourTableName ORDER … |
| | You can also eliminate the message box, and keep the focus on the textbox/Inputbox if any value other than an integer has been entered i.e. - [CODE]If Not IsNumeric(distance) Then SendKeys "{BackSpace}" End If[/CODE] |
| | As follows - [CODE]Set rsItemName = New ADODB.Recordset rsItemName.Open "......", cnItemNAme, adOpenStatic, adLockOptimistic 'Where open is your connection string If rsItemName.BOF = True Then Exit Sub ElseIf rsItemName.EOF = True Then Exit Sub Else Do While rsItemName.EOF = False cmbItemName.AddItem rsItemName("ItemCode") 'ItemCode is the name of your field rsItemName.MoveNext Loop … |
| | Let you choose between all printers available on your pc or network. Download zip and enjoy. Royal free. |
| | It looks like your connection string is faulty. Try the following links to get the correct connection string, and some troubleshoot solutions. [URL="http://www.connectionstrings.com/sql-server-2005"]http://www.connectionstrings.com/sql-server-2005[/URL] [URL="http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx"]http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx[/URL] |
| | I agree 100% vb5prgrmr. It seems that he wants somebody to do his work FOR him!!! and reckons by posting it a million times will actually help. It is VERY annoying to read the same post under a different heading!!! Please post 1 ONE post and we WILL try and … |
| | First close your recordset. Re-open the recordset with the new date criteria and then refresh the grid. [CODE]RS.close RS.Open "......................." Grd.Refresh[/CODE] Hope this helps Abu |
| | Try the following to get the sum of an integer - [CODE]Private Sub Command1_Click() On Error GoTo Errorhandler x = InputBox("Please Enter an Integer.", , Text1.Text) If x <> "" Then List1.AddItem Str(x) Do While x <> 1 If x Mod 2 = 0 Then x = x / 2 … |
| | Something from a very long time ago. Will help you though to populate your grid with search functions included. See attachment. |
| | Re: viewing database I assume you are talking about the Data tool? Place the tool on your form. Select Database Name and click on the cmd button with ... on it to open the connection wizard. Select the database you want to connect to and scroll down to RecordSource. Select the table source … |
| | You can also try your textbox format - [CODE]Text1.text = Format(Text1.text, "### ###.##") 'Where ## is the actual number entered into text box.[/CODE] You can also try this sub I've done some while back [CODE]Public Function Txtnumdeci(Key As Integer, Strinfo As String) As Integer Dim Deciprs As Boolean Dim Ctr … |
| | Follow my comment lines within your code... [CODE]Private Sub cmdcnsearch_Click() 'dim sql as string sql = "Select companyname,companysize,country,city from cooperate where CSTR(accnumber)='" & txtcnsearch.Text & "'" 'sql = "Select companyname,companysize,country,city from 'cooperate where accnumber=" & "'" & txtcnsearch.Text & "'" 'remove the cstr for the value you are looking for … |
| | Try something like the following: [CODE]Dim cnn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim ts As TextStream, fill As File Dim fso As New FileSystemObject Dim app As String Dim i As Integer Dim sFields As String Dim sData As String Dim myPath As String Dim fld As … |
| | Ever felt like you need to do SOMETHING, but you don't know what. You are sitting at your pc, thinking about coding and finishing that app. 10 minutes later you are so bored you start surfing. 20 minutes later you start a game. 10 minutes later you install something. You …  |
| | |
| | Select your combobox, in the properties window scroll down to 'sorted' and change the property value to "true". This will load the data alphabetically. When you add any text to the combo box AFTER you selected it, it will automatically select text available in there in that alphabet letter, i.e. … |
| | Why don't you just show all the open complaints in a datagrid? See the following link to connect to a datagrid - [url]http://www.daniweb.com/forums/thread225349.html[/url] Hope this helps. |
The End.