vba x 200

12,155 Topics

Member Avatar for
Member Avatar for Wiki_Tiki

I need help creating an elapsed timer with visual C++ 2008. Basically what I want to do is have elapsed time in seconds, minutes and hours tick down on a 'label' control. I've gotten it all set up, including the code for starting the timer ( this->tim_main->Enabled = true; ) …

Member Avatar for mcriscolo
0
391
Member Avatar for splitfinity

Hi guys. Im trying to get a wav file to play on a mouse over event. I want a wavefile to play when the mouse pointer moves over a label and stop wen it is moved off the label. I believe this can be done using the sndPlaySound, i have …

Member Avatar for splitfinity
0
185
Member Avatar for richwords

Well like i said i just joined this community and i,ve been working on vb6 applications and it has been giving me a lot of problems because i,m still new to programming. please i know i have some guru's out there who can help,so please post all necessary materials that …

Member Avatar for zandiago
0
348
Member Avatar for AUGXIS

hi guys, i get an error message "554 message is not rfc compliant" while i was trying to send an email. can you please help me with my code... [code] MAPISession1.SignOn With MAPIMessages1 .SessionID = MAPISession1.SessionID .Compose .RecipAddress = "myemail@email.com" .MsgSubject = "For Your Info" .MsgNoteText = "HELP" .Send End …

0
67
Member Avatar for dinilkarun

Hi All, Through Shell I am opening winxip32.exe in my vb 6.0 application. I want the application to wait until the shelled process has completed and then proceed with execution of the next line of code. How should I go about it. Please help. Regards, Dinil

Member Avatar for dinilkarun
0
87
Member Avatar for electrosoul456

I am using this query sql="select * from student" if rs.state=1 then rs.close rs.open sql,strcon,3,3 while not rs.eof datagrid1.datasource=sql datagrid1.refresh wend where as rs is a recordset variable and strcon defines the connection to the data base. please guide me for correction

Member Avatar for manoshailu
0
89
Member Avatar for Wiki_Tiki

Hi, I need help, cuz I don't have a clue how to program printers or anything. Here are the components I have (in terms of this subject): Main.h (Form) btnpgsetup (Page Setup button) btnPrint (Print Button) txtdisplay (RichTextBox) PrintDocument1 (PrintDocument control) pageSetupDialog1 (Page Setup) PrintDialog1 (PrintDialog control) What I'm trying …

Member Avatar for Ancient Dragon
0
130
Member Avatar for deftones

Hey people, I have quite a big code and want it to be repeated until the conditions are met. The problem is that every time I try to use Do...Loop statement, my program becomes "hung". Or even when I try to replace that statement with other methods, the program still …

Member Avatar for deftones
0
113
Member Avatar for abu taher

I use data control to link access file by data properties not code. use simple code like move next etc. I use find next to find data. but when i want to find i write the criteria like Name = taher. But i want I write only taher in find …

Member Avatar for electrosoul456
0
244
Member Avatar for davidao

Hi, I am trying to find a solution for a problem.. I've got a string but I need to format it in a specific type.... #-0.6|141.443719976486|59.8780753410541|-0.6|140.736613195299|59.1709685598 #534359|59.1356132208082|-0.6|140.821466009042|59.1851106954913| #17|-2.03|141.39422501803|59.828577866371|-2.03|140.78611066998259.2204660345 #9042|59.1851106954913|-2.03|140.821466009042|59.1851106954913|#40.82146600902.03140.786110669982|59.2204660345506|-2.03|140.786110669982| #9042|59.1851106954913|-0.67|141.429577840862|59.7932225273117|-0.67|#140.821466009042|59.185110695491| I am trying to end each line with "|" and move the rest of the characters to the next line.... …

Member Avatar for selvaganapathy
0
86
Member Avatar for andy_aphale

hello all, my self anil i am doing some timepass work in VB for practice. i am creating a webbrowser and i need some help i am creating it by using some components like microsoft internet controls. now i have created stop,refresh,back,forward,home buttons succsessfuly but i want some help from …

Member Avatar for selvaganapathy
0
194
Member Avatar for matt_wroe

Hello, I have written a program in visual basic 6 for controlling pumps on an addressed rs232 or rs485 network. Currently the names and addresses of these pumps are stored in an excel file which can then be edited by the software at runtime to add/remove pumps from the network. …

0
45
Member Avatar for hell_tej

Hi Frends, I m creating an access to VB6 connectivity Project. I ahve problem that VB6 Gives not me permition to leave any field NULL so when i save my record it genrate ERROR 94 That is invalid use of null value In my project it is not necessary to …

Member Avatar for manoshailu
0
144
Member Avatar for Teropod

Is there any way how i could compare arrays like pattern matching or should i write my own code? Thanks.

Member Avatar for manoshailu
0
397
Member Avatar for AUGXIS

