2,155 Posted Topics
 | |
| | |
| | |
 | Have a look at the following links. They might contain the solution you need. It seems that primary and foreign keys might be the culprit here, not sure though...:) [URL="http://support.microsoft.com/kb/242459"]http://support.microsoft.com/kb/242459[/URL] [URL="http://stackoverflow.com/questions/4028395/what-does-the-cannot-change-the-activeconnection-property-of-a-recordset-object"]http://stackoverflow.com/questions/4028395/what-does-the-cannot-change-the-activeconnection-property-of-a-recordset-object[/URL] [URL="http://bytes.com/topic/access/answers/198968-recordset-not-updatable-why-not"]http://bytes.com/topic/access/answers/198968-recordset-not-updatable-why-not[/URL] [URL="http://support.microsoft.com/default.aspx?scid=kb;en-us;207761"]http://support.microsoft.com/default.aspx?scid=kb;en-us;207761[/URL]  |
| | asc() function converts an ascii (well, ansi) character to its decimal equivalent. Have a look at [URL="http://www.bigresource.com/Tracker/Track-vb-2UGsP9z2Qg/"]This[/URL] link with some sample code to convert hex, decimal, ascii etc. |
 | In your sql statement the following - [CODE]"SELECT * FROM YourTableNameHere WHERE LastName LIKE 'S%'"[/CODE] |
 | |
| | This is a rough sample of an applications that will get your users to register the application with you. |
| | I'm not sure what exactly you want to do here. Do you want to call specific data and then only show that data? If that data is not available do you want to show all the data? Please be more specific, and I'm sure we can help here. |
| | Use the format function to set it to say two decimal places - [CODE]arrWhite(intIndex) = Format(.Fields(intFldCntr), "####.00")[/CODE]  |
| | Re: user control You can drop the user control, its crap. Have a look at the attached sample, I have added the code you need. Also have a look at the references in the application to see why its working. |
| | Eiven, please STOP adding the same question over and over. I have already gave you the solution on the last thread.  |
| | |
| | Re: HI TO ALL!!! Welcome to Daniweb.:) Thanks for the help offering, I'm sure members will appreciate it.:) |
| | Welcome to Daniweb.:) We will most definitely raise our glasses.;) |
| | You can use the following code - [CODE]'On your combo1 click event... Load Form2 Form2.Hide[/CODE] |
| | I have asked that your thread be moved to VB.Net. If you are already busy with .Net, stick to it. VB6 is becoming obsolete.:) |
| | Firstly, welcome to Daniweb.:) Secondly, please read our community rules [URL="http://www.daniweb.com/forums/faq.php?faq=daniweb_policies"]HERE[/URL]. We normally do not answer on questions with a title that contains "Help", "Urgent" etc. Being new though, no harm no foul. As far as your question goes, again refer to our rules. We do not help with homework … |
| | Firstly, try - [CODE]Case Is = 0 Text1.Text = ......[/CODE] Secondly, I think by using the rich textbox is the way to go because you are limited to the amounty of text a text box can take. a Rich text box is almost unlimited. MS Word uses rich text boxes … |
| | Can you see the code window at all? |
| | To get the next number, use the following - [CODE]Dim oConn As ADODB.Connection Dim oRs As ADODB.Recordset 'Using MS Access database... Dim sConn As String Dim xCount As Integer Dim oConn As New ADODB.Connection 'Declare a new connection... Dim oRs As New ADODB.Recordset 'Declare a new recordset... sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data … |
| | Yes vb6 can interact with almost any application, either directly or by using OLE. It obviously all depends on what you want vb6 to do. If you are very new to vb6, I suggest that you start with the basics first before getting involved in more advanced commands as manipulating … |
| | Thank you for opening your own thread.:) The attached file will help you in getting the backup sorted. You will however need to play with the code to suit your needs, getting the connection on the network, sorting sql user privileges etc. The code is not by me, all credit … |
| | Depends on whether you are using ADO or a data control.... Please be more specific with your question.:) |
 | It seems I have missed your post Abe, sorry.:) You can not print a report with just text box values. You can however take a picture of the screen and then print that... |
 | Nice effort from your side Nick. I've been reporting spam and other bad posts on a daily basis, and all credit to the mods, they normally react within an hour. Keep it up.:) As far as the goodie greenies goes, if others don't want it, throw some my way. It … |
