vba x 200

12,155 Topics

Member Avatar for
Member Avatar for Vijay_1

Hi All, I am well in Access Reports but in crystal reports just i am learning. I am using visual basic 2005 and access 2003 database. The report development in crystal, I am struggling and searching a long time but there is no useful tips. My database has more tables …

0
74
Member Avatar for ashvyas

Am having this piece of COde, but whenever am trying to execute this , Dim tsf As TestSetFactory - > error user not defined appears. pls help Dim tdc As TDConnection Sub UpdateStats() 'create QC connection QCconnect_silent "URL", "DOMAIN", "PROJECT", "USERNAME", "PASSWORD" 'process tests getMetrics 'disconnect QCdisconnect End Sub Private …

0
216
Member Avatar for amitash

Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks

Member Avatar for QVeen72
0
442
Member Avatar for amitash

Hi, in Excel I want to use a marco to automate a process so that for all the cells in a Range, if any cell is null, it changes to value 0. How can I achieve that? Thanks!

Member Avatar for AndreRet
0
101
Member Avatar for miramiey

Hi, I try to open vb6 file to visual basic 2008 but have a problem during a converting. here's the error that appear, ![26-7-2012_11-44-11_AM](/attachments/large/3/26-7-2012_11-44-11_AM.jpg "26-7-2012_11-44-11_AM") Can anyone please help me to fix this error. Thank you in advance.

Member Avatar for AndreRet
0
332
Member Avatar for Israelsimba

Im running an accounting package using crystal reports. all my fields are coming from the table except the totals. the problem is i have a running total where the **total income**-**the total expenditure = net income** for each month. the problem is that the opening balance is supposed to be …

Member Avatar for AndreRet
0
310
Member Avatar for innocentpaul

Can there be a way of connecting a vb 6.0 application to SQL server, how possible is that if am using ADODB?

Member Avatar for AndreRet
0
193
Member Avatar for number361

Hello! I'm a beginner developer and I'm currently learning Visual Basic 2008 Express Edition. I'd like create the following program: - search custom selected database - if selected database contains TABLEX and if TABLEX has data in ColumnY and it equals 0 then make some sort of signal/error/report where it's …

Member Avatar for Reverend Jim
0
138
Member Avatar for Estella

i want to extract icon from exe file. does anyone know how to do this?? thank you very much Regards Estella

Member Avatar for palvani
0
684
Member Avatar for katie1988

I'm creating a program where the user can search items in an access database and results are displayed in a listview. When I click search all items are displayed but when I enter an item in the textbox then search nothing is displayed. This is my code Private Sub cmdProdSearch_Click() …

Member Avatar for Bile
0
1K
Member Avatar for klars247

any1 here can help me how to backup and restore the datbase that im using by just clicking cmdbutton or something like that.

Member Avatar for debasisdas
0
57
Member Avatar for klars247

**In this code you must type the complete word in the textbox that stored in ur table to shows up in the listview. any1 can help me with this?? it should be base by letters not word.** Private Sub ListView1_click() Dim rs As New ADODB.Recordset Dim selected As String If …

Member Avatar for AndreRet
0
514
Member Avatar for heels

Hi All, I am tasked to generate report templates in excel and I am new to excel, VBA and still learning. A little more information on my task, the information for the report will be extracted from different sheets in the workbook which contains a whole list of calculation and …

Member Avatar for AndreRet
0
100
Member Avatar for Member #917847

I'm trying to have my panels overlap, but visual studio is placing my second panel INSIDE the main panel, I want them to be purely independent of one another. I have my main menu panel and when the user clicks a button that menu panel is disabled and changed to …

Member Avatar for crazyvonzipper
0
1K
Member Avatar for james.price.39501

//:How do I convert to string? C++? pragma once #include <iostream> #include <fstream> #include <istream> #include <string> namespace testrun1 { using namespace System; using namespace System::ComponentModel; using namespace System::Collections; using namespace System::Windows::Forms; using namespace System::Data; using namespace System::Drawing; using namespace System::IO; using namespace std; private: int total; #pragma endregion private: …

Member Avatar for Ancient Dragon
0
637
Member Avatar for TTTHXC

