vba x 200

12,155 Topics

Member Avatar for
Member Avatar for nfowomola2

I developed a [B]pay roll[/B] [/B]application for my organization, I want to create a [B]monthly report for the employees but I want it inform of querying the database[/B](data file) to generate a report for two different months(like January and December)[COLOR="Red"]on a single report sheet[/COLOR], PLEASE HOW CAN I ACHIEVED THIS?

Member Avatar for ChrisPadgham
0
136
Member Avatar for supereng

I need a code to look in my C drive for specific folders. I want it to go through the first folder and keep drilling in all the subfolders until it hits a dead end, and then go back to second folder and do the same etc..., looking for any …

Member Avatar for ChrisPadgham
0
785
Member Avatar for Joe Shmoe

If I have an EXE file what command can I use to link a RES file into the EXE!? I have tried many different linker programs and can't figure out how to do this simple task with any of them.

Member Avatar for ChrisPadgham
0
70
Member Avatar for violette

Hi guys. here's my problem. When there is Null values in the excel file, the macro will give me an error 'type mismatch'. Please have a look at my code. This code only works when there every field has value. it gives error if there is null value. [CODE] sqlStr …

Member Avatar for dspnhn
0
918
Member Avatar for aileengrace03

Private Sub Text5_Change() Dim ccs As Double Dim bal As Double Dim loss As Double Dim pcs As Double Dim bcs As Double Dim bgl, aa As Double Dim total As Double Dim a As Long Dim X, y, z As Integer X = 0 z = 0 a = …

Member Avatar for BitBlt
0
236
Member Avatar for Suirbachi

Hello all, I'm taking my first BASIC programming class this year, and for a final project, I'm trying to make a book-keeping log. What I want to have happen, is to open a list of books, highlight a book title, click the "check in" button and have the text change …

Member Avatar for BitBlt
0
304
Member Avatar for leutrim

please tell me how to creta a countdown timer in visual basic button1 (buton for start timer) labelsec(Sec lab) labelmin(min lab) labelhr(hours lab) txtsec(textbox for write sec) txtmin(textbox for write min) txthr(textbox for write hour) please tell me how to programming

Member Avatar for adam_k
0
349
Member Avatar for lxXTaCoXxl

I'm trying to replicate the visual basic power packs controls (rectangle, oval, and line) so that express users can get a spin of these wonderful graphic controls. However, I'm having some trouble getting the basic properties of them into the properties window instead of just the code editor window. [code]using …

0
65
Member Avatar for Abzz

[B]Hi can anybody help me plzz!! Right I calculate an equation in Form1 but how do I make the answer to the equation show up in a label on Form2?[/B]

Member Avatar for hkdani
0
65
Member Avatar for lxXTaCoXxl

I'm trying to incorporate my custom control called "windmill" into my application extension. I've created a few properties that I want to be visible in the properties window and when I built my project and tried to use it in a test project it did not work. To top it …

Member Avatar for lxXTaCoXxl
0
181
Member Avatar for ykbks

Hey there! Im new here, well, as a member, but not as a viewer. anyways, i am making a vb project, novice one. i need to open a file located in d:\\Documents\\MB.accdb now, i would be very happy if i would get the code to open the file, not in …

Member Avatar for hkdani
-1
7K
Member Avatar for Patrick Gondwe
Member Avatar for major_lost

I want to first say THANK YOU to all of you programmers for your help. You truly live steady to the core of IT and are an inspiration to us newbies! I have a simple utility that starts and stops a timer on a VB4 form. I record the time …

Member Avatar for ChrisPadgham
0
135
Member Avatar for datanetw

Hi Guys my name is tejas m having the same problem i am trying to compile a billing project but it wont simply work gives Unhandled exception in SPBS.EXE(Program Name) (CRAXDRT.DLL) Access Violation 0xc some zeros and 5 i am posting the complete code of frmreports can anyone help me …

Member Avatar for hkdani
0
407
Member Avatar for AquaNut

