12,425 Topics
![]() | |
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 … | |
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 … | |
[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 … | |
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. | |
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 … | |
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 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") … | |
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 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 … | |
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 … | |
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 … | |
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. | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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? | |
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? |
The End.