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 26
Search took 0.01 seconds.
Search: Posts Made By: Rood67
Forum: Access VBA September 18th, 2009, 02:03 PM
Replies: 1
Views: 15,366
Posted By Rood67
Question How To Use For...Each On A Recordset

Hi. With some great help from Mac here on this forum and a few post on some others, I was able to work out connected to AS400 through VBA and pull data into a recordset. See the issue and solution...
Forum: Access VBA September 18th, 2009, 12:36 PM
Replies: 13
Views: 30,516
Posted By Rood67
Thumbs up Pass Through Query to AS400 **SOLVED**

**SOLVED**


I had to use the .AddNew method on the local table to get it to create the record to be written to. Here is the complete code that resolves:
Connecting to the AS400
Running a...
Forum: Access VBA September 17th, 2009, 08:16 PM
Replies: 13
Views: 30,516
Posted By Rood67
Mac, I finally got to get back to this...

Mac,

I finally got to get back to this project. I also, finally found a connection string that allows me to use OLE DB for a DSN-less connection to the AS400 and allows for ADO recordset reads...
Forum: Access VBA July 16th, 2009, 11:47 AM
Replies: 13
Views: 30,516
Posted By Rood67
I can create views on the AS400. That is what...

I can create views on the AS400. That is what has dramatically increased the speed of my Excel workbooks that tie directly to a view instead of me running my queries in Access to refresh the local...
Forum: Access VBA July 15th, 2009, 05:40 PM
Replies: 13
Views: 30,516
Posted By Rood67
Hey Mac, Trying to be proactive in my...

Hey Mac,

