vba x 200

12,155 Topics

Member Avatar for
Member Avatar for FerrousRex

My company has been using an Access 2003 database for a couple years now and the person who previously worked on it just left, the problem is he never gave me the password to unlock the Visual Basic editor window, and I can't seem to contact him. Does anybody know …

Member Avatar for FerrousRex
0
259
Member Avatar for Entropy1024

I have a .mdb database that contains various records. One of the fields is date, ie '19/10/2008 00:00'. How do I sort the database by date? I an a beginner and currently learning with the 'Visual Basic in easy steps' by Tim Anderson. On page 104 he has an example …

Member Avatar for Entropy1024
0
321
Member Avatar for VBNick

I have been searching the net to find the simplest way to record audio from within VB. I found references to three different groups of APIs for wave in/out functions. Is there any reason I should use one rather than the other? as far as I can tell they all …

Member Avatar for debasisdas
0
113
Member Avatar for ChroNoS

Is there any way through which I can split a single string into substrings with 20 characters each. The first string should contain first 20 characters. The seconds string should contain the next set of 20 characters and so on. Is it possible to do what I'm thinking?

Member Avatar for rstkw
0
122
Member Avatar for Entropy1024

If I create a database that has 3 fileds per record; [I]String1[/I], [I]String2 [/I]& [I]ResultString[/I]. I want the user to enter in the first 2 strings then the program creates ‘[I]ResultString[/I]’ by adding the String2 to String 1 itself. Ie if you enter Big as [I]String1 [/I]and Cat as [I]String2 …

Member Avatar for rstkw
0
172
Member Avatar for ChroNoS

I have written a program, it uses a lot of replace funtions with huge amounts of texts. Resultingly, It takes hell lot of time to operate. Is there any way I can increase its speed?

Member Avatar for rstkw
0
123
Member Avatar for pardeep3dec

Dear Friends, I am attaching my test project with this mail. It will run on sharing folder and many user will access that programme but it is showing file already in used message; I am trying avoid this problem by my test project this programming will showing ip and computer …

Member Avatar for rstkw
0
112
Member Avatar for thakkarps

Hello, I am new to excel or vba i want to convert a data to export it to some output folder from a csv files from input folder there are 100's of such file in c:\raw which i want to work with the input file's details are the headers of …

0
44
Member Avatar for jeswills

I think i need a group of developers i can work with. I am a student of the university of london. My problem is using excel, if you scan it auto retrieves the serial number unlike ordinary textboxes. Please how can i make my program compactible with a hand scanner

Member Avatar for rstkw
0
62
Member Avatar for bruce_geo75

[B]hi everybody im new here and new in vb also and i need some help to learn vb.can i find somebody to help me ? plz.thanx.[/B]

Member Avatar for rstkw
0
108
Member Avatar for VBNick

Hi...I am making a speech recognition program for my own personal use, because I don't like the way the built in vista speech reco software works. Here are my questions: 1. when I open the app that I programmed in VB, it automatically opens vista's built in voice recognition software. …

Member Avatar for VBNick
0
162
Member Avatar for pardeep3dec

Dear Sir, My project uses Ms Access as back end tool and visual basic as front end tool. I have a problem when i run my project's tmgmt.exe file more than one time then it shows tmgmt.exe file entry into taskmanager's process tab. Suppose i used that file 4 times …

Member Avatar for sendoshin
0
282
Member Avatar for lostandfound

Just for anyone, who, like me, has got along using VB6 without the mousewheel whilst editing in the IDE. Until today I just assumed it wasn't an option. There is a simple fix in the form of a free addin from microsoft. [URL="http://support.microsoft.com/kb/837910"]http://support.microsoft.com/kb/837910[/URL] What a difference!!!!!!:$

Member Avatar for lostandfound
0
125
Member Avatar for rstkw

I have a degree in engineering. I spent 16 years in the military. I never liked computers until I built one. (Remember DOS 2 and the NEC V-20 processor chip?) I spent 10 years as a controls systems engineer, which, in my case, meant programmer. Visual Basic was forced on …

Member Avatar for jbennet
0
92
Member Avatar for K.Vanlalliana

Hi, all programmers of this Forum, I am using MS Axcel 2002 and I am trying to format Excel Sheet from VB so as to make a border within the selected cell. My CB code is as under and when I run this, it select the specified rangge, but no …

0
124
Member Avatar for nirav0190

Write a program counts in a given text the words that contain at least three different vowels (Vowels are a, e, i, o, and u). Words in the text are all lower case and are separated by at least 1 space, maybe more. The last word in the sentence ends …

Member Avatar for vmanes
0
105
Member Avatar for renjulekshmi

