vba x 200

12,155 Topics

Member Avatar for
Member Avatar for nagatron

hallo to all web masters and vb masters out there. I need your help in making my project in relation to VB and web link. Is it possible to detect all the links in a particular web page? I have a button "GO" then I have a 2 webpage "main.html" …

Member Avatar for ali32n70
0
109
Member Avatar for hamidreza2790

I want to call a .bat file with path: C:\x.bat , to run data file in path E:\xx.dat in [COLOR="Red"][B]VB[/B][/COLOR] The Application I am using in fact is a simulator, It means, I do need to prepare a separate data file . The application read the data file line by …

Member Avatar for ali32n70
0
119
Member Avatar for Zinando

Hello. I'm looking for a little help here. I need to extract file parts into a new file with a new format. I think the better way to explain it is to give an example: Extract line 3 column 2 from a group of files. The number of files can …

0
62
Member Avatar for shruti23

hi Sirs, i m using vb6 and acess2000, crystal report 9. i want to delete *.tmp files created due to crystal report 9. i want this in vb6 through coding. pls help me. these files are created on partition and of 0 bytes. so, pls help me its urgent. thanx …

Member Avatar for vponline
0
1K
Member Avatar for hamidreza2790

Hi I run a batch file by VB6. The bach file need to pass a text file and a string (such as abc). I used the following commands but I faced errors : Shell "n:\aa.bat " & "c:\a1.txt" & "abc " , vbNormalFocus Shell "n:\aa.bat " & " " & …

Member Avatar for bushman_222
0
207
Member Avatar for guest11

Hi all, I am facing problem regarding screen resolution. I mean i make one project and its run and look nice in my PC screen but if i run the same app. in others PC then its create problem i am not able to see the controls on my app …

Member Avatar for bushman_222
0
106
Member Avatar for likurg

Hi all, what is a VB function that would enable me to name a bookmark to exactly match its contents? I've got a macro that defines bookmarks across a mailmerge document, the next step for me is to title them according to their values, which are unique. Also, what would …

0
49
Member Avatar for astroboy_x4

Hello, have anyone tried copying files from a remote server via FTP using VB Given: FTP Site FTP Password >>> the task is to copy files from the remote server to another machine thanks

Member Avatar for khalidmehmoodaw
0
202
Member Avatar for bryan110

Hi Everyone, I am looking for Secure Ftp ActiveX component in Vb6 to use it in a command line program. Please , if anybody have an idea how to get it free or how to create it. Thanks, Bryan.

Member Avatar for khalidmehmoodaw
0
157
Member Avatar for aclogics

I would like to create an application that would, after manipulating a text file, log on to a private FTP site and PUT that text file onto the server, and then logout. I have the code to manipulate my text file and make it ready for sending and I have …

Member Avatar for khalidmehmoodaw
0
132
Member Avatar for poilkjmnb

Please convert this code to Delphi to VB 6.0 const C1 = 43941; C2 = 16302; function BorlandEncrypt(const S: String; Key: Word): String; var I: byte; begin SetLength(Result,Length(S)); for I := 1 to Length(S) do begin Result[I] := char(byte(S[I]) xor (Key shr 8)); Key := (byte(Result[I]) + Key) * C1 …

0
97
Member Avatar for shitmitty

Hello My situation is: I have an excel file which i use as my template, and i want to place data from a list of .xls files. I want to be able to run a macro which prompts me with a list of files i have in the G:\MyFolder, and …

0
50
Member Avatar for neffness

I'm building a new database program using VB, I want to use the datetimepicker to do this: Show today's date on the datetimepicker, Show today's "to do" in a Text box (it would know it was today because it would be linked to the datetimepicker Then If I change the …

Member Avatar for neffness
0
134
Member Avatar for andyhopper

hey all, i keep having a problem using vb with an access database. anything i try to do with access brings up the same error message saying database format not recognised. any ideas what i need to do. thanks

Member Avatar for jbennet
0
160
Member Avatar for Nuella

I am looking forward to getting a car insurance policy source code to compare with the programme i have just written. Thanks in Advance

Member Avatar for debasisdas
0
92
Member Avatar for A H

Hello. I need to write a program that listen to the Comm Port. i.e. if any other program is sending Data to the comm Port, I need to read it as well. Can it be done using VB 6 ?

Member Avatar for debasisdas
0
50
Member Avatar for poilkjmnb

Hello Friends, Any body help me to convert the code delphi to vb6.0 ---------------------------------------------------------------- const C1 = 43941; C2 = 16302; function BorlandEncrypt(const S: String; Key: Word): String; var I: byte; begin SetLength(Result,Length(S)); for I := 1 to Length(S) do begin Result[I] := char(byte(S[I]) xor (Key shr 8)); Key := …

0
96
Member Avatar for benjaminbbozok

