vba x 200

12,155 Topics

Member Avatar for
Member Avatar for andy999

hi all, I am completely stumped out but I did not find the solution of my query so far. so I am in hope posting this here in this forum. My query is: I have an application runs on my desktop. I want to take data from the desktop application …

Member Avatar for vb5prgrmr
0
158
Member Avatar for Civil Eng

Hello everyone! I am a geotechnical engineer and have been tasked with editing hundreds of excel files all in the same way so I decided to go back to my college intro to C days and make VBA do all of my dirty work! Anyhow, *I* think I am having …

Member Avatar for vb5prgrmr
0
123
Member Avatar for ramesh_natesan

Hello, I have a vbscript file whose file size is 0.9 MB. I opened this vbs file and copied all the lines in it and saved it into a new vbs file. And I noticed the size of this new vbs file became almost half reduced to 0.55 MB. Anyone …

Member Avatar for vb5prgrmr
0
86
Member Avatar for ankush.mukherje

Private Sub cmdusername_Click() Set adorsRAM = New ADODB.Recordset sSQL = "Select User from Master where CPU_No='" & txtcpuno.Text & "'" MsgBox (sSQL) With adorsRAM .ActiveConnection = cn .CursorLocation = adUseClient .CursorType = adOpenStatic .LockType = adLockOptimistic .Open sSQL End With If Not adorsRAM.EOF Then 'txtusername.Text = adorsRAM Else MsgBox "No …

Member Avatar for ankush.mukherje
0
157
Member Avatar for JohnDove

I want to get rid of the "publisher could not be verified..." warning messages that users get when they run my Visual Basic 2008 application, after downloading it from my website. How do I digitally sign it to my company name? My website has a secure area (i.e. SSL certificate). …

Member Avatar for kvprajapati
0
126
Member Avatar for bdrkb

Hi I would Like to set my vb form caption from database can do this pls help me urgently

Member Avatar for QVeen72
0
75
Member Avatar for kbalamuk

I wanted a feedback from people who have done this before: reading hundreds of data files and creating a chart for each using VB. Is this a viable approach to do this? as in, how is VB speed and does Excel give up on you when you do the plotting?

Member Avatar for debasisdas
0
57
Member Avatar for srbatcha

Hi i am doing one project in vb6.0 with ms-access 2003 database. i want bulk data updatation in one table from excel sheet. is possible , if possible pls give me a good solution. my table name : segment transaction its contain more then 20 columns , my updatation for …

Member Avatar for debasisdas
0
281
Member Avatar for ankush.mukherje

hi experts please help me with this code [CODE]Private Sub cmdreport_Click() Set crApp = New CRAXDRT.Application frmViewReport.Show Set adorsRAM = New ADODB.Recordset Set report = crApp.OpenReport("D:\Ankush\created\proj11\Reports\Report1.rpt") sSQL = "Select type, user, location, cpu_no, model, speed, ram_unit from Master where RAM=" & Form1.cmbram.Text report.ParameterFields.Item("pRAM").Value = Str(cmbram.Text) report.DiscardSavedData 'CLEARS REPORT SO WE …

Member Avatar for ankush.mukherje
0
148
Member Avatar for planethax

In VB6, how would I subtract 1 from a Hex? Do I need to convert to Integer first? (have tried HextoDec function, but not having success) Example Hex = FF FF Hex - 1 = FF FE

Member Avatar for joekbit
0
271
Member Avatar for bdrkb

Hi How can i send data from vb text box to crystal report text object directly

Member Avatar for abu taher
0
128
Member Avatar for npstyler

Hai Experts, I need to convert the pdf files to word document , i have seen some softwares that converts pdf files to word document , i need the component or and activex dll to perform this work if anyone have done plz. plz try to help me

Member Avatar for cocol
0
256
Member Avatar for planethax

Having a guy help me with some code, however, he doesnt know VB6 and only has freebasic I need to convert the following into VB6 so I can make a user interface (comport selection etc) but not sure how to do it. Even a step in the correct direction would …

Member Avatar for planethax
0
488
Member Avatar for umepinkie

Hi I'd made a form using visual basic and added a few check boxes. I want to know you save the check box item into Microsoft Access Database when I click on Save. for instance: checkbox1: item1 checkbox 2: item2 checkbox 3: item 3 and in MS Access, I have …

0
49
Member Avatar for jammiedude

Just downloaded Office 2010 to see what changes have been made in the VBA environment and all looks well. But i am having a big problem typing in my code! as soon as i type something it appears in red, it autocorrects so fast that if i type .range("A1") it …

Member Avatar for jammiedude
0
145
Member Avatar for pytup

