See Related Forum Messages: Follow the Links Below to View Complete Thread
Database Programming In Visual Basic
hello ,
i am developing a database application using MS access and Visual Basic 6.0.In one of the forms,I have to link 2 combo boxes.
The data in one of the combo boxes depends on the data in the other combo box.
ex. if i choose one value in one combo box then all the corresponding values related to that value should be displayed in the other combo box.
can anybody send me a code for this problem.
thank u
Insert An OLE Image Bitmap In Access 2000 Database Via Visual Basic 6 ADO Controls...
i have quite a problem here...
i have to store a linked OLE Image Bitmap in Access database using my client application developped in VB6...running with ADO 2.6
I must be able to read and write to my table an image that exists on my hard drive.
I can't only store my image path because i have to use a linked image on one of my Access Report using a dependant object linked on this OLE type field which is an image...
If you know how to show an image on a Access Report changing with different field values (image path stored in string field)....please help me too! this could resolve my problem!!
if you have any suggestions or solutions....
i would really appreciate!!!!
Datarepeater With Checkbox In Visual Basic 6
I reqire a code that contains a datarepeater control of visual basic 6 that contains a textbox and a checkbox control.I want the textbox and check box to be updated through vb code.Please help.
Thanks in advance
Manoj
Visual Basic Programming
I have a directive to develop language in VB6 where, when a person comes into the government and the months would go in decreasing order starting with October which is the 1st month of the fiscal year, in other words if the person came in December, since October is the beginning of the fiscal year it would be 10/12 and January would be 9/12 etc., etc. this would be in the FTE Gains. It could be represent by the number "10" or by the fraction "10/12".
However if an employee left in say September, it would be negative "-1/12" for FTE Losses.
Can you give me an example of how this language would look
or if Idid not look at it in terms of a date but rather as a single Integer rather than perhaps "11/12", but rather as 11 or -11 as an Integer rather than in terms of a date, can you give me an example of that or does it do the numbers in rescinding order in other words on the on hand, if a person came into the government in December it would it would be 10 months for FTE Gains if the person left in December it would be -2 for FTE losses, because October is considered the first months in the Fiscal year. Can I do this using an array with two list boxes, one for FTE Gains and one for FTE Losses? Can you give me an example of how that would look?
Attached is what I have done thus far. Any assistance you can provide is greatly appreciated.
Theresa
Programming In Visual Basic.Net
Hello I am in a visual Basic.net class right now. I am having problem trying to get this program to run. This program is programming exercise 11.2 on page 445.
I have to create a file for employee information and call in employee.txt. Each record will contain fields for first name, last name, employee number, and hourly pay rate. I have created this file already. I under this so far, but I don't understand the second part which reads:
Write a second project to precess pay roll. The applicatoin will load the employee data into an array of structure from the file with an extra field for the pay. The form wil contain labels for the information from the array(display one record at a time) and a text box for the hours worked.
A button called findPay will use a for /next loop to process the array. You willl calculate the pay and add the pay to the totals. Then display the labels for the next employee. (Place the pay into the extra field in the array.)
The exit Exit Button will print a report on the printer and terminate the project.(print the array).
Prcessing: HOurs over 40 receive time and a half pay. Accumulate the total number of hours worked, the total number of hours of overtime and the total amoun of pay.
I am very new to VB, and I am have problem with the code in the finepay.
and the code on how to calculate. Can someone help me with this project.
Thanks
Visual Basic Programming
A sample coding to retrieve datas from an mdb file
between two specified dates and
also check whether the
invoice number which we r going to save already exists between two
specified dates
Visual Basic 6 Programming
I am the beginner
I have created 2 forms. "Splash.frm" file and frmlogin.frm.
I have added 3 second delay to show fplash .frm .This is working fine.
After this I want to keep the "frmlogin.frm" open till user enters username and login.
Can somebody guide me?
USB Programming With Visual Basic
Good morning every one,
I have searched through the code guru database for information on an activeX control that I could use
to work with the USB from my visual basic application but have not found any. Would any one be
able to direct me to a site or give me the information if there is an activeX control available some where
to work with the USB like the MSCOMM works for the COM ports?
Thank you for your time.
Regards,
Mary
Programming In Visual Basic
hi every body
i am new in visual basic .Please can you help to learn vb.I does not know how to put the codes.Please i wait your help.
best regards
Visual Basic Programming
hai friends,
i need information about aligning text files by using tab and space function. In order to format text i used rtf file for storing
details. In rtf space and tab function are not working properly.
If i give spc(10) rtf file is not leaving space for 10 but it leaves only
two or three spaces. why such a conflict?
And when i use numbers then how to i get right allignment.
please guide me.
Regards,
Manju
Programming Multiplexer In Visual Basic
Hi everybody. I am a student and I am doing a project using the parallel port to control an interface.Actually it is a sample weaving machine in the lab.My problem is that I have 18 outputs. I have done some search and found I could use multiplexers and get up to 256 outputs.could you please help me. I wish if you could write some samples code to describe the use of multiplexers , how could we use address to communicate to the multiplexers. Please help, Thank you.
Book: Programming In Visual Basic.net
Does anyone know if the awnsers to the programing exercises are available anywhere? Or does anyone have the code for "The Switcher"? (exercise in chapter two involving lightbulbs)
Little Problem In Visual Basic Programming
hey everybody, new guy here. hope I started this thread in the right place.
Simple question (at least I hope it is simple):
Right now, I wish to instruct the program to do the following:
When I click on an image (local picture, bmp, jpg, etc), I want the program to check if this image box has a specific picture, if so, the program should continue, if not, then do something else. This is my line of thinking, but Visual Basic wouldn't accept it:
If Image2 (intControlArray).Picture = App.Path & "/RandomPic.bmp"
Label2="YES" 'or do anything
End if
The problem here is what the program should do if the picture is checked, the problem is that VB won't check the picture for me. whenever it gets to the "if" statement, it stops and says "type mismatch", I don't get it, is that the right way to check pic for an image box?
Please help!
Thanks
Visual Basic 6 Programming Help Needed
I am a beginner at programming with visual basic 6.0 Is there anyone of you guys or people that are expirienced with this program that can help me out with this projects I am doing. I am willing to accept any e-mails from people that want to help me out with this program I would really appreciate the help from any of you guys and gals.
Looking For Review Of Programming Visual Basic.Net
I am just wondering if anybody has read this or has seen a review of the book.
Is the book good or bad ?, would you recommend it?
for reference its
Programming Visual Basic.Net
by Dave Grundgeiger
publisher is oreilly associates
came out in december 2001
*** MIDI And Visual Basic Programming
Hi all, hope you're doing all right.
Just got a quick question for ya. How would I go about playing a MIDI note from pure VB code (with API calls and the like...)? I mean, for example, specifying the GM number, and then the note(s) and then it playing it for a specified amount of time?
Thanks in advance.
MOdem Programming Using Visual Basic
using AT Commands !!!
objective:
To send fax from MS visualbasic6.0
Controls used:
Mscomm controls.
comport used : 1
baud rate settings as per the mscomm control.
Modem used :
3Com U.S Robotics modem ,
class = class1.0 modem, fax modem.
steps involved:
1. Dilaing the remote fax numver , with a modem .
2. establishing communication with the remote fax machine.
3. handshaking with the fax machine.
4. once the fax machine is responded , data is sent in binary format.
modem codes used:
standard "AT" Commands for class 2.0 modems.
program status.
step 1: dilaing the remote fax machine no: accomplished.
step 2: establishing a handshake mode remote fax no:
step 3: sending data.
code:
****......
Private Sub Faxsend() **name of function
Dim i As Integer
Dim a As Byte
Dim pfad As String
Dim dialstring As String
'setting the mscommm port setttings.
MSComm1.CommPort = 1
MSComm1.PortOpen = True
If Err Then
MsgBox "COM Port not available"
Exit Sub
End If
'setting the baud rates.
MSComm1.Settings = "19200,N,8,1"
MSComm1.InputLen = 0
MSComm1.InBufferCount = 0
'variuos AT modem commands are used to send to the modem
'modem reset
MSComm1.Output = "ATZ" + vbCr
If wait("OK") = False Then Exit Sub
'setting the fax class=2.0
MSComm1.Output = "AT+FCLASS=2.0" + vbCr
If wait("OK") = False Then Exit Sub
'local id .
MSComm1.Output = "AT+FLI=" + Chr$(34) + "303" + Chr$(34) + vbCr
If wait("OK") = False Then Exit Sub
'command for Intitialize the fax parameters
MSComm1.Output = "AT+FIP" + vbCr
If wait("OK") = False Then Exit Sub
'entering the number fomr the user
Number = InputBox("Enter phone number:", "05524772")
'dialing the number using ATDT command
dialstring = "ATDT" + Number + ";" + Chr$(13)
MSComm1.Output = dialstring
If wait("OK") = False Then Exit Sub
'controls the mode that modem will act as datamodem.
MSComm1.Output = "AT+FAA=1" + vbCr
If wait("OK") = False Then Exit Sub
'MSComm1.Output = "AT+FDM" + vbCr
'If wait("OK") = False Then Exit Sub
'FLO command selects the method of flow control XON/XOFF=1
MSComm1.Output = "AT+FLO=1" + vbCr
If wait("OK") = False Then Exit Sub
'Enable to fax reception
MSComm1.Output = "AT+fCR=1" + vbCr
If wait("OK") = False Then Exit Sub
'indicates a document is availabel for polling
MSComm1.Output = "AT+Flp=1" + vbCr
If wait("OK") = False Then Exit Sub
'indicates whether the originating station wiches to poll
MSComm1.Output = "AT+FSP=1" + vbCr
If wait("OK") = False Then Exit Sub
'Negotiations message reporting
MSComm1.Output = "AT+FNR=1" + vbCr
If wait("OK") = False Then Exit Sub
MSComm1.Output = "AT+FMS=5" + vbCr
If wait("OK") = False Then Exit Sub
''document to poll
'MSComm1.Output = "AT+FTP=1" + vbCr
'If wait("OK") = False Then Exit Sub
MSComm1.Output = "AT+FCO" + vbCr
If wait("OK") = False Then Exit Sub
'command for data transfer from modem ...
MSComm1.Output = "AT+FDT" 'init fax data sending
If wait("Connect") = False Then Exit Sub
i = FreeFile
Open "c:windowsdesktopmyfaxfax.txt" For Binary Access Read As #i
"***** file manipulation takes place here...
'MSComm1.OutBufferSize = Len(tmpbuffer)
'MSComm1.Output = tmpbuffer
MSComm1.Output = Chr$(16) + Chr$(3) 'terminate sending fax data
If wait("OK") = False Then Exit Sub
MSComm1.Output = "AT+FET=2" + vbCr
If wait("OK") = False Then Exit Sub
MSComm1.PortOpen = False ' ,close line
End Sub
*******
where the program stops is :
sending the AT+FDT command , the modem even though being a class2.0 modem , is giving error message when FDT command is sent.
suggestions required.
thanks
SenthilVel.M
Visual Basic / Access Programming
Can someone look up the following web page:
http://forums.vb-world.net/showthrea...9328#post89328
Did anybody get to look at this new problem yet?
Let me know if this thing is unsolveable?
By the way - how can I post this as a new thread?
Thanks,
Stephen
[Edited by lspeed430 on 07-31-2000 at 10:24 AM]
Visual Basic / AS400 Programming
How can I take the AS400 and find out when I transmit information what filename it is using?
How can I make Visual Basic take user input and then save that information to an AS400 database?
What type of programming code would I need to start out with?
Visual Basic Programming Language
Hi, please i want any one that knows how to design a program on
vb about Automated stock control to please aid me by designing a
program using vb 6.0. the required fields in the program are
Stock code,Product name, Quantity Received, Quantity issued, Old
value, Stock balance, New balance. The Stock code,Product name,
Quantity Received, Quantity issued, Old value, are raw data.
Stock balance is gotten by adding old value + Quantity received,
New balance is gotten by subtracting Quantity issued from stock
balance.we shall make the deal after you have post me the
program.
An Intro To Programming Using Visual Basic...
Alright, quick question. I was wondering if there were any online walkthroughs for the book "An Introduction To Programming Using Visual Basic Versions 5 And 6."
What I mean by walkthroughs is that it will help show you what to do for the reviews and exercises and shows you what commands to input and such. Any help would be greatly appreciated.
Web Programming With Visual Basic. Urgent
In order to get full marks in my Vb coursework, i must be able to create a web browser named WebBrowser1 which can:
-block the possibility of sending emails from any site loaded on the browser.
-block all pornographic sites from loading
-also have some control, as above, on subsequent windows created from any parent site loaded on the browser. For example, how can i get all children website created from any site loaded on the browser to also load on the same browser, replacing the parent.
Please help.
Programming PowerPoint With Visual Basic
I am using PowerPoint and am trying to build a test at the end of the slides....Each question will be a separate slide..... I am having to use Visual Basic to accomplish keeping the scores...This works...However, I need to use Form_Load() and this does not work with PowerPoint...Is there another Function that does the same, but with one that is compatible with PP? Please let me know if any ideas!!!
Thanks!!!
Programming PowerPoint With Visual Basic
I am using PowerPoint and am trying to build a test at the end of the slides....Each question will be a separate slide..... I am having to use Visual Basic to accomplish keeping the scores...This works...However, I need to use Form_Load() and this does not work with PowerPoint...Is there another Function that does the same, but with one that is compatible with PP? Please let me know if any ideas!!!
Thanks!!!
Need Advice About Visual Basic And Game Programming
I just found this place and have learned Visual Basic a little last year in college. So have you built your games in just Visual Basic? And with Direct X? And how do these two fit together. I'm quite new at programming and since I already took VB6 I was wondering how well it works with game development Animated type game development with moving characters and special effects type stuff. (We didn't get that far in class and there was no mention of Direct X ).
I have been wanting to build something of my own but am just learning programming.
Has any one used Visual.net for game development?
Thanks
Visual Basic Programming With Provided Dll File
Dear Friends,
I have a problem in my work place with a price checking machine. The price checker my company bought from brazil, unfortunately they are not providing any interface program, one they have cannot communicate with the sql server 2000, cause out product details are in sql server, so they are just proving and dll file and allowing us to develop program ourself. but i have no experience in vb dealing dll file. i'm attaching the dll file and the documentation they provided.
any help from you will be helpful for me...
expecting a helpul reply,
thanking you in advance.
Game Programming With Visual Basic And DirectX
I am not sure exactly where this would go. I guess here.
I am looking to buy the book Game programming with Visual Basic and DirectX by Jonathan S. Harbour cheap. If anyone wants to sell the book or can direct me to a place cheaper than amazon.com I would greatly appreciate it.
Edit by Iceplug: Nope... here .
Excel File/ Visual Basic Programming
If I saved an Excel file in a similar grid format (columns & rows)- what programming code would I use to pull only the information I need based on the user inputting a specific column and row?
Any reply would be appreciated!
Thanks,
Stephen
lspeed430@aol.com
[Edited by lspeed430 on 07-26-2000 at 06:11 PM]
Who Is The Expert In Visual Basic Programming In This Forums
if u r the Expert Solve my problem ...
i did't work with visual basic i have Experience in Asp and Asp.net
this .exe file must and should run in visual Basic
so please help me
i want to check the application is there or not in the user systems.
if the application is not there install it message will be display
any one cam help me
advance thanks
Programming Serial Port In Visual Basic 6 0
Hi
I have made a code which use the serial port and the mscomm properties. It works very well in my pc using the serial port.
I tried to use it in a lap top. It doesn´t have a serial port, only usb. So I use an usb to serial bridge but it seems to send all totally different.
In the PC I use the serial port and it works ok and if I then use the usb to serial bridge it only sends the last data I sent from the serial port.
Do you think is this a port problem? or maybe I need something different in the code.
I thought the to ports work the same but maybe I'm wrong
Could you help me?
Thanks a lot
CM11A CM12U Programming In Visual Basic 6
Have been reading through the following thread: 708-708806 concerning making the CM11A respond to commands.
First of all, would like to thank the posters on this thread for the informative input. But based on that input, have been able to develop a working Active X control (ocx) and a basic program to turn on and off with Dim and Bright.
But here are few tips I've put together to help out any others to get the CM11A responding dependably in VB6 using the Microsoft Comm control.
But here are some general guidelines to follow using VB6:
(1) Set your Send Threshhold to 1.
(2) Set your Receive Threshhold to 1.
(3) Set the input mode to Binary instead of Text
(4) Set your settings according to specs: 4800, N, 8, 1
You can set it up with Text Mode. But this bombs on one of the house codes. Just one. But it does bomb.
Initialize the HouseAddress (HouseCode and Device Code) first on the CiM11A using hex code 4 as per the CM11A_protocol.txt.
.ouput = Chr$(&H4) & Chr$("&H" & strHouseCode & strDeviceCode) Both of these variables need to be strings and already converted to Hex$ values. Read the documentation.
0x04 in binary is 100, this is the value you want to use for initialization. Don't get this confused with sending a Housecode
Initialize the function command first with the following. You'll only want to do this after verifying that the checksums match.
PseudoCode:
Extract CM11a Checksum
Check the sum of the initialization string to see that it matches.
If it matches, initialiize the function wtih the following.
Send a function using Hex$ 6 (binary 110):
.output = chr$(&H6) & chr$(&H0)
Again, don't confuse the 0x06 value with a house code. And you do need the 0x00 in there following the 0x06!
Again, after sending this initialization string, you'll receive another input in the OnCom even: the CM11a responding to the initialiation string. See if you can't stop your program using the debug mode to query the value. After you see a few returns you should see a pattern. Based on your observations, you should be able to write code to deal with the buffer return from the CM11a after the function initialization string.
Preceding the Function call with this output forces the CM11 to respond with a checksum, which you can detect in the OnComm Event and program accordingly before sending your function command:
For example, after you pickup the right checksum from the OnComm Event, then send the command:
.output = Chr$(&h6) & chr$("&H" & strHouseCode & strHouseCommand)
Both variables need to be in Hex$: e. g. the housecode and the HouseCommand ( "2", "3", etc.......)
Check your checkum values. The documentation tells you what to look for.
All checksum values should be detected in the OnComm event. Once you receive a correct checksum in response to the above. Program your code to repsond appropriately.
But how do I get the checksum?
Declare at least 2 variables in the OnComm event to pick up the responses from the CM11:
Dim strBuffer as string, bytereceived() as byte
The second variable is a byte array. You will pick up different bounds on the array depending on what the CM11A sends:
Basically your array will have a boundary with 1 value or more. Use the values produced from the input with 2 values to extract your checksums.
If the boundary of the array has 2 values, extract the first value from the Buffer to obtain the checksum:
For example:
bytereceived() = .input
In essence an OnCom event receives the binary output from the CM11A. This data is transmitted as a binary array. If you want to verify this, you can declare a variant variable and have the input assigned to the variant. And then just use the varType function to find out exactly what type of data your storing.
Dim varReceived as variant
varReceived = .input
debug.print vartype(varReceived)
You should see an output of a number in the 8 or 9000 range. Consult your MSDN documention on the varType function to see exactly what the number means.
bytereceive(0) should be the check sum. You'll have to convert it into a Hex$. It's a binary value that you'll convert to a Hex$ value that you can understand and that corresponds with the documentation of the CM11A protocol.txt
But that's a start. I'm not gong to do all the work for you. I wouldn't want to take away all the fun. But it doesn't seem that many people have gotten past the initial stage of figuring out how to send the basic commands. But this should give you a good head start.
You can do further checks on the byte array boundary count to respond to different situations. But I'll leave that programming to you. But the general principle is to initiate an output, get the feedback from the CM11 in the OnCommEvent and put your code in the OnComm Event to deal with the various input strings you extract from using the mscomm.input value inside the OnComm Event.
And another good hint would be to use the ComEvSend and the ComEvReceive constants that come built in with the MSComm control within the OnComm event. But the ComEvReceive should take care of about 99% of what you want done.
Also, there are a few situations that will pop up when you unplug your CM11A, a radio frequency device has sent a signal to the CM11a (e.g. RR501), etc. Two of the byte values that you'll have to write special code for are "5A" and "A5." Just read the CM11A_protocol.txt. Search for these values, and the documentation should tell you how to respond. All these responses should be dealt with within the OnCom subroutine.
Hank
Object Oriented Programming Visual Basic 6
I would like to learn Object Oriented programming using Visual Basic 6.
I don't want to buy a book so I thought maybee you somewhere, maybee on the net where I could read som article about it.
Just to learn the basic about Interface and so on.
George
Parallel Port Programming Using Visual Basic
I am making an automated tempreture monitoring system using Visual Basic... could someone help with hardware interfacing (parallel port) using visual basic... the win95io only works under win9X system is there perhaps any other DLL which i can use in XP? or is there any other way?
thanks
shahzad
Display Checkbox Value From MS Access To A Textbox In Visual Basic 6 Form
hello everybody,
im new here...
i wanted to ask this: how do i display checkbox value from my database MS access to a textbox in a visual basic 6 form? it has been displayed "True" or "False" but i want it to display "Active" for true value and "Not Active" for false value.
And,
i want to send value from my option buttons, optionActive and optionNotActive. if optionActive is true, then the value sent to ms access is also true (where it checks my checkbox) and vice versa.
im sorry if the questios are not clear enough. if there's any doubt regarding my questions, feel free to ask me back. :)
thank you very much for assisting me.
|
TRACKER