Hi Coders, I have a minor problem that I would like to try and resolve. I am pasting data from an Excel spreadsheet and and adding a 0 to the start of each 9 digit string it's it's missing (thanks to the help of Rev Jim. This works great if …

Member Avatar for AquaNut
0
217
Member Avatar for gplkrsna

Hi All, Hi All, I'm trying to execute a vbscript programme, on execution I'm getting following error, can you please help me in coming out of the problem. "Wrong number of arguments or invalid property assignment: wsh" CODE snippet: [CODE]Set xl=createobject("excel.application") Set wb=xl.workbooks.open(testset) xl.visible=true Set wsh=wb.WorkSheets(1) <------- ERROR is seen …

Member Avatar for gplkrsna
0
110
Member Avatar for Gizzle72

Hi, I am trying to write a macro that will have the list box look at a cell in another worksheet and based on that data, lookup the corresponding data in another worksheet which will be used as the data for the list box. Formula I am using for cells …

0
60
Member Avatar for Member #925360

Alright, I have Textbox where I want only Numbers and Letters and backspace allowed. I don't want copy and paste, or spacebar or other ascii charachters. Can anybody help me?

Member Avatar for Member #925360
0
364
Member Avatar for Dorar

[B]My project is Housing reservation system for University I design the interfaces by VB and connect to my oracle data base account Oracle 11g, VB express edition are used The proble is with the login form [URL="http://im20.gulfup.com/2011-12-23/1324652639153.png"]http://im20.gulfup.com/2011-12-23/1324652639153.png[/URL] when I debug and enter the ID & password for User : according …

Member Avatar for dspnhn
0
528
Member Avatar for SureEM25

Welcome every one I am very glad to be here. It good to be talking to fellow programers and web designers. I am just learning python, I know little visual basics, I use html with dream weaver, and I also use drupal.

Member Avatar for Christing
0
44
Member Avatar for Cheda

Ok, I have a Windows 7 Ultimate 64 Bits system, so in the beginning, I couldn't use the Microsoft® Windows® Malicious Software Removal Tool because it says that it is not compatible with my system. Then I used the ATF-Cleaner and it was OK. Then I downloaded GMER and the …

Member Avatar for jholland1964
0
480
Member Avatar for puneet2

I have two For loop, first For loop does is creates a customer and input the customer info and then the second for loop within the first for loop does the follows which is capture the customer name and verify the with the data within the datatable. The problem I …

Member Avatar for hkdani
0
275
Member Avatar for martin11ph

I have a form that has a ton of work ongoing for around 10secs such as moving controls, resizing them, hiding some, making others visible and more importantly, mouse moving and clicking. I don't want the user to see these ongoing stuff so I thought of making a splash screen. …

Member Avatar for jumba_4u
0
184
Member Avatar for zoro20002

what is the error in the bleow: 'Public Event OnFilterAdded()' is an event, and cannot be called directly. Use a 'RaiseEvent' statement to raise an event. [CODE]Imports System Imports System.Collections Imports System.Configuration Imports System.Data Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.HtmlControls Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports Tawammar.CustomControls Partial Class …

Member Avatar for GeekByChoiCe
0
263
Member Avatar for aaronoafc

Hi, I'm a programming beginner and currently learning VB.net as a starting language. I have just been making a little test console application using visual studio asking about favourite football teams, please could someone tell me what I'm doing wrong? Below is the code, now I want the user to …

Member Avatar for Begginnerdev
0
140
Member Avatar for AquaNut

Hi All, I have a 3 richtext boxs where I add each line together and output to a textbox, all is working great. But the problem I am seeing is that I paste the contents from a spreadsheet which strips off the leading 0 (zero) from a 9 digit number …

Member Avatar for Reverend Jim
0
228
Member Avatar for shaima88

[COLOR="Green"] hi :( i am a student i have problem i can not understand how to transfer encryption code to decryption >>>>> i have exam soon please help me to advance my self in vb.6 that is my code in encyption and i use transposition cipher .. Public Function encrypt(ByVal …

0
42
Member Avatar for sam1

Hi, I am trying to create a Please Wait message in excel vba. This is to let the user know while processin some sql querry at the background which may take unkown amount of time. I would like to have it displaying in a userform. The situation is: Userform is …

0
102
Member Avatar for dinilkarun

Hi, I am running a batch file to generate a report. A command similar to the below one is put in the batch file. [url]http://localhost/XXXX/XXXX/Test.asp?format=EXCEL&cqs=N3-FMIJTUVMUTPO-QQEWQ3MP[/url] Test.asp contains the below <%@ Language=VBScript %> <% select case Request.QueryString("format") case "EXCEL", "Excel", "excel": Response.ContentType = "application/vnd.ms-excel" case "WORD", "Word", "word": Response.ContentType = "application/msword" …

0
89
Member Avatar for sotos

search button for vb 2010 ultimate in access 2007 database and filtering on a datagrid Hi all! I am trying to make a search button which filters a datagrid. First of all, I have a tab and on this tab a have a datagrid (dgr1). When I load this tab, …

Member Avatar for sotos
0
501
Member Avatar for kanyonb38

Hello Visual Basic Coding Experts, I have other application that I have not made myself, but can do what I am looking to do. I want a code to keep a form on top of all the forms in my application. Not Topmost, which keeps it open onto of all …

Member Avatar for hkdani
0
302
Member Avatar for ng5

does anyone know if you can make a water mark in visual basic 2010? I was wondering if it could also go behind all of my labels, text boxes, etc... like in the background... Thanks in Advance

Member Avatar for GeekByChoiCe
0
129
Member Avatar for Ole Raptor

Hello, I am trying to go through a list of comboboxs and set the selected value from the itemdata. So far I have this working for a single combo. I have a few combo's that I need to do this for and was trying to find a way to pass …

Member Avatar for ChrisPadgham
0
185
Member Avatar for shivaloca

Hi, I'm trying to translate a class to c# from vb6 (see C# code below). It fails to Build in Visual Studio, giving me "class used as type" error to relation to m_Dept. This assignment worked in VB6 and in VB.net but I want to rewrite the class in C#. …

Member Avatar for thines01
0
163
Member Avatar for dhnayak

I am here with given my one problem, is mentioned here below; I am beginner to visual basic programming after qualified VB6. And I wish to have some more experience for this programming. Hence I need some procedure on codling's for direct printing procedures. This is under a trial basis. …

Member Avatar for hkdani
0
3K
Member Avatar for ng5

I am trying to make a program that randomly selects a name. i have a prompt that allows me to enter the number of names and the names themselves. but i dont know how to save or open the information into an array... can anyone help me with this?

Member Avatar for codeorder
0
267
Member Avatar for newbie26

hi.. i created a crystal report in vb.net i saved it , copied and paste it to the folder of my vb6 project. when i ran the program (loading of the crystal report), it gives me an error "invalid TLV record" in this part:" . . . Set report = …

0
62
Member Avatar for rocdigga1486

Write a program to analyze a list of grades to determine the number of A’s, B’s, C’s, etc. after applying a curve percentage selected by the user. When the form loads it should contain all the grades and available curves in the list boxes on the left. The user selects …

Member Avatar for BitBlt
0
104
Member Avatar for aquamarine_kath

Hi. I tried to install vb6 on my friend's laptop. It was installed but when I double click the control on a form to write a code, it has stopped working. It says, "VB6 has stopped working". It was installed but I cannot put a code in it. Here are …

Member Avatar for LesF
0
231
Member Avatar for YungSoprano

Hi everyone, I'm creating a booking application for a hotel and have encountered an error on the following code; [CODE]Public Class Seaside_Hotel_DB Dim dbconn As OleDb.OleDbConnection Dim dbcmd As New OleDb.OleDbCommand Dim dbread As OleDb.OleDbDataReader Dim spath As String Public Sub New() spath = Application.StartupPath spath = spath.Replace("\bin\Debug", "") spath …

Member Avatar for YungSoprano
0
232
Member Avatar for CX Mike

Dear Team, I have a question regarding LINQ 2 SQL and data integration with textbox: I have one textbox and button on my form, one stored procedure and LINQ 2 SQL class file in my project, I want that when I hit button, my store procedure run the SQL query …

Member Avatar for thines01
0
262
Member Avatar for afonseka

Hi, I am in need of help to get few things sorted on a classic ASP page, if anyone could please advise me how to get this done or where I can find some examples please. Brief note on what I want to do I have a ASP page where …

Member Avatar for G_Waddell
0
187
Member Avatar for dashawk

Hi guys, I am just wondering if anyone have already developed an application using Visual Basic 2010 with Multitouch gestures? I have some research in these fields but I only get WPF or C# codes but still lacks details.... Anyone could share their ideas?

0
84
Member Avatar for alistairnear

Hi Guys.. can you help me in my thesis project? it is about partitioning a flash drive using Visual Basic 9.. thanks a lot... Alistair

Member Avatar for Reverend Jim
-1
129
Member Avatar for Member #854131

Good morning, All I am going to place the tag propeties at each node. And the tag content will be file path. But my coding is not working..Can someone help me.. Thnx. My code to generate treenode tag properties from xml is as below: [CODE] Private Sub AddTreeViewChildNodes(ByVal parent_nodes As …

Member Avatar for Member #854131
0
115
Member Avatar for legodadda

Flip Vertical and Print Code: Printer.PaintPicture Picture1.Picture, 0, Picture1.ScaleHeight, _ Picture1.ScaleWidth, -Picture1.ScaleHeight, 0, 0, Picture1.ScaleWidth, _ Picture1.ScaleHeight, vbSrcCopy I have seen this code in various places on the web but it does not seem to work. I am trying to get a label to flip to the vertical. Any help …

Member Avatar for BitBlt
0
368
Member Avatar for belfagor

hello everybody, i wish to know if there is a way to retrive only some kind of information like: hard drive, ram, video, sound, modem, lan, wlan and put all in a form? thanks

0
64
Member Avatar for bonzo2008

How shall I write the code so i get surname first and forenamn last Set rs = db.OpenRecordset("SELECT * FROM tblData WHERE Surename & Forename LIKE '"& "'" & "& '*'") i don't know if this is right

Member Avatar for StephNicolaou
0
105
Member Avatar for kiki256

So i want to have an application where the user types in a word in a text box and in another text box they put a letter for example "e" and in the third text box they put down what letter they want to replace it with example "f" So …

Member Avatar for kiki256
0
2K
Member Avatar for Tobyjug2222

Hello, I'm currently making a program in Visual Basic 2010 for my Course work, and I'm struggling a little as it involves a "log-in system." The system will save the Users Information in a folder (Called UserInfo.txt) (Address, Password, Email etc..), and the folder name being the username of the …

Member Avatar for berniefitz
0
1K

The End.