Hi All , it is my first post in this great forume , I am in a greate problem and i hope to find the solurion here , I created a datareport and used the (shape) object as a frame for each row in the report , my case is …

Member Avatar for benjaminbbozok
0
88
Member Avatar for ChroNoS

is it possible to insert a character say " " (space) after every 2 characters in a string? using this doesnt seem to work : [CODE] Dim s As String s = "010001000100" s = Mid(s, 1, 2) & " " & Mid(s, 4) MsgBox s [/CODE] it adds space …

Member Avatar for ChroNoS
0
156
Member Avatar for Entropy1024

I have a database working with VB6 and Jet. Everything works fine except that I now need the database to be accessed from a second machine on the network. It appears that only one person can be connected at a time to the database using Jet, is this correct? In …

Member Avatar for Entropy1024
0
130
Member Avatar for humbleade

hello every1, I am a college student and a new user on this forum just like I'm new to VB, please take it as if I know NOTHING about VB, I have VB 6.0 on my system, and I av a mini project to submit b4 February 20, 2009. I …

Member Avatar for potatochips
0
105
Member Avatar for accorpc

Alright folks...I'm new to this visual basic stuff, and to the site. I am working on an assignment for a class...it'll probably look pretty easy to the rest of you, but I just can't figure it out. What I need to do is take the information from the input box, …

Member Avatar for accorpc
0
162
Member Avatar for smile4evr

hw to add multiple conditions in a single update statement?? my project goes code like this... [code] If release.Enabled = True And nonosc.Enabled = True Then Dim rst12 As New Recordset Dim sql12 As String sql12 = "update Passport_Release_Information_N set Ename2='" & taker.Text & "' ,Any_ID1='" & takerid.Text & "' …

Member Avatar for AUGXIS
0
185
Member Avatar for nschessnerd

Hey i need a script to change the password of a user... i found some code: [code type=vb] strUser = InputBox("Enter username of user") strOU = InputBox("Enter domain where user's account resides") Set objUser = GetObject("LDAP://CN=" & strUser & ",OU=blah,DC=blah") objUser.SetPassword "password" MsgBox "Done!" [/code] but m not sure how …

0
65
Member Avatar for abu taher

I work with a student database project. when I click Add New button a massage show. I write code in add new button was "adodc1.recordset.addnew." massage was "Multiple - step OLEDB operation generated errors. check each OLEDB status value, it avaiable. No works was done." when I press ok another …

Member Avatar for abu taher
0
106
Member Avatar for bharanidharanit

Hello sir, I want to campare datas with different list boxes and need to alert the user. I grabbed datas from website and made it to be displayed in first 4 list boxes. and i already stored listbox5 and listbox6 values. consider these are those datas [ATTACH]8003[/ATTACH] listbox1 and listbox3 …

0
67
Member Avatar for abu taher

I have 4 text box in a form. when I click a button another Form show with a MSflexgrid. when I click in a msflexgrid the data show a text box of another form. I write code: form1.Text1.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.RowSel, MSFlexGrid1.ColSel) But I when I click msflexgrid the same data …

Member Avatar for aktharshaik
0
1K
Member Avatar for santhanalakshmi

Hi, If Not IsNull(rs!permaddr1) Then mpaddr1 = Mid(rs!permaddr1, 1, 500) Else mpaddr1 = " " where permaddr1 is a field type of varchar(1500). Example permaddr1 = "No:11/19 , Anna Salai , Chennai-1"(from sql server retriving the values) This value is now is stored in mpaddr1. Now, My main problem is …

Member Avatar for sendoshin
0
185
Member Avatar for vinzanity

what if the value is from the database? not just the text from msflexgrid. please correct my code. txtsol.Text = rs.Fields("sol").Value & fgrid.TextMatrix(fgrid.RowSel, fgrid.ColSel) what will happen now is, the row from db will populate all the textboxes in the form from a click in msflexgrid. any advice? thanks..

0
44
Member Avatar for komrad