Trying to be proactive in my learning, I was searching for more and more info and examples. One forum had a post that the person said this VB6 book on ADO would work for VBA (their close...
Forum: Access VBA July 15th, 2009, 05:16 PM
Replies: 13
Views: 30,516
Posted By Rood67
Hi Mac, Yes, that is exactly what I want to...

Hi Mac,

Yes, that is exactly what I want to do. THANK YOU very much.

I want to open a "read" connection to the AS400, a "write" connection to local Access table. As I step through the AS400...
Forum: Access VBA July 14th, 2009, 04:19 PM
Replies: 13
Views: 30,516
Posted By Rood67
Thanks again for the quick reply Mac. Here's...

Thanks again for the quick reply Mac.

Here's the process that I do now.
Use the form (refer to first screen shot of first reply) to run the queries you see on the left side of the picture.
The...
Forum: Access VBA July 14th, 2009, 12:09 PM
Replies: 13
Views: 30,516
Posted By Rood67
Hi Mac, Great to read your reply, I was getting...

Hi Mac,
Great to read your reply, I was getting worried no one could help me. I apologize for not inserting code in the first post, and that had to be a deterrent to others posting I'm sure.

I'm...
Forum: Access VBA July 9th, 2009, 11:38 AM
Replies: 13
Views: 30,516
Posted By Rood67
Cool VBA Passthrough Query

Hello all,

I use Access 2007 to connect to a hosted AS400 database (iSeries 5). I used to sit and wait nearly 17 minutes for the queries I had set up to create local tables to run an populate.
...
Forum: Access August 19th, 2008, 02:41 PM
Replies: 0
Views: 1,313
Posted By Rood67
Selecting A Printer From Code

Hi. I think I got this piece of code from here. And it works... right up until a new printer is added, then because it's hard coded, it ceases to function properly until re-coded.

Private Sub...
Forum: Access October 18th, 2007, 09:00 AM
Replies: 2
Views: 2,076
Posted By Rood67
Hi Mac, No, I put the code on the Detail...

Hi Mac,

No, I put the code on the Detail sections - On Print event. I'll try it in the On Format and see if it does any better.

On a happy note, Access2007 has this ability built in for any...
Forum: Access October 16th, 2007, 02:38 PM
Replies: 2
Views: 2,076
Posted By Rood67
Shading Every Other Line In A Report

Hello all,

Simpler problem this time than some of the others I've posted... ok, to me it's simpler.

I have used the following code successfully in the past to shade every other row of a report....
Forum: Access October 12th, 2007, 12:14 PM
Replies: 6
Views: 1,535
Posted By Rood67
Hey Mac, The public declarations are in the...

Hey Mac,

The public declarations are in the (General) (Declaration) section along with the Option Compare Database. I have hammered away at finding the solution, and found it in another forum...
Forum: Access October 12th, 2007, 10:01 AM
Replies: 6
Views: 1,535
Posted By Rood67
Public Q, A, strSQL As String 'Q is for double...

Public Q, A, strSQL As String 'Q is for double Quote and A is for Ampersand
Public aoLabel As AccessObject 'Set up an object variable to pass to sub routine to use in setting properties
__________...
Forum: Access October 10th, 2007, 03:24 PM
Replies: 6
Views: 1,535
Posted By Rood67
Thanks M.McDonal, Your excellent advise got...

Thanks M.McDonal,

Your excellent advise got me through the other problem I was having, so I'm confident this should work.

The overall goal here is to let the few conditional test set the main...
Forum: Access October 8th, 2007, 04:44 PM
Replies: 6
Views: 1,535
Posted By Rood67
Change An Objects Properties Via Sub Routine

I'm continuing to refine the code of a routine that runs several queries and uses colored labels as indicates of the overall process.

Look at the post by me to see the original problem I had and...
Forum: Access October 8th, 2007, 04:26 PM
Replies: 5
Views: 1,222
Posted By Rood67
I found the solution to my problem and thought I...

I found the solution to my problem and thought I had posted it here. The short of it is this...
__________
Public Sub DC()
Dim c As Long
c = 0
For c = 1 To 8000: Next c
Me.SetFocus
Me.Repaint...
Forum: Access August 9th, 2007, 09:21 AM
Replies: 5
Views: 1,222
Posted By Rood67
Hello again, Here's the code that I have so...

Hello again,

Here's the code that I have so far. This is a re-write of the original to convert it to sub calls. However, this results in the same issue. I open the form and get my three white...
Forum: Access August 8th, 2007, 02:09 PM
Replies: 5
Views: 1,222
Posted By Rood67
Thanks for the suggestion. I'm going to go code...

Thanks for the suggestion. I'm going to go code that now and see if that works.

I hope I'm understanding exactly what you stated. As one sub/mod calls another, the exiting of the new sub/mod...
Forum: Access August 7th, 2007, 05:24 PM
Replies: 5
Views: 1,222
Posted By Rood67
Using Colored Labels As Process Indicators

Hello,
I am at my wits end trying to figure out why Access 2007 VBA is doing what it is doing. Below is a complete copy of the code behind a command button on a form. The intended purpose of the...
Forum: Access May 21st, 2004, 02:31 PM
Replies: 10
Views: 2,832
Posted By Rood67
Bob, I tried every way possible to get this to...

Bob,
I tried every way possible to get this to work with it being text, but it will not. The M$ example is using a number field, not text. When I altered the table to to be in the form of:...
Forum: Access May 20th, 2004, 12:49 PM
Replies: 4
Views: 1,021
Posted By Rood67
Hello all, I have found a work around to my...

Hello all,

I have found a work around to my problem. I have set up Access to run some queries as SQL Pass Through's and my other queries to pull from these.

Annoying, but it works. So if...
Forum: Access May 19th, 2004, 10:12 AM
Replies: 4
Views: 1,021
Posted By Rood67
Thanks for the reply. Let me add, I know nothing...

Thanks for the reply. Let me add, I know nothing about MySQL other than it's a "free" database that most people use on websites. Why in the name of all databases did the company we purchased our...
Forum: Access May 18th, 2004, 11:05 AM
Replies: 10
Views: 2,832
Posted By Rood67
Download the qrysmp00 file from Micro$oft at this...

Download the qrysmp00 file from Micro$oft at this link. It has an example of how to do a running sum in one query.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;207626


Hope this...
Forum: Access May 18th, 2004, 10:58 AM
Replies: 4
Views: 1,021
Posted By Rood67
Connecting Access2000 to MySQL Database

Hello,

What I am attempting to do, is generate a custom report using Access2000, from information stored in a MySQL database. The MySQL is located on a server here at my place of employment, and...
Showing results 1 to 25 of 26

 




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