|
1) PLEASE don't yell!
2) This has nothing to do with Access.
3) The resposne from KK should get you what you need. Just please use appropriate subject lines next time. I thought this was going to be an MS Access question.
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
My Blog[^]
-- modified at 15:06 Wednesday 30th November, 2005
|
|
|
|
|
Hi! There ,
Yes this is a Microsoft Access application question.
Otherwise if you have other formulas to solve my question, i would really appreciate.
Also i appreciate your corrections and anything else you think you should tell me coz this builds me alot. Thanks very much.
Regards
Joseph
ffffffffffffffffffff
|
|
|
|
|
Is it possible to perform bit operations in VB6. I mean, like in VC++ there's the ">>" operator to move bits to the right direction, is it possible to do that in VB6?
Thanks in advance,
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
VB6 doesn't support bit-wisde shift operators. You'll have to do it using math operations. But, when doing the math, please keep in mind that VB6 also doesn't support Unsigned numeric types either!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
http://www.vbaccelerator.com/tips/vba0030.htm
|
|
|
|
|
Hi,
Can i create tables from vb6?
I tried it but i get this error if i use the provider- Jet 3.51 (for MS-Access) , if i use Jet 4.0 i do not get this error.
So does the syntax change when i use Jet 3.51?
ERROR:
"Invalid SQL statement, expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' ,
or 'UPDATE'."
Alter,Update,Delete,Insert etc. work in Jet 3.51, only Create gives this error.
Can anyone tell me the syntax for create table in vb6 using Provider 3.51?
Right now my code reads like this;
sSql="CREATE TABLE Tab1(ID Number,Age Number)"
gCon.Execute sSql
Thanks in advance,
Sarah
-- modified at 23:57 Wednesday 30th November, 2005
|
|
|
|
|
|
Thanks for taking the time to answer my query.
I am coding in VB6 so i am thinking if the .net site would help me but i will give it a try.
Thanks again.
I get the error only if i use Jet 3.51 provider , I do not get it if i user Jet 4.0 provider,but i need it to work with Jet 3.51.
So please help if u know what is wrong with my syntax.
-- modified at 5:26 Thursday 1st December, 2005
|
|
|
|
|
You might have to use ADOX back in the jet3.51 environment to do any DDL type stuf. I haven't used it since about 1997, so I forget.
ADOX Documentation on MSDN[^]
|
|
|
|
|
If the database is SQL Server, then 'Number' is not a valid data type (use INT), otherwise, I don't know the answer.
|
|
|
|
|
Thanks for taking the time to answer my query.
I am using MS-Access not sql.
|
|
|
|
|
The best thing to do is create a stored procedure that creates the table you need. Then from your code you can execute that stored procedure and have the table created. The caution I stress is that it should be a one time deal unless you do a check to see if the table currents exists or your perform a drop table first in the SP.
|
|
|
|
|
I have used this driver instead of Jet 3.51
DRIVER={Microsoft Access Driver (*.mdb)};DBQ=
and it is working now (My boss says it's alright to use
this driver in our project)
Thanks Scott and KaptinKrunch for ur help.
-- modified at 7:11 Tuesday 6th December, 2005
|
|
|
|
|
I am a newbie so any help is appreciated. I wrote a program in VB.net (Visual Studio 2003)that uses the Internet explorer control. It needs to be fully automated for a lobby display application however some sites occasionally cause a java script error from the IE control. Is there any sure way to surpress these since there will not be ability for someone to click the dumb "continue running scripts" button. I tried messing with the settings for IE under Tool-> Internet OPtions -> Advanced but this seems to have no effect and I not sure whether these even propagate down to the control instance used by the application anyways. Thanks in advance!
Windows XP sp2
IE 6.0.290
DK
|
|
|
|
|
Oh I forgot to mention another reason why this is such a big issue. When the Java errors occur they application stops all activity, timers wont run, all other events will not be serviced until this occurs. So even if you are monitoring if the page loads properly by looking at the some state parameters associated with the IE control the Java script error dialog box stops time in the application until you manually click the "okay continue runnng scripts" button in the dialog box!
|
|
|
|
|
If you're using the Microsoft JVM, open Internet Explorer, click on the Tools menu, Internet Options, Advanced Tab and make sure that "Display a notification for every script error" is unchecked. Oh!, do this under the user account that your app is going to be running under.
If you're using the Sun JVM, go into Control Panels, Java Plug-In, Basic Tab and make sure the "Show Exception Dialog box" option is unchecked.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
If only it were that simple. If I turn off Display a notification for every script error I still get the indication that a script error has occured. Not sure why this cant be shut off. Were you able to verify that this method works? When I turn on the script debugging option in the same options area for IE it brings up the piece of offending code when the scipt arror is detected (arror is a null or not object type error for some ad ware). When I dont have the option to debug checked it just give me the dialog box about if I want to continue running scripts on this page. Why would the second option seems to have an effect but not the first one for not displaying a notification for script errors. Weird but I guess I'm still stuck.
|
|
|
|
|
Simple answer. Fix the error 
|
|
|
|
|
KaptainKrunch is right. The simplest way to fix this problem is to not have it.
No, I haven't tried it. Time is short these days...
The only other thing you can try is to install Sun's Java RTE and TRY that. If it does something similar, your only option is to fix the code causing the errors.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I know what you mean. Its not my fault that IE does not handle script errors as per it's setting and that in general IE seems to have java-script incompatibilities but I guess it is my problem since it affects me... Its not even my Java code that is the affending culprit.
I have tried to look though MSDN for help. I think there may be a method that involves turning on script debugging and then the event can be detected and handled in a truley round about fashion within the VB program. I'll guess I'll have to dig through this.
Thanks.
|
|
|
|
|
Hi all,
i want to learn the concept of threads in VB.Somebody please help me with this.
Thanks in advance,
Sushma
|
|
|
|
|
|
Read the official VS2005 help it will answer your question.
You can also read the .NET FW system.threading.thread class documentation since contains code samples. It's really basic.
|
|
|
|
|
In VB6, is it possible to dispatch the events generated by a Winsock control that is in a form inside the module class. This winsock control is also a member variable of that class. I'd like to catch the DataArrival an Error events inside the class.
Thanks in advance,
MArc Soleda.
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Hi,
Can anyone point me to a direction where I can find some info on how to set/remove user from folder security using vb.net.
Appreciate it..
Thanks...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
