2,155 Posted Topics
 | Where will your database be stored? on a LAN pc/server? The size of the network does not really count. What does count is your database. Access will not be able to handle that many requests. Rather move up to MySql which is open source (free). All you need then, is …  |
| | Correct on the security issue. Rather get password from your recordset... $sql = mysql_query("SELECT id FROM admin WHERE username='$manager' AND password='".md5($password)."' LIMIT 1"); // query the person |
| | Can you please mark this as solved, thanx Jean. :) |
 | If I read this correctly, you have opened the recordset where the id = 2. According to you, the name field is empty??? thats why nothing shows in text1.text. What seems to be the problem then? To check if it IS empty, you can do teh following... If rs!name = … |
| | @ram, As deceptikon stated, it will be hidously long... There are so many (good) and FREE packages out there. If you want to just study it, rather get a free and open source (as was suggested) and go with that. I personally would choose a different subject to hone my … |
 | You can create menu items at run time... Design Time First right click any place on your form where there are no controls. Then choose Menu Editor… Now in the editor add a main menu, Give it a caption such as Favorites and a name such as mnuFav. Then click … |
 | Try - $sth = mysql_query("SELECT COUNT(username,firstname) FROM users WHERE id='".$required_id."'"); return (mysql_result($sth, 0) == 1) ? true : false; This should return record 1 because you declared "$required_id=1". |
 | Re: mysql a Few things I've picked up... You have 3 fields in your table freescript - idads, waktu, number. When you insert a record, you do not specify anything for number which will result in a NULL entry. mysql_query("insert into adsmgt (idads, waktu, number) values ('$idads', '$time', '')"); When you echo … |
| | Do you need to show the actual time or the countdown of a timer? If time then the format i.e. hour:minute:seconds? |
| | Unfortunately we can not unless you are prepared to pay for the service. This is a helping community where we help you on solving problems with your code etc., not doing projects, homework or unpaid services. :) |
| | I have a function as below in javascript that gets all the values from different inputs/selects. It must then build up a string that will be passed to a textarea. This was working fine last night when I tested. I then tweaked something, not sure what I did and of … |
 | What exactly is the problem here? On which line are you getting errors? |
