vba x 200

12,155 Topics

Member Avatar for
Member Avatar for bops

hi everyone, I am doing a project for college, which involves programming using VBA in Excel. I have most of it sorted and i am having trouble on this 1 part. I need to find out how to use variables to access a sheet and range within the spreadsheet variable1 …

Member Avatar for bops
0
217
Member Avatar for Sam Lehman

I'm making a program which sends a specified line of text to the active window when you press a specified hotkey. I've figured out how the hotkey part, but have no idea on how to send the text to the active window. does anyone give me some ideas on this? …

Member Avatar for BountyX
0
275
Member Avatar for Lunaticrr

I have 3 text boxes and one command button on this form. Users are supposed to input something into text1 and text2 and click the command button for text3 to show the results. However I would like the programme to consider the values of text1 and text2 and based the …

Member Avatar for jwshepherd
0
158
Member Avatar for tom_h_500

I was wondering if it was possible for me to write a simple program that either lets you use command prompt with visual basic (i.e. press a button and it does a command in CMD) if it can't be done in VB is there any other programming languages that allow …

Member Avatar for jwshepherd
0
206
Member Avatar for Lunaticrr

I know pictures can be added to picture boxes and backgrounds by using the "Properties" and adding something to "Picture". But I want to know how I can actually get the program to display an animation or picture say, after inputting something into an inputbox, or say after a particular …

Member Avatar for jwshepherd
0
241
Member Avatar for user777

Hi, I am using ADODC Connection. I saw in one project it is written as following: Dim rsT As New ADODB.Recordset Plz let me know whether ADODC=ADODB. And can we change the above example as below: Dim rsT As New ADODC.Recordset

Member Avatar for Alvein
0
166
Member Avatar for user777

Hi, Could somebody write code for search button plz. I am attaching the project here. Thanks in advance for any help.

Member Avatar for w00dy
0
129
Member Avatar for user777

Hi, I would like to change the caption of "ADD COMMOND BUTTON" to "SAVE" when it is pressed at run time. Could somebody is there to help me in this regard. Thanks in advance.

Member Avatar for jwshepherd
0
325
Member Avatar for SpS

Basically what i want to do is....whenever i drag the form...i should be able to see the current top and left coordinates...i know there is a resize event but it does not updates top and left...it only updates height and width.... is there any way to simulate reposition event

Member Avatar for SpS
0
93
Member Avatar for user777

Hi Could somebody let me know in the following project which is attached herewith how to write code to auto calculation for the following: Opening Balance & Balance Amount The above two text boxes should be updated and show the calculations automatically when we fill in remaining text boxes. Thanks …

0
72
Member Avatar for user777

Hi, friends! Could somebody tell me what code should be written for the following buttons to search the database ( I am using ADODC CONTROL) : Find First Find Previous Find Next Find Last I will be grateful for any response...

Member Avatar for user777
0
182
Member Avatar for effigy

Hi everybody, I want to print screen my form, if I press Print Scrn button, its can to print at the printer.How can I do? Give me pls.

Member Avatar for jwshepherd
0
201
Member Avatar for Thong_Ispector
Member Avatar for purplegerbil
0
109
Member Avatar for hoyasaxa

For those of you who have ever had a problem with this, there is a simple solution... You need to re-register Jscript.dll and Vbscript.dll Its very simple-- Click Start, and then click Run--In the open box, type regsvr32 jscript.dll, and then click OK. --Click Start, and then click Run again …

Member Avatar for joowithau
0
193
Member Avatar for Lunaticrr

How do I get my text boxes to automatically highlight the default text so users can start typing without having to delete or highlight it themselves?

Member Avatar for Lunaticrr
0
118
Member Avatar for cmdolcet69

I'm having this issue on how to sort reports based on part numbers i have part numbers that i return have either a part number as in 1000 or if there have been multiple part number could be 1001-2 mean that there were 2 revised copies of the part number. …

Member Avatar for jwshepherd
1
190
Member Avatar for purplegerbil

Hi, Is it possible to measure the width of a line of text saved into a variable. i.e. strData = "XXXXXX" length = 12 strData = "iiiiii" length = 4 Any font can be used as the data isn't going to be output on screen. The reason: I have a …

Member Avatar for purplegerbil
0
524
Member Avatar for Thong_Ispector

