12,155 Topics
I have an app in VB w/ Excel that uses the Microsoft Solver feature. In order to ensure functionality of the Solver I run the line: Application.Run ("Solver.xla!Auto_Open") when starting up the program. I have now discovered that for some reason, after running this line, a listbox (that is totally …
Okay here is my code: If optName.Value = True Then Dim strSQL As String strSQL = "SELECT * FROM Usages WHERE UsageID = " & List2.Text & "" Adodc1.RecordSource = strSQL Adodc1.Refresh Refresh is causing an error in from clause?? I tried setting my adodc1 to an adcmdunknown recordsource, with …
I am having a world of problems with this can anyone please help. I don't know what I am doing wrong. Following the code is the error message I am getting. Here is the code I am using: [code]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html > <head> <meta …
Hi, Is there any way to send a SMS Message in VB6? If so, please share your information with me. Thanks
Dear All I am using the API calls to ReadFile and WriteFile to access data coming in on serial ports and sending commands out to devices on Serial ports. Everything works fine in the VB6 developer. When I compile the programme I can compile to P-Code and everything works fine. …
pls help, i need a vb6 code to compare images in a database and returning query of duplicate
i have in vb6 2 proyects in one.....now there group into one....but from proyect 1 how can i call a form from proyect 2.... Example From Proyect1 From1 a Comand Click To open or Call Proyect2 Form2 To show.... Please help if is posible.....
Hello is it there any function to know the size of a dynamic array?
Does anyone have a custom function to Remove a child node from a TreeView and move it to another child? That may not make sense, so here's an Example: [code] Private Sub Form_Load() Dim Test As Node Dim Test2 As Node Set Test = TreeView1.Nodes.Add(, , "Testing", "Testing") Test.Expanded = …
hi there i want my forms do not move is there any property that sets it at a fixed position thank u very much
Hi, I am bound to use VCF15.ocx and need to set printer programmatically. According to the help file it can be done via PrintDevMode property, but there isn't any *working* example available. Any ideas? Thanks! PrintDevMode Property Member of: F1Book, F1BookView Remarks The DEVMODE data structure contains information about the …
hi friends, i m new in vb.net, and can someone guide me to run vbscript in vb.net, with liabrary or tool we use to run VB.script in VB.net cheers birbal
Hi, I have a custom control that we delevoped, I Added a new property to the control hence breaking compatability. I re-compiled all applications with the new version of the OCX and released them to TEST. All applications passed testing and was delivered to our client. All these app's with …
hw cn i enter & save data in a form which is a subset of another form(database) that is already populated. i want that when i update this record it automatically gets saved in the mother database against the respective record
Hello everybody, I want to make an installer of my VB6 app so that it installs all the required files, create database, tables, Stored Procs in MSSQL 2000. Is there anybody who can give me some idea on this? Thanks in advance!
hi I am facing a problem in vb with crystal report the code is as under : on running it is some showing error in formula mn = Cmb_Mnth.Text yr = Val(Cmb_Yr.Text) Crpt1.Connect = "UID=sa;PWD=;DSN=WORK" Crpt1.ReportFileName = "D:\WORK\REPORT1.RPT" Crpt1.SelectionFormula = "{Emp_Bill.bl_mnth} = " & mn & " " And "{Emp_Bill.bl_yr} …
Thank u so much for sending this code,and i appreciate it so much.But i need to be able to move foward by getting thesame code that will save into the database,Others conversion i used were'nt working.Pls help me with the code that will save in to the database(SQL server) with …
i am developing a project so it involves working with picture.i have a code in vb6 that can retrieve image from the sql server,the code is this.And i need exact of such code that will be able to save into the DB,to avoid disparity in the binary conversion. Dim CN …
I've been using VB 6.0 for a long time and this is the first time that I run into this. When I make changes to a project and try to save it, VB gives a message "File [name of the project.vbp] not found". I've checked that I tried to save …
Please I've been struggling to use a [B]datagrid control to display records with check Boxes in VB 6.0 [/B] but which I could not, and has been come a headache for me. Can any kind persons/Gurus help me solve this burning problem? For God's sake. I've been going from site …
Hello, I have a question. I work in visual c++ in a document/view arhitecture (SDI application) and i draw some stuff with some opengl functions (cubes, cylinders) but when i hit the "New" menu from the File menu it doesn't erase or clear my drawing I don't know why. Can …
Hi, i'm using ms access and i have a table and a form which have the field code_url. I would like to know how can i create a form with a button that i could use to cut string in the field name code_url for example: <a href="yahoo.com?234234234sdef">Episode 1</a><br><embed src="videos/vplayer.swf …
hi guyzz, i wanted to have two connection using access and mysql in my proj. my access was my main db connection and what ever data in my access will store directly in mysql db when their is internet connection... I declared 2 fuction connection but my problem is the …
can i use animated gif instead of bitmap images on the background of my forms? or can i post animated gif on my forms? can anyone tell me how this can be done? need your response thnx in advance.
I, i am beginner in VB programming. I am developing a software using Vb as front end & database in foxpro. Can anybody help me to connect entered text in textboxes to database. How it is saved in database & retrieval. I am using DAO tool. Neeraj Pareek
pls can anybody help with how to insert a bracket into a string after the count of 3 characters in vb6
hi there, i'm working on something that requires images i have solved how to save the images in the method of uploading.. i researched on how to access a webcam and thats solved... my problem is capturing the image... on the webcam window... i would like to just capture the …
Hi everyone. I am a student at University of Eastern Africa, Baraton. I'm majoring in Mathematics and Minoring in Computer Science. I have been given a project to develop in Visual Basic and I am like, I have no idea of how to begin or how to do that question. …
Pls i want to generate two report from my database one for duplicate of record based on thumbprint the other for original thumbprint using VB6 and sql server.I need the code.I will appreciate your help. i mean i want to track duplicate of thumbprint in one table and distinct of …
i want to use Crystal reports to generate my reports. how can i connect to the server. i am using SQL server as my database with vb6
I have developped a program using vb6 used by a college to store students scores in diferent courses. My problem is that i want to create a button users can use to search for a specific record using the students admission number. I do not have much knowlegde in finding …
Hello, I'm trying to open an existing Excel file, and read in some cells. When I run the program to test, it gives me "Compile error: Variable not defined." when it gets to the line: "Set ExcelWS = " (in red). ExcelWB is defined, but not ExcelWS. I followed examples …
Hi, i am creating an application. i have menu strip which some items such as notepad, internet explorer, etc. here is the code how i startup notepad [ICODE]Private Sub Notepadmenuitem_Click()Handles menuitem2.click Shell("Notepad.exe",Windostate.normal) End Sub[/ICODE] the probem is that when i click on the item it would open it but my …
After i click on link "Area Clienti" appear the tipical autenticatin box How to insert in user box the value of my_var = user, and in password box the value of my_password=mypassword and after check "save pasword..." and click on ok button????? naturally in VB or VBA or vbs code …
Hey, just thought I'd throw a quick introduction for myself to get involved with the forums. My name is Chris Majcher, most people call me by my last name when they figure out how to pronounce it (which is simply Major). I'm a programming student, with experience in Visual Basic, …
I'm writing an app in VB with an excel worksheet. At one point I need to solve a set of equations that are not explicit, so I need a numerical solver program. Excel's Solver is supposedly designed for this purpose; however my past experience is that it is very fickle …
hi thisis my first post here, what i need to know is how to read/write files using visual basic 9 (visual studio 2008) its different in vb6 and vstudio for open (text) as (int) for output for those who have or r familiar with vstudio 2008, i took the "windows …
Hi Everyone, I have a C++ program lesson, but i can't to do it. I have a binary file with structured datas. I have to read the datas, and take into a class (structure array). Here is my code: [CODE]#include <iostream> #include <fstream> using namespace std; struct dolgozo { char …
i was working on a data grid(visual basic) but i could not edit anything from the database. can it be done.help
Hello Everybody, My Name is Emmanuel Etafo from Africa I just started programming and i have falling in love with Visual Basic 6.0... I really need all the assistance i can get..its really not easy because i do not have a teacher but i have found good books and as …
Hi All, Back again looking for some help and guidance, I have a recordset and I want to loop through this recordset until I find the field with the highest date. I am have a basic knowledge of how it should work but I have no idea what way to …
hi, how can I read all the names of files present in a folder and store it into an array???.
Hiya, I'm looking for the control that is in Internet Explorer, Tools...Options...Advanced tab. It's class name is SysTreeView32. I have looked everywhere for this control or something similar but no joy. Any help is much appreciated. Gray
Hi list, After creating a rs with UNION ALL two tables it's possible know record by record the original table source (using any extra SQL feature or something else) SQL = "SELECT * FROM tabA UNION ALL SELECT * FROM tabB ORDER BY field" Set rs = db.OpenRecordset(SQL) Thanks Fernando
hi, i have a problem with my form so i have a form with windowstate = maximized now there is a button in that form that if i click on, a new form will be opened. so the problem is that if the new form has been opened and i …
Hi I am using Visual Basic Developer 2005 I have this simple code that will delete all files created before today in the specified folders. The code works fine but I get an exception problem when the fso object deletes the files ie at fso.DeleteFile(file) inside the second For loop. …
Hello, I'm a newbie at VB and am trying to get some help with a process. My code will check an Excel file for dates and store them in a number of variables. Then I want to be able to compare those dates to the current date. I was thinking …
Can anybody give me the code to extract files from a zip file to a specified location using VB6.0
I am usually not keen for asking for help in these kind of situations but I am really stumped when it comes to this, all I really need is a good step in the right direction and I should be (hopefully) fine. I am currently writing an airplane seating program …
I am looking for a visual studio tutorial, can you suggest one? I have expirience working in visual basic and was asked by my boss to learn asp.net. So I got visual studio installed, and read a few sites about asp.net. the idea of visual studio looks very much like …
The End.