A1VBCode Forums / Classic Visual Basic (VB 6 or earlier) / General Visual Basic

help and add code please help

anonymous8255 — Sat, 21 Jan 2012 12:23:47 GMT

Hi everyone, im making a replacement shell, i want to make one that will take over windows explorer, and i got it all done but the problem i have is, i want to open a text program that i made built into my program, and i want to save it to my shell desktop with icon and i want to make a folder just like what windows dose, please help thanks.

VB Code for data entry form

spruchni — Wed, 26 Oct 2011 13:05:06 GMT

Here’s my situation: I have not used VB for awhile, and I am looking to create a user-friendly program in which data entry people can input information about customers.

Fields to be included on first form
First name
Last name
Address
City
State
Zip
Email

What would be the appropriate coding for this?

It would be really appreciated. Thanks.

Please help about multiple replacing text in text file

kristian17 — Wed, 18 Jan 2012 22:44:37 GMT

i have a question about multiple replacing text
this are the scenario

to be replace=9999 new value=9000
9999 9000
9999 9000
9999 9000
9999 9000
9999 9000
9999 9000
9999 9000
9999 9000
9999 9000
9999 9000

please help it will replace line by line and if the line > 999
the new value will increment into 9001 please help

connect my access form photo to vb6

cabdiqani — Sun, 10 Apr 2011 03:09:21 GMT

iam preparing a project which is school database managment system so in registeration i went to do one condition that is every student must have his photo so a create form in access which is called registration so i want to connect my reg form to the vb form and the photo appear to may form and i can upload so help me do ing that

Three Level hierarchy using MSDATASHAPE [Resolved]

chaw12 — Sun, 15 May 2011 09:50:51 GMT

hi...

i have this code:

Set rs = conn.Execute("SHAPE{SELECT * from tblemployee} " & _
"APPEND((SHAPE {select * from tblcharge} " & _
"APPEND({select * from tblpayment} AS charge " & _
"RELATE eeid TO eeid)) AS payment " & _
"RELATE eeid TO eeid)")

i have my report working when i used the simple relation hierarchy of it but with the above code, i just can't get it working it give me an error like "Data Field 'charge.slo' not found". 'slo' is found on tblcharge.field

please help....

Edit: Keith [Resolved] and Bold corrected.

Aren't you going to tell use how?

Converting Variables to byte arrays

Perrie — Tue, 31 May 2011 06:58:39 GMT

Ive just discovered winsock doesnt like User Defined types so I figure it will be easier to convert the entire block of data into a byte array, send that and then convert back into its components in the type at the other end.

Bytes and strings are easy to do but I cant seem to find any reference as to how integers, long integers, singles and doubles are assembled except for how many bytes long they are.

I know that 1 bit is used to determine if the value is positive or negative but is it the most or least significant bit and in what order are the bytes stored to create the value.

Function Rounddown in excel how above in vb

zikri_aushaf@yahoo.co.id — Wed, 16 Nov 2011 01:52:56 GMT

Hello

How to Rounddown Example 1.250.525 rounddown to 1.250.000, if in excel it can automatically

but how above in vb please tell me

Thank's

Need Your L'll Help

hannahraasch — Tue, 06 Dec 2011 07:57:33 GMT

Database Access with the Data Control : Could you provide me some detail about this. Any tutorial or related materials like aerticles, blogs etc. anything..

Autofill password to open a pdf file in adobe reader

murali.sidd — Mon, 14 Nov 2011 12:52:27 GMT

Here is my situation, I use to get a lot of mails from Incometax department where they send PDF attachments which are protected with a unique designated password. lets say a password as birthdate in ddmmyyyy format. I will have a database of those passwords in one excel file. but i want to automatically fill the password in the reader so that opening the file becomes easier. If somebody could help me find a code for it I would appreciate it. Thank you.

how do i make VB6 program RUN on LAN

Segzysoft — Thu, 10 Nov 2011 06:42:16 GMT

how do i make VB6 program RUN on LAN, I dont mind if i can even get a small code that can accept a personal details under a LAN using MS Access.

VB in place of Perl

TheatrePete — Thu, 03 Nov 2011 23:08:24 GMT

I am the website administrator for an amateur theatre society. On the website there is a facility for booking seats on-line. It’s in an HTML file with a Form used to take and Submit data.

While I understand that Perl language is nearly always used to communicate between the user and the server, I hear that Visual Basic can also be used, and since programming in VB is something of a hobby for me, I’d really appreciate some help. My efforts so far to find some direction have been fruitless.

I’ve downloaded Perl sample scripting off the Internet, but cannot manage to get it all working. Nor can I find anything where VB is used. Can anyone suggest a VB scripting solution?

Please help.