I wrote a simple program that displays a picture. On my computer it looks fine. On my neighbors it is bigger than his screen.. Both computers show the same resolution under properties His machine has onboard video... Oh, the program is fine on my laptop as well. Image is 500 …

Member Avatar for Thong_Ispector
0
131
Member Avatar for LIMS2LIMS

Hi, (MS Word XP and Outlook XP) Can someone give me the VB code to set up a macro (command button) so the end user can click within the word doc and it will email to the coded recipient? Hope this isn't asking to much. ;) Thanks as always

0
68
Member Avatar for srikkanthan

I have an issue like, I need to insert data from an XML file into MS Access table. I am able to do this with ADO as one by one row. But this terribly hits the performance when the number of rows to be inserted exceeds 1000. Kindly help with …

0
66
Member Avatar for Burndailer

Hello, I've a question about the helpfile in the menu of vb. I'm working now 1 year with this program on my notebook, but today i get suddenly a error when i choose help or index in vb6 menu. The error says : busy to try using a not compiled …

Member Avatar for Burndailer
0
92
Member Avatar for fearless®

Hi, all. How seeing callerid with VB6. But, are you this function all modems supported? What do it. Thanks. Sorry, I'm :rolleyes: writing English.

Member Avatar for fearless®
0
137
Member Avatar for LadyFinger

i'm creating a password using VB6 and SQL 2000 as da db. my problem is i don't no how to connect the password table in db wt the textbox. so guys, any idea ?

0
80
Member Avatar for clam

Hi all, I have had some experience using pointers in C and C++, but not in VB6. I am using a function that requires as an argument (ByVal lPtrBuff As Long, ByVal lWriteSize As Long). I am assuming this means a pointer to the beginning of the data I want …

Member Avatar for clam
0
132
Member Avatar for johnroach1985

hiya all.The problem is this i have created this Form1.exe in visiual basic.But I can't seem to be able to erase it.I tried everything.First I tried shift+del then i went like to safe mode from admin than from my normal user name but each time i try to erase it …

Member Avatar for johnroach1985
0
125
Member Avatar for switty

hello everyone! I'm new in vb6 and i have to create a program that simulate a round robin scheduler....using two concurrent prorams....i already know how to use the winsock and how to send the data in the server but my probel is what will i use if i have a …

0
101
Member Avatar for Thong_Ispector

I need to know if there is a command to eject removeable media. I am not trying to physically eject a floppy, I am trying to clear a compact flash card for safe removal... Thanks in advance...

Member Avatar for Thong_Ispector
0
106
Member Avatar for buzzmethru

