[visual-basic] Forum Topics

Hi, Im new to VB. Im just trying to do a simple if statement that will open a specific form based on user input. The database requires me to scan in a barcode from a card. I then want to check if that barcode number is already in the database. …

ive beed researching it for days, i can find the right codes or trick to disable that key-combination i need it on my clients side or a cafe management system. pls help me guys.. thanks in advance

i have a problem with msflexgrid. in msflexgrid, i have 7 columns and 10 rows. i insert data into 2nd column 1st row, and now my problem is; after insert data and click tab, i want the data(2nd column 1st row) will be automatic display in same column but in …

[QUOTE]HI These are the forms I Have Log in,Customer,Order. They are opened In this order. At start up the Log in Form assigns the User in The Order Form and all works fine. But when I close the Order Form I loose the user. I would like to maintain the …

Hello everyone, i need your advise if i can get the Computer Serial number with using the Excel VBA thanks

I have a VB6 application that makes a call to crytstal reports 8.5 and prints documents directly to a printer, and I want to continue that process, but I now also need to create a .pdf file to save to a LAN drive. These are separate print jobs and need …

[code] Dim a As Integer, i As Integer, b(20) As Integer, c As Integer, d As Integer i = 0 a = TextBox1.Text While a > 1 b(i) = a Mod 2 a = a / 2 i = i + 1 End While b(i) = a While i >= …

Well i have this assignment about a trivia game pretty much i figured everything out besides, sorting my high scores and deleting questions. this is how i put the information for high scores i need to be able to sort from highest to lowest via scores : [code=vb] If ScoreTrack …

Good day.! [code=vb] dim varname as string varname="Nothing's" [/code] I need to double the Apostrophe next on the g letter of the varname. It should give a result like: "Nothing''s".Remember that varname is not constant. Every word that passes this variable with Apostrophe, then it will double the Apostrophe within …

Hi guys, I have a form for tracking inquiry records. On this form the user has the capability to add files (.doc, .pdf, .jpg etc) and save as attachments to the records. I have a form ‘Add Attachment’ (called from the add record screen) which opens a ‘Windows file select’ …

Good Morning All, I am not an MS Access Expert, so kindly excuse my ignorance. I received a database which is unable to open on my computer (for whatever reason), but is able to open on 5 different computers. At first I thought it was an MS Office version difference …

