Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 129
Search took 0.01 seconds.
Search: Posts Made By: Clive Astley
Forum: Access April 15th, 2006, 12:53 PM
Replies: 2
Views: 1,138
Posted By Clive Astley
Pap, Is the whole report in Usd or Rs? Or is...

Pap,

Is the whole report in Usd or Rs? Or is any individual purchase likely to vary between Usd and Rs?


Clive Astley
Forum: VB Databases Basics April 6th, 2006, 10:31 AM
Replies: 0
Views: 1,250
Posted By Clive Astley
DBCombo and DataControl

dtaInput is the main DataControl connecting to an Access database. dtaDescription feeds the DBCombo which exists to display a Description instead of the unfriendly DesciptionID. cboRecordType simply...
Forum: Access January 17th, 2006, 02:59 PM
Replies: 1
Views: 1,221
Posted By Clive Astley
Data Types

When I ran the following module:

Sub GetFields()
Dim tbl As TableDef
Dim fld As Field
Dim TableToProcess As String
TableToProcess = InputBox("Enter table get fields list:")
For Each tbl In...
Forum: Access November 20th, 2005, 01:49 PM
Replies: 2
Views: 1,378
Posted By Clive Astley
Hi Jim, You can use the MS Common Dialogue...

Hi Jim,

You can use the MS Common Dialogue control.

HTH
Clive

Clive Astley
Forum: VB Databases Basics August 23rd, 2005, 12:48 AM
Replies: 2
Views: 1,470
Posted By Clive Astley
Many thanks Cliff. Clive Astley

Many thanks Cliff.

Clive Astley
Forum: VB Databases Basics August 21st, 2005, 01:30 AM
Replies: 2
Views: 1,470
Posted By Clive Astley
Copying from one table to another

I have DAO connections to two databases dbNew and dbOld. I want to copy data from a table in dbOld to a table in dbNew. Currently I have done it by creating two recordsets and looping through them.
...
Forum: Beginning VB 6 July 7th, 2005, 12:15 AM
Replies: 2
Views: 928
Posted By Clive Astley
Many thanks Marco. Clive Astley

Many thanks Marco.

Clive Astley
Forum: Beginning VB 6 July 4th, 2005, 12:44 AM
Replies: 0
Views: 3,624
Posted By Clive Astley
DataGrid click event

I tried using the click event to extract the selected record using datagrid.text. But it gives me the record that was selected before the mouse is clicked (obvious when one thinks about it). What I...
Forum: Beginning VB 6 July 4th, 2005, 12:40 AM
Replies: 2
Views: 928
Posted By Clive Astley
Printing a code module

When I print out a code module it comes out all in black, eg the green used for comments and blue for keywords is lost.

Is it possible to have it print out in colour? Or is there a third party...
Forum: VB Databases Basics July 4th, 2005, 12:32 AM
Replies: 1
Views: 849
Posted By Clive Astley
Crystal Reports should be on your VB6 CD. It's a...

Crystal Reports should be on your VB6 CD. It's a bit difficult to find and needs to be installed separately from the CD.

Alternatively, you could use the Data Environment to connect to your...
Forum: Access February 23rd, 2005, 02:51 PM
Replies: 3
Views: 1,156
Posted By Clive Astley
Good reasoning. Thanks for sharing it with us. ...

Good reasoning. Thanks for sharing it with us.

Clive Astley
Forum: Access February 23rd, 2005, 02:49 PM
Replies: 1
Views: 2,155
Posted By Clive Astley
How do you access the required name in TblNames? ...

How do you access the required name in TblNames?

Clive Astley
Forum: Access February 12th, 2005, 08:22 PM
Replies: 4
Views: 1,200
Posted By Clive Astley
Hello IB, Best way to make a subform is to...

Hello IB,

Best way to make a subform is to use the subform wizard.

Bind the textbox to the MainContactNumber field of your Estimate table. The default value will then go to this field...
Forum: Access February 12th, 2005, 03:18 PM
Replies: 4
Views: 1,200
Posted By Clive Astley
It looks like you haven't got the forms linked;...

It looks like you haven't got the forms linked; eg as form and subform?

An alternative. On AddEstimate form put a textbox, hidden if you like. Make it's default value equal to the...
Forum: Access February 12th, 2005, 08:23 AM
Replies: 2
Views: 1,004
Posted By Clive Astley
Have you tried refreshing or requerying the combo...

Have you tried refreshing or requerying the combo box underlying query?


Clive Astley
Forum: Access January 27th, 2005, 12:35 PM
Replies: 4
Views: 1,345
Posted By Clive Astley
Many thanks Greg for this reminder. Missed it...

Many thanks Greg for this reminder. Missed it first time round.

Clive Astley
Forum: Access December 21st, 2004, 07:39 AM
Replies: 5
Views: 1,244
Posted By Clive Astley
Hi Stanny, Can you give more info, as Mike's...

Hi Stanny,

Can you give more info, as Mike's suggestion works for me.

Best wishes,

Clive Astley
Forum: Access December 15th, 2004, 03:50 AM
Replies: 2
Views: 904
Posted By Clive Astley
Both are big subjects. Best thing is to get a...

Both are big subjects. Best thing is to get a beginners book on both subjects out of the library. That shouldn't be too difficult - there are far more basic books than advanced books.

Hope this...
Forum: Access December 14th, 2004, 04:20 AM
Replies: 3
Views: 1,124
Posted By Clive Astley
Glad it worked for you Skinny. In doing what...

Glad it worked for you Skinny.

In doing what you have done you have pretty well done what you want to do in your expanded request.

Let us say you have two tables, Clients and Orders, keyed on...
Forum: Access December 8th, 2004, 03:23 AM
Replies: 4
Views: 937
Posted By Clive Astley
Hi Rao, Just make another form bound to the...

Hi Rao,

Just make another form bound to the information you need and call it, say, from a command button. Suggest you read up on Pop Up forms in help.

Hope this helps,


Clive Astley
Forum: Access December 7th, 2004, 11:58 AM
Replies: 3
Views: 1,213
Posted By Clive Astley
Glad you found a solution. Have not come across...

Glad you found a solution. Have not come across "bostek" but that sort of remark doesn't seem in the spirit of this forum. I've been helped numerous times with a simple solution which I had...
Forum: Access December 4th, 2004, 02:57 PM
Replies: 8
Views: 1,866
Posted By Clive Astley
On the face of it, a snapshot recordset sounds...

On the face of it, a snapshot recordset sounds great. But I don't think you can bind a form to a recordset?

Re VB6 and VBA. I use both and find books on each invaluable to my knowledge of the...
Forum: Access December 4th, 2004, 07:51 AM
Replies: 3
Views: 1,213
Posted By Clive Astley
Hi Michael, Just a thought. Are you sure you...

Hi Michael,

Just a thought. Are you sure you are not making any subtle changes to the form? Such as changing a label's caption or some module code? I have come across this in the past but can't...
Forum: Access December 4th, 2004, 07:49 AM
Replies: 2
Views: 896
Posted By Clive Astley
Yes, use each query as a recordsource for a form....

Yes, use each query as a recordsource for a form. Then use these forms as subforms placed on the tab control.

Sorry can't help with the avi file. But I think you just need to place an OLE object...
Forum: Access December 3rd, 2004, 02:29 PM
Replies: 4
Views: 3,613
Posted By Clive Astley
Can a Level span more than two fiscal years? ...

Can a Level span more than two fiscal years?

Clive Astley
Showing results 1 to 25 of 129

 


All times are GMT -4. The time now is 01:27 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.