 |
Anthony's VBA Forum Where the knowledge is shared |
| Menu |
 Home PageForum Index FAQ Memberlist Usergroups Register Profile Messages Login/Out |
| Quick Search |
| Links |
| Who's Online | |
[ Moderator ] |
|
| Search found 12 matches |
| Author | Message |
|---|---|
 Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
 Forum: General Excel VBA Posted: Mon Feb 21, 2005 3:44 am Subject: new in VBA |
| Anthony,
as u said i put my whole sql string there, but the same error appears. ------------------------------------------------------------------------------- Private Sub CommandButton2_Clic ... |
|
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Thu Feb 17, 2005 1:28 am Subject: new in VBA |
| i'm using the below code to update the database, but i'm getting an error of microsoft ODBC invalid character. Below is part of the code that is effected. The error is for variable s. Please help,than ... | |
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Mon Jan 10, 2005 11:49 pm Subject: new in VBA |
| does that mean that i cannot update the database directly from the application. | |
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Fri Jan 07, 2005 2:42 am Subject: new in VBA |
| Anthony,
i have assigned a value for i, in order to loop. I have shifted all the codes into userform1 as below. Yet, i'm still getting an error of 'Run-time error '1004':Application defined or object ... |
|
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Tue Jan 04, 2005 11:16 pm Subject: new in VBA |
| and i'm a bit confused here.
If i change the i in Cells,hw is my update statement going to loop? There are many to be updated at a time. If i change it to an integer, it will only update that parti ... |
|
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Tue Jan 04, 2005 9:13 pm Subject: new in VBA |
| anthony,
thanks,it helped. But now i'm getting the following error (Run time error '3709':The connection cannot be used to perform this operation. Its is either closed or invalid in this context) i ... |
|
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Mon Jan 03, 2005 8:57 pm Subject: new in VBA |
| I'm sorry i didnt point the error.
It stops at strSQL1 and strSQL2 |
|
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Sun Jan 02, 2005 9:21 pm Subject: new in VBA |
| Anthony,
That worked. Thanks. I"m getting this compile error of user defined type not defined at connection declaration. I hope u can point out my mistake because i use the same method as in VB. If u ... |
|
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Thu Dec 30, 2004 9:48 pm Subject: run time error 1004 |
| anthony,
thanks for the code given. I've applied them in my modules. I have two modules for one user form. But i'm getting a runtime error of 1004 : application defined or object defined error at my ... |
|
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Tue Dec 28, 2004 8:54 pm Subject: new in VBA |
| thanks for the information. i think i'l use ODBC. But, do i need recordset for this? | |
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Mon Dec 27, 2004 9:07 pm Subject: new in VBA |
| thanks for the reply.I'm so relieved to know that its possible.
but i'm using oracle database,i will have to use ADODB is it? Does it involve recordset? thanks again |
|
| Topic: new in VBA |
|
| sarj Replies: 22 Views: 80287 |
Forum: General Excel VBA Posted: Wed Dec 22, 2004 11:11 pm Subject: new in VBA |
| hello,
i'm new in VBA. I just wanted to know whether is it possible for me to update certain fields in database according to the ones choosen and pasted in excel. Can i do it by using VBA? If my exp ... |
|
All times are GMT - 4 Hours |
Powered by phpBB © 2001, 2002 phpBB Group