Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 37
Search took 0.01 seconds.
Search: Posts Made By: amjad_mahmood
Forum: VB Databases Basics August 14th, 2005, 06:26 AM
Replies: 1
Views: 2,390
Posted By amjad_mahmood
Microsoft ODBC for Oracle

Dim conn As New ADODB.Connection
conn.Open "driver={Microsoft ODBC for Oracle};" & _
"server=js;" & _
"uid=hsonschergffdg;pwd=xxdfhsons"
Set Cat = New ADOX.Catalog
Cat.ActiveConnection = conn...
Forum: Pro VB Databases August 10th, 2005, 12:44 AM
Replies: 2
Views: 1,069
Posted By amjad_mahmood
Thanks for your help. I have tried to use the...

Thanks for your help.
I have tried to use the execute command but probably I need to correct it's syntax
ActiveCell.Offset(Tb, 2) = conn.Execute("select count(*) from " & Cat.Tables(Tbl).Name, 1,...
Forum: Pro VB Databases August 9th, 2005, 06:01 AM
Replies: 2
Views: 1,069
Posted By amjad_mahmood
Want to get number of recs without opening rs

How to get number of records without opening recordset?

I have successfully established the connection to a database as follows

Dim conn As New ADODB.Connection
conn.Open "driver={Microsoft...
Forum: Excel VBA August 9th, 2005, 05:49 AM
Replies: 0
Views: 916
Posted By amjad_mahmood
How to get # of recs without opening recordset

How to get number of recs without opening recordset?

I have successfully established the connection to a database as follows

Dim conn As New ADODB.Connection
conn.Open "driver={Microsoft ODBC...
Forum: VB Databases Basics August 9th, 2005, 05:31 AM
Replies: 1
Views: 1,247
Posted By amjad_mahmood
Pls Help me count records [soon after connection]

I have successfully established the connection to a database as follows

Dim conn As New ADODB.Connection
conn.Open "driver={Microsoft ODBC for Oracle};" & _
"server=js;" & _...
Forum: Excel VBA August 5th, 2005, 06:56 AM
Replies: 0
Views: 1,950
Posted By amjad_mahmood
How do I get a list of all tables of Oracle DB?

How do I get a list of all tables of Oracle DB?


Following is the code in which i have marked the point (in comments) where I need assistance

Sub OracleToExcel()

Dim conn As New...
Forum: Excel VBA August 4th, 2005, 11:38 PM
Replies: 2
Views: 1,922
Posted By amjad_mahmood
Yes I need to pull oracle data into Excel: The...

Yes I need to pull oracle data into Excel:
The data source name= js
user name = hsons999
server = 192.166.105.20

Can you provide me with a sample code to help me start downloading data into...
Forum: VB Databases Basics August 4th, 2005, 06:06 AM
Replies: 1
Views: 741
Posted By amjad_mahmood
Takeover of Administration of Oracle

I have recently joined a local pharmaceutical company as a Manager-MIS

The corporate objective is to outsource the ERP development (which is currently being done in-house costing plenty of time...
Forum: Oracle August 4th, 2005, 04:09 AM
Replies: 1
Views: 986
Posted By amjad_mahmood
Takingover of Administration of Oracle

I have recently joined a pharmaceutical company as a Manager-MIS

The corporate objective is to outsource the ERP development (which is currently being done in-house costing plenty of time and...
Forum: Excel VBA August 4th, 2005, 12:01 AM
Replies: 2
Views: 1,922
Posted By amjad_mahmood
How to coonect Excel to Oracle

Hello Guys,
Is it possible to convert the data of
excel to oracle directly ( without using MS-access ) with
the correct datatype ?? I downloaded the oraxel from
www.oraxel.com but it is not...
Forum: Excel VBA April 19th, 2005, 05:10 AM
Replies: 3
Views: 1,729
Posted By amjad_mahmood
Try using Flexgrid instead of listbox

Try using Flexgrid instead of listbox
Forum: Excel VBA April 19th, 2005, 12:52 AM
Replies: 1
Views: 2,980
Posted By amjad_mahmood
You can not use Sht1 as a variable object. The...

You can not use Sht1 as a variable object. The syntax should be:
x=1
y=1
workbooks(x).sheets(y).OLEObjects("Image1").Picture = LoadPicture(filepath)
Forum: Excel VBA February 22nd, 2005, 05:44 AM
Replies: 4
Views: 2,186
Posted By amjad_mahmood
Hi, You can Try a dummy message box, which...

Hi,

You can Try a dummy message box, which will have user to click OK, before doing Set xlApp=Nothing
Forum: Excel VBA February 22nd, 2005, 04:04 AM
Replies: 4
Views: 2,186
Posted By amjad_mahmood
You are probably doing Set xlApp=Nothing too...

You are probably doing Set xlApp=Nothing too quickly because xlApp.Quit is a slower command to execute. This command "xlApp.Quit" needs some time the process is in the background and the parent...
Forum: Excel VBA February 22nd, 2005, 03:47 AM
Replies: 1
Views: 1,617
Posted By amjad_mahmood
I think you would have to do the following: ...

I think you would have to do the following:
select each object individually, go to properties, look for the property "Print Object", disable it, I presume you have left all these objects with...
Forum: Excel VBA February 21st, 2005, 05:35 AM
Replies: 2
Views: 4,113
Posted By amjad_mahmood
Kathy, It's just to tell you that your...

Kathy,

It's just to tell you that your question was interesting, I am surprized that so far no replies have come so far, I know that it's possible to invoke macros from one VBA project to...
Forum: Excel VBA February 17th, 2005, 05:23 AM
Replies: 1
Views: 3,802
Posted By amjad_mahmood
Please do as follows: Function CAGR(StartValue,...

Please do as follows:
Function CAGR(StartValue, EndValue, NumberOfYears)
CAGR = Format((((EndValue / StartValue) ^ (1 / NumberOfYears)) - 1), "0.00%")
End Function
Forum: Excel VBA February 2nd, 2005, 01:30 AM
Replies: 6
Views: 3,394
Posted By amjad_mahmood
Please let me see your file, if possible my...

Please let me see your file, if possible

my email address is amjad.s.mahmood@gsk.com
Forum: Excel VBA February 2nd, 2005, 12:51 AM
Replies: 3
Views: 11,247
Posted By amjad_mahmood
Yes that's it! It worked with my file, by...

Yes that's it!

It worked with my file, by just replacement of my CmdFinish_Click() with yours

Thanks you.

Can you can express "in nut shell" what we have learnt? I mean "the form unload rule"
Forum: Excel VBA February 1st, 2005, 04:14 AM
Replies: 3
Views: 11,247
Posted By amjad_mahmood
Good Question! I have followed your problem...

Good Question!

I have followed your problem and created a dummy application in which one form opens the other, the other opens the other and so on.

An I have reached to the mark where you have...
Forum: Excel VBA February 1st, 2005, 01:26 AM
Replies: 1
Views: 1,481
Posted By amjad_mahmood
Please correct me if I am wrong. You are probably...

Please correct me if I am wrong. You are probably facing problem with the line of code:
Range("PN").FindNext(r3).Select

if this is so
replace this line with the following lines or (something...
Forum: Excel VBA January 31st, 2005, 02:03 AM
Replies: 1
Views: 1,718
Posted By amjad_mahmood
Your question is too short in words for me to...

Your question is too short in words for me to grasp it.
Can you show me the code where VBA is Opening Excel file?
Is it opeing a read-Only version of the file which is already opened?
Or is it...
Forum: Excel VBA January 14th, 2005, 03:52 AM
Replies: 1
Views: 3,931
Posted By amjad_mahmood
Try the following command just before fileName =...

Try the following command just before fileName = .GetOpenFilename(

ChDir "your Path"

I am not sure, but it should work!
Forum: Excel VBA January 14th, 2005, 03:40 AM
Replies: 4
Views: 11,577
Posted By amjad_mahmood
This is giving me great knowledge. Thank you...

This is giving me great knowledge.

Thank you very much

Amjad
Forum: Excel VBA January 14th, 2005, 02:49 AM
Replies: 2
Views: 1,870
Posted By amjad_mahmood
Yes! Goto the cell where u need this to...

Yes!

Goto the cell where u need this to happen
type the formula =Tabname()
This will at first cause an error
now press Alt+F11 to goto VBA editor
Insert a new module

type these three lines...
Showing results 1 to 25 of 37

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.