Hi, i have got code: [CODE]Dim numbers(99) As String Dim howmany As String Private Sub Command1_Click() howmany = InputBox("how many number you want input?") For x = 1 To howmany numbers(x) = InputBox("Enter a number") Next x FontSize = 14 For y = 1 To howmany Print numbers(y) Next y …

Member Avatar for QVeen72
0
112
Member Avatar for pankaj.garg

Hi, i am trying to create a program where user can add picture to a form at runtime..and store it in a database as well...i am using following code to define array of picturebox and load a picture in it... [code] Dim mimage() As PictureBox ReDim mimage(0 To num1) As …

Member Avatar for pankaj.garg
0
2K
Member Avatar for 22MDS

Please help. Can you help with the code I require? I have tried but I don't seem to beable to get it right. I have simple I/O Random FIle which works fine but I would like to be able to input a string into a textbox to find the record …

Member Avatar for vb5prgrmr
0
85
Member Avatar for niro_fernando

[B]which languages used to build window media player , how they create such beautiful interfaces , plzz tell me, [/B]

Member Avatar for niro_fernando
-2
64
Member Avatar for poojan

i have been trying to make a program to transfer any kind of files through [B][COLOR="Green"]serial port[/COLOR][/B] using [COLOR="Green"][B]VB6[/B][/COLOR], i was able to transfer the text file but not other files so please help me on this

Member Avatar for joekbit
0
102
Member Avatar for Frederick2

This is my first VB.NET post as I'm mainly a C/C++ and PowerBASIC developer. I'm trying to figure out how to pass a struct like so as a function parameter to/from a C/C++ or PowerBASIC dll using PInvoke of course in VB.NET. The struct in C looks like this... [CODE=C++] …

0
68
Member Avatar for b3nsoi
Member Avatar for palcy

hi!!! am palcy , am having problem in my listview with my save button whenever i try to edit something then press the command button for saving the update that ive' done it give's me the error "querry is too complex" then pointing my "rs.Update" code any solutions or proper …

Member Avatar for QVeen72
0
134
Member Avatar for gvlral

I have recently use a Exit For within a For Next Loop to exit the loop later the procedure returns to the same For Next Loop. I noticed the control does not reset. Is this what is supposed to happen?

Member Avatar for QVeen72
0
109
Member Avatar for mellowmike

I wasn't sure whether to put this question here or in the Windows section, but I was wondering if there was a way to put images into a Visual C++ project. That way, I won't have to load an image from an outside directory, and it will already be in …

0
68
Member Avatar for xairylle

Help... I've been asked to do a VB6.0 program. I'm required to enter values in a database that will be queried later on. Unfortunately, I can't seem to get the code right. This is what this part of the program should do: 1. Get the name to be searched 2. …

Member Avatar for jireh
0
181
Member Avatar for JohnPhilipps

Hello, I have two data comboboxes on a VB6 form "DataComboMasterPolicy" and "DataComboPurchasingGroup" after selecting the first appropriate choice with "DataComboMasterPolicy" I would like for the 2nd datacombox "DataComboPurchasingGroup" to only display the data associated with the user's selection. The data is in an Access 2003 db. My code for …

Member Avatar for jireh
0
160
Member Avatar for Israelsimba

is it possible for me to retrieve data from different tables then display them on a single data report. i am using a data environment for connection. if its possible how can i do it

Member Avatar for Israelsimba
0
103
Member Avatar for mchi6aa2

I need a visual basic code for the followings: Suppose a restaurent menu. unlimited user can access that. items will be listed there with the price. they will pick up some of them and then including tax (15%) the total will be shown. thats it. then the program ask for …

Member Avatar for jireh
0
225
Member Avatar for metalclunch

Hello. I'm trying to develop a very simple user-based information system. For example, read a folder for .ini files and get the pInfo stuff for each different player. It's for a network game I'm developing. So here's a BASIC example. [code=c++] if( PlayerInfo[playerOne][pLeader] == 1 ) { cout << "Player …

Member Avatar for metalclunch
0
1K
Member Avatar for pankaj.garg

Hi, i m trying to make a program (VB6) in which i need to do some tasks as soon as the date changes (like creating new database etc.), but dont know how to keep track of date change...searching on this gave me following - 1. Using a timer with 1 …

Member Avatar for pankaj.garg
0
172
Member Avatar for pankaj.garg

Hi, i have couple of doubts.. 1) How do i use MSComm Component in a module...i could gather that i might have to use 'class module' for that..but not able to make that work. 2) if i use a class module..how to pass parameters to a class...as i would like …

Member Avatar for pankaj.garg
0
299
Member Avatar for Julen

Hello to everyone, I have a problem while migrating a Visual Basic 6.0 application to C#. The thing is that my program has to communicate with a third-party application instancing an object. That application will be running and when I run my application, it should detect the active instance of …

