1,130 Posted Topics
 | Once again, as I am repeating both WaltP and kinwang2009,... What method do you use to open the file(s) in question presently??? Native... FreeFile Function Open Statement Input Function Or Line Input Function Close Statement Or via the API CreateFile, or FSO, or are you actually using the API ShellExecute …  |
| | Re: Minus Well using integers will not allow for the showing of cents or decimal value portions of a dollar... [code] MsgBox Format(-1000.45, "$#,#.00;-$#,#.00") [/code] Good Luck |
 | As kinwang2009 pointed out, the use of the msgbox function is called for here, but as you may be wanting to have a custom message box, you will need to show the form vbmodal and/or return a value from that form. [code] Load FrmMsgBox FrmMsgBox.label1.caption=”Do you want to save the … |
| | Using the Printer object, you could use its currentx and currenty properties to line up your text before you enddoc it... Good Luck |
| | Ahhh.... I see... You need to use a for loop along with the mid function to retrieve each character from the string. Then you could use either a select case or an if elseif endif structure to test that character and build your output string... Good Luck |
| | Hmmm.... tblCustomer iCustID 'auto number vFName 'first name vLName 'last name tblCustBal iBalID 'auto number iCustID 'number-foreign key to tblCustomer's unique id (auto number) '... Or however you have your tables designed... Then in access, tools>relationships, drag iCusID from tblCustomers to iCustID in tblCustBal. When the dialog comes up, select …  |
| | |
| | ...Like "'%" & inputedvalue & "%'" Good Luck |
| | It looks like it is possible but the error you reported is a problem with your query... It is saying that this part... [code] strSQL = "SELECT * FROM [COLOR="Red"]tablename[/COLOR] [/code] is the problem. It might be you have accidently misspelled the table name in some way or anothere. Go … |
| | Re: unknown question Sounds like you want to add the ability for user to run a script at runtime... See microsoft script control under components and in help. Also, use your friends (yahoo, google, ask, answer, bing) and search for vb6 script control as I know there are a couple of examples out … |
| | raj, you know by now not to raise the dead and instead copy the url into your thread if you need to reference it... I am reporting your post... |
| | The Change event of the textbox, perhaps???  |
| | If you did an order by Date_Recieved, I'm betting that the 3rd record would be first and the second record would be last as that would be the order of the dates... Which means your functions are returning the correct value/records... Which means, if you want the last record, you … |
| | Not sure if you can do this anymore blocker, as M$ does not like you to do these things. But, I do know that there is code out there (that worked on older systems) that you can give a try. Now, I believe you know who your friends are by … |
| | strSQL = "SELECT SUM(Amount_Paid) AS THESUM FROM tablename" 'open Result = Rs.Fields("THESUM").Value Good Luck |
| | Use the tag property of the text box... Good Luck |
| | SomeVariable = DTP.Month SomeVariable = Month(DTP.Value) SomeVariable = Format(DTP.Value, "m") 'or mm for 03 Good Luck |
| | If, those date fields are date fields and this is an access database you are trying to access, then the single ticks ( ' ) (plumbers crack) :) need to be replaced by the pound symbol (#)... (don't go there! :)) Good Luck |
| | Time to use your friends (yahoo, google, ask, answers, bing) and search for vb6 word automation tutorial... Good Luck |
| | Re: msgbox problem With better english.... To do what you want would require you to subclass the message box, which is no easy thing, and then you may not be able to accomplish what you want. So, your only choice is to create a form that you can use as a message box … |
| | or... [code] textunit.SelStart = Len(textunit.Text) [/code] Good Luck  |
| | A typical error handler goes something like this... [code] Private Sub Command1_Click(Index As Integer) On Error GoTo Command1_ClickError Exit Sub Command1_ClickError: End Sub [/code] Now, looking at your code I can see you have the exit sub after the msgbox and not before the error handler label.... Good Luck |
| | Well you could use the SUM(fieldname) in a query but it is hard to tell with what little information you have given... Good Luck |
| | To "Exit Sub" so nothing else happens but before this you may want to "SetFocus"... Use Exit Sub so the rest of the code does not execute after your message box and if you want use Text1.SetFocus to make it easy for your user to enter information... Good Luck |
| | Do you have a table that lists the quantity? If so, you could create and use another table that holds notification info on when user should be notified when the stock is running low... Or for that matter you could append a field to the table... say iReOrdQty and use … |
| | What that error is telling you is that you do not have a control by that name. So, go to form design view and click on the option button that you think is of that name and see what its name is in properties... Good Luck |
| | see [url]http://www.connectionstrings.com[/url] for the connection string you will need. See M$ for the oracle driver you will need if you don't have it, and see one of your friends (yahoo, google, ask, answers, bing) and use them to search vb6 ado tutorial... Good Luck |
| | Use the mouse move event of both the form and control along with the MouseIcon and MousePointer properties of both to change and reset the mouse icon. You can also use the mouse move events to start and stop any animation or to control changes in the image displayed. Good … |
| | That error is telling you that you missed a closing statement of some sort within the loop if not the closing statement of the loop itself and in this case you missed and End If to the last If bCheck = True Then statement... Good Luck |
| | So I take it you are using some sort of VBA and NOT VB! Like Access, Excel, Word, or some other office product... And since you don't write code and neither does your IT department I would suggest that in the future that you go to [url]http://www.rentacoder.com[/url] and place your … |
| | Put the date in your calculations... Good Luck |
| | Here are some SQL terms for you to look up... Group By Clause with a Having Clause Order By Clause Now, there are several ways to accomplish what you want to do... You can group by on the company name with a count of company name having that count > … |
| | [code] 'where Tution_Fee = tablename strSQL = "UPDATE Tution_Fee SET (Amount_Paid = [Tution_Fee].[Amount_Paid]+" & (Val(Text1.Text) - Val(Text2.Text)) & " WHERE Tuition_Fee_ID_PK = " & Form2.Label16.Caption [/code] Good Luck |
| | Re: pls help Besides Walt's advice, it sounds like you want to make your form scrollable via the use of a horizontal scrollbar. The easiest thing to do, would be to put all your controls into a picture box except the scrollbar. Then you could use the change event of the scrollbar to … |
| | drew and mudan... It is not nice to necropost as you have!!! Raising the dead around here may get people miffed at you. If you are having the same problem as someone else or in this particular case as an old thread, please do not highjack the thread or resurrect … |
| | As a matter of fact I do have something that you could look at and come up with something that may work for you but that is not the point of these forums. The point is, is we would like to see an effort from you and what you have … |
| | vishaldalya, I'm holding off on reporting your post for one reason only, and that is because you are new to this forum, but as things go... We will not do your homework for you. You want it done for you, goto [url]http://www.rentacoder.com[/url] or [url]http://www.odesk.com[/url] and put your homework up for … |
| | Time to use your friends (yahoo, google, ask, answers, bing) and search for vb6 excel tutorial. You will also need to know the Dir Function... And to do what you want to do is enumerate through folder making a list of the excel file names. Then you will have to … |
| | The PDW is a bit outdated, but with that said, if you run it as admin and still recieve this error message, it should be no problem. However, if you do have problems with your program you might want to download Windows Installer 1.1 or inno. Windows Installer is the … |
| | Form? Datagrid view??? Datasheet View??? If you are in access, you cannot add a DTP to a table...(at least as far as I know but then again I don't do much VBA...). Me thinks we need more information... Good Luck |
| | And what does that proceedure look like? Also, the randomize statement should only be called once in the lifetime of a program, which means you should move it to your startup object, either sub main or form load. Good Luck |
| | Re: help me pls!! If you are using ADO and a DNS Less connection string see [url]http://www.connectionstrings.com[/url] for the proper format. If not, then we will need to have more details like the relavent code, the actual error number and description, and the line of code that is causing the error, along with what … |
| | And if you are using access, instead of the single ticks (') you will need to use the pound (#) sign... Good Luck |
| | However, the query unload event is fired before the unload and terminate events and this event will be able to tell you how and why your form is closing... Good Luck |
| | Okay, you almost have it. In Form2, Command1_Click, you have Form3.Combo?/Text?.Clear/"" and this is where you should be adding the information you want to carry over to Form3. You will also need to double click on the command2 button to create the sub for that functionality also... Good Luck |
| | Re: Help me? Delete what? A file? Use Kill Statement. Delete a record? From what? A text file? Read it in, remove what you want, and write it back out. From a database? Use a delete statement (DELETE FROM tablename WHERE fieldname = somevalue). Don't know how to access data in a database? … |
| | Well,... You are going to have to map (no pun intended), the x/y cordinates of the form/image control/picture box to the cities displayed and if you have more than one map, your going to need more than one set of coordinates. Now, I have a suggestion for you on your … |
| | and perhaps Walt you should recognize that this thread is in the wrong forum and have moved it to the VB.NET forum...  |
| | See [url]http://www.vbforums.com/showthread.php?t=473677[/url] for more sorting routines... Good Luck |
| | I'm betting if you use your friends (yahoo, google, ask, answers, bing) and search for convert delphi to vb, you will find a couple of converters out there... Good Luck  |
The End.