hi guys, i was trying to sum up all the balances of clients to know which of them has reach their credit limit but my codes are not working. It shows an error and highlights on this code [code] rsArmaster.Open "select sum(balance) as credit from ArMaster where shippercode= '" & …

Member Avatar for AUGXIS
0
116
Member Avatar for mode17

hi i'm creating a program with the same effect as the green screen used in the movies and i'm having problem in getting the right value of green colors, but when i uses black or white as a color to be mask it works but not with the green, can …

Member Avatar for selvaganapathy
0
99
Member Avatar for arun_kumar112

Hi All, I am new programmer, I have to create list of item which are selected from list box . It should be displayed like " a,b,c,d,e,f " How can I do ? it can be in a string or numeric . only selected Item is required to display displayed" …

Member Avatar for selvaganapathy
0
116
Member Avatar for Djali

Hi Guys, I want to ask about dat file. How can I create a code for read and write dat file with VB ?, eg : string string 0.5000, 40 0.7699, 60 0.8431, 70 1.6754, 50 string string For above example,The code read string value in line 1 and 2 …

Member Avatar for selvaganapathy
0
110
Member Avatar for orion_nsk

Hello Everyone, I'm Uploading this Project for the ones who need Help regarding VB's MSCHART CONTROL!!! This Sample Shows : [B]1) How to Show Data from an Access2003 Database on Chart. 2) How to Print Data from MSChart Control. 3) How to "Save As..." the Chart, as .Bmp file.[/B] Hope …

Member Avatar for Djali
0
350
Member Avatar for prasethavm

What is the difference between crystal report and data report in vb. how to create crystal report and data report in vb.

Member Avatar for debasisdas
0
51
Member Avatar for apuamy

i have developed an application which uses TRIM command and MSCOMM command. When i am running the exe file in any other computer, error shows in TRIM command.Error shows some component missing. Then i loaded VB 6.0 in the new computer still error continues. Then i tried my software in …

Member Avatar for apuamy
0
93
Member Avatar for carlos_lopez_m

Hi everyone! I have a program written in C++ which already exports some data to Excel, on the other hand, I have another program written in VBA to analyse the data. I used to run them independent but now I would like to simplify them. Is there a chance to …

Member Avatar for carlos_lopez_m
0
172
Member Avatar for mstrauss

I have created some subroutines and User Defined functions in Excel's VBA. Internal to them, I have created arrays. I would like to use Excel functions on these arrays, but can not seem to. For example I would like to use the determinant function, which is mdeterm in excel. If …

Member Avatar for vbCNEW
0
162
Member Avatar for bytigma

Hi guys, Hope you will be able to help me with this problem. The problem that I have is that I have two .xsl files that are uploaded to the same specified folder at 4pm everyday. The file names are the same apart from the end digits specifying the date …

Member Avatar for vbCNEW
0
107
Member Avatar for jtomacelli

I need to copy the data from the top row of a worksheet to all those empty rows underneath it UNTILL you get to a row that has data…then start over and copy that new data into the empty rows….and so on… I have the code that we've written so …

Member Avatar for vbCNEW
0
116
Member Avatar for ymidexterous

Hi Everyone! Need help in my new Project with Visual Basic 6.. I need to send a 5 volts signal from my pc using a VB6 program to the serial port where I could place a relay... Thanks :) Dexter A.

Member Avatar for ymidexterous
0
689
Member Avatar for deftones

Ok, I have this code as an ex.: [code] Private Sub Command1_Click() Dim L As Long, L1 L = Label1.UBound L1 = L + 1 Load Label1(L1) Label1(L1).Move Label1(L).Left + Label1(L).Width Label1(L1).Visible = True End Sub [/code] If I press the button two times, it will make two copies of …

Member Avatar for deftones
0
92
Member Avatar for drichird

Here is some old VBA code inside a Word 2003 document to open and then save a word document: [code] Documents.Open FileName:=docFileName, ConfirmConversions:=True, _ ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _ PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _ WritePasswordTemplate:="", Format:=wdOpenFormatAuto 'do stuff to the opened file here... ActiveDocument.SaveAs _ FileName:=docFileName, _ FileFormat:=wdFormatDocument, _ LockComments:=False, _ Password:="", …

0
107
Member Avatar for deftones

Hi everyone, I have a tiny problem here but just cant handle it, since I'm new to VB6.. I want to put a code into a module which contains a lot of lines with same objects. I have an idea of relating those objects with variables, so instead of, for …

Member Avatar for selvaganapathy
0
118
Member Avatar for ocw
Member Avatar for inf4mi5
0
135
Member Avatar for veledrom

Hi, How can add 4 rows and 6 columns into MsFlexGrid1 with Command_click event in VB6? Thanks

Member Avatar for veledrom
0
486
Member Avatar for andrew13d

I do not clearly understand this concept of scripting. May someone please explain this to me and give me some applications of scripting. I have seen some examples of scripts but I am trying to really see what can be achieved through scripting. I hope am not jumpig the gun …

