10,987 Topics
 | |
| | 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’ … |
| | 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 … |
| | 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 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 … |
| | 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 … |
| | 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 … |
| | |
 | 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 … |
| | 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 … |
| | 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 ? |
The End.