| Subject | Date Asked |
|
| Key Sending Using VB6 | 11/11/2009 |
Q: im new to the programming world, but i am looking for a way to make the computer think its receiving ...
A: You can use the SendKeys command for this. For the pause you'll need to use the Win API function ...
|
| Sendkeys & Different Focused Windows | 9/15/2009 |
Q: Hey Richard, So far I have a code to auto run a macro on start-up that will open the Clip Art ...
A: You need code to switch to another open program application. I have done this before, and I know ...
|
| VB6 Programme Install File | 9/9/2009 |
Q: We currently have a VB6 set-up programme that will auto-run Install from the CD. It currently uses a ...
A: Use the PACKAGE AND DEPLOYMENT WIZARD that comes with Visual Studio 6. Let me know if you have any ...
|
| output to word doc | 9/3/2009 |
Q: I have asked a questions before, and you need to know the access version. the access I use is 2003. ...
A: In a nutshell, set up the report that you want to export to Word. Use minimal formatting because ...
|
| output to word doc | 9/1/2009 |
Q: I have asked a questions before, and you need to know the access version. the access I use is 2003. ...
A: Before I go into too much detail, what is the REASON why you want to output the report as a Word ...
|
| Calendar in Excel | 8/24/2009 |
Q: First off, I want to thank you for any information you can provide. As I have little to no clue how ...
A: This tutorial isn't exactly what you want, but it does cover changing cell colors and should get you ...
|
| Changing criteria by combobox. | 8/18/2009 |
Q: You ask for brevity. I have asked for help with my problem many times briefly with no answer. I ...
A: Peter, I only ask for brevity because some people type in their entire life story before getting to ...
|
| World time clock | 7/27/2009 |
Q: I want to make a world time clock and have a selection of about 4 locations and destinations from a ...
A: Well, if your time clock doesn't need to be EXACT (to the second) then you could just insert a ...
|
| adjusting a listbox within Visual basic | 7/26/2009 |
Q: I'm currently taking this class on VB and am having problems changing the appearance of my list box. ...
A: I don't understand. Where is your output going? Are you adding this all to a textbox? If so, how? ...
|
| mysqk and dsn from client to other | 7/14/2009 |
Q: Is possible to connect other pc with the same code on the dsn on original pc where reside the dsn? ...
A: You won't be able to use a DSN named on the server from a remote workstation. See: ...
|
| Path vs. File | 7/11/2009 |
Q: VISUAL BASIC 6Considering a FOLDER could be named "Bluecow.jpg", how would I find out if ...
A: You would just say: X = Dir("C:\Bluecow.jpg",vbDirectory) If X = "" then DirectoryFound = FALSE ...
|
| MS Excel VBA, Mailing Address Question | 7/10/2009 |
Q: I have a set of mailing labels that were created in WordPerfect. I have taken these and created a ...
A: Yes, Ross, you could certainly do this, but it's probably going to involve some serious programming. ...
|
| VB6 Combo Box | 7/9/2009 |
Q: I am a beginner in VB6. i have a combo box with several items in the list. i have used screens ...
A: Database programs like Microsoft Access have this behavior, but VB6 combo boxes do NOT. You'd have ...
|
| String handling | 7/8/2009 |
Q: I have a question regarding some string handling. My basic problem: I have to calculate the exact ...
A: If you're working with Excel, why not just use the HOUR and MINUTE functions in a cell? ...
|
| Reading/Writing INI | 6/26/2009 |
Q: I know, I should look into the Microsoft Scripting Runtime library, but I'm really not very good at ...
A: Sounds like you just need to use basic FILE I/O to write/read a text file. I cover this in my VB201 ...
|
| Saving a color to a datafile | 6/15/2009 |
Q: i have a form with a color dialog. after i choose the color i want as a background, i would like to ...
A: I would just use a simple text file. Write out the information, then read it back in next time the ...
|
| Access database filtering combo box | 6/13/2009 |
Q: Microsoft Access I am in the process of creating a database. I have two tables 1. Mining 2. ...
A: Just use a WHERE clause in the SELECT statement for the combo box rowsource - OR make a query that ...
|
| Microsoft Access | 6/12/2009 |
Q: My question relates to Microsoft Access. I have created a calculated field called "BlockID" which ...
A: Just include the FORMAT function with your calculated field: BlockID = ...
|
| specific question | 6/11/2009 |
Q: i am using vb6+msaccess2003 and the control is adodc. i want to search a particular recordset from ...
A: Recordsets are basically objects you can use in VBA code to edit, add, and delete records. They give ...
|
| Programming Help | 6/5/2009 |
Q: Using Visual Basic 6.0 : Dim x as string x=">" if 2 x 3 then msgbox "2 is Greater" else msgbox "3 ...
A: You can't do that. You'd have to have different conditions for each operator type. If MyType=">" ...
|
| Capture End Sub/Function Event? | 5/26/2009 |
Q: I have (what I hope is) a generic VB/VBA question. Is it possible to listen for an End Sub/Function ...
A: Sure… if you want to do what I think you want to do, you could just use a variable or even a form ...
|
| Access VBA 2003 - dynamically Creating controls | 5/21/2009 |
Q: My Question is really quite simple... Is there a way to dynamically Create Controls (textboxes, ...
A: Yes, it is possible, but if you don't have that many controls it might be easier for you to just ...
|
| Crystal IX formula | 5/12/2009 |
Q: Greetings: I have a question regarding a formula written in Crystal XI. Will you be able to help ...
A: As it says right in my question instructions… I do not use Crystal Reports! Sorry. Let me know if ...
|
| Word macro Save As file name but as a html type at the root of H:\ drive | 5/11/2009 |
Q: I am new to VBA and was surfing the Internet until I found the website where you are displayed as an ...
A: The SaveFileName is where you specify the name of the file… you can make that whatever you want. ...
|
| How to select multiple rows from a table in VB | 4/26/2009 |
Q: I have a table called VolunteerScheduledData which has many rows. More than one row can have the ...
A: You have to LOOP through the records with a WHILE loop. While Not LRS.EOF 'get your record ...
|
| converting text file into data file | 4/23/2009 |
Q: how can i convert a text file downloaded form Internet can be converted into a access data file ...
A: There is an import wizard in Access you can use and specify the separator character. Let me know if ...
|
| VBA Code | 4/22/2009 |
Q: I am in the process of building a macro for my database. I am deleting/importing 9 tables on a daily ...
A: Instead of deleting the table, just run a DELETE QUERY in your macro. Let me know if you have any ...
|
| Access VBA Array - How to load results of a Query/Table | 4/20/2009 |
Q: Sorry for posting this incredibly simple question. After spending the last 2 hours googleing and ...
A: Greg, I wouldn't bother with an array if all you're doing is sending an email. I would just use a ...
|
| Dynamic Arrays | 4/14/2009 |
Q: I am in school, but my question is not asking you to do something for an assignment. I do my work ...
A: An ARRAY is when you have a fixed number of variables all called the same thing. Like a[12] which is ...
|
| Sql Query | 4/14/2009 |
Q: I am using VB6 & MS ACCESS I am applying following sql statement to get specific records using ...
A: First, NEVER use the Field name NAME. It's a reserved word. Your problem is PROBABLY because you ...
|
| Need assistance for VB6.0 | 4/13/2009 |
Q: First of all i compliment you on how you help the unexperienced students,hence i created Table ...
A: I do NOT use Crystal Reports. Let me know if you have any other questions or comments. Also, be ...
|
| Formatting a Cell | 4/5/2009 |
Q: i am trying to prepare a roster. I have 9 conditions according the available shifts for a member. ...
A: You're talking about cells… is this an EXCEL question or a VB question? VB doesn't use cells. It ...
|
| Search Data B/W 2 dates urgent plz help!!!! | 4/1/2009 |
Q: Sir, I am creating a project in vb6.0 using acess database i have added search option there also ...
A: You can specify criteria for running your queries, such as limiting between two dates, checking for ...
|
| file formating | 3/31/2009 |
Q: How do I save data from a listview to a text file using Fixed-with columns formatting? I already ...
A: Instead of commas, you'll have to write out SPACE characters. You'll need to set a length for each ...
|
| Query output update on VB6.0+MS-Access | 3/27/2009 |
Q: Please, I need help on the following: I run a query (table view output) and then manually change a ...
A: It sounds to me like you just need to learn how to properly create CALCULATED QUERY FIELDS. You can ...
|
| Mandatory field question | 3/25/2009 |
Q: I have a worksheet that has approx 30 fields that are to be mandatory, and about a hundred that ...
A: Then set a variable once the warning has popped up, and if it's triggered a second time, just ignore ...
|
| How to run a query made in access from VB6 | 3/18/2009 |
Q: I have made an access database and successfully connected a vb6 front end which is the forms, ...
A: Use DAO or ADO recordsets. It's too much code to go into here, but if you do a Google search, I'm ...
|
| Close VB Program | 3/17/2009 |
Q: I have a VB6 exe that needs to be closed. After the .exe program is closed it will copy the latest ...
A: Use batch files or a separate updater program. Your EXE can write a batch file which performs the ...
|
| VB Query | 3/17/2009 |
Q: Is there any tools avalable for converting Ms-access2003 .MDB project (having forms, queries. ...
A: Not really. The best you can do is purchase the Access Developer Extensions and convert your project ...
|
| Color and Pixel Detection in a Specified Area? | 3/15/2009 |
Q: The subject pretty much explains the question. I would like to know to make the program detect a ...
A: I don't have code handy for you, but I know it's possible. I've done it before. You have to ...
|
| VB 6 & Access for multiuser not multiusing | 3/13/2009 |
Q: I have been having this issue for a while now and haven't been successful at attaining an answer or ...
A: That makes sense. Without seeing all of your code, I wouldn't have guessed that. I assumed your RS ...
|
| Format Numbers in Listbox | 3/9/2009 |
Q: This is for Visual Basic 6 prof.ed. not .net What code can be used to format numbers in a listbox so ...
A: Try: Format(X,"0.000") Let me know if you have any other questions or comments. Also, be sure to ...
|
| how 2 use barcoder scanner in VB6.0 | 3/9/2009 |
Q: Sir, How can I access a barcode scanner in my visual basic application. The application should be ...
A: Get a barcode scanner that sends the data to your PC like any normal keyboard does. They're ...
|
| VB 6.0 If statements | 3/8/2009 |
Q: Quick question I was wondering if there was a way to put If conditions into a loop in such a way ...
A: VB6 lacks a "CONTINUE" statement which would take care of this (they added it in VB.NET). In the ...
|
| VB 6 & Access for multiuser not multiusing | 3/7/2009 |
Q: I have been having this issue for a while now and haven't been successful at attaining an answer or ...
A: It sounds like you have everything set up OK. Without looking at what you've got going on there, it ...
|
| mscomm1 | 3/5/2009 |
Q: This code: With MSComm1 .CommPort = 1 .Settings = "9600,n,8,1" ...
A: You might just be sending the data too fast to the COM port. Try inserting a delay between each line ...
|
| generate report | 3/5/2009 |
Q: I want to generate a report from the database in Access by writing some VBA code. I will have a Form ...
A: Use Docmd.OpenReport and specify a WhereCondition for whatever ID you wish to view. Let me know if ...
|
| search in a combo box | 2/27/2009 |
Q: i would like to know if i am able to search a combo box that is populated by a database. i would ...
A: Combo boxes do have an AutoExpand property which will bring you to the data that matches what you ...
|
| Retrieving Information from a word file | 2/24/2009 |
Q: i am trying to write a program that helps people learn how to type quickly, and i have sentences ...
A: Save your Word document as standard TEXT (.TXT file). Then you can use standard VB file I/O (open, ...
|
| Automated E-mail | 2/23/2009 |
Q: I am using Visual Basic 6.3 in Excel according to the help menu. I am trying to automatically ...
A: Yes, it is possible. You might be able to find some source code with a Google search, but it's too ...
|
| how to call a function in runtime in VB 6.0 ? | 2/20/2009 |
Q: i have some procedure like sub a_on msgbox"A" end sub Sub b_on msgbox"B" End sub dim str as ...
A: You would have to use an IF/Then statement and just check the value of str. Call the appropriate ...
|
| Maximise | 2/19/2009 |
Q: I was just wondering if you can help. I am starting out in coding and was wondering how to get a ...
A: The Shell command has a couple of parameters - one I believe is vbMaximized. Check the VB help ...
|
| VB6 help | 2/12/2009 |
Q: im trying make a program to Launch Programs with Listbox And one Command button and i dont know the ...
A: You can use the SHELL and SHELLEX functions to run external programs in VB. Shell "Notepad.EXE" ...
|
| file copy callback..i need help... | 2/10/2009 |
Q: ..good day...i am a college IT student with beginners knowledge in visual basic 6.0... i just want ...
A: I don't understand what you're asking. If you just want to know how to copy a file, use the FileCopy ...
|
| VB Read the contents of a web page | 1/24/2009 |
Q: I am Returning back to VB programming after being away from it for 14 years. I would like to know ...
A: The easiest way is to use the Microsoft Web Browser control. It has methods to launch a URL, and ...
|
| Images file | 1/21/2009 |
Q: Windows XP, VB5, Access. I need to scan a lot of documents and would like to know the best way to ...
A: If you're scanning THAT many documents and need OCR and search capabilities, I would recommend you ...
|
| Deploying Vb 6.0 Files with Ms Access | 1/15/2009 |
Q: I developed a Program to store Library information,i used Vb 6.0 with ms Access.I deployed it using ...
A: If the database is in the same folder as your program, and you don't have any physical paths ...
|
| VB program startup | 1/14/2009 |
Q: I am creating VB application in VB6 for managing Internet cafe's activities. It will have a client ...
A: You just want to learn how to make these two applications talk to each other? There are a couple of ...
|
| how can i convert automatically figure value in words | 1/13/2009 |
Q: I want convert a numeric value of a text box into words means 5500 to five thousand five hunderd ...
A: There are no built-in functions for this in VB. You would have to either develop this code yourself ...
|
| .txt file listing drive letters | 12/31/2008 |
Q: Is it possible to use vbs to create a .txt file listing the drive letters on a computer (no mapped ...
A: Yes, you need to enumerate the Drives collection and then just use standard File I/O to write your ...
|
| VB6 Classes | 12/19/2008 |
Q: I am new to class programming and have the following question. I am making a project application to ...
A: Yes, you can use an array: Project.Task(X) Let me know if you have any other questions or ...
|
| question on threading concept | 12/17/2008 |
Q: I am generating keys in hexadecimal using different random function and storing it in a text ...
A: Put a DoEvents command somewhere in your loop/sub this will free up the system. Then, add an ABORT ...
|
| VBA/Access | 12/14/2008 |
Q: I have a table in Access that consists of 7 numeric values. There is never more than 6 total records ...
A: You could use a recordset and a couple of For/Next loops. Recordsets are basically objects you can ...
|
| Standard EXE doesn't work outside VB6 | 12/13/2008 |
Q: Richard Ross I'm a VB newbie, created an interface using VB6 to an MS access database , Standard ...
A: You need to use the PACKAGE AND DEPLOYMENT WIZARD to create a SETUP file. Let me know if you have ...
|
| Access folder using network path | 12/12/2008 |
Q: I just want to access a folder which is in another computer using network path so that i will be ...
A: You need to set up a network share for that folder and allow full access for your user account. Let ...
|
| Search for a specific file extension | 12/10/2008 |
Q: Richard, I'm new to this so I hope I can explain this, well enough not to confuse you. My question, ...
A: You can use the Common Dialog Box ActiveX Control to be able to browse your drive for files. As far ...
|
| buttons in vb 6.0 | 12/4/2008 |
Q: I have a button in a form and what I want is change the backcolor when I click on it AND IF I CLICK ...
A: Set a variable X with the previous color. When you click a second time, revert back to X. Let me ...
|
| VB6 AND MS ACCESS | 12/3/2008 |
Q: I'm developing a library management system. i want the system date to be displayed in a textbox.how ...
A: Use the =DATE() Function. Let me know if you have any other questions or comments. Also, be sure ...
|
| Edit text inside cell | 12/2/2008 |
Q: I have a copy/paste script which extracts text and pastes it into excel. The script pastes both ...
A: Sure. Use the INSTR function to locate the position of the $ and then cut everything off to the ...
|
| HTML to VB | 11/15/2008 |
Q: i need to get name, number an email add from HTML files and place in in an excel file. what commands ...
A: You will need to know VB File Input/Output as well as Text String Manipulation. I cover these ...
|
| radio button to a test file issues | 11/14/2008 |
Q: Problem code followed by my question... Private Sub Command1_Click() Open "c:\test.dat" For Append ...
A: If Option1=TRUE then Write #1, "Coin" Or something to that effect? Let me know if you have any ...
|
| 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 ...
|