Hi Im new here ... I was wondering if anyone could help with the following ...[URL=http://myweb.tiscali.co.uk/buzzmethru/buzzmethru/vb6/no_mouse3_HELP.zip]click for zip vb6 file[/URL] This is my 4th week with VB6 - previously my only coding experience was with PLC's writing using ladder logic, Omron specifically, I hope it is a silly mistake on …

Member Avatar for buzzmethru
0
131
Member Avatar for clam

Hi Guys. Basically I was wondering if it is possible to Append to the START of the file, instead of the end? For a bit of background information, I have a lump of raw data in hex (they are samples collected from a microphone on a microcontroller then transferred to …

Member Avatar for Thong_Ispector
0
237
Member Avatar for Thong_Ispector

I seem to be leaving something running when trying to exit my program. If I use the X in the upper right or the click event to UNLOAD I can still see the program running in the task manager and it will not let me run it again until I …

Member Avatar for jwshepherd
0
107
Member Avatar for TetuGal

Hello I am going into my final year in september and need to come up with a topic for my final year project. I am studying Software Engineering. Any assistance will be highly appreciated. Kind regards

Member Avatar for Kiba Ookami
0
276
Member Avatar for c#dummie

hi im doing parameterized query whereby the user has to enter id and password. im using access database to store my data and using visual studio .net 2003 to build my app. if the id n password match, data is retrieved. i need help to ensure that password typed is …

Member Avatar for plazmo
0
114
Member Avatar for Kiba Ookami

I am trying to Install VB6 Enterprise Edition but I keep getting the following error: C:\WINDOWS\SYSTEM32\AUTOEXEC.NT. The system file is not suitable for running MS-DOS and Microsoft Windows Aplications. Choose 'Close' to terminate the application. Now, I've had this issue previously with some older games I've tried to install and …

Member Avatar for w00dy
0
141
Member Avatar for Nonie

Pls. help me. I have a list box that connect to a dao table. The list box is populated by a pnr_no field from that table whenever a command button is clicked to make it visible. From the list box, I can click whatever PNR No. that was displayed in …

Member Avatar for Nonie
0
100
Member Avatar for Burndailer

Hello people, I've a question about the next thing. I want to make a program with vb6, so when i type a line in a textfield and i push a button that the line will be saved into a text file. If i then push another button the saved text …

Member Avatar for Marikanna
0
111
Member Avatar for switty

hello! is it possible that the two windows of a vb6 program are running? How? can you give me one example just to show so that i'll be able to understand...thank you very much! :lol:

Member Avatar for Marikanna
0
77
Member Avatar for MrConfused

Thus far I have always chosen the font Courier New because all letters are the same width. Is there any way of determining how "long" a string will be when using other fonts? I would like a way of checking the string's actual length so I can format a printout …

Member Avatar for MrConfused
0
197
Member Avatar for c#dummie

im a total newbie to c#, visual studio .net 2003 and even Access database 2000.. im doing my forms using visual studio and my data are all stored in access db.. i've some vague concepts abt how to design my app.. im not sure it'll work as i do not …

Member Avatar for nattylife
0
156
Member Avatar for abhay_fgr
Member Avatar for nel_cr

Hi: I need to join 2 wavs into only one, How can do it this in VB6?? Thank you

0
58
Member Avatar for Gotmad

i get this error Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/gonemad/public_html/Forum/upload/includes/config.php on line 42 thanks in advance

Member Avatar for Gotmad
0
144
Member Avatar for cancer10

Wot is the difference between declaring a Global Variable and a Public variable? I mean both variables can be accessed through out the project so wots the main difference apart from that Global variables cannot be declared in forms but modules only?

Member Avatar for jwshepherd
0
328
Member Avatar for rhari_81

Respected Sir/Madam, I am a beginner in vb programming and i want to try out some applications which might make me more confident.So,can you guide me what type of applications can i try and how to proceed further for implementing the same.Awaiting your response for the same. Yours Sincerely, Harish.R

Member Avatar for ndw2004
0
200
Member Avatar for meij023

Hi you all, I have the following problem: when (in VB6) the application runs and the form is docked (in the taskbar), there is a popup of the application whenever there is text written to the textbox on that form. How can I avoid the popup?

Member Avatar for meij023
0
122
Member Avatar for bourgm

I'm not a VB programmer.. Tinker here and there.. I know this is a very easy question.. In a Microsoft Access Database I have a Table called "inventory". In "inventory" i have a field called "location" that I want to go to null after I update another field. I know …

Member Avatar for jwshepherd
0
122
Member Avatar for Damon999

When I restart the server on my network, the mapped drives on the client computers disconnect (bacause the folders are no longer available as the server is restarting). Is there a way to get the mapped drives to automatically connect when the server has booted back up. They do it …

Member Avatar for w1r3sp33d
0
113
Member Avatar for sowmiya

how to write coding for undo operation in a simple text editor.I tried it but i couldn't do it.plz somebody help me. :?:

Member Avatar for jwshepherd
0
137
Member Avatar for Nonie

Kindly help me. I am new to VB and also in SQL database programming. I am doing a small library system consisting of 3 tables namely: Member which has Mem_Code as primary key, Name etc., Book which has Book_Code, Book_Name etc.and Issue which has both Mem_Code, Name, Book_Code and Book_Name …

Member Avatar for jwshepherd
0
192
Member Avatar for mwaora

Hi there, Apparently i have developed a tea auction system and one of the requirements that have come up is; [B]To generate invoices for each client, check the email address of the client and then generate emails for each client. So when the user opens the default mail browser he …

Member Avatar for jwshepherd
0
602
Member Avatar for paladin4service

I am trying to build a scientific calculator. However, I have two major problems. 1. The decimal to separate the tens from the tenth 2. Modulus which outputs the remainder of the division of two numbers. Remainder = dividend – quotient * divisor; I can get the rest, but I …

Member Avatar for Ancient Dragon
0
261

The End.