HOW TO USE THE FLEXGRID CONTROL FOR DATA ENTRY.......... responses are highly appreciated...............!!!!!!!!!!!!!!!!

Member Avatar for jireh
0
121
Member Avatar for nagatron

Hello to all, I have a problem in connecting VB6 to MS Access 2003. I have tried all the instruction posted here in forum until the message appear every time I run the program "Supplied Provider is different from the one already in use." What does it mean? I am …

Member Avatar for jireh
0
193
Member Avatar for nish88

hi all, i am using ms date and time picker and am unable to assign a value to it. i am getting the error read only property. can anyone tell me how to solve this? thanks

Member Avatar for abu taher
0
106
Member Avatar for LostInVB

I have put together this whole network account creation and audit process. The creation process starts with importing data from our ADP system into SQL 2005 and creating a .csv file for each of the 12 sites to create the network accounts, based on job title. Then I add in …

0
35
Member Avatar for K.Vanlalliana

I am doing one project in which Whenever I export the result, the list of record should be extracted as Excel file and the list of record should be listed within Excel Table with formated Line. So, I want to format Excel from VB so as to make line / …

Member Avatar for K.Vanlalliana
0
222
Member Avatar for Oscar G. Gidei

i want to link my forms with access tables and dont want to use the odbc object. i need to use the ADO is it posible and how. for in my first instance it worked, but when i moved it to another computer it signaled "Canot find database" Help pliz

Member Avatar for jireh
0
202
Member Avatar for dreamgirl

hello, well my question is that when am creating a standard vb calculator, am unable to display the number 1,2 and so on the textbox?? How do we do that? Thx in advance

Member Avatar for Froot Loops
0
144
Member Avatar for cgeier

Does anyone know how to communicate with a Unisys UTS60 system in Visual Basic? I'd like to be able to send commands and receive data.

0
100
Member Avatar for furjaw

Visual Basic 2005 Professional Edition: I need to drag and drop an image from one PictureBox to another PictureBox where: 1) the image is visible while being dragged 2) the image can be dropped at any location within the target PictureBox 3) the image can be rotated within the target …

Member Avatar for prasantha60
-1
114
Member Avatar for hightert

I am new to vb6. I am trying to automatically click a button on a web age. I keep getting the run-time error 91, object variable or With block variable not set at the line doc.All("btnAcknowledge").Click. I have also set the HTML object library. Can I get some advice. Here …

Member Avatar for hightert
0
114
Member Avatar for DhruvaRai

Hi there I would like VB6 procedure to execute the TAB key as soon as the maximum length data is entered on the text box without having to press the TAB key. Text box has a maximum length of 5 characters. What code do I use to automatically move the …

Member Avatar for jbennet
0
115
Member Avatar for terrible@VB

So I'm taking this introductory class on Visual Studio 2008 and I've been pretty lost since it started. Our current project is to write a code that will allow you to type in a starting and ending point then click the calculate button to calculate the factors of each number …

Member Avatar for jireh
0
181
Member Avatar for andyhopper

i am trying to create a button that will open a database from a vb6 system. I have got so far but i dont know what is meant to go instead of [B][U]Database[/U][/B] Option Explicit Dim ACC As Access.Application Private Sub btnDatabase_Click() Set ACC = New Access.Application ACC.[B][U]Database[/U][/B].Open "" ACC.Visible …

Member Avatar for andyhopper
0
112
Member Avatar for regalla

Dear friends, i want to pass data from one form to another form which is having back end ms access table1 for form1, table2 for form2 connected to forms with databound controls data1. my problem is while entering data in text1 of forms1, it should go to text1 of form2 …

Member Avatar for jireh
0
163
Member Avatar for dcparham

folks, trying to pass variable from test1.html to test1.asp. simplest code possible, even works on our ISP host, but not my web server. please help?? code for test1.html, which calls test1.asp: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>A.html which calls B.asp</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> …

Member Avatar for dcparham
0
277
Member Avatar for ninjakx

Ok I have a project in which I must find the days active each project took based on dates. Assuming the project has an end date. For example I have the Date Initiated as 2008-Sep 29 05:09pm I have Task Ready 09/29/2008 5:21PM I have Task Done 9/25/2008 05:25PM I …

Member Avatar for Jx_Man
0
95
Member Avatar for jammiedude

Could anybody help me with a problem i have? I have a budget sheet and a list of incomes and expenses, and i need to be able to search a specific column and look for a certain text like general ( which may be displayed as "Commission - General") then …

Member Avatar for K.Vanlalliana
0
108
Member Avatar for ben_harvey327

