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 21 of 21
Search took 0.01 seconds.
Search: Posts Made By: fastcorvette
Forum: Pro VB Databases January 27th, 2005, 01:18 PM
Replies: 1
Views: 2,252
Posted By fastcorvette
Inserting a picture from a database into Word

I have a picture stored in an Access database, it is not stored on the hard drive anywhere, it is only in the database. I use the Word object to create a Word document in VB6 and I need to be able...
Forum: Pro VB 6 April 1st, 2004, 10:50 AM
Replies: 3
Views: 7,328
Posted By fastcorvette
No I did not so I had to make the field...

No I did not so I had to make the field "invisible" by just putting no data in it for those instances where I didn't want it to be seen. For my situation that worked just as good.

I have a red on...
Forum: Access December 24th, 2003, 01:56 AM
Replies: 5
Views: 4,488
Posted By fastcorvette
I didn't know you could access a VB function with...

I didn't know you could access a VB function with SQL in Access 2000. How do you do that? I have no idea how to create a SQL statement that would reference a function in a VB module.
Forum: Access December 18th, 2003, 12:30 PM
Replies: 5
Views: 4,488
Posted By fastcorvette
I can't declare variables in a SQL statement that...

I can't declare variables in a SQL statement that is going to be used against an Access database. The syntax I am looking for will have to be one long line that can be run against the Microsoft Jet...
Forum: Access December 18th, 2003, 09:46 AM
Replies: 5
Views: 4,488
Posted By fastcorvette
Using A CASE Statement

What is the correct syntax for using a CASE function in a SQL statement that has 4 cases to evaluate when running against an Access 2000 database? In VB the CASE would be as follows:

SELECT CASE...
Forum: Access December 16th, 2003, 07:50 PM
Replies: 3
Views: 4,251
Posted By fastcorvette
Yes, I am talking about the number of decimal...

Yes, I am talking about the number of decimal places. The SQL statement as it is sets the decimal places to zero. I have to go into the database in Access 2000 where the data type is correctly now...
Forum: Access December 16th, 2003, 06:25 PM
Replies: 3
Views: 4,251
Posted By fastcorvette
Alter FIeld Size And Scale

How do I modify the following SQL statement to not only change the field type to number but to also change the field size to decimal and the scale to 2?

ALTER TABLE Table1 ALTER COLUMN Field1...
Forum: Access October 31st, 2003, 12:53 PM
Replies: 8
Views: 11,128
Posted By fastcorvette
They are both numeric. I can't explain the need...

They are both numeric. I can't explain the need for the glitches. That's why I never even considered using them before, but that's what fixed it.
Forum: Access October 31st, 2003, 12:29 PM
Replies: 8
Views: 11,128
Posted By fastcorvette
That's funny. I've worked in Information...

That's funny. I've worked in Information Technology services for over 10 years and all through out my time in college we referred to a single quote as a glitch.

The Cost/PricePer field ("MAmt")...
Forum: Access October 31st, 2003, 10:50 AM
Replies: 8
Views: 11,128
Posted By fastcorvette
Thanks for your input. It turns out that I had...

Thanks for your input. It turns out that I had to put the zero in glitches in order for it to work.

IIF(PricePer > '0', (Cost/PricePer), 0)
Forum: Access October 31st, 2003, 08:49 AM
Replies: 8
Views: 11,128
Posted By fastcorvette
IIF Statement Question

I am using the following SQL statement going against an Access database:

SELECT *, (Cost/PricePer) as MAmt FROM Table WHERE Num = @Num

Which works, however, PricePer can be zero so I have tried...
Forum: Access October 10th, 2003, 10:28 AM
Replies: 2
Views: 1,474
Posted By fastcorvette
That worked! Thanks!

That worked! Thanks!
Forum: Access October 9th, 2003, 10:03 AM
Replies: 2
Views: 1,474
Posted By fastcorvette
Tricky SQL

In a table, Field2 can contain 1 of 2 values. Depending on what value is in Field2, the value in Field3 needs to be placed in a different window in my program. So, using a SQL statement, I would...
Forum: Pro VB 6 October 8th, 2003, 11:57 AM
Replies: 9
Views: 3,736
Posted By fastcorvette
Thanks for all your help! I finally found the...

Thanks for all your help! I finally found the ALTER COLUMN command in the Microsoft Knowledge base and that works perfectly! Thanks again!
Forum: Access October 8th, 2003, 11:53 AM
Replies: 2
Views: 1,624
Posted By fastcorvette
That works! Thanks!

That works! Thanks!
Forum: Pro VB 6 October 8th, 2003, 10:03 AM
Replies: 9
Views: 3,736
Posted By fastcorvette
Thanks for all the code! If I execute the...

Thanks for all the code! If I execute the following code, it works:

Dim cat As ADOX.Catalog
Set cat = New ADOX.Catalog
cat.ActiveConnection = dbConnect...
Forum: Pro VB 6 October 8th, 2003, 09:48 AM
Replies: 3
Views: 7,328
Posted By fastcorvette
VB6 Data Report Designer

I'm using the built-in Data Report designer in VB6 for reporting purposes. I have a scenerio where the value of 1 field in a record determines which label on the report is to receive the value of...
Forum: Pro VB 6 October 8th, 2003, 09:08 AM
Replies: 9
Views: 3,736
Posted By fastcorvette
Thanks. I'd never used ADOX before. Do you have...

Thanks. I'd never used ADOX before. Do you have a sample of code showing how to reference and change the datatype of a field in a table?
Forum: Pro VB 6 October 8th, 2003, 08:43 AM
Replies: 9
Views: 3,736
Posted By fastcorvette
Thanks for your reply. In development, I've...

Thanks for your reply. In development, I've already changed the datatype in an existing database as I did my testing and now I need the application to perform the same change to the user's existing...
Forum: Pro VB 6 October 8th, 2003, 08:14 AM
Replies: 9
Views: 3,736
Posted By fastcorvette
Changing Datatype In Access Database

Is there a way to change the datatype of a field in an Access database table through VB code? I've found a why to do it by adding a new field to the table, copying the data from the field I want to...
Forum: Access October 8th, 2003, 08:12 AM
Replies: 2
Views: 1,624
Posted By fastcorvette
Changing Datatype In Access Database

Is there a way to change the datatype of a field in an Access database table through a SQL statement? I've found a why to do it by adding a new field to the table, copying the data from the field I...
Showing results 1 to 21 of 21

 




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