1,130 Posted Topics
 | How about one line... [code] Option Explicit Private Sub Form_Load() Dim S As String S = "string1 string2 string3 string4 string5 string6 string7" S = StrConv(S, vbProperCase) Debug.Print S End Sub [/code] Good Luck |
| | The simplest way for a test, is to use a control that can contain a graphic and has a visable property like the picture box control or an image control. You will need at least a couple of these. Then use a timer or two (one would do) and within … |
| | Access, SQL, MSDE, dBase, Fox Pro, Alpha5? What is your DBMS? a simple generic way of pulling information based upon dates is as follows. Select * from yourtable where yourdatefield >= somedate AND yourdatefield <= somedate Then there is the between statement if your DBMS supports it From VB press …  |
| | Re: update database Couple of possibilities Lets start with the date. Are you sure it is a properly formatted date? What DBMS (Access, SQL, dBase)? Each handle dates just a little bit differently. If you are using Access then go to the query analyzer, build your insert string there and see what characters … |
| | Use the Format function [code] txtreceitno = Format(rs.fields("orno") + 1, "00000") [/code] Good Luck |
| | see strongm's threading post (about halfway down) at [url]http://www.tek-tips.com/viewthread.cfm?qid=519374[/url] It can be adapted quite easily for what you want to do but I must warn you do not get too creative with threads in vb6. If you need any help please post again. Good Luck |
| | Why loop on input when you can read whole file in in one step? [code] Public Function ReadFileReturnStringArray(PathFileName As String) As String() Dim FileNumb As Integer, FileContents As String 'get a free file handle FileNumb = FreeFile 'open file Open PathFileName For Binary As #FileNumb 'retrieve its contents FileContents = … |
| | Okay, right of the bat I can see a potential problem with your timer control and its sub procedure. Not knowing, as I only read the first few lines, what your timer interval is set at I can guess that it may be way too low causing a problem called … |
| | search web for terminating a process or end a program through code There are many examples Good Luck |
| | How is the program choosing the printer? What is the method of printing? If printer.print mystring then remove/comment out printer selection code End If |
 | 32,000 identifiers, 64Kb limit per proceedure, but it is all limited by the amount of memory you have on the system as per the documentation. Perhaps your pagefile.sys is not large enough or you may need more ram. Good Luck |
| | Try... [code] Do While Not Eof (FileNumber) 'do stuff here like reading in your file Loop [/code] Good Luck |
| | [code] If rsOrder. BOF = False AND rsOrder.EOF = False AND rsOrder.RecordCount <> 0 Then MsgBox "Order Number Exists!" End If [/code] |
| | Select * from your_table where your_field = "Available" Or am I missing something? |
| | Try something like... [code] If rs.BOF = False AND rs.EOF = False AND rs.RecordCount <> 0 Then rs.MoveFirst Do While Not Rs.EOF rs.Edit rs!pcarrier = "Paid" rs.Update rs.MoveNext Loop End If [/code] |
| | [QUOTE=hkdani;821654]Don't really know what you're criteria for a valid filename is since you didn't mention the criteria: that might be helpful. But it appears that you 're not allowed to start the name with a number? [code]Private sub CheckName() dim strName as String strName = txtInput if isNumeric(left(strName, 1)) then … |
| | Otherwise known as API. Application Programming Interface. If you have VB 6.0 SP?, then you can access the API view via the vb interface or design environment buy the menu item Add-Ins... Click on Add-Ins and if you do not see an entry in the sub menu that says API … |
| | Only a guess, but it looks like you may be comparing an integer with a string. Set a breakpoint on or just before line in question, then user cursor to hover over each value to be evaluated, or use debug window, and check to see if itemcode(i) actually has a … |
| | What it is saying in MS-Speak is that the field "Qty" does not exist. Make sure you have it spelled correctly and does exist within the database. Good Luck |
 | [QUOTE=winrawr;820958]ok but wait, wat's the diff? o i no, it's that vb can't use classes rite? not OOP? ic ps. look at the filename of the attachment, of course it's a joke :)[/QUOTE] Man oh man where do I start? First off, its the syntax that is different between C++ … |
| | Well, it sounds like you have a plan but to execute it you are going to need to write some code and depending upon which way you go depends upon how much code you will have to write. Now if you trust the user to create a properly formatted SQL … |
| | Re: help [QUOTE=ryan311;820814]i have error to my code in the bold word! [code] Set rs = New ADODB.Recordset Set rs1 = New ADODB.Recordset Set rs2 = New ADODB.Recordset rs.Open "Select * from temp where pcode='" & txtEdit.Text & "'", cn, adOpenKeyset, adLockPessimistic rs1.Open "Select * from product where brandname='" & txtEdit.Text & … |
| | If you have the database open via your code or through the access application then you will recieve this error. You need to close all connections to the database prior to trying to copy it. Good Luck |
| | Re: help [QUOTE=ryan311;820332]it is possible? if the user in the running time, click the close button or the X button that we can see in the top of the form and then if the user click the close or X button message box will appear "you cannot log out"? how can i … |
| | If you don't want it executed, don't call it from the click event. |
| | i see the ; character after each setting but the readonly=0. Should it not be readonly=0; ? |
 | If the API instructions are above your head, check out the MMC (Multimedia control). Right click on your toolbox, select components, scroll down and select the Microsoft Multimedia Control 6.0 (SP3). Once it is on your form press F1 for help and read all about it. Good Luck |
 | [QUOTE=sal21;818942][url]http://www.x-rates.com/cgi-bin/cgicalc.cgi?value=1&base=EUR[/url] Based the link how to count element in table of this page? note: is the table where are all currency values tks. in vba please[/QUOTE] What technology are you using to view/download the document? |
| | There are a couple of ways to solve this but first question is... does the other program create the file if it is not there? If so, you could wait until you have exclusive access to the file and once you do you could do a couple of different things. … |
| | Use the Name operator [code] Name OldFileName As NewFileName [/code] |
The End.