96 h & no success with proxy login

whistler — Fri, 14 Oct 2011 10:42:03 GMT

Hello, once again

I have a very BIG problem. I made program that connect to proxy server and browse via proxy server. However, my company has a made private proxy server which I must authenticate through to get to the internet.

I read hundreds pages of docs, but without success. My program code look like so:
[CODE] module:
Public Declare Sub UrlMkSetSessionOption Lib "urlmon.dll" _
(ByVal dwOption As Long, ByRef pBuffer As Any, _
ByVal dwBufferLength As Long, ByVal dwReserved As Long)

Public Type INTERNET_PROXY_INFO
dwAccessType As Long
lpszProxy As String
lpszProxyBypass As String
End Type
Public Const INTERNET_OPEN_TYPE_PROXY = 3
Public Const INTERNET_OPTION_PROXY = 38

Public Declare Function InternetSetOption Lib "wininet.dll" Alias "InternetSetOptionA" _
(ByVal hInternet As Long, ByVal lOption As Long, ByRef sBuffer As Any, ByVal lBufferLength As Long) As Integer
Public Declare Function InternetSetOptionStr Lib "wininet.dll" Alias "InternetSetOptionA" _
(ByVal hInternet As Long, ByVal lOption As Long, ByVal sBuffer As String, ByVal lBufferLength As Long) As Integer

form:
Private Sub Command6_Click()
Dim ipi As INTERNET_PROXY_INFO
dim username as string
dim password as string

ipi.dwAccessType = INTERNET_OPEN_TYPE_PROXY
ipi.lpszProxy = "46.37.165.113:17890"
ipi.lpszProxyBypass = ""

username = "america01" 'proxy server ID and PASS real and WORKING
password = "YpEEJy8u" 'proxy server ID and PASS real and WORKING

call UrlMkSetSessionOption(INTERNET_OPTION_PROXY_USERNAME, username, sizeof(username), 0);
call UrlMkSetSessionOption(INTERNET_OPTION_PROXY_PASSWORD, password, sizeof(password), 0);
call UrlMkSetSessionOption(INTERNET_OPTION_PROXY, ipi, Len(ipi), 0)
Form1.WebBrowser1.Navigate "http://whatismyipaddress.com/"
[/CODE]

