12,425 Topics

Member Avatar for
Member Avatar for Engineer.Saleh

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

Member Avatar for Jupiter 2
0
1K
Member Avatar for degater1

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 …

Member Avatar for vb5prgrmr
0
138
Member Avatar for firoz.raj

i simple was to add information in a listview using save button. but when click save it hangs.kindly help me .any help would be Greately appreciated. here is the code what i have written. [code=vb] Private Sub btSave_Click() Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset ' On …

Member Avatar for vb5prgrmr
0
96
Member Avatar for sunderthomas

[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 >= …

Member Avatar for sunderthomas
0
131
Member Avatar for usbport

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 …

Member Avatar for vb5prgrmr
0
84
Member Avatar for PinoyDev

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 …

Member Avatar for PinoyDev
0
77
Member Avatar for PinoyDev

Good day.! I just need a code that will trigger the listview to put some color like(red) in a row/cell being selected. Pls help.. Thank you for spending time.

Member Avatar for PinoyDev
0
71
Member Avatar for success_always

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’ …

Member Avatar for vb5prgrmr
0
97
Member Avatar for maydhyam

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 …

Member Avatar for maydhyam
0
352
Member Avatar for shahji

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, …

0
74
Member Avatar for kehar

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 …

Member Avatar for QVeen72
0
146
Member Avatar for BillWebber

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, …

0
83
Member Avatar for anishmbait

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 …

0
34
Member Avatar for ramesh_natesan

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 …

Member Avatar for raman242001
0
355
Member Avatar for arkhadi

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

Member Avatar for vb5prgrmr
0
65
Member Avatar for lazlo2000

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 …

Member Avatar for vb5prgrmr
0
91
Member Avatar for snyp

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 …

Member Avatar for Ancient Dragon
0
283
Member Avatar for forum_theone

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 …

0
45
Member Avatar for LindseyV

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") …

-2
53
Member Avatar for Loony064

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 …

Member Avatar for Loony064
0
118
Member Avatar for Andiswa

Hi all, I'm developing an online booking system. I'm freaking-out becasue this is my school assignment project which I'll be evaluated on but i'm pretty new in IT . I'm really struggling. I'm going to use MS Access as my db and Visual Basic.Net to develop the user interface. What …

Member Avatar for msnmnk
0
102
Member Avatar for asadalim1

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 …

0
68
Member Avatar for KuriYokan

Hi guys. I'm pretty new here. I was recently playing around with templates and found them to be really useful. I was wondering how I could check the data type of the variable that was passed into the function, and I heard about RTTI from my friends. I've looked around …

Member Avatar for KuriYokan
0
139
Member Avatar for khanayub_chand

I am using vb6 and Oracle as Frontend and backend.Data Report is being used for reporting,but the problem is even after closing the report, the Session for that report still exists. I needed a way wherein, I can dispose the Session when the report's unload event is fired.

0
44
Member Avatar for saurabh.abhyank
Member Avatar for Mordecai17

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) …

Member Avatar for vb5prgrmr
0
171
Member Avatar for JohnKelly

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 …

Member Avatar for 1RealTruth
0
805
Member Avatar for azjherben
Member Avatar for Lerner
0
89
Member Avatar for shibu.web

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

Member Avatar for vb5prgrmr
0
124
Member Avatar for BillWebber

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 …

Member Avatar for BillWebber
0
154
Member Avatar for PinoyDev

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 …

0
46
Member Avatar for linux
Member Avatar for swisschris104

Umm... Im New To c++, But Not New To Programming Lemme Tell you All About Me Before Yu All Pile On Me! Im Only 14! I Can Program basic Online Codez :CSS and HTML. I Can Also Program Visual Basic ( 3/4 of it) My Question About C++ is Can …

Member Avatar for Narue
0
134
Member Avatar for sal21

In a asp page have a combobox with 3 item(see html) I want to loop in all items of combobox... similar: i use this to connect oie: Set OIE = CreateObject("InternetExplorer.Application") URL = "http://mysite/GP.asp" OIE.Visible = True OIE.navigate (URL) Do While OIE.readyState <> 4 Or OIE.Busy DoEvents Loop select element …

0
90
Member Avatar for asadalim1

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 …

0
82
Member Avatar for s_sridhar

I'm not quite familiar with Visual C++. I was trying to create a basic win32 program. I compiled it but i don't know how to run the output file. If i select start without debugging, it asks me to choose the executable file. But i don't know what to do …

Member Avatar for s_sridhar
0
116
Member Avatar for vb_programmer

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 …

Member Avatar for zwr
0
256
Member Avatar for Cliffs0fdover

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, …

Member Avatar for toko
0
142
Member Avatar for killdude69

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. …

Member Avatar for vb5prgrmr
0
179
Member Avatar for bitki_1407

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 …

Member Avatar for lordofhell
0
4K
Member Avatar for wk123

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 = …

Member Avatar for wk123
0
144
Member Avatar for gingank

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 …

0
57
Member Avatar for gingank

[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 …

0
64
Member Avatar for Bikram Singh

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. …

Member Avatar for Bikram Singh
0
101
Member Avatar for Jouni79

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 ?

Member Avatar for QVeen72
0
91
Member Avatar for nokomoli

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 …

Member Avatar for vb5prgrmr
0
152
Member Avatar for agrothe

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?

Member Avatar for agrothe
0
118
Member Avatar for devpta

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 …

0
81
Member Avatar for smjabbar

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

Member Avatar for kvprajapati
0
76
Member Avatar for limesight18
Member Avatar for vb5prgrmr
0
62

The End.