[visual-basic] Forum Topics

i want to convert a fie(document,excel,picture) to binary format using VB.Please how can i achieve this

Hi, I got a runtime error 3709. It says "The connection cannot be used to perform this operation. It is either closed or invalid in this context." I can't find what's causing the error.. Here is my code: [CODE] Public Sub S_LOAD_flxUser() Dim strSql As String Dim rsLoad As New …

Hey, I'm currently doing some work on a program i'm creating for Uni, now i'm getting the above error on the following line of code: [CODE] if ((position.X < boundary.Width - 50) && (counter == 0))[/CODE] All the variables are set to Public. The error is within an 'Alien' class …

How to run a command of MS DOS with code through visual basic 6.0 for ex. setting the path, zip and unzip files etc. and also the commands of Visual Foxpro Databasese through VB.

hello guys! Its been a long time posting here since I've switch to dot net...But I CANT LEAVE VB6 in programming.! I just want a little help.. Anybody can recode this statement regarding connecting to SQL SERVER local database.. The connection is succesful. But i want to trap the error …

hello, im using vb6 with access 2007 (.mdb) im using adodc connection. my question, how to prevent if the data existed in my database. i've put primary key in my database and i need an example like it's giving msgbox "data existed!" anyone can help me? thanks.

Placing ComboxBox in DataGrid Cell is a task usually found in Invoicing application. Here is my version of same.

...here is the scenario...in my inventory system i have database and it's fields are "Item Number,Description,Last Week Stocks,Deliveries,Total Stocks,Total Withdrawal and Current Stock...this is my logic if adding new stock it will add to 'Current Stock' and to 'Total Stocks' and if withdrawing stocks 'it will add to 'Total Withdrawal' …

Is there any code that will enable me to click on portions of the form with the use of coordinates? I know most of you find it easier to just use controlname.click but it is not possible for my application. Hope someone can help. Thanks.

Hi, I am trying to output some data from sql db within excel to XML. I am updating the sql db from the excel worksheet and then outputting the records from the db to xml. I have used CDATA to parse html within xml but i can only get one …

i made report for invoice printing which contains 10 pages for single invoice, i want to Print Terms & condition on every next page it means my report will be of 20 Page.. please help me... thanks in advance

Hi all, thanks in advance for your help. Is it possible (and if so how:sad: ) in Excel (using VBA or whatever easiest) to have 2 worksheets A and B where worksheet B is atomatically updated. A bit more complicated tho!! I enter data into A, and B takes that …

I'm a very new developer (if you could even call me that), and I'm killing myself here. Essentially here's what I'm trying to do. A user scans a series of documents which are sent through a program that places a .tif or .pdf of each document into a folder on …

Hello Guys!! NickName: RJ or you can call me starmax Age: 24 Location: CNMI Hobby: Hiking, mountaineering, playing guitar, mixing some music... well I'm just a simple person, I love to learn new things. actually I'm working as a Casino Dealer, for 2 years now, I'm having a part time …

Hi, I am trying to output some data from sql db within excel to XML. I am updating the sql db from the excel worksheet and then outputting the records from the db to xml. I have used CDATA to parse html within xml but i can only get one …

How to Combine or Merge PDF files without using DLL in VB6

Hi, I have a question in MS SQ L enter prise edition. I have writtend an application in Visual studio 2008 standard edition and I am connecting to ms sql sever enterprise edition 2008 r2. When I depoy the application I created and install inanother computer some components relating to …

Hi All, I need to create a macro that will copy the data in the last 5 columns of the spreadsheet and paste it to the next 5 columns, also I need to have a pop up that will let me add date to the heading of the new inserted …

Dear all I am developing an application in VB & Access .I am trying to secure application by adding user control,trace modules,database password. (just today i saw how to make a folder inaccesible+ not to allow delete.) 1)I would like to know how do i secure my application.. am i …

I am trying to learn vbscript and am having trouble with one of me first scripts, can someone look and see what I am doing wrong? I get the following error: Line 13, Path not Found. 'if folder B does not exist it is created option explicit const OverWriteFiles = …