What wrong I`m doing ?

Data report help...

chaw12 — Sat, 07 May 2011 11:17:04 GMT

hi...

i am developing a program and access is the database that i choose as backend. i am having a trouble on using the data report. i have 3 tables and all of them are linked by the employee id

table1-consist of names
table2-consist of their charges(amount)
table3-consist of their payment in charges

below is the sample query that i made to linked the 3 tables

"Select table1.*,table2.*,table3.* from (table1 INNER JOIN table2 on table1.eeid=table2.eeid) INNER JOIN table3 on table1.eeid=table3.eeid where table1.eeid="string""

i set the connection of data report on the ff:
set datareport.datasource=recordset

and i also set the datafield of the textbox inside the data report.

when i execute the program, the system doesn't give me an error but the data report show no data on every datafield.

what could be my mistake. please help...

thanks....

Auto Sum on excel through vb6

chaw12 — Wed, 12 Oct 2011 23:32:00 GMT

hello!!

ive create a program and one of its function is to export report into excel file but my problem is i dont know how to auto sum the amount for each record example employee1', it is a charge management system it is where the penalty of employee is recorded. and i want to auto sum each of their recorded amount on one excel report, please someone give me a hint..

thanks,,,

Digitize Part of Bitmap Image

La Vesey — Tue, 27 Apr 2010 12:18:23 GMT

I am a raw beginner to visual basic (I have ver. 6), I do have some experience with quickbasic 4.5 which is not visual.
I need code to open a large bitmap image in JPG format, size is 2300 by 2697 pix and my screen size is 1024 by 768, placing it on a background ( or layer), which will not be saved. Then on an active layer I want to draw parts of this bitmap image in as points (nodes) and lines, or ploylines, and when done, save this vector data (layer).
Then I want to export or save this vector data to a file in plain text.

Looks like what I need to do is write code for a "picture box" in order to load (open) the jpg bitmat, --- then ---

write code for recording (appending) the screen coordinates of each mouse click, to an ascii text file.

I have read general books for V B but it appears they are assuming that I already know what is going on, which I do not.

There are commercial programs which will do this, but they are very expensive, and the beauty of writing my own is that I have some control over how it works.
La Vesey

Please I need a code that can send sms to a GSM phone using VB6. I am working on my project and i want to introduce GSM phone alert.

Segzysoft — Tue, 11 Oct 2011 15:33:22 GMT

Please I need a code that can send sms to a GSM phone using VB6. I am working on my project and i want to introduce GSM phone alert. I will be glad if i can find a help. I know i am with the right people that heve good program skills

vb6 application to run on mobile phone

chaw12 — Sat, 16 Apr 2011 21:38:43 GMT

hi..

is it possible to run vb6 project .exe on bb 8520?if it is possible can u please give me a hint or a link on how to do it?

thank you

How to monitor network users?

daveofgv — Sun, 11 Sep 2011 12:25:15 GMT

Does anyone know how to monitor all network users activity (create, delete, move, etc... files/folders)?

Please let me know.

Thanks

daveofgv

Deployment of sql database Please help

chaw12 — Sun, 11 Sep 2011 09:44:09 GMT

hi,,

i have created a stand alone program and i use MySQL 5.0 as the database and i already compiled it to .exe. but my problem is when i installed and run it on my laptop as i have created the program on my desktop, the database could not be read, it says unable to locate/read the database blah blah, my question is , do i need to install also the Mysql 5.0 on my laptop where the program is installed? my laptop has no programming tools installed on it... please help

Please, how can i save image using VB6 and Access

Segzysoft — Tue, 23 Aug 2011 18:00:00 GMT

Please, i need someone to help me out. I am trying to work on my project " Student Information system which will involve saving passport photograph using VB6 and ACCESS database

Insert Data into Excel file through VB 6

vbraval — Thu, 23 Jun 2011 03:03:25 GMT

i want to make simple VB Form where i am inserting numbers and that Numbers will be stored in Excel Spreadsheet.
so Please Need help ..
How can i insert, Delete, update, Data into Excel Spreadsheet Through VB 6

Create New Worksheet With Data From Another Worksheet By Part No

bstafford — Wed, 27 Jul 2011 00:02:09 GMT

Hi,

Can anyone help me with this please?
See the details in the post below
Regards

Bill

Stop Watch Program?

Black Out — Fri, 08 Jul 2011 13:41:29 GMT

I have a little experiece with Visual Basic 3.0, but I have not written code in quite a while. I would like to write a stop watch program that would get inputs from external photoelectric sensors. The sensors will be placed 200 feet apart on a pond to measure top speeds of radio controlled boats. Is this possible? Would there be any other hardware needed to link the photoelectric sensors to the computer? I assume there might be a piece of hardware that plugs into a USB port and then the sensors can be linked up?

Thanks for any help.

vb GRAPH DATA ACQUSION

skvelinfotech — Thu, 14 Jul 2011 01:51:13 GMT

FROM GRAPH DATA ACQUISITION READ DATA DISPLAY AND SAVE

Help with vb6 color pallete

chaw12 — Sat, 04 Jun 2011 11:15:18 GMT

Hi...

my vb6 color pallete is having an error. ive been using the same application then suddenly i just noticed that in all controls in vb6 each time i go to any properties that has color on it and click on Pallete Tab, well the color pallete doesnt show any color and if i run my mouse over it then the color boxes will appear but with no colors. how did this happen. thanks..

Data Transfer

Perrie — Mon, 30 May 2011 22:34:39 GMT

Im setting up a Server/Client application and using winsock to transfer discrete variables and arrays between the 2 apps but I also have Bitmaps and Wav files to move from one to the other, some of which can be sizable.

Should I stick to using winsoock for them and send as byte arrays or would it be better to use FTP, If FTP would be better,some guide to using FTP between server/client apps would be appreciated.

Photo on data report

chaw12 — Sat, 09 Apr 2011 13:46:15 GMT

Hi..

is it possible to create a report on data report where for example every name will show its corresponding photo in one report? I've been trying to create a report were all employee info with photo will be generated in one report but the problem is, it only shows the first photo on the record on every information of the employee. i already tried looping it but it shows the last photo of the database on every information of the employee. the report only shows one same photo on every information.

please give advice...

thanks...

Subtitle WMP ( sous-titres WMP)

mdegremo — Wed, 11 May 2011 12:05:04 GMT

Avez vous une idée pour insérer un fichier de sous titres (srt ou smi) lors de la création d'un Lecteur vidéo avec Windows media player sur VB ?

Have you any idea to insert a subtitle file (srt or smi) when creating a player with Windows Media Player on VB?

MyDiary Test

Jabdennel — Sun, 01 May 2011 07:24:39 GMT

Hey guys. Just wondering if you could test out my program for me? Thanks ;D

http://uploading.com/files/9c2cmd12/MyDiary.zip/

Username is admin
Password is admin

You can change the settings when the program is run.
All of the data is stored as a string using the "settings" in vb.

THANKS

Updating using dataGrid

chaw12 — Fri, 22 Apr 2011 12:19:30 GMT

hi..

i am having a trouble on how to update the data that is on the data grid. the data grid is bound on the table and now what i want is that each time the user make changes on the data that is viewed on the datagrid, that changes will also reflect on the database.
please help how can i achieve that.

thanks

datagrid properties where also enabled to updating

QUIZ PROGRAM IN VB6, PLEASE HELP

shaan — Wed, 20 Apr 2011 00:06:27 GMT

Hello friends, this is my first post on this website. I am learning how to program in VB6 as I am a student at a college. I need help in creating a QUIZ PROGRAM for a teacher who will create questions and answers himself/herself which will be maximum of 20 questions & answers. I know how to link forms to each other, labels and all the other basic stuff, however, I don't have the knowledge of creating such program that someone will have to make up the questions and answers for their students.

What I basically need help in is that I have to create a text box where the teacher will type in the question and option buttons for the answers but to do this I want to place a "ADD" button on the form so that once it is clicked by the teacher, he/she will be able to make up the questions and answers.

or it can be any other easier way to for the teacher to make up questions and answers that you have in mind and suggest me it. I tried my best to explain easily what I need help in, please let me know if you don't understand properly. Thanks a lot for your help.

listview.ocx

chaw12 — Thu, 14 Apr 2011 20:01:01 GMT

hi..
can anyone of you please give me a link to free listview.ocx in vb6.. im tired of using the default listview in vb6. coz it cant be customized to what the i want. so if someone of you there know a link to a better listview,will you please share...

thanks...

trial aplication

johansoft — Fri, 08 Apr 2011 22:24:37 GMT

Hello programmer vb classic ...
I wanted to ask, I'm making an application
ready made, but there is a problem in the application.
the problem is I want to make a trial form
but who reads the serial hard drives and also create a keygen for the program. please help me

Load image at runtime on data report

chaw12 — Tue, 29 Mar 2011 13:27:32 GMT

hi..

please help how to load a picture on data report at runtime. i am using this code but it always give me an error each time i load the data report.

private sub command1_click()
rs.open"path"
with datareport

set .datasource=rs

.Sections("section4").Controls("RptImage").Picture = LoadPicture(picture filename)
.show

end with

end sub

the error says "Doesn't support object or method"

please give me advice.

thanks...

how to backup and restore

chaw12 — Sun, 20 Mar 2011 23:33:43 GMT

Hi..
can any one please tell me whats wrong with this code...

Open "C:\sample.bat" For Output As #1
Dim str As String
str = "mysql path\bin\mysqldump.exe --host=localhost --user=user --password=pass --database=dbase -r> c:\bck.sql"
Print #1, ComandoSh
Close 1
ProcId = Shell("C:\bck.bat", vbHide)

it only create a text file and bck.sql but it has no record at all.
im using mysql 5.1
thanks

Controlling soundcard VB6

Kiter — Sat, 28 Aug 2010 14:28:12 GMT

Where can I find more information about controlling soundcard (Windows 7)?

Search Box in Visual Basic

bunnyali2011 — Tue, 22 Mar 2011 04:21:56 GMT

Now, imagine there is search box (textbox), and below there are a search button with a rich text box.

My text file located in the drive C is like this:

Product: Cement Size: Big: Cost: 245 Type: Construction
Product: Iron Size: Big Cost: 123 Type: Consruction
Product: Glass Size: Small Cost: 23 Type: Non-Construction
Product: Chocolate Size: Small Cost: 10 Type: Food

I want to search only two types of items in my text file located in drive C, namely: Construction and Non-construction. When the user will type a product name, OR size, OR whatever, he must get results only for the Construction or Non-construction. The user must not get results for the Food. And the user can make misspelling of words in the search, so the Search box must tackle it. And yes, the results should appear on the rich text box on the form itself.

My questions are:

1/ What is the code of doing the Search according the criteria above?
2/ What is the code to put the results on the rich text box?

Thank you!

advanced media player

Kiter — Tue, 22 Mar 2011 15:50:03 GMT

In the past I used msdxm.ocx as media player, but it won't work under windows 7

What media player can I use?

I need:

duration
current position

Kiter

Combobox and MaskTextBox in Visual Basic

bunnyali2011 — Mon, 21 Mar 2011 04:24:44 GMT

Well I have a combobox with 3 items namely: Product Size and Cost.

I have also a maskedtextbox.

If I select "Product" and "Size" on the combobox, I want to disable the maskedtextbox from filling, how must I do it?

Icons

chaw12 — Fri, 11 Mar 2011 09:10:59 GMT

Hi..

Ive been trying to download an icons on the net but every time i put it on the imagelist it always give me an error. can someone please give me a site where i can download icons that can be use in vb6/.net? or maybe a link to a site where i can download a software that can make an icons..

thank you