hi all i have a program that has message boxes, the msgboxes have help buttons and ok buttons, the coding of the ok button is simple but how do i code the help button i have tried so much but i failed. i really want it to be a hyperlink …

0
63
Member Avatar for noobguy

I created a Class That takes gallons of fuel and Mileage then gives the total Mpg. I need it to give the mpg after both the gallons and mileage are entered and also the total Mpg. [code] Public Class MilesPerGallon Private mileCount As Integer Private gallonCount As Integer Private mileTotal …

Member Avatar for jireh
0
98
Member Avatar for sarifah

hi i have a problems. can anyone help to settle this problem? for exp; a person will know about their status that he must pay the fines he borrow my pencil.after 3 days, he must pay the fines. 1 late day, he must pay rm1. it will also automatically calculate …

Member Avatar for Teme64
0
121
Member Avatar for dirtyhiphophead

I am working on a media player for my final year project using vb 6.0. i am trying to avoid exporting of songs that have being imported or played with the player.I was thinking if there was the option of changing the music format to a format that most operating …

0
65
Member Avatar for jammiedude

Hello, if anyone can help with this I would much appreciate it. I am writing a macro within vba for excel, and i have successfully managed to use the shell command to call my batch file but, how would i program the rest of the macro to carry on when …

Member Avatar for jammiedude
0
244
Member Avatar for pardeep3dec

'I am putting my folder in sharing then try to use these from different pc but it shows 'file already in used PLEASE GIVE ME SOLUTION [code=visualbasic] Dim dblogin As New ADODB.Connection Dim rclo As New ADODB.Recordset Private Sub cmdok_Click() dblogin.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\tmgmt.mdb;Persist Security Info=False" rclo.Open …

Member Avatar for AUGXIS
0
161
Member Avatar for noobguy

I am new to this forum so please enlighten me. I posted a question that I needed help with about 4 hours ago since then there has been several visitors to the post but no replies. Is it that the question was too hard or worded incorrectly please tell me. …

Member Avatar for Narue
0
108
Member Avatar for laoballer

Hi all, I'm in need of a way to decompress .gz files that will be downloaded from the NCDC. These Files contain weather information that will be used for some analysis work. My problem is I have a vb6 application and would like to be able to decompress these gzip …

Member Avatar for debasisdas
0
177
Member Avatar for TOROOOLOLOOLO

Guidelines on how to use the package wizard to package vb6 and ms access database.I don't know my way around it. Please help.

Member Avatar for debasisdas
0
68
Member Avatar for nish88

hi all, i am doing my school project where the user can upload picture and store it in the database. actually like on web page when you are uploading picture you get a window with a browse button. i want to do something similar in ms access 2003. i have …

Member Avatar for debasisdas
0
100
Member Avatar for K.Vanlalliana

I want to make line in Excel with a click of my VB Form button, but I do not know the correct code, can any one help me.

Member Avatar for hell_tej
0
113
Member Avatar for hell_tej

Hi Folks, I Trying to Copy File UJF.mdb in another Location which is User Specifyed. I Closed All Connection, But Still ERROR 70 'Permision Denied' Occurs :'( [ICODE] rs.close con.close FileCopy "D:\UJF\UJF.mdb", "D:\Person.mdb" MsgBox "Backup Successfully Compleated", vbInformation [/ICODE] How to Copy Access 2003 .mdb File to Another location Without …

Member Avatar for hell_tej
0
213
Member Avatar for pardeep3dec

Hi friends, Please give me the solution of making a project multiuser on LAN. I am using Ms Access as backend tool. When i run that programme on another PC then it shows file already in used and programmes goes out. Pardeep

Member Avatar for hell_tej
0
127
Member Avatar for hell_tej

Hi friends, I m creating a software with backend of ORACLE 9i. I need to Generate backup ORACLE "ADDFILDP" table to ACCESS "ADDFILDP" table(Simply Copy the data to one table to another[ORACLE to ACCESS Table]):$ An access File is already Created. I was code for it as Follows [ICODE] Private …

Member Avatar for hell_tej
0
112
Member Avatar for Bhatti302

Dear I think I Solve Your Problime. When You Open Your Curent Form VB use Private sub Form1_load() endsub this Code is used for Form Load. When You Form Load You enter the following Code Private sub form1_load() text1.text="" text2.text="" text3.text="" text4.text="" Command1.Enable=false Msgbox "Enter All Deatiles && fill All …

Member Avatar for jireh
0
107
Member Avatar for swapna7999
Member Avatar for jps447

Hi, Please help me on how to control remote parallel port using vb? I already know how to control the local parallel port but I still need additional parallel port to be used on my current project.

0
77

The End.