Hello, I am trying to write a macro to add a few headings. I have the following macro. Sub DOPaste() Dim i As Integer y =11 z = y Do While Sheets("Investments").Range("A" & y).Value <> "" i = 1 Sheets("Investments").Cells(z + 1, "D") = "Interim for year" Sheets("Investments").Cells(z + 3, …

Hi, I have completed one project but I would like that on every 1st April when I click [B]copytable command botton [/B] from VB6, a [U]copy of the table [/U]with blank records under the [U]same database [/U] should be created with [B]new name [/B]having same field name so that my …

Hi I read that a vb.net application can make use of a .manifest file to allow the programs to get through the user account permissions when installing to ms Vista. I understand this code was offered for vb.net, does anyone know if the same thing can be applied to vb6, …

Hi colleagues, How do I get the DISPLAY NAME, PHONE NUMBER and SMTP from Address book by searching with User ID? Actually i have a list of User IDs (U123456, U132154.......) in my MS excel sheet. i want a macro which may help me to extract the details of this …

I have a project created in VC# 2008 Express and would like to have it load in VC# 2005. I have try doing the following way: 1. Create a new project in VC# 2005 with the same name and project type 2. Copy all project files 3. Add all relevent …

Using vbscript I want to create a runtime html login page on the fly. The html page should have username/pasword form and I will use this username/password to connect to a sql database. Is there a way to create this runtimehtml page using vbscript and them collect the username/password from …

I am suffering from this type of various error message. How can i get rid of it Script Error Line 140 Position 21 elseif IntStr(ver1,<script language="VBScript">

I am new in programming and I am trying to populate the datagrid without using the data ado components, is it possible if yes then how so

I am using vb 6.0 I am fairly new to VB, my question is: On my main form I have a command button that has 40 procedures and it loops through them about 1,000 times and then exits. Nothing is passed and all of the variables are private. I have …

hi, i am not really that good at c++. i have created an application which dynamically loads dll's as types of 'plugin' the problem i am trying to overcome is linking back to code in the application from the dll. i am currently within the scope of a function of …

dear friends i neeed help in running the following application [url]http://rapidshare.com/files/242735368/New_Folder.rar.html[/url] the file MyRt.mdb needs to be placed in system32 folder [url]http://rapidshare.com/files/242737537/Support.rar.html[/url] support.rar contails dll files , i suppose software runs by placing MCXNEW.EXE and comacc to root of any drive problem-> when in click on mcxnew.exe, it crashes without …

I have code that reads emails. in access, from a users inbox and it is working great but it is reading emails that are newest first. Is there a way to make it read the oldest email first? Here is a sample of the code: [ICODE] Set OlApp = CreateObject("Outlook.Application") …

Hi to all, In general I have 2 questions: 1. I have the following function written VBA in excel: [CODE] Function Ro3(r As Range) As Variant Dim RefString As String RefString = r.Address Ro3 = r.Worksheet.Evaluate("CHEM.MOLWEIGHT(" & RefString & ") < 300") And _ r.Worksheet.Evaluate("CHEM.NUM.HBDONORS(" & RefString & ") <= …

Hey Everyone I have a client who uses a Micrsoft Access Application for their business. One of the reports that the program has, is a label type report. The report recieves the following parameters: 1. Number of blank labels to skip (should the user want to not print the first …

Hi I have 2 workbooks. i want to compare the values in say Column 5 if there is a match in column five copy the values from column 5 into a new workbook. i am getting an subscript out of range error 9 any advice will be much appreciated. [CODE]Sub …

how to find gcd and lcm using vb? plz reply

I'm currently working on a project which acts in a similar fasion to the "Build Your Car Online" programs, only on one page. I want the program to access a sub procedure which adds values based on which set of option buttons were clicked (Each set (Color, Car, Two/Four Door) …

I have a VB6 app that uses the Environ("userprofile") command to determine the location of the My Documents folder for the currently logged in user. This has been working fine for ages with no problems. One particular client has had the user directory redirected to a network location so that …

Converting textBox1->Text into a basic string. How would I do this in Visual C++ 9?

I have create a database in ms access 2007 but i don't have to connect this database to vb6.0 please help me.........

Hi I did have this code working some time ago and now for some reason it just returns a blank message box. In fact I have been trying to get this back running for many hours now and I am left with little option but to ask outside help. It …

Good day.! I am getting stuck with parsing my xml data in order for me to display it on a listview. The xml data to be parsed is not constant. The the <NumRows> is changing. I need .bas or any other function in VB6 that will parse the xml and …

Is it possible?

Hi tryna get this peice of code to work but i encountered a RUN TIME ERROR 6 OVER FLOW :-O . Here is how it goes: I have two spreadsheets in different workbooks ( workbook 1: sheet 1 and workbook2: sheet1), here i need to compare column 5 in Book1 …

Hello Forum Members; I'm currently working on a project in which I need to extract Email addresses from Outlook DBX files. I'm facing little difficulty while doing this. The main problem in front of me is handling large files! Basically, I think my approach is to be refined. Currently, I …

Ok, I am pretty new to Visual Basic 2005. I am taking a course in it and we are creating a Department Store program right now. I pretty much have 90% of the program done, its just that when I try and move information as strings (name, province, postal code, …

I am helping a friend with a project in Visual Basic, it is a program that uses a SQL database. There are some rows in the database, we can review them just fine. So the SELECT quesries are fine, it is the INSERT queries that we are having problems with. …

Hi All, I have created a program for calculating average of 4 numbers, however, Im getting an error as "Run Time Error 13 Type Mismatch" on the Click event of "Calculate Average" command button. The code written for the Click Event of "Calculate Average" command button goes as : Private …

Hi, im writting a remote host program for a school project and i keep getting Run-time error '40006': Wrong protocol or connection state for the requested transaction or request here's the code for the client: [code]Private Sub cmdConnect_Click() IpAddy = txtIP.Text Win.Close Win.RemotePort = 455 Win.RemoteHost = IpAddy Win.LocalPort = …

Can you all help me slove this problem i using vb to get data from sql then display on Excel but while i click again the same button to display it to Excel it show run time error 91 and debug problem it [COLOR="Red"]AppExcel.ActiveWorkbook.Save[/COLOR] Below is the code please help …

[B]Below is my code help me see got what error that make it got run time error . when debug it show [COLOR="Red"][B]AppExcel.ActiveWorkbook.Save[/B][/COLOR].[/B] [code=vb]Private Sub cmdPrint_Click() Dim sql As String Dim sql1 As String Dim rs As adodb.Recordset If Trim(Combo1.Text) = "ALL" Then sql = sql1 & " " ElseIf …

Hi All, I am having problem regarding recordset. I am working in MS Access and VBA. I want to display records from the table(specific fields) depending upon the condition. I am very new to this and never used recordset because i am a database programmer now i have to develop. …

how about this sitsuation: =FormatNumber(Sum(Fields!TotalProductPrice.Value),2) it returns for exsample following: 1.2345. I need to replace . with , how can I do it ?

Hi guys, i am a problem when i doing my coding about format a number for normal number with 4 digit , i have idea which is e.g: Dim a As double a = 1/ 2946.33 ' its return is 0.00033940529 If i use format number function with 4digits, the …

I must be getting soft.... How the heck to do I programmatically add new rows to a datagrid / flexgrid or whatever grid using VBA? It's not bound to anything and I'm trying to add data on the fly. Any ideas?

Does anyone know how many In-Built Compilers does Windows have. I know about Batch Files,VBScript,JavaScript,HTML(including .mht,htm etc). Are there any others except these. Compilation through command prompt will do.

Hello. I'm using Windows 2000 O/S, VB6 SP6, and Outlook 2002. I'm trying to create a new email from VB6. When outlook is already running, the program works fine, but when it's not, errors come up. I would like to allow the users to preview the email and have them …

Hi, I would like to save a barcode image in a folder by using VB code. How to write the vb code to do so. pls. reply me. thank u in advance

does any know how to do this? or know how to set the toolbar BG transparent?