javmedia

With rs .Open squery, conn, adOpenStatic, adLockPessimistic .Edit .Fields("EmpID") = txtEmpID.Text .Fields("LName") = txtLast.Text .Fields("FName") = txtFirst.Text .Fields("MName") = txtMiddle.Text .Fields("Pos") = txtPos.Text .Update End With

Wait, there is an option.. Bill could buy the FIasco Awards and add it as a feature in Windows 7 just in time for the next version. Fiasco Live with Instant Message Failure hmmmm I never got that thing to work, and to be forced to upgrade to something not …

I recommend against using VB for this as it requires users to have MSIE browsers only. However, a workaround that is not seemingly mentioned Anywhere is the following... in the tag script language=vbscript (if used) remove the language definition and netscape/mozilla should be able to treat the page as ASP …

You're kidding right? Thats not VB classic source code to begin with. Thats .net or C # and it sure will not compile in VB 5 or 6

[b]Part 1 - VB5 or 6 to MySQL[/b] Using ODBC 3.51 connector [code] Set DB = New ADODB.Connection Set RS = New ADODB.Recordset DB.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & _ "SERVER=" & sHostName & ";" & _ "DATABASE=" & sDBName & ";" & _ "UID=" & sUID & ";PWD=" …

I did a simple test on my P4 2x3GHZ with 2GB RAM hardware/software setup MyISAM MySQL 5.0.51 Windows XP SP3 using MySQL Query Browser local connection 127.0.0.1 tested on 2,679,888 records ascending sorting in 8.9753 seconds - fetching took 0.0019s [code=sql] SELECT id,f1 FROM `cohouse`.`ukco` ORDER BY f1 ASC LIMIT …

Yes because it's a API call missing. Try this... --- [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 …

I personally find inner joins in MySQL to be more nasty than awkward. Consider using "sub queries" instead It seemed to me they are faster in MySQL as well. See MySQL Man page 11.2.8.4. Subqueries with ALL

This is a traditional homework assignment huh? I will not give you the answer but the hints to solve the problem option one... run one query on table 1, load data run same query on table two altered, load data (this is not the answer the teacher wants) do a …

Before reloading a list view, combobox or other controls like this use .Clear lvwCustomer.clear empty old values and reload again

Yup... Nice and complete comatose. I didn't want to do the guys homework so I replied with a ref to the function name only. Not sure how you can report double posting since I'm new here but this is one is a repeat from nagatron. see [url]http://www.daniweb.com/forums/thread179552.html[/url]

This means the field name is not "requsition_no" Check your database definition (design) and verify the name of the field in the table specified that it exist and is named identically. You should also never use SELECT * in your query definition above as it has the following problems... a) …

Could be your con string causing this too. Hard to tell when I can't see the db. Is this Access, Jet, MS SQL or other SQL92-SQL2000 compliant DBMS, with or without DNS or is it ADO called? To me (being away from VB for over a year) the call seems …

Fastest way... Search help file for info on "InStr Function"

Where is the opening quotation mark for the ending ;") ???

MySQL is easier to find online on most hosts. MS Access requires MS server and costs more to host. MySQL is free MySQL free means they also most likely have PHP, which some Windows boxed server providers still dont like to support for some reason. PHP login is faster and …

Dont filter in the external application as it is faster to issue constraints in your calling query in this case. using PHP style for readability [code] "SELECT `c3`,`c4` FROM `MyTable` WHERE `c1`='$c1Value' AND `c2`='$c2Value' LIMIT $maxDisplayedResultsCount;" [/code] or for range [code] "SELECT `c3`,`c4` FROM `MyTable` WHERE (`c1`>='$c1ValueMin' AND `c1`<'$c1ValueMax') AND …

Search the web for effictive and simple examples of "SQL cross join" and "Jet4.0 connection strings" & "MS ADO DNSLess connections" to apply VB6/VB5 to work with MS Access effectively

Still, try adding a space between the code and the %'s That was a oddity on a system I used to run some 6 years ago.