| Subject | Date Asked |
|
| VBA and time operations | 11/4/2008 |
Q: I would like to know if MS Access has the ability (some function) to fill the time and then ...
A: Yes, MS Access can do this relatively easily with the Now() or Date() functions. There are some ...
|
| change the direction of backspace | 10/29/2008 |
Q: I want to change the direction of backspace in richtextbox.The backspace deletes character which is ...
A: Use the DELETE key instead of the BACKSPACE key. Anything beyond that would involve customizing the ...
|
| Strip space delimited strings | 10/24/2008 |
Q: I am able to import strings into a visual basic 6 program, but I need to strip the string into ...
A: There is a SPLIT function which you can use to break this up into an array on any character - in ...
|
| How to use drivelistbox & filelistbox | 10/23/2008 |
Q: I am trying to use a drive list box on a form to select a specific drive like (c) drive @ run time ...
A: Brian, explaining how to use these in detail here would take much more time than I can spend. ...
|
| Date formatting | 10/22/2008 |
Q: I have a input form which takes an arrival date in a textbox and similarly the number of nights to ...
A: It seems like an International Date setting problem. Check your Windows time/date settings and make ...
|
| VBA | 10/21/2008 |
Q: This is NOT a homework question!!! I am working on a project using MS Access 2003 and I need to ...
A: If you want to refer to a value on a Form, you can use the notation: Forms!FormName!FieldName You ...
|
| Passing a value from one form to another | 10/20/2008 |
Q: I have two forms both with a field named 'Change Control Number' (both set as primary key in the ...
A: Just put it in your button that does the form open: FormName.Show FormName.TextBox = Value I'm ...
|
| regarding combobox in vb.net | 10/15/2008 |
Q: i am fetching data into comobox from a column of a table but i only want unique values to be ...
A: Use an aggregate query to show unique values. To do this, use an Aggregate Query... also called a ...
|
| Validation | 10/12/2008 |
Q: im quite new at vb and am trying 2 validate the amount of numbers in a bank account. so i want 16 ...
A: You need to use the LEN function to determine the length of a string. If Len(BankNumber) <> 16 ...
|
| Simple Calc | 10/9/2008 |
Q: I am just starting to learn VB. I tried to do a simple calculator but I'm already having problems ...
A: Remember text boxes are just that: they store text. You can really add text values together. You ...
|
| passing variables | 10/8/2008 |
Q: I have following problem, I want to pass a variable in VBA code (MS Access) M_Variable = "Text" with ...
A: What do you mean by pass the variable? Pass it to what? And you don't need the with statement. ...
|
| Visual Basic Check boxes | 10/8/2008 |
Q: I'm trying to do a program to identificate microorganism as a part of the course of microbiology ...
A: You're on the right track. You just have to create a series of if/then clauses to determine your ...
|
| Combo Box Requery | 10/2/2008 |
Q: I have combo box on subform that I can’t get to requery based on a select query. Records should ...
A: That's a limitation with Access. You simply CAN'T have a subform in datasheet view. The best you can ...
|
| SQL Record Count, SELECT COUNT(*) | 10/1/2008 |
Q: I have been messing with this for about 12 hours now. I have search the Net as well. I this issue is ...
A: You could try removing the adOpenStatic type as well. Again some recordset types do not support the ...
|
| form display | 9/28/2008 |
Q: I had developed a small aplication in vb. I want to create a form which should be diplayed after ...
A: Set a registry key or use a file to determine whether or not this user has opened your application ...
|
| startup form | 9/28/2008 |
Q: how to change startup form of a project through coding.
A: You wouldn't use a startup form. You would use a sub main If you want to change which form loads on ...
|
| Importing Certain Lines of Data | 9/26/2008 |
Q: I wanted to know what Visual Basic code I might use to import specific lines of data from a wordpad ...
A: Importing from notepad is not hard. You just have to know basic file input and output. Open ...
|
| Error 3464 :Data Type Mismatch in creiteria expression | 9/26/2008 |
Q: i have this problem , i have a table that contain "Employee Name, Tasks, Date" i have done a combo ...
A: First of all this is a Microsoft Access question but not in Visual Basic question. You have to make ...
|
| VB & Access 2003 | 9/24/2008 |
Q: How to make procedures available to all forms in Access 2003? I tried PUBLIC, but it doesn't work. ...
A: You're asking this under the wrong category. This is the VB category. Not the Access category. ...
|
| Rnd whole numbers | 9/23/2008 |
Q: I'm making a little game where you need to use 2 dice to make some actions. I know a little bit on ...
A: Generating random numbers in VB is easy. Here's the code: Randomize N=10 X = Int(Rnd*N+1) The ...
|
| vb6.0 and msdatabase | 9/22/2008 |
Q: how can i prevent duplicate entry in database , i have Student table where idno and scholar no are ...
A: Index the field and set it to NO DUPLICATES. Let me know if you have any other questions or ...
|
| SQL Record Count, SELECT COUNT(*) | 9/21/2008 |
Q: I have been messing with this for about 12 hours now. I have search the Net as well. I this issue is ...
A: Some cursor types don't support RecordCount at all. Others only support RecordCount if you first ...
|
| vb6 | 9/21/2008 |
Q: I have designed an application with vb6. When I run this application on other systems, fonts change ...
A: Use standard fonts. If you use fonts that are only on your system, your results will be unreliable. ...
|
| Generating an audio tone from VB6 | 9/15/2008 |
Q: I am designing a VB6 project where I need to create a continuous tone from the sound card. I also ...
A: Bill, here is some code I used for a project doing this a while back. Just drop this in a module, ...
|
| Save worksheet after its selected 3 times | 9/13/2008 |
Q: I'm trying to develop a work-around to my previous "Save worksheet after printing" question. I know ...
A: You've got me! I'm sorry, but I honestly don't know the answer to your question off the top of my ...
|
| Writing Macros | 9/11/2008 |
Q: Do you know where I can find a list or chart of the numbers that correspond to the color pallets? ...
A: I don't have one off-hand. I'm sure you can find one with a Google search. Personally, I just put a ...
|
| VB 6.0 & MS Access Problem | 9/11/2008 |
Q: Sir, i have MS Access 97 database. i have put navigation button on form, when the form display last ...
A: You've moved beyond the beginning or end of your recordset. You can use an ON ERROR statement to ...
|
| random txt | 9/10/2008 |
Q: I want to make a random txt with the specific value i want with a txtbox so i typed the following ...
A: Round your value off using the INT or FIX functions. Let me know if you have any other questions or ...
|
| visual | 9/10/2008 |
Q: Write a program to print this triangle: * ** * **** * ****** * ******** * ********** Don't use ten ...
A: Yes... I can do it... but can YOU do it? I'm sorry, but your question sounds like a HOMEWORK or ...
|
| Visual Basic | 9/9/2008 |
Q: I am hoping that you can help me with the following: I am new to Visual Basic. I need to do a ...
A: Just place two textboxes on your form and a button. When the user enters their data, your button ...
|
| Visual Basic 6.0 | 9/8/2008 |
Q: i am absolute beginner.i want to learn visual basic but confused which version should i learn vb ...
A: Personally, I think VB6 is much easier to learn than the newer versions, but that's just my opinion. ...
|
| Quetion in VB/MS Access regarding date | 9/8/2008 |
Q: Well in my application I can store dates in MS Access database in "medium date format(01-jan-2000)" ...
A: What do you mean by "retrieving" the data? Where are you retrieving it to? Just FORMAT it there. If ...
|
| OCR on VB | 9/1/2008 |
Q: what i need to do is to scan a file then i will browse it using a vb program then i will convert the ...
A: You'll have to find a third-party program or library that adds this functionality. VB alone doesn't ...
|
| visual basic 6.0 | 8/30/2008 |
Q: can u tel me the codes in vb to get a person's age from his birth date?
A: Sure. Just use the DateDiff function. See: ...
|
| Visual Basic | 8/30/2008 |
Q: I've made an IRC Client. I have a textbox for sending messages. My question is, how can i make it so ...
A: You'll have to use the KeyDown or KeyPress event and look for the ENTER character code (13 or 10, I ...
|
| Vb6 Loops | 8/29/2008 |
Q: I just learnt how to make a string in vb6 but I don't know what can loops can do for, any ...
A: Loops are used for anything you need to COUNT or ITERATE through. Let me know if you have any other ...
|
| vbYesNo | 8/27/2008 |
Q: Is there a way to change the yes and no buttons to say "print" and "next" on the example below? ...
A: Nope. You could make a custom form that LOOKS like a MsgBox and put whatever buttons you want on it, ...
|
| vb6.0 case statement | 8/26/2008 |
Q: what is case,cse else, end select in vb6.0
A: The SELECT CASE statement is just an alternative to IF/THEN. Instead of saying IF A=B Then Do ...
|
| Access 2003 EVAL function | 8/25/2008 |
Q: I am trying to modify the enabled & locked controls for a group of text boxes in a form in Access ...
A: Yes, you would have to rename your boxes though. Create a CONTROL ARRAY. If you copy one text box ...
|
| accessing a barcode scanner using visual basic code | 8/19/2008 |
Q: Sir, How can I access a barcode scanner in my visual basic application. The application should be ...
A: Most barcode scanners that I work with convert the barcode into standard numbers and letters. Just ...
|
| Excel Macros | 8/17/2008 |
Q: The following macro gives me the error - Invalid use of property & takes me to first .Value line ...
A: You don't have a properly formed statement. Plus, your InputBox is returning a STRING value. You can ...
|
| DIR function missing in Access 2003 | 8/15/2008 |
Q: The following code used to work but now it is giving this error "The expression you entered has a ...
A: This should work fine for you: X=UCase(Dir("smpftpp02AshBrkrgeSCUNAREQ.xls")) But you can't assign ...
|
| Putting data into a specific place in a file | 8/13/2008 |
Q: Okay, my question is this: Can I use VB6 code to add data to the end of a text file, rather than ...
A: Change this line: Open "C:\highscores.txt" For Output As #Channel to this: Open ...
|
| AutoNumber Generation | 8/11/2008 |
Q: am creating a certain program and in that program i want to add a field which will be creating ...
A: See this tutorial on creating your own counter: ...
|
| access form in vb | 8/9/2008 |
Q: how can i open my access form in Visual Basic project.
A: I don't believe you can open an Access form directly from inside a VB project. You'd have to launch ...
|
| repetitive dates in exel sheet | 8/9/2008 |
Q: I would like to prepare a effort tracker for all the employees in my firm in a singhe excel sheet ...
A: Well, I don't have time to write the macro out for you here, but if you simply make the list of ...
|
| On vb 6.0 date formats | 8/9/2008 |
Q: how to retrieve the month number whenever enter month name
A: If someone types in the NAME of the month, you're going to have to resolve it yourself. I'd ...
|
| Close button | 8/7/2008 |
Q: How can i disable the close button, so people can't close it?
A: Set the ENABLED property to FALSE. Let me know if you have any other questions or comments. Also, ...
|
| Type mismatch | 8/6/2008 |
Q: I have created a software that handles invoices from xmls. This works fine everywhere, including my ...
A: Do you have any strange ActiveX controls or other objects included in your package? It just sounds ...
|
| VB6 add days to calendar but not count weekends | 7/24/2008 |
Q: I am trying to put together a calendar calculator in VB6 that will calculate the number of days ...
A: I don't have code for it handy, but it should be hard to write a loop for this where you simply ...
|
| delete hidden files | 7/24/2008 |
Q: i want the code to delete protected hidden files using visual basic..... i tried this using "kill" ...
A: You're going to have to first unhide and unlock the files. You could try this command first: SHELL ...
|
| How to Convert? | 7/20/2008 |
Q: My Brother had create a vb project before 2 years ago.He give me it as a package.When i asked for ...
A: I don't understand the question... how would you get the project files? You have to HAVE them to use ...
|
| question for a school project | 7/19/2008 |
Q: Out of all the programming languages out there, why did you choose to learn visual basic? What is so ...
A: I like Visual Basic primarily because it's easy to use. I also program in C/C++ and several other ...
|
| replace VALUE of a variable | 7/11/2008 |
Q: As I can transfer arguments to script through command file. Script should replace VALUE of a ...
A: You could use the Replace() function. Let me know if you have any other questions or comments. ...
|
| vb code | 7/10/2008 |
Q: I am a beginner in Vb6 with access 2000 coding i am designing a project for the diabled people.I am ...
A: If you need to specify the table to open at RunTime then just put it in a variable and say: ...
|
| Visual Basic 6 | 7/7/2008 |
Q: May i ask about VB 6.0 with Photoshop CS?
A: You may ASK, but I don't know how much help I'll be. Yes, I use both VB and Photoshop, but I don't ...
|
| Sage Accounting package | 7/7/2008 |
Q: I'm working on an application in VB6 and want to interface to sage accounting package for thepurpose ...
A: I've never used Sage Accounting. Sorry. Let me know if you have any other questions or comments. ...
|
| Click a Button On VB6 WebBrowser Automaticly | 7/6/2008 |
Q: I am making a program where it automatically fills out a sign up form on a website in a vb6 web ...
A: There is a .SUBMIT method to the WebBrowser object, I believe. It's been a while since I've done ...
|
| Finding difference between to dates | 6/20/2008 |
Q: I have two fields in a (vb 6)form such as IssueDate and ExpiryDate.it store data from the database.i ...
A: You'll have to change your dates to a format that VB understands, like mm/dd/yy. Once you've done ...
|
| MS Access - SQL | 6/17/2008 |
Q: I have written a query as follows... strSQL = "SELECT CREDITORS.CreditorId, ...
A: You just need some PARENTHESES around your criteria. (A + B) * C is not the same as A + (B * C) ...
|
| facing problem in LostFocus property of textbox | 6/15/2008 |
Q: First many many thanks for your previous valuable suggestion, Sir here i am doing a validation ...
A: Compare the value that the box had BEFORE you tabbed to it with the value as you're leaving. If ...
|
| vb6 exe | 6/13/2008 |
Q: i have developed one application in vb6 and i added a option in right click menu which will run my ...
A: You would have to make it a PARAMETER in your program. Just read the Command string in your Sub ...
|
| Is date field can remain blank in VB frontend | 6/11/2008 |
Q: i am creating an application using VB 6 with Access. i am retriving some records from access table ...
A: You could try throwing an "on error resume next" statment in your code... that will bypass any lines ...
|
| Moving Objects | 6/9/2008 |
Q: We have a sprite move along and he tries to reach the end. The problem is the walls that are ...
A: If the walls aren't showing up until the end, then you need a routine in the middle of your loop to ...
|
| Help Me, Please! | 6/8/2008 |
Q: I've downloaded a File Search.ocx from http://www.martin2k.co.uk/vb6/tips/vb_36.php And I want to ...
A: I haven't looked at the file you've downloaded, but you can use the KILL command to delete files, ...
|
| problem while installing the set up file in other system | 6/7/2008 |
Q: i created .EXE file and Packaged it. while i am installing in own system it installed successfully ...
A: You are obviously missing a setup file. Did it tell you which file was not up-to-date? Without more ...
|
| ListBox Related in VB | 6/6/2008 |
Q: i added several list items in listbox control. and the style of the listbox is checkbox. I want the ...
A: That is the only style offered by the ListBox control. Anything else would involve serious custom ...
|
| Visual Basic6.0 | 6/4/2008 |
Q: 1.0)Just tell me what extension is used for visual basic programming. 2.0)Can we use the code of ...
A: 1. I don't understand your question. 2. Usually, yes. 3. Try Google. Let me know if you have any ...
|
| Ask how to save to excel files and give password | 5/31/2008 |
Q: i want to ask how to save to excel files and gives password to the file..Thanks a lot..
A: Just go to File > Save As... > Tools > General Options. You'll see two boxes on there to enter your ...
|
| How to use IF function in Visual Basic | 5/30/2008 |
Q: How to use IF-ELSE function in Visual BAsic?
A: The most basic form: ' If Condition Then ' Statement1 ' Else ' Statement2 ' End If Enjoy. ...
|
| Time Conversion | 5/30/2008 |
Q: Rost Do you know of any code that could convert elapsed time (ie: 03:46:01 shown in a label1) to a ...
A: I don't have the code handy, but it wouldn't be difficult to write it. Just break the numbers down ...
|
| adding numbers | 5/29/2008 |
Q: I am currently making a program for my school to use for their cricket team. However I have trouble ...
A: I'm assuming you're adding up by 0.1 until you get to 0.6. In that case, you could say: 'If X < ...
|
| VB data question | 5/23/2008 |
Q: Beginner trying to help someone out. I have read 16 bytes of data from a file that looks like this ...
A: That all depends on how you're storing the number. If that's one TEXT string, you could use the ...
|
| keyboard key assigning | 5/21/2008 |
Q: I am starting to my first P.O.S (Point of sales program. I want to know the code for assigning a key ...
A: You can use the KeyDown, KeyPress, and KeyUp methods for handling this. I cover them in my VB106 ...
|
| Error in SQL Statement | 5/14/2008 |
Q: Kindly advise what is wrong in the following sql statements: INSERT INTO: (nor inserting the ...
A: Looks like it's in this line: db.Execute ("Delete * from authors where 'author = " & List1.Text & ...
|
| vb6.0 calculate age from date of bitrh | 5/12/2008 |
Q: i would like calculate candidate age from 01-01-1968 to 01-01-1984 if candidate's birth is ...
A: Here's a "good enough" answer for most circumstances: Just subtract the values. If you say: X = ...
|
| Access 2003 | 5/11/2008 |
Q: I have a comlex database with various data types but want to have reports only print those fields ...
A: If you set the CanGrow/CanShrink properties to YES for both the text boxes AND the detail section, ...
|
| accessing the same database at the same time | 5/6/2008 |
Q: Sir,i want to ask could be any problems that may occur when 3 clients access the same database at ...
A: That would depend on your database software, and whether or not your VB is coded properly. If not, ...
|
| write file | 4/29/2008 |
Q: I'm using VB6 and using about 50 checkbox's on a form I am creating. By looking at the short code I ...
A: Sorry, I didn't mean to sound rude, but I had just finished answering about 30 questions last night ...
|
| write file | 4/28/2008 |
Q: I'm using VB6 and using about 50 checkbox's on a form I am creating. By looking at the short code I ...
A: Uhm.... it might help if I knew what you were trying to do. ??? Let me know if you have any ...
|
| Visual Basci trial version | 4/26/2008 |
Q: Hi I want to create one trial version application in visual basic ? Means it may be for 15 days or ...
A: Easiest solution: hard code a KILL date into your Form Main event: 'if Date > #6/1/2008# Then ' ...
|
| access and vb | 4/23/2008 |
Q: I have an Access 2003 database with no primary key. Using a vb6 program I open it, and move to the ...
A: That's very strange. Are you sorting your recordset? I would recommend using a field such as an ...
|
| vb6,0 and excel | 4/22/2008 |
Q: What is the syntax for making MyTable a variable in this statement?? conn.Execute "Insert into ...
A: Something like this: MyTable = "CustomerT" Conn.Execute "Insert into " & MyTable & " (FirstName, ...
|
| getting a substring | 4/21/2008 |
Q: I have a problem I need to get a certain part of a string but i dont know the positions of the ...
A: Steven, this is a very good question. Let's say your string (S) is: Name=Joe,ID=421Enabled You ...
|
| DHTML | 4/18/2008 |
Q: How can I get a FREE tutorial/ ebook on DHTML in Visual Basic 6. Thanks
A: Uhm... I don't know. Try a Google search for "free dhtml visual basic ebook" ??? Let me know if ...
|
| Screen saver custom text | 4/17/2008 |
Q: Richard. Why can I only put no more than 20 words on my computer screen saver to see? Is it possible ...
A: I'm sorry, Sterling, but I don't know. I'm a VISUAL BASIC expert, not a Windows expert... and while ...
|
| user imput | 4/17/2008 |
Q: sir want to replace the dir name aaa with info entered into a form textbox thanks earl MkDir ...
A: Assuming your textbox is Field1, just say: MyString = "C:\Users\Earl\Documents\" & Field1 MkDir ...
|
| VB6 - Copy Text in Text Boxes to TXT ONLY when populated | 4/17/2008 |
Q: Hey team, I'm having a bit of trouble with a program we use here at work that does ship ...
A: Just add some IF statements to whatever code is creating the TXT file. 'If Field1<>"" then ' ...
|
| Compiling vb6 project | 4/16/2008 |
Q: How do I compile a vb6 project so that it will run on a computer which does not hve vb6 installed? I ...
A: Look for the PACKAGE AND DEPLOYMENT WIZARD which should be on your Start menu in the Visual Basic ...
|
| question | 4/16/2008 |
Q: i want to build a password protected form. i let the user to type in text box and validate the ...
A: Well, I'm assuming you're going to hard-code the usernames and passwords into variables in the form ...
|
| Finding common elements (values) from two columns in MS access database using VB 6.0 | 4/16/2008 |
Q: I am new to VB 6.0. Currently I am doing some data pre-processing for a project, and not being good ...
A: Just stick with Access and use the FIND DUPLICATES query wizard. Let me know if you have any ...
|
| Rename File w/TimeStamp Using Batch | 4/14/2008 |
Q: I would like to have a batch file rename an existing text file to the following format: ...
A: Well, it wouldn't be a BATCH file, it would be a VB program. I would need to type this in to test ...
|
| Writing existing values from an Access form to an existing table | 4/14/2008 |
Q: I have some fields that have been on an access form for a while, but are not currently part of any ...
A: If your FIELDS are on a form, and they're NOT bound to a table, then when you type data into them, ...
|
| calculator | 4/13/2008 |
Q: Hey, I'm not sure whether you will be able to help me out or not, but calculator programming is very ...
A: Yeah, this looks fine. I would have approached it slightly different... B=15 C=0 For(A,1,15) ...
|
| moving items from a listbox | 4/11/2008 |
Q: I'm using Excel 2003 and trying to write some VBA code. I have a listbox1 and load several values ...
A: I cover list boxes in DEPTH in my VB105 tutorial, Lesson 2. http://www.599cd.com?GOVB105 You can ...
|
| Seek or Get from a Comma delimited file? | 4/11/2008 |
Q: I just need to get an idea on the best way to read a simple text file that has variable length ...
A: If it's already a text file, you could probably just read in each line and then parse it yourself ...
|
| Command Button Back Colour | 4/11/2008 |
Q: I want to cahnge the BackColour of CommandButton in VBA/MS-Access how can I do this at runtime?
A: Yes. You have to set the button's STYLE property to Graphical, and then use the BackColor property. ...
|
| Randomizing Code | 4/10/2008 |
Q: I am making a game in VB6 where you have to uncover the winning square. the squares are all command ...
A: Use the Randomize and RND functions to generate random numbers. Cordially, Richard Rost ...
|
| VB6 Pong | 4/9/2008 |
Q: I am attempting to upgrade the pong game I made. I have the two paddles(shapes) a ball, also a ...
A: Colin, I've never tried making a game with VB - I have always stuck with business-type applications. ...
|
| Formating textbox in vb 6.0 | 4/9/2008 |
Q: i want to format a text box(txtarrival)in vb so thatwhen the user enters a value in in that value ...
A: Well, normally you could use the CDate() function but that assumes the user is at least entering the ...
|
| Status bar | 4/8/2008 |
Q: I like to ask if there's a way to get the text that are diplay in the status bar using vb. Please ...
A: I don't know the code off the top of my head, but I know I do cover the StatusBar control in my ...
|
| Runtime Error 339 | 4/8/2008 |
Q: when i make an exe file of vb6 project and try to run it on ANOTHER computer, it runs, but when i ...
A: You're missing a dependent file, obviously MSADODC.OCX. Did you run the PACKAGE AND DEPLOYMENT ...
|
| Save image from a webpage | 4/6/2008 |
Q: I want to automate the process of downloading all the images present on a web page to a folder on my ...
A: Load up the page in a WebBrowser object. Scan through the HTML of the page looking for IMG tags. ...
|
| help in vb6 | 4/5/2008 |
Q: sir please tell us how to separate a string like(;255:234 ;254:213 ...
A: This is pretty complex, but I'll get you started... First, you're going to have to know how to read ...
|
| VBA Code | 4/4/2008 |
Q: I am a beginner in VBA.i have set a fixed date with combo box in userform and i have 3 conditions ...
A: You're on the right track. To subtract 2 days from a date, just -2 from it. So if your date is in ...
|
| Changing VB file into .exe | 4/4/2008 |
Q: i would like to find out how i can change a visual basic application into a .exe one, so i could run ...
A: If you're using VB6, just run the PACKAGE AND DEPLOYMENT WIZARD. Look on your Windows Start Menu. It ...
|
| VB 6.0 DB Access Query | 4/4/2008 |
Q: We are using a VB application. Initially whenever a connection needed, we are creating a database ...
A: Just looking at your code, I see that you're specifying the FILENAME of your MDB file instead of the ...
|
| Regarding Text Box Control | 4/4/2008 |
Q: How Much character we can insert in a text box Control?when I am trying to insert large amount of ...
A: I'm not sure what the upward limit it - perhaps you could test it with a loop, or just do a little ...
|
| vb trial version | 4/3/2008 |
Q: how to make a demo version or trial version of a software,project
A: The EASIEST way would be to make a separate version of your program that has a KILL date in it. For ...
|
| VB | 4/2/2008 |
Q: How to combine multiple textfile data into single texfile using VB code.
A: You want to combine two text files into one using VB? That's just a matter of opening the first one, ...
|
| moving an object | 3/31/2008 |
Q: I'm designing a program for kids, and I've created a cat and i want the cat to move by pressing a ...
A: You can access the .left and .top properties for the object (assuming it's something like an image ...
|
| Command Buttons generated from Database | 3/31/2008 |
Q: I am making a simple EPOS system in Visual Basic 6.0, and want to take products from a database and ...
A: Is it possible? Sure, but it's not going to be easy. You're going to have to create a function to ...
|
| Help with random number elimination | 3/30/2008 |
Q: For a program I'm making, I need it to generate random numbers, and then prevent the numbers from ...
A: You would have to store them in an array, listbox, or table (depending on how many numbers we're ...
|
| 3d | 3/28/2008 |
Q: can we make 3d video game on vb? like delta force
A: Just like you *could* move your entire house in the back of a small pickup truck, a moving van would ...
|
| COMPILE ERROR | 3/26/2008 |
Q: I'm trying to compile a VB% project using a VB6 environment but I get the following error: Trying ...
A: Some file is missing - either from VB or from your project. Cordially, Richard Rost ...
|
| String Concatination to Integer values | 3/26/2008 |
Q: I 've a problem with concatination o f string to integer in visual Basic. Like i have to use the ...
A: You should be able to concat a number onto a string. This works fine for me: ' S = "Hey there " ' ...
|
| Runtime error # 13 "Type Mismatch" | 3/26/2008 |
Q: i am writting a batch program in VB6.0 to stop alll the running tasks in HFM (Hyperion Financial ...
A: Sorry, I've never used HFM and without a copy of that class library, there's no way I could help ...
|
| interact with other open application | 3/25/2008 |
Q: I would like to create a program that will verify first if the other specific application was ...
A: Here is some code that will list all open applications: ...
|
| Simple VB to resolve imported data issues | 3/24/2008 |
Q: I import data into Excel 2007 and format to text, however, many times I need to hit F2 and enter to ...
A: If you record your keystrokes in a macro and then take a look at the VBA code that the macro ...
|
| files in a directory | 3/24/2008 |
Q: How to count the number of Zip files in a Paricular Directoty and display the file names using VB or ...
A: Use the DIR() function to loop through all of the files in a directory. See the help system for the ...
|
| VB6 -controlling Notepad - Go To line# | 3/24/2008 |
Q: Is there a way to automate opening of a text file in Notepad and jumping to a specified line number, ...
A: I haven't tested this, but you could TRY using the SENDKEYS statement to send a series of ...
|
| VB6, Forms don't show when I run....odd | 3/23/2008 |
Q: I have run into sort of a huge roadblock, after building about 8 forms and coding a few VB6 no ...
A: Silly question, but are you LOADing or SHOWing your forms anywhere? VB just won't automatically show ...
|
| Clipboard | 3/21/2008 |
Q: I need to automatically get what's inside the clipboard. For example, if I copy "Google", I need it ...
A: See: http://jalaj.net/2007/01/15/accessing-clipboard-from-vb/ I hope this helps you. Let me know ...
|
| Storing values in VBA array | 3/20/2008 |
Q: I'm new to VBA. What am I doing wrong? I want to permanently store the values in the 2 arrays ...
A: The array code looks fine. It must be a problem with your Excel code. I hope this helps you. Let ...
|
| visual basic 6.0 | 3/20/2008 |
Q: sir, i want to code in vb for browse image. meance if some one copy there image on destop. i want ...
A: You can use the Common Dialog Control to browse for a file on your computer. Then, you can load it ...
|
| Add data from form to Access Database | 3/20/2008 |
Q: I created a form that that has textboxes with data that is entered by the user. I am trying to ...
A: Well... what is happening? Are you getting an error message? Personally, I still use DAO more than ...
|
| startup form | 3/19/2008 |
Q: I have written some utilities for my business on VB5. These go back a few years. I don't write many, ...
A: I don't know about VB5 (it's been MANY years since I've used that) but in VB6 you set the startup ...
|
| AUTOMATION TIE-IN | 3/19/2008 |
Q: I am trying to automate a machine which checks thousands of parts a day. Currently, an operator ...
A: Bill, that all depends on your hardware. How does the machine physically connect to the computer? Is ...
|
| Application access thru user and priviledge | 3/19/2008 |
Q: I am developing an access / VB application. I want to set up a user and priviledge table, and i have ...
A: If you want to create your OWN security through VBA code (controlling who can access what thru your ...
|
| Special Characters | 3/18/2008 |
Q: How do i restrict users from inserting special characters in a text box and how to remove any ...
A: Probably the easiest way to go about this would be to have an event fire after the text box is ...
|
| vb6.0, Accee database and Bar code reader | 3/18/2008 |
Q: how can i use bar code reader scanner with database and vb6.0 programme
A: The best barcode scanners are "WEDGE" scanners which "wedge" themselves between the keyboard and ...
|
| Close form | 3/18/2008 |
Q: I am attempting to use VBA to close a form and depending on certain condition/s ( as below a ...
A: It looks fine to me. Make sure you're specifying the correct form name. You can try removing the ...
|
| compile vba | 3/16/2008 |
Q: I have written a simple program. in VBA to use with EXCEL, I want to compile it to an EXE program. ...
A: It can't be done. VBA cannot be "compiled" into a stand-alone program. You'll need Visual Basic / ...
|
| multiple table in data report | 3/16/2008 |
Q: . i am trying to build invoice application, user issue number of item, so i have created two table ...
A: Create one query with both your Orders and Order Details. Use that query to make a report that uses ...
|
| how to save what i type in my developed notepad:visual basic | 3/16/2008 |
Q: how to make notepad in visual basic (or rather in v.studio 2008!)? i have no problem with anything ...
A: This is just a matter of basic File I/O with the Open, Print, Line Input, and Close commands. There ...
|
| Hyperlink problems | 3/11/2008 |
Q: Form field (Text66) defined as Hyperlink. Access 2003 table field defined as Hyperlink. Using VBA I ...
A: It's the same format, whether the link is to a URL or a file like C:\MyFile.TXT. In either case the ...
|
| read from one database and save in another database | 3/11/2008 |
Q: how do we read records from the some table in oracle database and then display it and finally add it ...
A: Attach to both tables and then use an UPDATE QUERY or an APPEND QUERY to move/copy/add the records. ...
|
| VBA Error | 3/10/2008 |
Q: When loading a module I get the following error "VBA Initialise ComError The Docfile has been ...
A: Sounds like either one of your project files is corrupt, or it's one of VB's files. You can try ...
|
| VISUAL BASIC WITH ACCESS | 3/7/2008 |
Q: Good Day Sir!! I'm developing a program which saves a record into a database. My program have the ...
A: The best way to go about this is to use a RECORDSET to add the data to your table. I hope this ...
|
| Hyperlink problems | 3/7/2008 |
Q: Form field (Text66) defined as Hyperlink. Access 2003 table field defined as Hyperlink. Using VBA I ...
A: Are you formatting the hyperlink string properly? Access like to have hyperlink strings in the ...
|