i have a function in a module that requries integer values. these values are set by the user typing in two textboxes on the form. the texboxes contain Hexadecimal data in string form. function: Friend Function addNewCode(ByVal Location As Integer, ByVal Opcode As Integer) As Boolean If (Not LocStack.Count < …

Member Avatar for Reverend Jim
0
778
Member Avatar for mavtcr

**Dear All,** I am a new entrant in the **DANIWEB**.I am a beginner in Visual Basics.Self studying through browsing the net.I want to make a small programme to be used by 5 or 6 users.in a stand alone computer.How this user management system can be coded.The following operations are required. …

Member Avatar for mavtcr
0
228
Member Avatar for sheick21
Member Avatar for alexander1s

Hello, I would like some advices with my program, i having issues I have a program in visual basic that is linked to access database using the connection wizard. in access i set the number field to autonumber but in visual basic i putting as a text because it would …

Member Avatar for Bile
0
111
Member Avatar for Bile

-->>Hi all out there... -->>I developed my application in windows 7 lately but my OS crashed suddenly so I decided to install XP SVC-Pack3 -->>I installed back my VB 6.0 but when I run my Application the Codes that were fine in V=Windows 7 are now Mulfunctioning... -->>Now Iam going …

Member Avatar for Bile
0
215
Member Avatar for DarkPyros

hey, guys, was wondering if i could get some help with this school assingmnet. no, im not asking for code. more like guidance and clarification. the following is the assignment itself: *You are required to create a Visual Basic application for the Roytec Examinations Department. The program must accept student …

Member Avatar for DarkPyros
0
223
Member Avatar for teppuus

Hello, I am working on debugging a program at my job. My coworker who wrote the program passed away last year, so it fell to me to try and update some changes we needed. I am a novice at programming and VB6 but was able to make the changes. Unfortunately, …

Member Avatar for teppuus
0
139
Member Avatar for soapyillusion

Hello everyone, I've been out of college for a little over a year now with my degree in web development (or so it says at least on my degree) My school wasn't the best at training me and i've spent the better half of this year trying to teach myself …

Member Avatar for soapyillusion
0
137
Member Avatar for BadVinegar

I'm fairly new to visual basic. I was trying to make a program that generates code for you, based on whatever the user inputs. But whenever I click generate, I get this error "Invalid CastException was unhandled. Conversion from string "//Generated using MAYAN. Minecr" to type 'Double' is not valid." …

Member Avatar for BadVinegar
0
245
Member Avatar for Eruditio

First of all, I realise there are a fair few related questions on many other sites, in addition to Microsoft Support pages. I have spent many hours on this issue, and this is where I stand and what I know/have been able to achieve: * I have an application written …

0
217
Member Avatar for Nitro40

I would like to silently print PDF files from the hard drive to a named printer, which may or may not be the default printer. In the [URL="http://www.daniweb.com/techtalkforums/showthread.php?t=17156"]this thread[/URL], it shows how to silently print the PDF but it always goes to the default printer. Is there a command line …

Member Avatar for dan7
-2
1K
Member Avatar for nquadr

Hi, I wanted to find out if there was a way to design a macro that takes information from a column in Excel to a text box on a webpage. I have over 600 records that I can input 15 at a time. I would like to run a macro …

Member Avatar for AndreRet
0
141
Member Avatar for GregDen

Hi all, Can someone please help me. I'm writing a VB5 app that connects to an Access 97 database using a data access control with the following parameters: Connect = "Access" DefaultType = 2 'UseODBC Exclusive = 0 'False Options = 0 ReadOnly = 0 'False RecordsetType = 1 'Dynaset …

Member Avatar for TnTinMN
0
352
Member Avatar for Medearns

hello all, please help me in Finding the pixel values of an image using visual basic ...pls attend, i need it urgently..! tnx

Member Avatar for SudoWin
0
46
Member Avatar for cheesepotato
Member Avatar for cheesepotato
0
784
Member Avatar for me_coolvibes

Hi, I am trying to call some MATLAB functions from my Visual Basic App. I have referred to the mathworks documentation, but havent been able to find much information. Also, I need an ocx/activex component to be able to display the results of some matlab plots that I'll access through …

0
60
Member Avatar for GregDen

I am writing a VB app that provides the user with a menu of reports written in Crystal Reports 4.6. When the user selects a report, it is shown in the Crystal Reports preview window from where it can be printed to the selected printer. My problem is that the …

Member Avatar for GregDen
0
1K
Member Avatar for tjamesp

Hi, I am trying to write a macro in Excel 2003 that will sort some data and delete the unwanted rows. Basically, starting on line 3, in columns C to L, if the charater strings "N" or "NI" DO NOT appear, I want to delete the row. The number of …

Member Avatar for Member #235788
0
194
Member Avatar for plusplus
Member Avatar for WolfPack

Hi, How do you delete a newline character that is inside a VB string? Apparently Trim removes only spaces. Thanks in Advance.

Member Avatar for hcassper
0
14K
Member Avatar for Ahmed.Adb.Elazeem

**hello evrey one i have problem,,,,, i want transfer data from textboxes to MsfilxGrid when i press a command1 ?? and when i finish iwant to save data from MsfilxGrid to database ?? when i press a command2 in VB6 **

Member Avatar for AndreRet
0
301
Member Avatar for colmar

I am trying to alter the voice in a DirectSS Text to speech control. I am able to make the control speak. "DirectSS1.speak (Label1.caption) 'This reads the words from a text box" Going on the above how do I change the voice. The other properties I am playing with as …

Member Avatar for InfrequentCoder
0
3K
Member Avatar for mohammed rifai
Member Avatar for hanzbu
Member Avatar for Israelsimba

i developed a payroll running in VB6 and using SQL 2000 Database, and when i install it on my laptop with windows 7, it gives me an error message 'You dont have permission to perform this operation'. Im logged in as administrator.

Member Avatar for AndreRet
1
294
Member Avatar for gertails

please give me an idea or codes in vb6. How to control other system units using vb6. or how to shutdown other units using vb6. please give me the idea or some codes thank you.. ASAP

Member Avatar for samsylvestertty
0
145
Member Avatar for estina

**Bold Text Here** how do we code the following buttons?capslock,shift,control,tab and enter

Member Avatar for AndreRet
0
66
Member Avatar for gee_azizi

Hey guysz. I had follow up the Daniweb discussion on VB6. I tried to develop a software based on what I got. It is a similar to library system (it is a different program actually). Thanks alot ^^. Now I almost 80% done. So I need a little help 1. …

Member Avatar for gee_azizi
0
149
Member Avatar for nquadr

I have the following code that I would like to count files in a folder and return their name. Function CountFilesInFolder(strFolder As String) As Long Dim noOfFiles As Long Dim FileName As String FileName = Dir(strFolder) noOfFiles = 0 Do While FileName <> "" FileName = Dir 'ActiveSheet.Cells(noOfFiles, 1).Value = …

Member Avatar for WetCoastLife
0
293
Member Avatar for Skate Bart

okay. Here's my problem. I have a form in which a Microsoft Hierarchical Flex Gid (fgdCompany) is used to display records taken from a database to relavent textboxes on the same form. When a record from fgdCompany is clicked, then the data in that record is shown on the textboxes. …

Member Avatar for AndreRet
0
618
Member Avatar for shaunnyagomo

i need to download a drive for the serial /dual channel serial relay board and the code using VB 6.0 for switching on and off

Member Avatar for AndreRet
0
51
Member Avatar for jeffrey4u

I want to load two pictures into an image control at these periods 1. When the mouse is over the image control 2. When the mouse has left the image control I got this Lines of code (from the net) that work for mousemove event on Picturebox control but unlucky …

Member Avatar for AndreRet
0
172
Member Avatar for ZNERB

Hello, I am getting these constant annoying errors in Visual Basic .NET 2010 Express. I'm pretty sure I'm not the only one, but these errors are always relating to images and resources! [QUOTE][B]The Type 'Global.ExampleProject.My.Resources.Resources' has no property named 'example.png'[/B][/QUOTE] I am pretty sure these are bug, due to the …

Member Avatar for jsurefo
0
594
Member Avatar for SkyAiedail

good day! I'm a begginer at visual basic. for our thesis, our professor, want us to create an examination where the items are from the database and the items will load randomly.. we don't have any idea on how to do it. please help... if it is not possible to …

Member Avatar for samsylvestertty
0
183
Member Avatar for kashif.ibraheem

hi i am kashif from sri lanka i need some help from u all to make a student record system with my school logo in vb6 is that posible for u to help me to make this i am very thank full to get help from u friends plz

0
64

The End.