Hello all, I'd like to know if it's ok to use vbscript within a css page? I'm thinking about defining certain variables at the beginning of the style sheet so that it's easy to change between colors (or load the colors from a database so each user can have their …

Member Avatar for siriyal
0
107
Member Avatar for laggerz

hello there im new in this forum any way im a junior programmer at our company i have a little prolem in accessing indexes of the fox tables any other way in accessing it in OBDC or in code. I use linking in access 2003

Member Avatar for laggerz
0
61
Member Avatar for carlos_lopez_m

Hi everyone: I'm calling an Excel file from C#; now, because I Want to run automatically a Macro, I've added to my Workbook code, Private Sub Workbook_Open() the name of the routine I want VBA to execute as soon as the file is open. The problem is that C# is …

Member Avatar for carlos_lopez_m
0
159
Member Avatar for Mark Red

Ok I have written a calculation form using textboxes as the sngvalue inputs everything works fine so no problems here, but I have tried countless methods to register when the decimal point has been entered or deleted from the textbox, as adding another decimal point raises an error, I am …

Member Avatar for Mark Red
0
199
Member Avatar for pixelmeow

I have SQL code in my VB6 project for select, insert, and truncate. For example: [code=VB] strSQL = "SELECT CASE_IDENTIFIER" & vbCrLf _ & " ,DOCUMENT_TYPE" & vbCrLf _ & " ,DOCUMENT_NUMBER" & vbCrLf _ & " ,CASE_LINE_NUMBER" & vbCrLf _ & " ,DELETION_INDICATOR" & vbCrLf _ & " ,MASL" …

Member Avatar for pixelmeow
0
211
Member Avatar for Bhatti302

[code] Hello to all masters Dears I have a Problim in Creating Shortcut on the disktop of my computer. I am cteat a Project in The VB6.0 i Want to creat a Shortcut on the DISKTOP of my computer. I am creat a Package Setup using "Package & Deployment Wizard" …

Member Avatar for aktharshaik
0
94
Member Avatar for locsin

I want to use find command for searching file in the database, but if I add "and" command i received error. It is possible to use and in Find command I try to this syntax but it is error .Open "Select *From salary'", strconek, adOpenStatic, adLockOptimistic .Find "empno = '" …

Member Avatar for aktharshaik
0
126
Member Avatar for jeffrides

I am a begining programmer taking a college course in VB. I am trying to place a label into a form. The project is complete and the problem is with some 'pretty' additions I am trying to do. The label properties appear fine; the same as all the other labels …

Member Avatar for jireh
0
120
Member Avatar for sarifah

please help me. urgent i have one date in a txtBox1.what i want is, after i click the button, the other date will appear on txtBox2. [B]The other date[/B] is the date after several days such as 7 days. so, how or what the coding to enable the other date …

Member Avatar for smile4evr
0
126
Member Avatar for smile4evr

please can u help me with all basic VB coding like... if command button is clicked from one form how can i link it to another form in the same project and a few examples of simple codings at the basic level... thankx a lot!

Member Avatar for rstkw
0
303
Member Avatar for smile4evr

please help me out in wat could be the error in the below code as it is not running when it comes down to the openrecordset statement! [code] Private Sub cmdOK_Click() Dim rst As DAO.Recordset 'check for null password If IsNull(Trim(userid)) Then MsgBox "User Name required.", vbExclamation userid.SetFocus Exit Sub …

Member Avatar for smile4evr
0
89
Member Avatar for smile4evr

can someone please help me with using tabs and hw to set the system date in vb6

Member Avatar for smile4evr
0
106
Member Avatar for sanbadgerdude

I have a file structure that is common to all of the jobs I do. When I start a new job I go into my computer (Explorer) copy the folder to clipboard, go to another location on a different server and paste this folder then I have to rename it …

0
57
Member Avatar for rajivkatyal
Member Avatar for debasisdas
0
62
Member Avatar for rstkw

I'm not sure why I want to do this, but it seems like I used to know how. Now I cant get it to work. The code would be something like: Public Sub FormattedString() '*** I want to break the string up into an array of '*** characters and reverse …

Member Avatar for selvaganapathy
0
140
Member Avatar for greenvader

i need to open a msword file using vb6, read the data and insert a new data. could someone please help me with this. thanks in advance

Member Avatar for greenvader
0
95
Member Avatar for rstkw

There is a website that makes highly optimized VB code available. Something like VBSpeed or something like that. Does anyone have a link to it?

Member Avatar for rstkw
0
107
Member Avatar for bodocz

Hi! I expect the next program wait 1 sec. and exit but doesn't work. Could anybody help me? Private Sub Command1_Click() Timer1.Interval = 1000 Timer1.Enabled = True aaa = 0 lo: If aaa < 1 Then GoTo lo Else End End If End Sub Private Sub Timer1_Timer() aaa = 10 …

Member Avatar for rstkw
0
277
Member Avatar for carson myers

I can't find out if a form is in focus in my code. I have a form subclassed to catch an event that the form is being moved, so that I can have a separate form docked to it that moves along with it (without using a timer). But each …

0
74
Member Avatar for vbdave

Hi, I made a small Access DB that has a Date field in it (DUEDATE). The DB is used for demonstration purposes to show current orders. I need a function that would randomly update the orders due date in the table (orders). I would like to input a starting date …

Member Avatar for rstkw
0
113
Member Avatar for Entropy1024

I have a database all up and working and now need to create a grid view. I am very new to VB and have been using the book Visual Basic in easy steps by Tim Anderson. On page 108 it describes how to create a grid view. In the text …

Member Avatar for debasisdas
0
134

The End.