| | |
| | With all the recent hype about spammers, bots and malware, I found [URL="http://wpmu.org/why-you-should-never-search-for-free-wordpress-themes-in-google-or-anywhere-else/"]THIS[/URL] link "Why You Should Never Search For Free WordPress Themes in Google or Anywhere Else" The first page that google supplied is numbered and discussed in detail to every link provided. It seems they are all cluttered … |
| | Hi Problematic. It seems that I have missed your post being new year and all.:) You can try the following - [CODE]Text1.Text = Datagrid1.TextMatrix(Datagrid1.Row, 1) 'The 1 at the end refers to the coloumn value in the grid, in this case coloumn 1...[/CODE] |
| | Re: TAB KEY What operating system are you running, XP, Vista or win 7? Sendkeys will not work in Vista or Win 7, hence my question. There is a work around once I know which OS you are using.:) |
| | Re: hi Welcome to Daniweb Sharmila.:) I'm sure you will find all the help you need. We have some very strong members in the Java section. Thank you for your offer of helping out where you can. It will be appreciated.:) |
| | I would personally use two combo boxes where the user can select the surname, once that is selected, populate the second combobox with the names, then load the datagrid. [CODE]'All your data and record source code here RS.Open "SELECT LastName FROM tblrecords", cn, adOpenStatic, adLockOptimistic If RS.BOF = True And … |
| | I had a look at your two sql statements and found some discrepancies - [QUOTE]tempSql2 = "INSERT INTO tempTbl (IDPrev, DaysPastDuePrev) SELECT ID, DaysPastDue FROM loanTable2" tempSql3 = "INSERT INTO tempTbl (IDRef, DaysPastDueRef) SELECT ID, DaysPastDue FROM loanTable3"[/QUOTE] Shouldn't "IDRef" in tempsql3 be "IDPrev" and so on for all the … |
| | @frexyang, you will have to open your own thread. Nobody will reply on this if you have hijacked another members post and even worse, from 2007.:) Post your new and own question and I will see if we can help. Also give us the current backup code you have... |
| | Re: Reports in VB6 What kind of reporting tool are you using? Is it a third party control like Crystal Reports or is it VB6 Report control? |
| | Just be careful when searching for wordpress. Have a look at my thread I started this morning [URL="http://www.daniweb.com/forums/thread339838.html"]Here[/URL]. |
| | a Very new welcome again.:) I'm not sure if the poll will work though. |
| | Re: Hello, world! Welcome to Daniweb. Hope you get all the solutions you require. If you know an answer, shoot away and answer a question.:) |
| | We do not do full projects here on Daniweb. Please read our posting rules.:) What code do you have thus far? What controls are you using? What database are you using? etc, etc... |
 | I did not like the attachment. As far as I know, we are not allowed to post full on applications (.exe) here, Jhai. The code looks fine, I'll play a bit with it when time permits.:) |
| | |
| | |
| | Welcome to Daniweb.:) Just make sure that when you do reply to other threads that your reply is relevant, that the post is not an ancient (old) post, that the post is not marked as solved etc. Enjoy our diversity of forums, we'll see you around.:) |
| | Re: facebook rumors! Totally spam/malware. It was posted on quite a few sites during the past few days. Seems that we were not the only ones getting the flack.;)  |
| | |
| | The way I have done something like this before is to create a table in my database for users. Before changing any user credentials, determine if a user has full access or not by checking their status from the table created. |
| | I suppose it all boils down to personal preference. Security will always be needed by the industry, but so is networking, especially seeing that almost everything nowadays goes to the cloud. I am sure that there is vast opportunities in both fields. Maybe talk to some people near you on … |
| | It seems we have missed your post over the new year celebrations.:) In your code, can you show us where the error occurred? The error normally refers to your code referencing something that does not exist when called. If I can see where the error was generated, we can get … |
| | Have a look at [URL="http://devcity.net/PrintArticle.aspx?ArticleID=100"]THIS[/URL] link. It contains several interactions with multiple forms in your project.:) |
| | Re: Maze Array I'm not sure what you need here? 500 x 500 what, 25 x 25 what? Give us some more info please.:) |
The End.