1,130 Posted Topics
 | Some say it was blasphemous for ms to call their new OO programming languages VB and C but as things go they did. Here is some background that may help you... [url]http://windowsdevcenter.com/pub/a/oreilly/windows/ron/why_vba.html[/url] [url]http://www.adaptiveintelligence.net/Developers/Articles/YesVirginia.aspx[/url] So be forewarned, the "Classic" VB and variants thereof (VBA, VBS) are no where near what you … |
| | Yes, use the least common denominator when you package up your program, which means, that if you want your program to run on 98, 2k, XP, Vista, 7 then you need to compile it and package it on a 98 computer. Or, lets say you program is only targeted for … |
| | Okay, this has been discussed several times in many forums so you should be able to use your friends, google, yahoo, or any other search engine of your choice to more than enough examples and suggestions. Good Luck  |
| | Check the format property of the field or you could just change the field to long and store it as a number in the format of yyyymmdd since you are only storing the date portion. This causes you a little more problems as you have to format it going in … |
| | Well to begin with, I would change you varient variable to a string. Then I would check to see if that string equaled vbNullString and if it didn't, then add the value retrieved from the database. Otherwise, why add an empty string to a combo box. Good Luck |
| | Well if your friend is doing it in delphi, then ask them what they are doing. Which API's and where. What settings and so forth. Then create it yourself. Good Luck |
| | You could possibly be passing a negative value if your process takes longer than a second (Delay 1000 - Duration). Second, "End" is an execution command so perhaps you should change the declaration MyEnd or something else. Good Luck |
| | |
| | Use the data form wizard with the option of code (search for it in this forum and you will find my instructions on how to find it if you don't know where it is). Then see [url]http://www.connectionstrings.com[/url] Good Luck |
| | So that message box appears after your code tries to send the email right? For now on your design computer use spy to spy on that dialog box. Then code it up with FindWindow and SendMessage to click on the button you want. Good Luck |
 | Did you create an install package with the PDW, Inno, or the new installer from MS? Sounds like you did not and so your program is missing dependencies. Good Luck |
| | |
| | Most users will have a problem with you changing their screen resolution but what you can do is set the maximized button to false in properties of the form. That way your form will constantly look the same even if it does not fill the entire screen. Note: you should … |
| | I take it the *.MDB is on a share as the back end to an existing system. Can the system itself be modified? Should be simple enough for programmer to add table and a quick loged in loged out switch in table. Then table could be queried. Just a thought... … |
| | Does user perform an action to say they want to create a new record and when they perform this action you clear all fields except this new order number in preparation for user to enter data? Then... Text1.Text = Trim(Rs.Fields("IDField").Value + 1) (Note: In multi user environment this can become … |
| | You will need a variable to keep track of how many friends have been entered. [code] Dim MyFriendCount As Integer, LoopCounter As Integer [/code] Then you will need to initialize your friend counter [code] MyFriendCount = -1 [/code] Then you will need to test to see if you haved entered … |
| | [code] SELECT AccountInfo.incategory, Sum(AccountInfo.InAmount) AS TotalAmount FROM AccountInfo WHERE (((AccountInfo.Date)=#1/1/2009# OR (AccountInfo.Date)=#12/31/2009#)) GROUP BY AccountInfo.incategory; [/code] Good Luck |
| | See the replies at .... [url]http://www.vbforums.com/showthread.php?p=3590854[/url] Good Luck |
| | Check in the help files for the specs of the database. I'll bet you have gone over some sort of limit and i'm almost sure it is the 64k limit imposed on modules. Good Luck |
| | The correct declaration of this from the vb API viewer is... Public Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As Long So from what I can tell the declaration that they are using is correct (its just without the alias), however, if … |
| | It has been a long time since I used CR, but if I remember correctly, you can set the sql statement of the CR so that only the records you want are queried for, thus making it faster. Good Luck  |
| | You cannot "add" strings together (+), you can however concatinate strings together (&). As for everything else, it looks fine at first glance. Good Luck |
| | [url]http://www.ebay.com[/url] [url]http://www.nextag.com[/url] Good Luck  |
| | So, you want the string to start off with a comma? Well then.... [code] MyString = "," & MyString [/code] Good Luck |
| | Have you seen this... [url]http://www.thescarms.com/vbasic/volumecd.aspx[/url] or this... [url]http://www.vbcode.com/Asp/showzip.asp?ZipFile=http%3A%2F%2Fwww.vbcode.com%2Fcode%2FCdPlayer2.zip&theID=1639[/url] or this... [url]http://www.devx.com/vb2themax/Tip/19040[/url] Good Luck |
| | |
| | Most barcode readers are very simple to intergrate into vb programs. Start new project, add a text box to the form, and run the project (or just start notepad). Scan something (if using project make sure text box has focus). Good Luck |
| | Do you mean something like this??? [code] Private Sub Text1_KeyUp(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyReturn Then Text2.SetFocus End Sub Private Sub Text2_KeyUp(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyReturn Then Text1.SetFocus End Sub [/code] or like this??? [code] Private Sub Text1_KeyUp(Index As Integer, KeyCode … |
| | I saw an example somewhere on the web, don't remember where but they used a combo box. So search (google/yahoo) for... Nevermind I searched and got these results... [url]http://search.yahoo.com/search?p=vb6+-net+grid+combo&fr=yfp-t-152&toggle=1&cop=mss&ei=UTF-8[/url] Good Luck |
| | Google and yahoo are your freinds as is [url]www.pscode.com[/url]. There are many snippits out there that does this. Good Luck |
| | So you are talking about checking over the internet. You will need to create a seperate exe to (these are searchable terms (google/yahoo))... 1.)Check Internet Connection 2.)URLDownLoadToFile 3.)Open statement, Line Input Function, Close Statement, FreeFile Function 4.)ShellExecute So the suggested process would be to... 1.)Check the internet connection to see … |
| | Without seeing your code it is hard to guess what exactly is going on but from the sounds of it, you have not fully unloaded the form when you try and show it again. Good Luck |
| | Well it looks like you have lost reference to a custom control. Did this project come from another computer? If so you need to instal/register the missing control/dll on this new computer. If not, and you have the controls installed correctly on this computer then find the controls (which should … |
| | Okay, so questions with possible answers are coming from a database/text file/some source right? You only need one form with a label to display the question. Then if it is multiple choice, meaning that user would select one or more answers, then use a hidden check box for that question … |
| | Update.... where somefield=somevalue You are missing the where statement and as such are setting everyrow to same value. Good Luck |
| | Re: resourcefile You don't, you need to either use LoadResData or LoadResString to extract the information from a resource file and then use split to put that information into an array to add it to your combobox or save it to a file to use your code. Good Luck |
| | So then you are wanting to use the text as the foreign key? StringValue = List1.List(List1.ListIndex) Good Luck |
| | Combo1.Text Option1.Caption Good Luck |
| | Use the Line Input function instead of the input function. Line Input will read the entire line. Good Luck |
| | For an example, use the data form wizard. You will find this very useful wizard under Add-ins and if you don't see it, click on Add-In Manager. Use the code option. Good Luck |
| | Read up on the Dir Function in VB's help. There is also a usable example. Good Luck |
| | |
| | Read up on creating controls, activex exe's, and dll's. Good Luck |
| | Re: listbox question To add items to a listbox use the .AddItem method. Now from the sounds of this you will also need to use the .Clear method on List2 before you populate it with places. Now, how are you going to hold all of this information? Text File, database, code, ini file, … |
| | Do you know how to use ADO, DAO, RDO? Do you know what a select query is? Have you ever heard of the Data Form Wizard? You have left al lot of information out of your request like... Database type (Access, MySQL, SQL, Progress, Alpha5, FoxPro, dBase, Text Files, Oracle, … |
| | Because you don't have them in upper case. You have them in Propercase (Four, Five, Six). If you want them in all caps then use the UCase function or change your code. Also, if you set a breakpoint in TxtPaymentInWords_KeyPress, you will find out that when you go TxtPaymentInWords.Text = … |
| | Easier if you add the items to two comboboxes, add a command button to add the values from each combobox together to output to your text box. Otherwise you are going to have to keep track of what is selected and this will cause you more code and headachs. Good … |
| | Re: FRMREtrieve Okay, to split on the comma (,) you need to use... THE Split Function! [code] Dim MyArray() As String MyArray = Split(lstData.List(i), ",") txtID.Text = MyArray(0) txtName.Text = MyArray(1) txtAge.Text = MyArray(2) [/code] Then would it not be lstData.RemoveItem(i)? And now for why you are having so many problems... Tools>Options>Put … |
| | Time to delve into the API... FindWindow and SetParent should do the trick for you... Good Luck |
| | Yeah, that is one of the unfortuanate things about the command button is that they did not expose the fontcolor or forecolor for the control, but you can get around this (as mentioned above) by setting the style property to graphical at design time. Then you could use a picture … |
The End.