You are here:
- Home
- Computing/Technology
- Basic
- Visual Basic
Visual Basic/Questions Answered by Expert Richard Rost
| Subject | Date Asked |
| reminder note | 6/18/2011 |
| Q: this is my question- i am making a simple patient medicine reminder dbase program in ms access. I ... A: Yes, of course. Just about anything is POSSIBLE with Access. Exactly WHAT you can do is only limited ... | |
| Stop concatenating numbers | 5/26/2011 |
| Q: Richard, I have a form which derives its recordsource based on a specific button (different age ... A: Convert your TEXT values to LONG INTEGER values: MyBox = CLng(Txt1)+CLng(Txt2) Let me know if you ... | |
| Date Arithmetic | 2/17/2011 |
| Q: With the InputBox command, I am entering a date in the following format: mm/dd/yy. My second step ... A: Just remember that an InputBox returns a TEXT value, so you might want to convert the result that's ... | |
| Access 2007 - vba | 2/4/2011 |
| Q: I have an unbound mainform where i am getting 1 start date and 1 end date and a bound subform where ... A: You could do this with a series of DLOOKUP statements. Let's say you have a table that has all of a ... | |
| Command Button 1 plus Command Button 2 triggers this event. | 11/12/2010 |
| Q: In Visual Basic I need help making a code that that triggers an event by clicking command buttons in ... A: How about check boxes for each of your command buttons. In the event for command1 set the checkbox ... | |
| Listbox looping question | 11/1/2010 |
| Q: i just wanted to know how to recognize if a listbox has no item item or if a listbox has been ... A: You can use the ListCount property of the listbox to determine how many items are in it. I cover ... | |
| Hmm | 10/27/2010 |
| Q: Kai so, I know this may sound a little silly, but I cannot add numbers no matter what I do. The ... A: You want to add the VALUE of the text in the box, not the text itself. =VAL(box1)+VAL(box2) I ... | |
| controlling another program using api | 6/29/2010 |
| Q: im trying to code a poker odds calculator,the basics of this i can handle but im wanting to add an ... A: Good luck. I built something like this YEARS ago to run with my favorite poker site's program, and I ... | |
| RE: Visual Basic - adding numbers | 6/18/2010 |
| Q: You answered the question below some time ago and I need a similar response, however it doesn't ... A: Well, just change the code a little bit: If X < 0.6 or X > 0.6 then X = X + 0.1 Else X = 1 End ... | |
| VBA variables in SQL | 6/10/2010 |
| Q: I am burning my brain up trying to do something I thought would be so simple that I must be the ... A: Try: DoCmd.RunSQL "INSERT INTO TestingActivities (TestingActivityDescription) VALUES (" & ... | |
| Visual Basic KeyPress for Space | 4/27/2010 |
| Q: I've searched all around for the answer to this. I want a sub-procedure to run after I press the ... A: Look for a property on that button that's being pressed called DEFAULT. Set that to NO. The default ... | |
| VBA- refering to the first 3 characters of a cell | 3/11/2010 |
| Q: I would like to define a variable that refers to the first 3 characters of a specific cell. Example: ... A: If you want to look at a cell that contains "January" and want to return the first three characters ... | |
| MS Access 2000 -“No value given for one or more required parameters “ Error | 3/4/2010 |
| Q: This is a followup to the question I submitted yesterday. If I use an actual value or assign the ... A: The SQL interpreter cannot resolve the field name from your form. That's why this works: "WHERE ... | |
| Permutations in VB | 12/25/2009 |
| Q: Whats the best way to make a program reconginse your input of 7 characters and then generate all ... A: You could probably do this with a couple of loops to iterate through all of the characters one by ... | |
| Help With Tab Delimited File | 12/24/2009 |
| Q: I am importing a tab delimited text file, and have a few problems.The software I'm writing in is ... A: Why not just open the file for reading, open a temp file for writing, loop from 1 to 50, read in a ... | |
| 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 ... | |
Visual Basic
Answers by Expert:
Richard Rost
Top Expert on this page
Expertise
I can answer any questions pertaining to Microsoft Visual Basic 6.0, Microsoft Access VBA, and the Visual Basic Language in general. I do NOT use VB.NET or VB 2005/08 much yet, so don't ask me any questions specific to those. Also, please feel free to check the Tips & Tricks section of my web site for VB tips.
Experience
I am the president of VBLearningZone.com and 599CD.com. I specialize in Microsoft Access and Visual Basic Tutorials. I have been teaching in the classroom since 1994, and online since 2002.
Education/Credentials
I am a self-taught VB expert. I have been building software for clients since the early 90s (and on my own since I was a child). You can see a sample of my Tutorials on my web site at 599CD.com
©2012 About.com, a part of The New York Times Company. All rights reserved.