|
Holy Orders wrote: Data type mismatch in criteria expression
Simply put, it's when I try to add values to the database for student
information like student number, last name, course, etc.
What data is the database expecting and what are you trying to put in there. You may want to show the database table structure along with your code you provided
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
You've got a ton of problems with this code. I'd rewrite it to simplify it, but you have to do it yourself. If anyone else rewrote the code and you turned it in, the coding style would suddenly change and you'd get put under a microscope for cheating.
Holy Orders wrote: * When I try to add user information, I generate this error
Data type mismatch in criteria expression
Simply put, it's when I try to add values to the database for student
information like student number, last name, course, etc.
We can't answer this question because you've supplied no information on the structure of the database or the code that is used to add this to the database. From the error, you tried to do something like put a number into a field expecting a string of characters.
Holy Orders wrote: * I see this error when I code this
Dim f3dg1 as List
Well, the f3dg1 is user defined, i just referred to it as mnemonics to form3
which has a datagrid. What the error in here is the keyword List, which VB "doesn't seem to recognize"
What is "List"?? From your code, "List" better be the name of a form you created in your project. It's also a very bad name to use because in .NET 2.0 (VS 2005), List is now a collection class.
Holy Orders wrote: * Ok, here's the last. Here is the program segment for my datagrid.
I can't display column headers in my datagrid (gave me countless sleepless nights... duh) which is why my query (well, actually just a masterlist) don't work.
You do NOT have to create three seperate variables for TextBoxColumns. You would actually be better off putting in the code to setup the DGV in a seperate method. And your current variable names suck, badly. A CompSci student writing a thesis paper should already know the meaning of 'self documenting code' and how it applies to variable names.
|
|
|
|
|
Dave Kreskowiak wrote: We can't answer this question because you've supplied no information on the structure of the database
Which is what I asked last night and no reply, so no help until then :->
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Yeah, I thought the more people that bring that up, the greater the chance of it sinking in...
|
|
|
|
|
Dave Kreskowiak wrote: the more people that bring that up, the greater the chance of it sinking in..
Yep.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I want to use Crystal Report9.2 to create a test.rpt,and test.rpt contains a picture in the detail section, but the picture field is only stored the file path in the SQL server, I do not how to create this test.rpt, and after creating it how to call the test.rpt in vb6.0?
Many Thanks!
|
|
|
|
|
(1) - Record Audio
I want to make an audio recorder. It can record from microphone input, all sound from the computer, part of it (wave only, cd audio only, or line-in only). How can I do that.
(2) - Read Current Audio Volume
Is there some ways to read the volume of the audio mixer, since i want to make something using progress bar that detect current volume of my pc. Anyone can help me?
Thanks
- No Signature Available -
|
|
|
|
|
Hello,
You may use the following VB Script to record audio:
Dim rec
Set rec = CreateObject("AudioCtl.AudioRecord.1")
'Select sound device 0
rec.DeviceIndex = 0
'Set output file
rec.SetOutputFileName "1.mp3"
'Start record with given parameters, record mp3 audio
rec.StartRecord 2, 11025
'Record for 10 secs
WScript.Sleep 10000
'Stop Record
rec.StopRecord
Thanks,
James
James Smith
www.componentone.com
|
|
|
|
|
Hi,
I thought you might be interested in this[^] article, from the Coding4Fun blog
I are Troll
|
|
|
|
|
Guys how can i get my computer name using visual basic 6.. thnkz..
|
|
|
|
|
use this api
Private Declare Function GetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long
|
|
|
|
|
Or you can use the Windows Scripting Host to get it.
Dim WshNetwork As Object
Set WshNetwork = CreateObject("WScript.WshNetwork")
MsgBox WshNetwork.ComputerName
|
|
|
|
|
I did try and search for a meaning, but what does the # do on statements like:-
V = 10000#
Andy.
|
|
|
|
|
The appended character specifies that the literal value should be treated as a certain datatype instead of the type that's infered by the number. For example, 10000# says that the number should be treated as a Double type instead of an Integer. 10000@ should be treated as a Decimal type. The documentation on it (VB.NET) is here[^].
|
|
|
|
|
This is one of the older style type suffix characters (e.g., #, $, %,...).
You can still even declare variables without specifying a type with these (e.g., Dim myDouble# - not recommended though). This is outdated syntax that should be purged from the language.
I would recommend using the newer type suffix 'R' for this case. ('R' for double literals, 'D' for decimal literals, 'S' for short literals, 'I' for integer literals, 'UI' for unsigned integer, and 'US' for unsigned short).
David Anton
http://www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
C++ to C# Converter: converts C++ to C#
C++ to VB Converter: converts C++ to VB
C++ to Java Converter: converts C++ to Java
Instant C++: converts C# to C++/CLI and VB to C++/CLI
|
|
|
|
|
Within VB.Net 2003, I noticed a odd thing. When I try to round a decimal such as .805 to 2 places, I get .80. If I round a decimal such as .815 to 2 places, I get .82. Is there a reason that VB.net does this? Is there a way to get around this issue? Thanks for the help.
In some additional testing I have found that it appears that when the hundredths position is 0 or an even number it rounds down and when it is odd that it rounds up. This seems very odd and inconsistant to me. I hope that someone has the answer.
-- modified at 17:09 Friday 14th September, 2007
|
|
|
|
|
The .NET CLR uses "bankers rounding", or "Round-To-Even". Read[^].
It's not just VB.NET that does this. It's any language, including C#, that targets the .NET Framework.
|
|
|
|
|
I have a radio button that is disabled on form load, why is the font color(forecolor) different when disabled and how do I change it? Thanks.
mshytech
|
|
|
|
|
mshytech wrote: have a radio button that is disabled on form load, why is the font color(forecolor) different when disabled
Because it's disabled. This is standard Windows functionality.
mshytech wrote: and how do I change it?
You don't. There is no property to change the disabled foreground color.
You can simulate the "normal" colors with a disabled RadioButton by leaving it enabled, then handling the Click event of the RB and resetting it's Checked property to the opposite of what it is:
RadioButton1.Checked = Not RadioButton1.Checked
|
|
|
|
|
Great, that works! What ever happened to control arrays?
|
|
|
|
|
add a class to your project which inherites radiobutton
add this code to your class .to disable the event do not write anything in the subroutine.
Protected Overrides Sub OnEnabledChanged(ByVal e As System.EventArgs)
End Sub
-- modified at 15:42 Friday 14th September, 2007
A.E.K
|
|
|
|
|
You might want to review your post and clean it up a bit. Noone can read it unless they reply to it.
|
|
|
|
|
what are you talking about Dave?
A.E.K
|
|
|
|
|
Originally, your post just had the peach colored bar, with no code in it.
|
|
|
|
|
hi first u write the code and in load form for line u disable radio button not first ok
your problem is sol ve
|
|
|
|