12,425 Topics

Member Avatar for
Member Avatar for AWPROGRAMMER

I have multiple projects in the same database that use the same dll code. Currently I have to define in the dll what the project names are and what the unc path is that each particular project needs to reference for it's excel file. The excel file contains notes that …

Member Avatar for AndreRet
0
158
Member Avatar for abelingaw

[URL="http://www.daniweb.com/forums/thread341763.html"]http://www.daniweb.com/forums/thread341763.html[/URL] Regards to that, i also wanted the system not to be able to delete Administrator Accounts via my code also posted there. Here's the code again: [CODE] Private Sub cmdDelete_Click() ' On Error GoTo err Dim intYN intYN = MsgBox("You are about to delete a record." & vbCrLf & …

Member Avatar for AndreRet
1
146
Member Avatar for doremon89

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

Member Avatar for AndreRet
0
213
Member Avatar for aquamarine_kath

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 …

Member Avatar for AndreRet
0
796
Member Avatar for p90pts

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 …

Member Avatar for Ketsuekiame
0
107
Member Avatar for vasaviam

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.

Member Avatar for VBzambo
0
2K
Member Avatar for PinoyDev

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 …

Member Avatar for PinoyDev
0
106
Member Avatar for cavern

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.

Member Avatar for ChrisPadgham
0
87
Member Avatar for Shalvin
Member Avatar for debashishm
0
146
Member Avatar for masterfact18

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

Member Avatar for AndreRet
0
544
Member Avatar for martin11ph

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.

Member Avatar for AndreRet
0
2K
Member Avatar for sam1

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 …

Member Avatar for AndreRet
0
187
Member Avatar for piyushdhamecha

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

Member Avatar for AndreRet
0
417
Member Avatar for RichIT

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 …

Member Avatar for faizshafie
0
138
Member Avatar for ayarton

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 …

Member Avatar for ayarton
0
210
Member Avatar for starmax

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 …

Member Avatar for starmax
0
312
Member Avatar for piyushdhamecha
Member Avatar for tjm6f4

Hi, I'm pretty new to C# but I'm very familiar with C++ and first off I wanted to know if anyone has a good website with some tutorials for C#. Other than that, I have a few basic questions regarding GUI programming. I suppose one question at a time is …

Member Avatar for Ketsuekiame
0
159
Member Avatar for ichiban1985

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 …

Member Avatar for AndreRet
0
109
Member Avatar for ash07

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 …

Member Avatar for AndreRet
0
157
Member Avatar for slugdoug

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

Member Avatar for AndreRet
0
104
Member Avatar for gingank

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 …

Member Avatar for jhai_salvador
0
235
Member Avatar for ftl25

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 …

Member Avatar for IssamLahlali
0
1K
Member Avatar for SaberExcalibur

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 …

Member Avatar for Luc001
0
165
Member Avatar for masterfact18

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

Member Avatar for peter_budo
0
155
Member Avatar for masterfact18

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

Member Avatar for abelingaw
0
290
Member Avatar for AWPROGRAMMER

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 …

Member Avatar for AndreRet
0
206
Member Avatar for Xjmaslord4

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

Member Avatar for AndreRet
0
180
Member Avatar for neelle26

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

Member Avatar for abelingaw
0
114
Member Avatar for PM312

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

Member Avatar for debasisdas
0
73
Member Avatar for kubic

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 …

Member Avatar for kubic
0
258
Member Avatar for HelloPeople1

Hi guys I just started writing in c++ yesterday, although I did write in visual basic before. After watching some basic c++ youtube video's i decided i wanted to make my first game, tic tac toe. So as a warning i did this without using anyone else's code or any …

Member Avatar for jonsca
0
170
Member Avatar for abelingaw

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 …

Member Avatar for jhai_salvador
0
529
Member Avatar for prajana

Hello! I am very pleased to join Daniweb. I found it very interesting and helpful and immediately joined the community in the hope of getting some help regarding my final year project. Well coming to the point, m designing an Attendance Management System(AMS) for my college. I have created accounts …

Member Avatar for abelingaw
0
119
Member Avatar for mistymarian

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

0
90
Member Avatar for JD69

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

Member Avatar for lolafuertes
0
63
Member Avatar for JD69

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 …

0
69
Member Avatar for PM312

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

Member Avatar for AndreRet
0
1K
Member Avatar for jogieglenmait

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.

Member Avatar for panchong
0
1K
Member Avatar for MichellePV

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 …

Member Avatar for AndreRet
0
160
Member Avatar for daniwaber

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.

Member Avatar for AndreRet
0
286
Member Avatar for martin11ph

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 …

Member Avatar for AndreRet
0
904
Member Avatar for authi

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

Member Avatar for debasisdas
0
107
Member Avatar for mike42intn

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 …

Member Avatar for codeorder
0
165
Member Avatar for divakar.it

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

Member Avatar for AndreRet
0
212
Member Avatar for neosonic

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 …

Member Avatar for AndreRet
0
344
Member Avatar for ITHope

I am currently taking C++ but i am also in Software engineering. for my software engineering class we have to create a project(of our own choosing) coding included by April. my question is how would i use c++ to create a rigorous/simple software.... i want to do something pertaining to …

Member Avatar for daviddoria
0
180
Member Avatar for anu89

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 …

Member Avatar for AndreRet
0
83
Member Avatar for abelingaw

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 …

Member Avatar for AndreRet
0
115
Member Avatar for pardeep3dec

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 …

Member Avatar for AndreRet
0
233

The End.