Hi All, I want to ask how to remove unwanted character from string?? Can provide an example? Dim A As String A = "@AA@BB@CC@DD" If i want to remove @BB what method i should use? First i try to use instr to detect where the @BB but how to do …

Hi, Does anyone know of some code analysis tools (add-ins) for VB6? I used to use checkstyle and some other tools for Java, and am looking for something similar for our VB6 project. There is a huge codebase, and as I'm just starting out in VB coding, I'd like advice …

I'm using 2005 visual studio. I have made a windows application, using visual basic language along with crystal reports. My crystal reports function well whenever i run it within the unpublish project but the time I published the project the crystal reports always fail. Because it can't find the RPT …

[CODE]Form3.Adodc1.RecordSource = "select * from login where username = '" + Text1.Text + "'" Form3.Adodc1.Refresh If Form3.Adodc1.Recordset.EOF = False Then If (Text2.Text = Form3.Adodc1.Recordset.Fields("password")) Then MsgBox "login success" Unload Me Else MsgBox "invalid pasword" Text1.Text = "" Text2.Text = "" Text1.SetFocus Form2.Refresh End If Else MsgBox "invalid username" Text1.Text = …

[code]Form3.Adodc1.RecordSource = "select * from login where username = '" + Text1.Text + "'" Form3.Adodc1.Refresh If Form3.Adodc1.Recordset.EOF = False Then If (Text2.Text = Form3.Adodc1.Recordset.Fields("password")) Then MsgBox "login success" Unload Me Else MsgBox "invalid pasword" Text1.Text = "" Text2.Text = "" Text1.SetFocus Form2.Refresh End If Else MsgBox "invalid username" Text1.Text = …

I want to simulate the enter key when my form opens so that it can continue it processes without the user having to push the enter key or selecting OK with the mouse. I know the question is then why have the form at all. I did not write the …

[CODE]Dim Hours As Integer Dim Minutes As Integer Dim Seconds As Integer Dim Time As Date Private Sub Mydisplay() 'This code is common to all three text boxes so I 'put it in it's own sub. 'Extract the numbers from the text boxes by using 'the Val() statement. Hours = …

[CODE]Option Explicit Dim temp As Integer Private Sub Form_Load() Text1.Enabled = False Text1.MaxLength = 10 End Sub Private Sub Command1_Click() Text1.Text = Text1.Text + "1" End Sub Private Sub Command2_Click() Text1.Text = Text1.Text + "2" End Sub Private Sub Command3_Click() Text1.Text = Text1.Text + "3" End Sub Private Sub Command4_Click() …

How can i generate next increment number for alphanumeric serial . i.e first cheractor is alphabet and next four cherectors are numeric. ( N1125 )

Hi, I need to use LPT as SPI with CS DO CLK But how to setup LPT pins for SPI can I use D0 D1 D2 on lpt port for this ? is this correct ? lpt pin 2 CLK Lpt pin 3 CS Lpt pin 4 DI [CODE]Const Po378 …

Ok, here's another problem which i really need help. One suggestion from our panel suggested if we can have a module which do not allow deleting a record (one or more) in the database which are Administrator type. Those records cannot be deleted whether through 1. the program itself (via …

Hi. . . i got this code in visual c3 and i want to code it in visual basic. . .somebody help me please in doing it. . . [code] byte* p = (byte*)(void*)Scan0; int nOffset = stride - b.Width * 3; for (int y = 0; y < b.Height; …

i am trying to find a code that will do a search and find the ip address of any printer on the network with a ip address? Please help thank you

i have a a form that has: textbox1 = registration name textbox2 = network folder path textbox3 = local user name textbox4 = password i need a button that will send all of this information to a webpage with a single click of a button. The section where this information …

How can i trigger Leave Cell event for Msflexgrid through command button click or textbox lost focus.

my problem is so simple guys, how do i make [B]3 textboxes[/B] connect to a database of users using [B]adodc in a different form?[/B] [B]so that if you entered your userid, username and password you could log in.[/B] i cant post my code now but ill try later on.

I completed a form for my supervisor using VB via Microsoft Word. It worked beautifully on my end...I could fill it out, save it, etc. I password-protected the document and only allowed people access to fill-in the form, which consists of drop-down menurs and text boxes. However, when another user …

Hi:) How can I scroll the report in runtime by mousewheel. I am using VB6 (SP6) and for reports I am using VB report control.