0
133
Member Avatar for olgar

i want to do a search in a listbox This is the code I've written but not working properly formats you some idea [CODE] If TextBox1.Text = ListBox1.Name Then MsgBox("true name") Else MsgBox("false name") End If[/CODE] thanks for help

Member Avatar for sidnei
0
93
Member Avatar for malfane

First, my disclaimer is that I am not familiar with Excel or VB :( That being said, one of my users is getting an error when running a macro in Excel 2007 from his personal.xlsm. The macro is a simple color change which we have re-recorded several times but when …

0
52
Member Avatar for PinoyDev

Good day.! What a frustration drives me just this day.! Last night we got power lost. Just this day when i open my vb project, ive got an error message says that project1 cannot be loaded. When i try to open one form on that project it also returned, form1 …

Member Avatar for vb5prgrmr
0
2K
Member Avatar for bobnoby

Hi, I've been working on a program that lets you make cartoons. You have to draw one frame at a time. This works fine. The problem is, all you can do is playback the cartoons, you can't save them. I need to find out how to save multiple picture files …

Member Avatar for vb5prgrmr
0
115
Member Avatar for zawpai

Hi, Could you please show me where my error is? I have created one "DLL" file by myself. Then, I want to reuse it in another project, but the system prompt error message whenever I call that "DLL" function. I created "DLL" with "ActiveXDll". The following is my dll code. …

Member Avatar for vb5prgrmr
0
262
Member Avatar for sidnei

Hi, in my job, we use VB6 applications to control various needs, such as supply management, sell, buying, etc... We use ZEBRA printers, with ZPL print codes, directly from LPT1, wich seems like above code: Open "LPT1" For Output As #1 Print #1, "SOME TEXT TO PRINT" Close #1 (Of …

Member Avatar for SCBWV
0
1K
Member Avatar for kzip
Member Avatar for sathya8819

Hi, I have an application where I need to load images present in a folder onto my Visual Studio application. As in if I have a folder named temp and I have say 5 images temp1-temp5 inside the folder temp, i need to load each of the images temp1-temp5 (in …

Member Avatar for sathya8819
0
344
Member Avatar for selvaganapathy

This simple code shows to display the form in different shape. Also using the Gradient Brush to add Look And Feel to your form. Moving the form is also possible. Requirements Just draw a Form (Form1) and add Event handler for Load, MouseDown, MouseMove, Paint and DoubleClick for Form1. Then …

Member Avatar for anoop4real
1
219
Member Avatar for dre-logics

Use visual basic 8.0 Dymo labelwriter 400 Installed Dymo labelwriter 400 Software Development Kit (SDK). My problem is that there is a label is printed, but the mylabel. SetField are not included in the barcode label. The default values are printed. The object name in the label are correct (OText1 …

Member Avatar for dre-logics
1
1K
Member Avatar for guen

I need help convert from vb6 to php, this script for encrypt or decrypt some text and protected with password. Please i really need this, thank you. Private Sub Command3_Click() Dim S1, S2 As String S1 = RndCrypt(Text1.Text, "yourpassword") Text2.Text = S1 End Sub Function RndCrypt(ByVal Str As String, ByVal …

Member Avatar for Member #114696
0
96
Member Avatar for an_nurif83

ai.. i have try alot of times connecting the database in Ms Office Access 2003 with VB 6. bUT there is error when i try to connect between "record source" in vb with data that i save.Can anyone help me and give me some advise,references or way to solve this …

Member Avatar for vb5prgrmr
0
645
Member Avatar for jeffrey4u

Can someone teach me how to make a smiley move as i see in yahoo and msn messenger?:-/:icon_rolleyes:

Member Avatar for jeffrey4u
0
112
Member Avatar for Kalusingh
Member Avatar for apiss_nurz

:?: hai...i need ur help...i need sumbody here can send me a complete student profile system coding and interface..i really really need it pls.........it urgent..

Member Avatar for mucikera
-1
755
Member Avatar for fajar_07201

1) i have a group of data and equations that have been formulates in microsoft excel. Is it possible for VB to directly read my formula from excel or i have to copy the formula and place it in VB coding? how to code it? 2) can VB read my …

Member Avatar for vb5prgrmr
0
79
Member Avatar for neosonic

Hi all, I have a picturebox with scalemode pixel dim height as integer dim width as integer height = picbox.scaleHeight width = picbox.scaleWidth picbox.PaintPicture pic, 0, 0, height, width, 0, 0, picheight, picwidth note: picheight and picwidth are the height and the width of pic (in pixel) that has been …

Member Avatar for neosonic
0
2K

The End.