2,155 Posted Topics
Re: This sounds cool, very cool, if you live nearby. I think the costs involved from South Africa to there might be just a little bit out of my reach, damn!:sad: I believe that there are a few of these get together meetings within the IT industry that was tried and … | |
Re: And you have done what so far? We will help with errors etc, not doing homework. Please read our posting rules. Also no information given, what language you are using, what tables in database etc. | |
Re: Your strSql is incorrect. Use the second strSql which is correct. [QUOTE][COLOR="red"]strSQL = "SELECT * ATM WHERE pincode = '" & pinenter.Text & "'"[/COLOR][/QUOTE] = Incorrect [QUOTE][COLOR="Green"]strSQL = " SELECT * FROM ATM WHERE pincode =" & "'" & pinenter.Text & "'"[/COLOR][/QUOTE] = correct | |
Re: You need to bind your labels to your recordset. Once a record is displayed on a label use [CODE]Recordset.MoveNext 'to move to the next record. You can also do this via loop and maybe a timer with the following code (Change to suit your needs) - Dim emailgroup as String … | |
Re: Have a look at the attached zip application I got from the net a while back. You will still have to do your own coding to tweak it to your specifications. | |
Re: You are calling an update function on your data control without a command to add the data first, hence your error. - [CODE]dtaAdd.Refresh dtaAdd.Recordset.Update[/CODE] Add some data to add to the database first, then call the update function. | |
Re: Hello Louise, there is two ways of doing this. Try the one that suits your needs the best. One way: Put this macro in your MyExcelNameHere.xls or other startup workbook. Attach it to a toolbar button, or give it a keyboard shortcut. [CODE]Public Sub ExtendedTime() If TypeOf Selection Is Range … | |
Re: Obtain the website you would like to control, right click on it and select "view Source". Note that you have to use the web browser control in your application. In vb6, references, select Internet library. In components, select web browser control. In the source code, find the textbox name that … | |
Re: If you can tell us a bit more about tf/idf, what it does, we might be able to supply some code. I had a quick look at some explanations and it did not make much sense to me. What exactly would you like the app to do? | |
Re: I agree, it is quite sad that youngsters take their own life because of insecure and ill brought up bullies. This is however a fact of life that stares us as parents in the eye on a daily basis the world over. Thanks for the link. | |
Re: The following links provide all the help you need to load your help files (invoke) [URL="http://www.helpscribble.com/dotnet.html"]http://www.helpscribble.com/dotnet.html[/URL] Or, [URL="http://www.helpware.net/mshelp2/demo2/h1xNET.htm"]http://www.helpware.net/mshelp2/demo2/h1xNET.htm[/URL] | |
Re: First of all welcome to Daniweb. This post will be moved to Hardware and Software/Microsoft Windows/Vista and Windows 7. Please read our posting rules. I'm sure you will find the answer over there. | |
Re: We need to see your code where the error occurs. This is probably because you are calling an update function AFTER you have closed a recordset etc. | |
Re: Swap the lngFirst and lngLast parts around. That will then display descending. | |
Re: Start with your application. What does it have to do? Then start by breaking it down into steps, for instance - Convert Miles to Kilometers multiply one mile by 0.123456 (sample!) to get one km. Let user type in the value of the miles traveled. Use the above multiplication to … | |
Re: [QUOTE]Private Sub cboCustomerID_Change()[/QUOTE] Change the above to the cboCustId_Click or lost focus event. This should solve your problem. | |
Re: The reference you have set to folder is incomplete. [QUOTE]Dim folder = "C:\Tester"[/QUOTE] Specify Tester as in Tester.txt etc. | |
Re: When considering programming in a new language, go for .NET. vb6 is old, whether we like it or not. Should you wish to go for vb6, try the following from microsoft on the RS232 cable communications - [URL="http://http://support.microsoft.com/kb/194922"]http://http://support.microsoft.com/kb/194922[/URL] You will be using the comm dialog control to do all your … | |
Re: Try the following - [CODE]Private Sub UserForm_Initialize() Dim ListItems As Variant, i As Integer Dim SourceWB As Workbook With Me.ListBox1 .Clear ' remove existing entries from the listbox ' turn screen updating off, ' prevent the user from seeing the source workbook being opened Application.ScreenUpdating = False ' open the … | |
Re: Try the following code, it might be what you are looking for. This will import and export your data... [CODE]Imports System Imports System.Data Imports System.Data.OleDb Imports System.IO Code : Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim intFileNameLength As Integer Dim strFileNamePath As String Dim … | |
Re: It is possible by using a pop up form scenario. Look at the following link which might contain your answer - [URL="http://stackoverflow.com/questions/280891/make-user-control-display-outside-of-form-boundry"]http://stackoverflow.com/questions/280891/make-user-control-display-outside-of-form-boundry[/URL] | |
Re: phpmyadmin is just a DB client; it is not needed to access the DB. If you want to write Java code to access the DB then JDBC is the way to go. If you're unfamiliar with JDBC, there's a tutorial on java.sun.com. | |
Re: Welcome to Daniweb. I'm sure your help will be appreciated VERY much to all other members. You might find others helping out as well when you are stuck. Enjoy your stay. Elihu, shame on you. You should know better than to post your email here...:$ | |
Re: What kind of error is generated? Paste the code and show us on which line the error occurred. | |
Re: [QUOTE]Constants are named storage locations in memory, the value of which does not change during program Execution. They remain the same throughout the program execution. When the user wants to use a value that never changes, a constant can be declared and created. The Const statement is used to create … | |
Re: Thanks for opening your own thread amrahim, it is much appreciated. Below should do the trick for you, just add the controls as needed. [CODE]Option Explicit Private Declare Function GetTempPath Lib "kernel32" Alias "GetTempPathA" (ByVal nBufferLength As Long, ByVal lpBuffer As String) As Long Private Declare Function GetTempFileName Lib "kernel32" … | |
Anyone following the Ryder cup? Europe ahead by one point (4-3) hoo hoo!!! Sorry USA. Whats up with the weather though, you need a boat to get around! Good luck to both teams though. I'm supporting Europe and Monty. ![]() | |
The End.