I have an IP camera that feeds video over lan or the internet thru a browser. It has its own interface on either Mozilla, IE or other browsers. I tried calling the site using the Microsoft Internet Controls component and it works fine. The GUI is called upon and I …

*THIS IS THE CODE WHERE I CLICK A BUTTON TO SIGN UP FOR AN ACCOUNT* Set db = New ADODB.Connection db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\useraccount.mdb" Set rs = New ADODB.Recordset rs.Open "Select*from useraccounts", db, adOpenStatic, adLockOptimistic rs.AddNew rs!Lastname = Text1.Text rs!Firstname = Text2.Text rs!Contact = Text3.Text rs!UserName …

I am new to Visual Basic I'm a student and im working on a payroll calculator program I got it to where it will display user input now i have to get it to calculate pay based on which radio button is selected im doing this one at a time …

I am trying to create a windows form using visual c++. I type the variable value in the text box in windows and read it in by clicking a button. The variable is now stored in the form1.h header file. I want to use that variable in the my_proj.cpp code, …

I would like to copy and paste special values in excel using VB6 during report generation. But pastespecial is not working. Its throwing error 1004 Paste Special method worksheet failed. Below is the code. can you please advise [CODE]xlTmp.ActiveSheet.Range("H7:H23").Select xlTmp.Selection.Copy xlTmp.Sheets("Consolidation").Activate xlTmp.ActiveSheet.Cells(6, 4).Value = P(N) xlTmp.ActiveSheet.Cells(8, PS).Select xlTmp.ActiveSheet.PasteSpecial xlPasteValues, xlNone, …

Hi, I just want to ask a simple question.. hopefully. I use package and deployment wizard to create my software's installer. My software can be run by using a lot of pictures and document that because it contains millions of pictureboxes. Those pictures must be located in the same folder …

I need the syntax of queries in visual basic 6 to edit the database in ms access.please help me.The name of database is patient details and it has fields as name,id,height,weight,bmi,email,phone etc. if the id is already matching i need to update the details and if its not matching i …

Regarding my earlier post. [URL="http://www.daniweb.com/forums/thread327097.html"]http://www.daniweb.com/forums/thread327097.html[/URL] I encounter an error saying [ICODE] Run-time error '462': The remote server machine does not exist or is unavailable [/ICODE] Haven't notice this error earlier. Code: [CODE] wrdApp.Documents.Open App.Path & "\Reports\Locatorslip.docx" wrdApp.WindowState = wdWindowStateMaximize wrdApp.Visible = True [/CODE] The code works fine. Error only appears …

This is the code I have to validate control number that we use to keep track of our inventory. However, I dont know much about Access so I have written and tested this function in VB.Net on Visual Studio. Now, I need to convert my code so it work in …

Dear Experts, I am working on a TCP/IP project but my problem is that whenever my programme trying to reconnect again to server then server giving message port number is different. i.e. every time my programme is run its port no showing different in server so kindly guide how can …

Hi, I am using vb6 to manipulate my word 2003 template .dot and save it into .doc. My current method is: I am creating I word class, called W. then I use: W.activedocument.SaveAs "documentname.doc", 0, 0, "". 1, "", 0, 0, 0, 0, 0 It can be used perfectly for …

i am typing below code in each and every date text box keypress event to allow numbers and back slash keys only. can any function or subroutine be created to avoide typing same code again and again in the project. [CODE]Private Sub Text1_KeyPress(KeyAscii As Integer) Dim ch As String ch …