| |  # Please see attached image # a User will click on an img which in return will either show - -if unchecked is visible, checked image will be visible (javascript used for this) -and vice versa. I have no idea how to achieve the following - If a … |
| | If I read this correctly, you already returned a value for $txt2, When making the call to your database, you now need to echo out the field values - //You had this - <h2><a href="' . $row['$txt2'] . '/' . $row['$txt2'] . '.php">' . $row['title'] . '</a></h2> //Try this <h2><a … |
| | I have the following code which works just fine... $result = mysql_query("SELECT * FROM test_prefixvehiclefeatures ORDER BY Feature ASC"); $count = 0; echo "<table border='1'> <tr> <th>Select a Feature</th> </tr>"; while($row = mysql_fetch_array($result)) { $count = $count + 1; echo "<tr>"; echo "<td>" . $row['Feature'] . "</td>"; echo "<td><img src='images/unchecked.png' … |
| | I just picked up on this today. What is the skill endorsement all about? |
| | I have 3 select boxes, each one returns a different field from database i.e., in database - 2010 BMW 320i, record 2 2008 Aston Martin DB9 and so on. What I do is to first get user to select a year, then submit form so I can return all vehicles … |
| | I have suggested in your own post on how to get a proper answer. This thread is 7 years old and you will not likely get an answer here, sorry. |
| | Re: psexec I've never tried it myself, but this sounds like a job for DCOM. [Here's](http://support.microsoft.com/kb/266717?wa=wsignin1.0) a Microsoft article that walks you through DCOM with VB6. You create an ActiveX exe on machine A, and then VB6 code running on machine B can call into the exe running on machine A. You … |
| | Firstly, is LB_NO an integer (number only)? If so, remove the ' signs from your sql.... > "WHERE ((LB_No) = " & txtLB_No.Text & ");" like this. Secondly, your WHERE clause is in the incorrect place, should come after FROM RegistrationTB - > "FROM RegistrationTB WHERE LB_No = '" & … |
| | Once you have created your installation package with the PD wizard, open the package folder. You'll see a Support folder, setup.exe and a SETUP.LST file. In that same folder add a text file by using notepad and save it as Autorun.inf. In this txt file, add the following text... [autorun] … |
 | Try the following, in your macro - Function TextExtract(ByVal strSearchFor, ByVal Target As Variant) As String Dim OneCell As Range TextExtract = "" If TypeName(Target) = "Range" Then For Each OneCell In Target If InStr(1, OneCell.Text, strSearchFor, vbTextCompare) > 0 Then TextExtract = strSearchFor Exit For End If Next OneCell … |
| | |
| | Re: Number format? If you google the following you should get plenty of sample code. You will be making use of the following functions to check for an integer value, search for characters etc - IsNumeric cInt Mid Left Right Replace ASCii With the above you can perform any validation check you need.  |
| | Most above contains the answer. Remember to return a record first that will be deleted otherwise the first record in the table will be deleted, not the one you wanted. So, to do some error trapping - Private Sub cmdDelete_Click() Dim con As ADODB.Connection Set con = New ADODB.Connection Dim … |
| | You can try the following - If combo1.Value = "One" Then combo2.AddItem "stuff for one" Elseif combo1.value = "Two" Then combo2.AddItem "stuff for two" Else combo2.AddItem "stuff for three" End If |
| | Nope, not yet. The little research I've done shows that we have to wait for the surface pro to be launched. The surface rt will not be able to run any x86 applications, where the pro will run windows 8 and any apps should run fine on that. |
| | Seeing that outlook web app is web based, you can add a web browser to your form and open the web app in your browser. From there you can populate all the fields with text etc. and send from app. |
| | It all depends on what scanner you have, what it will be used for etc.... Have a look at these few links, might help with what you need. [URL="http://www.bigresource.com/VB-USB-Barcode-scanners-in-VB6--cSBl6Zdb0H.html#"]Here[/URL], [URL="http://www.bigresource.com/VB-VB6-0-and-peripheral-devices-bar-code-scanners--YL3IWpYQse.html#"]Here[/URL] or [URL="http://www.bigresource.com/Tracker/Track-vb-YL3IWpYQse/"]Here[/URL]. It seems that you will either have to reference to the drivers or it will be linked to …  |
| | Your problem is with the "Set rs = "part. cn is a connection that will handle all requests hence "cn.Execute" Remove the Set rs = part - cn.Execute("INSERT INTO employee VALUES('" & txtempname.text & "', " & txtempid.text & ", '" & txtssn.text & "') ") |
| | If it is a pdf doc, why save it to your database (maybe I'm missing something.. :) )? I've downloaded in excess of 200 mb pdf docs to my server and let users download with no hassles at all with the following... (maybe still loosing the plot here, if so, … |
| | Show us the code that causes the loop to freeze. |
| | I have the following scenario - User clicks on an image to search for a particular brand vehicle. The value of that image must then go the hidden box where I will post the value returned to another form. I just can't seem to get the value returned... My code... … |
| | Try the following - $query = "SELECT 'username', 'password', 'firstname' FROM users"; $query_run = mysql_query($query) while($row = mysql_fetch_assoc($query_run)){ $users = $row['username']; echo 'Welcome, '.$users; } else { echo mysql_error(); } |
| | Before you run your query - Dim startDate As Date, endDate As Date startDate = dtPicker1.Value endDate = dtPicker2.Value ''Remember to add error trapping code to check if there are any values returned... Now run your query |
| | Firstly, this is .net code... Public strThis As String In your button click event - strThis = Label1.Text In form pie - pie.label1.text = strThis  |
| | Re: Using vbkeycodes Nothing to add, I saw the post on a 2 year old thread, bitblit gave you the solution. :) |
| | Firstly, actioning a form will take you to the form you specified... process.php You need to get values selected from a select (drop down) to load the next scenario, right? Try the following - <select name="Friday2" id="Friday" onchange="this.form.submit();"> <select name="Friday2" id="Friday"> <option value="0">Block # - Day - Time</option> <option value="100">Block … |
| | If I read this correctly, you have variables saved from some forms, you now need to add these values to an excel file, right? |
| | Unfortunately we can not. See our [RULES](http://www.daniweb.com/community/rules) here. Show us what you have so far and we will gladly help.  |
 | Most of your code is clashing with win 7. Have a look at my tutorial [here](http://www.daniweb.com/software-development/visual-basic-4-5-6/code/313435/installing-vb6-applications-on-vista-or-windows-7). Then have a look at one of my old posts... [here](http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/233288/saving-images-file-to-sql-server-or-ms-access-databases#post1027218). |
| | vb has a huge variety of options, vb4/5/6, vb.net, asp etc. Which line do you want to excel in, software, web dev etc. ? |
| | I would personally add hidden textboxes to retrieve the values... In your broadcasttext.php form, before submit, add the hidden text boxes... <input type="hidden" name="myhiddenvaluehere" value="<?=$_POST['myhiddenvaluehere'];?>"/> Once you have that, it's quite easy to retrieve the value from another form - In addScheduled.php - $myhiddenvaluehere = $_POST['myhiddenvaluehere']; Once you have all …  |
| | Although Kinwang is 100% correct, it will NOT work under the Change event, rather use the LostFocus event. [CODE]Private Sub Text1_LostFocus() Text1 = Format(Text1, "#,##0.00") Text1.SelStart = Len(Text1.Text) End Sub[/CODE] When you need to return the value again use - [CODE]dim xValue As Integer xValue = CDbl(Text1.Text) 'This will remove … |
| | Nice JX_Man, as always you showed the exact and to the point code. :) |
| | How would you know which files to open? In other words, are they saved in a specific folder, When the user inputs say 3 files, how will you know which ones to open with what name? |
 | |
| | Stuck again... :) I am returning close to 60 records from a search in mysql. I want to add these records to a select box. When I am looping through the records, it adds a select box for each record. Not sure where I am going wrong. It does load … |
| | Try the following - IF(SUBSTR($string, -1) != '.') { $string.= '.'; } |
| | I am totally stuck here and found tens of samples on posting to get and set values. What I am trying to do is - 1) Let a user enter a vehicles year model into a textbox in my form (set to post) 2) I then need to get this … |
The End.