Member Avatar for Shanti C
0
110
Member Avatar for lIGhT4umEnAll

Hi friends I need some help from VB and Oracle guru's. I am trying to create a dynamic table from VB 6.0 in Oracle (mean I want to create a table whose name is dynamic issue) For this purpose I code as follow and get error table name is not …

Member Avatar for manoshailu
0
159
Member Avatar for sddproject

Hi everyone! I want to have a coin toss on my program: i have two images (a heads and tails) and i want the user to click on a button which will generate one of these pictures randomly. There's all this code on how to create a random number generators, …

Member Avatar for Teropod
0
310
Member Avatar for veledrom

Hi, When i click on a datagrid, the selected row's id is added into a text or combo or listbox. User will see and navigate through the added items but, can't change. What is the best way to do this? I need to disable changeable property of text or combo …

Member Avatar for veledrom
0
118
Member Avatar for veledrom

Hi, I populate data from database to datagrid but, cursor focuses on last row. How can i make it focused on to first row? Thanks

Member Avatar for Jx_Man
0
89
Member Avatar for veledrom

Hi, I fill the Dbgrid with information that come from database via adodc connection. Is there any chance to add checkbox across the each records listed in Dbgrid? I will check one or several particular records and update them with a record stored in a textbox. For example; [code] ....UPDATE …

Member Avatar for veledrom
0
114
Member Avatar for turbojol

Hello to all, Please can someone help me on how to create a databse at run-time. I have created a database with Access that I am using with the VB application and it is working well. But now, I want the user to be able to create another database that …

Member Avatar for Teropod
0
809
Member Avatar for myVbasic

I have used MS Access to generate a report and can print a particular report history by using macro. Is there a way I can print a specific report of the MS Access report from VB 6?:(

Member Avatar for myVbasic
0
83
Member Avatar for Member #239854

I am trying to import several files to access. I have the code to search the C:\ drive but I need to look thru all the folders also. Below is what I have so far the works. Thanks in advance for any help. Wayne [code] Dim strfile1 As String Dim …

0
53
Member Avatar for ___SnipeR___

[B]hi all, i try to move it to the up and resize it but i can't, can an one help me, by give my the code for this frm [/B]

Member Avatar for ___SnipeR___
0
98
Member Avatar for tinkel

im trying to create a system where i have 1 server.. and many computers.. with the server, i install a software, how can i install the software to other computers by installing it only in the server.. by using vb6.. is that possible??? hmmm...

Member Avatar for debasisdas
0
74
Member Avatar for iamnoangel26

What version of MS access is compatible to VB 6.0??? And any other application beside of access you can suggest. Thanks a lot...

Member Avatar for Jx_Man
0
91
Member Avatar for splitfinity

Hi guys Im trying to get a pdf file (I'm using as a help file in an app) to open up when the help button is clicked. This is the code i am currently using: [code] [I]Private Sub DisplayInstructionManual() Dim AcrobatReader as String Dim pdfFile as String AcrobatReader = "C:\Program …

0
56
Member Avatar for Tony Barber

Hi Everybody I am stuck can somebody help me please. I am testing a very small portable barcode scanner. After scanning I need to upload the scanned data. I am in VB6 I am using the mscomm1 control I tell the scanner to send the data. I have a [B]OnCom[/B] …

Member Avatar for Teropod
0
316
Member Avatar for pardeep3dec

Hello friends, I need procedure for continous accessing oracle database using visual basic. Follwing i am giving coding use by me but some time it give disconnection error Please help for continous connectivity. [code] dim db as new ADODB.connection dim rs as new ADODB.recordset db.open "Provider=MSDAORA.1;User id=ourpro;Password=ourpro1;Persist Security info=False" [/code] …

Member Avatar for QVeen72
0
150
Member Avatar for Member #315542

Im looking for a good access VBA book. Im advanced in access but completely new to VBA but have done other programming languages like c, c++, java, php and a few others Any recommendations greatly appreciated Thanks

Member Avatar for CindyK
0
122
Member Avatar for tijoseymathew

Hi, I would like to identify the patterns in a picture which is in picture box, the patterns will be of simple shape like a square, traingle etc.. I think if I can access the pixel data of the picture then a basic for next loop will suffice, the memory …

Member Avatar for tijoseymathew
0
228
Member Avatar for gedinfo

Hello, I have inherited an application written in VB6 that does not handle the number of print copies properly. Changing the number of copies to a number other than one(1) results in only (1) print. I am new at VB6, and would appreciate any tips on how to address this …

Member Avatar for Teropod
0
843
Member Avatar for veledrom

Hi, I have encripted password column in my table. I use VB6 code below to check password but it doesn't work. I think i have to call a function to decrypt it. Where and which function do i use in my sql code below with text1.text. Thanks [code] .......WHERE psw=' …

Member Avatar for Jx_Man
0
154

The End.